Attachment 1 - Schedule of Services USCGC WILLIAM SPARLING DD Repairs.xls

XLS spreadsheet 45 KB Posted

Attached to
DRYDOCK: USCGC WILLIAM SPARLING FY27 DD
Solicitation number
70Z08026QPBPL0042
Issued by

About this file

This is a pricing schedule and foreseeable cost worksheet for ship repair services related to the USCGC WILLIAM SPARLING (WPC-154) fiscal year 2027 drydock availability. The contract covers definite work items including hull plating inspection, tank and void inspection and preservation, watertight closure assessment, propulsion shafting system inspection and repair, ASW/Firemain system renewal and overhaul, electrical power distribution thermographic inspection, machinery and HVAC ventilation system cleaning, rudder and stabilizing fin inspection and repair, bow thruster inspection, stern launch door inspection and preservation, sewage and grey water system cleaning, freeboard and weatherdeck preservation, underwater body preservation, cathodic protection system maintenance, drydocking, temporary services, and sea trial support. The contract also includes open and inspect repair items priced on a labor rate basis (2,051 hours) with a material markup/handling fee of $87,900 serving as the fixed price ceiling for unforeseen repairs.

The foreseeable cost worksheet requires contractors to calculate distance-based factors including Port Engineer/Contracting Officer transportation by air or car, per diem allowances for crew and government personnel, cutter operational costs, family separation allowances for crew with dependents ($9,637.81 calculated for 13 personnel over 89 days at $8.33 daily), and crew home visit transportation. All pricing is structured on a job basis with unit prices and extended prices to be completed by the contractor. The worksheet directs contractors to utilize specific government resources including NOAA nautical charts, GSA per diem and airfare rates, and commercial port distance calculators to accurately calculate foreseeable costs. The estimated period of performance is November 10, 2026 through March 9, 2027.

View the file

Other files

On GovTribe

Work with this file

  • 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 WILLIAM SPARLING (WPC-154) DRYDOCK AVAILABILITY FY2027
ITEMDESCRIPTIONUNIT PRICEUNITQTYEXTENDED PRICE
D-001Hull Plating, InspectJOB$0.00
D-002Tanks and Voids, Inspect and PreserveJOB$0.00
D-003Watertight Closures, AssessJOB$0.00
D-004Louver and Damper Assembly, Inspect and RepairJOB$0.00
D-005Propulsion Shafting System, Inspect and RepairJOB$0.00
D-006ASW/Firemain System Components, Renew/OverhaulJOB$0.00
D-007Electrical Power Distribution System, Thermographic Inspection (450 VAC And Below)JOB$0.00
D-008Machinery Ventilation System, CleanJOB$0.00
D-009HVAC Duct System, CleanJOB$0.00
D-010Rudder Assemblies, Inspect and RepairJOB$0.00
D-011Stabilizing Fins, Inspect and RepairJOB$0.00
D-012Bow Thruster Propeller and Tunnel, Inspect and RepairJOB$0.00
D-013Stern Launch Door, Inspect and PreserveJOB$0.00
D-014Sewage and Grey Water System, Clean and InspectJOB$0.00
D-015Freeboard, PreserveJOB$0.00
D-016Weatherdecks, PreserveJOB$0.00
D-017U/W Body, PreserveJOB$0.00
D-018Impressed Current Cathodic Protection (ICCP) and Anti-Fouling System, Inspect and MaintainJOB$0.00
D-019DrydockingJOB$0.00
D-020Temporary Services, Provide - CutterJOB$0.00
D-021Sea Trial Performance, Support, ProvideJOB$0.00
D-022Bilges, Clean and Partial Preserve(PLACEHOLDER)JOB$0.00
D-023Stern Tube Interiors, PreserveJOB$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
Open and Inspect Repairs
The Labor Rates and Material Markup/Handling Fee will be used throughout the life of the contract for all open and inspect repair items. The total extended price for both CLINs below are being used solely for the purposes of evaluating price.
OA/G-001**Provide breakdown, as follows:

Labor Rate

Unit Price: $________; Quantity: 2051 ; Unit of Issue: Hour; Extended Price: $____________Hour2051$0.00
OA/G-002Material Markup/Handling Fee

Unit Price: $87,900.00; Quantity: 1; Unit of Issue: Percent ________%;

Extended Price: [$87,900.00 X percentage quoted]: $______________$87,900.00Percent$0.00
Total Fixed Price Ceiling of Open and Inspect Repairs$0.00

&C(3/9/2026) Draft-1 - Page &P of &N Contractors will enter labor rate here.

Contractors will enter material markup/handling fee here.

Foreseeable Cost

FORESEEABLE COST WORKSHEET
USCGC WILLIAM SPARLING WPC-1154FY27
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: 427 Commercial St Boston, MA 02109
NAUTICAL MILES BASED ON ROUND-TRIP (TO AND FROM)
NUMBER OF DAYS OF AVAILABILITY119
(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=25
B. Total number of day(s) in drydock.B=119
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=$240.00
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=13
B. Number of Days for Availability minus 30 days if availability is greather than 30 days:B=89
C. A multiplied by B = C (Daily FSA rate of $8.33)C=$9,637.81
(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=13
B. Number of Homeport Visits:B=2
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. Per Diem for Contracting Officer (KO)$0.00
5. Cutter Cost Operations Factors$0.00
6. Family Separation Allowance$9,637.81
7. Crew Transportation Home Visit$0.00
Total Cost of Distance Factors:$9,637.81
Total Contractor Quoted/Proposal Price:$0.00
TOTAL EVALUATED QUOTE/PRICE$9,637.81

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

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