Attachment 1 - ALLIGATOR DD SOS.xls

XLS spreadsheet 79 KB Posted

Attached to
USCGC ALLIGATOR DD FY25 Federal contract opportunity
Solicitation number
70Z08025QPBPL0022
Issued by
Department of Homeland Security US Coast Guard

About this file

This file is a comprehensive pricing schedule and cost estimate worksheet for the drydock availability of the USCGC ALLIGATOR (WPB-87) in Fiscal Year 2025. The detailed pricing schedule includes 40 specific job items for vessel maintenance and preservation, such as hull plating testing, tank cleaning and inspection, propulsion system renewals, and sea trials, with each line item priced at $0.00 in this document. The worksheet also includes foreseeable cost calculations for various factors like transportation, per diem, crew separation allowances, and operational costs, with a total evaluated quote/price of $2,199.12.

The solicitation (Number 70Z08025QPBPL0022) is issued by the Department of Homeland Security US Coast Guard as a combined synopsis/solicitation for commercial items using Federal Acquisition Regulation (FAR) subpart 12 and 13.5 guidelines. The drydock availability is planned for 63 days, with the work to be performed in Galveston, Texas. The solicitation covers a comprehensive maintenance and preservation effort for the Coast Guard cutter, encompassing multiple systems and components to ensure the vessel's operational readiness.

View the file

Other files for this federal contract opportunity

Other files attached to USCGC ALLIGATOR DD FY25, newest first.
File Type Posted
70Z08025QPBPL0022_SOL.pdf PDF
Attachment 2 - ALLIGATOR_DD_Spec.pdf PDF

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

SOS&S

PRICING SCHEDULE FOR:
USCGC ALLIGATOR (WPB-87) DRYDOCK AVAILABILITY FY2025
ITEMDESCRIPTIONUNIT PRICEUNITQTYEXTENDED PRICE
D-001Hull Plating (Side Scan), Ultrasonic TestingJOB1$0.00
O-002Ultrasonic Thickness Measurements, PerformJOB1$0.00
D-003U/W Body, Preserve, 100 percentJOB1$0.00
D-004Hull Plating Freeboard, Preserve, 100 PercentJOB1$0.00
D-005Tank, Dirty Oil, Clean and InspectJOB1$0.00
D-006Tank, Oily Water, Clean and InspectJOB1$0.00
D-007Tanks, MP Fuel Service, Clean and InspectJOB1$0.00
D-008Decks, Exterior (Main Deck), PreserveJOB1$0.00
D-009Superstructure, Preserve, 100%JOB1$0.00
D-010Capastic Fairing, Depth Sounder, RenewJOB1$0.00
D-011Mast, Preserve (“100%”) – Contractor Interference RemovalJOB1$0.00
O-012Main Engine/Reduction Gear, RealignJOB1$0.00
D-013Intermediate Water-Lubricated Propulsion Shaft Bearings, RenewJOB1$0.00
D-014Aft Water-Lubricated Propulsion Shaft Bearings, RenewJOB1$0.00
O-015Intermediate Bearing Carriers, RenewJOB1$0.00
O-016Aft Bearing Carriers, RenewJOB1$0.00
D-017Propulsion Shafts, RenewJOB1$0.00
D-018Stern Tube Interior Surfaces, Preserve, 100 PercentJOB1$0.00
D-019Propellers, RenewJOB1$0.00
D-020Fathometer Transducer, RenewJOB1$0.00
D-021Speed Log, Skin Valve, RenewJOB1$0.00
D-022Sea Water System, Perform MaintenanceJOB1$0.00
D-023Rudder Assemblies, RenewJOB1$0.00
D-024Stern Launch Door, Remove, Inspect and ReinstallJOB1$0.00
D-025Grey Water Holding Tanks, Clean and InspectJOB1$0.00
D-026Sewage Holding Tanks, Clean and InspectJOB1$0.00
D-027Grey Water Piping, Clean and FlushJOB1$0.00
D-028Sewage Piping, Clean and FlushJOB1$0.00
D-029Cathodic Protection/Zinc Anodes, RenewJOB1$0.00
D-030DrydockJOB1$0.00
D-031Temporary Services, Provide - CutterJOB1$0.00
D-032Sea Trial Performance, Support, ProvideJOB1$0.00
D-033Stern Tube Assemblies, RenewJOB1$0.00
D-034Fuel System Piping/Valves, Clean & InspectJOB1$0.00
D-035Stuffing Box, RenewJOB1$0.00
D-036Enclosure, Selector Valve, RenewJOB1$0.00
D-037Stern Gate, Hydraulic Cylinder Area, PreserveJOB1$0.00
D-038Port Void & Lazarette, PreserveJOB1$0.00
D-039Hull Plating, RenewJOB1$0.00
D-040Intrusion Detection System, ReplaceJOB1$0.00
O-00AComposite Labor RateHour0$0.00
D-00BGFP ReportNSPEANSP
O-00ZLaydaysDay5$0.00
Total Price of Definite Items$0.00
Total Price of Option Items$0.00
Total Price of Definite and Optional Items$0.00
Over and Above/Growth Work
The Unit Price Column will be used throughout the life of the contract if growth work is added to the scope of the contract. If Over and Above/Growth Work is issued, these items will be awarded at the quantities needed via a contract modification. The quantity shown is an estimate only and may be exceeded at the unit prices offered.
OA/G-001**Provide breakdown, as follows:

Over and Above/Growth Labor Rate

Unit Price: $________; Quantity: 908; Unit of Issue: Hour; Extended Price: $____________Hour908$0.00
OA/G-002Over and Above/Growth Material Markup/Handling Fee

Unit Price: $33,097.50; Quantity: 1; Unit of Issue: Percent ________%;

Extended Price: [$33,097.50 X percentage quoted]: $______________$33,097.50%$0.00
Total Price of Over and Above/Growth$0.00

&C(3/14/2025) Rev-0 - Page &P of &N

Forseeable Costs

FORESEEABLE COST WORKSHEET
USCGC ALLIGATORFY25
Contractor's Name:
The contractor shall fill-in all yellow labeled boxes below to determine their foreseeable costs. Please read all notes and headers of sections for instructions in completing this worksheet.
DISTANCE FACTORS FOR: 3000 FT POINT RD GALVESTON, TX 77550
NAUTICAL MILES BASED ON ROUND-TRIP (TO AND FROM)
NUMBER OF DAYS OF AVAILABILITY63
(1) Port Engineer/COR Transportation: AIR TRAVEL
(Applicable if > 50 miles from PE address

(PE's desk location)

A. Number of CG Representatives from NESU:A=1
B. The number of round trips between the contractor's facility and NESUB=1
C. A multiplied by B:AxB=C=1
D. Travel cost per trip:D=
E. C multiplied by D =E, if >50 miles from NESU otherwise N/A.E=$0.00
(2) Port Engineer Transportation: CAR TRAVEL
A. Number of CG Representatives from NESU:A=1
B. Number of Driving miles Round-trip between the COR office and contractors facility:B=
C. Travel cost per driving mile (rate at $0.58 per mile)$0.580$0.00
(3) PER DIEM: (Applicable >50 miles CREW + PE)
A. Number of Ship's Crew & Port EngineerA=12
B. Total number of day(s) in drydock.B=63
C. Per diem cost at place of performance, per day: (if < 50 miles, enter "0" for all below)C=$0.00
C.1.1. Enter Lodging Daily Per Diem Rate
C.2.1. Enter Meals & Incidentals Total Daily Rate
C.2.1.1. Enter Meals & Incidentals First & Last Day of Travel Daily Rate
D. AxBxC= D: (if >50 miles from NESU)D=$0.00
(4) PER DIEM: (Applicable >50 miles Contracting Officer Travel & Per Diem. KO location is Norfolk, VA 23510)
A. Number of KO authorized travel:A=1
B. Total number of KO travel days:B=3
C. Transportation cost for KO travelC=
D. Per diem cost at place of performance, per dayD=$0.00
D.1.1. Enter Lodging Per Diem Rate
D.2.1. Enter Meals & Incidentals Total Daily Rate
D.2.1.1. Enter Meals & Incidentals First & Last Day of Travel Daily Rate
E. A [(B*D) + C] =E=$0.00
(5) CUTTER COST Operation Factors:
A. Round Trip Nautical Miles from the vessels pier to the contractors facility:A=0
B. Cutter Cost Factor Per Nautical Mile:B=$34.42
C. A multiplied by B= CC=$0.00
(6) FAMILY SEPARATION ALLOWANCES (FSA) Applicable if > 50 miles from Homeport - for crew with dependents only (Daily Rate $8.33). If less than 50 miles enter 0 for A below.
A. Number of Personnel entitled to Family Separation Allowance:A=8
B. Number of Days for Availability minus 30 days if availability is greather than 30 days:B=33
C. A multiplied by B = C (Daily FSA rate of $8.33)C=$2,199.12
(7) CREW TRANSPORTATION FOR HOME VISIT (Applicable after 31 consecutive days if > 50 miles from Homeport - for crew with dependents only
A. Number of Personnel (with dependents) entitled to HOME visit:A=8
B. Number of Homeport Visits:B=1
C Mileage to homeport = (Roundtrip Ticket Cost)C=
D. A multiplied by B, multiplied by C = D:C=$0.00
GRAND TOTAL
1. PE/COR Transportation (AIRFARE)$0.00
2. PE/COR Transportation (CAR)$0.00
3. Per Diem for Crew and PE/COR$0.00
4. Cutter Cost Operations Factors$0.00
5. Family Separation Allowance$2,199.12
6. Crew Transportation Home Visit$0.00
Total Cost of Distance Factors:$2,199.12
Total Contractor Quoted/Proposal Price:$0.00
TOTAL EVALUATED QUOTE/PRICE$2,199.12

Contractor enters name here Contractor shall utilize: https://nauticalcharts.noaa.gov/publications/docs/distances.pdf http://ports.com/sea-route/ Contractor shall utilize: https://www.gsa.gov/travel/plan-a-trip/transportation-airfare-rates-pov-rates-etc/airfare-rates-city-pair-program

Contractor shall utilize either (1) the total dollar amount for commercial round-trip airfare if their dry dock is greater than 150 driving miles from the PE's homeport OR (2) Enter "0" if their dry dock is less than 150 driving miles from the PE's homeport.

Contractor will enter either (1) "0" if their dry dock is located less than 50 miles or more than 150 miles from the PE's homeport or (2) the total number of round trip driving miles if the contractor is located between 51 to 149 miles from PE's homeport.

Contractors shall utilize https://www.gsa.gov/travel/plan-book/per-diem-rates/per-diem-rates-lookup to estimate per diem rates based on the location of their facility.

Contractor shall utilize: https://www.gsa.gov/travel/plan-a-trip/transportation-airfare-rates-pov-rates-etc/airfare-rates-city-pair-program

Contractor shall utilize either (1) the total dollar amount for commercial round-trip airfare if their dry dock is greater than 150 miles from the KO's location in Norfolk, VA 23510 or (2) Enter "0" if their dry dock is less than 150 miles from the PE's homeport.

Contractors shall utilize https://www.gsa.gov/travel/plan-book/per-diem-rates/per-diem-rates-lookup to estimate per diem rates Do Not Change this cell unless Drydock is less than 50 driving miles from Homeport. Then enter 0.

If contractor's facility is:

- located < 50 miles from the ship's homeport, enter $0.

- located > 51 miles but less than 149 miles from the ship's homeport, multiply round trip vehicle mileage by $0.58

- located > 150 miles from ship's homeport, utilize https://www.gsa.gov/travel/plan-a-trip/transportation-airfare-rates-pov-rates-etc/airfare-rates-city-pair-program

CostEstimateBreakdowns

Composite Labor Rate55
Assumed G&A Factor15%
Assumed Profit Factor10%Direct LaborDirect Material/Subs Cost
ITEMDESCRIPTIONUNIT PRICESub-Contracted (put a "1" in the blank)Total Labor HoursTotal Material & Subs (cost + G&A + profit)Eng TechMachinest/Pipe FitterElectricianShipfitterWelderFirewatchInsulator/LaggerPainterGen Labor/Helper/RiggerSupt/QA/NDTMat/Sub Cost 1Mat/Sub Cost 2Mat/Sub Cost 3Mat/Sub Cost 4Lab RateAreaWorkItemIDWIFileIDLoadData
62Baltimore, MD
52Biloxi, MS
56Boston, MA
50Charleston, SC
60Corpus Christi, TX
51Hampton Roads
64Honolulu, HI
55Houston, TX
56Los Angeles, CA
55Median Rate
49Miami
50Narragansett Bay, RI
55New London, CN
45New Orleans
62NYNY
49Panama City, FL
60Philadelphia, PA
51Portland, ME
57Portland, OR
55San Diego, CA
67San Francisco, CA
55Santa Barbara, CA
55SE North Carolina
65Seattle, WA
48Tampa-St. Petersburg
60Wilmington, DE

&C(09/28/2009) Page &P of &N

CostEstimateTemplate

File details come from the government source that posted it. Updated .