Attachment 1 Schedule of Services_Rev.xlsx

XLSX spreadsheet 28 KB Posted

Attached to
DRYDOCK: USCGC FREDERICK HATCH DD FY25 Federal contract opportunity
Solicitation number
70Z08025QPBPL0002
Issued by
Department of Homeland Security US Coast Guard

About this file

This is a pricing schedule spreadsheet for the USCGC Frederick Hatch (WPC-154) FY2025 drydock availability maintenance contract, containing line items for various inspection, repair, and preservation work. The schedule includes 24 definite work items covering tasks such as hull plating inspection, tank preservation, sewage system cleaning, rudder repairs, HVAC cleaning, and various preservation work for underwater body, freeboard, and superstructure components. The document also includes provisions for over-and-above growth work with 2,706 estimated labor hours and material markup calculations.

The pricing schedule incorporates a detailed foreseeable costs worksheet that accounts for travel expenses, per diem rates, and family separation allowances for a 119-day availability period. The worksheet specifically calculates costs for 25 ship's crew and port engineer personnel, with provisions for 12 crew members eligible for family separation allowance at $8.33 daily rate. The contract work is to be performed at US Naval Activities Victor Wharf Pier 3 in Santa Rita, Guam, with the total evaluated price comprising both the contractor's quoted price and distance factor costs of $8,896.44 for family separation allowance.

View the file

Other files for this federal contract opportunity

Other files attached to DRYDOCK: USCGC FREDERICK HATCH DD FY25, newest first.
File Type Posted
Attachment1 Schedule of Services_Rev HATCH DD.xlsx XLSX spreadsheet
Attachment 3 - Operational Foreseeable Cost.xlsx XLSX spreadsheet
70Z08025QPBPL00020004_US signed.pdf PDF
QUESTIONS_ANSWERS.pdf PDF
70Z08025QPBPL00020003.pdf PDF
70Z08025QPBPL00020002_US HATCH signed.pdf PDF
70Z08025QPBPL00020001_US HATCH Amendment signed.pdf PDF
70Z08025QPBPL0002_0_US COMBINED SYNOPSIS SOLICITATION FREDERICK HATCH DD REPAIRS.pdf PDF
Schedule of Services - CGC FREDERICK HATCH DD.xlsx XLSX spreadsheet
5. FREDERICK HATCH (WPC 154) DRYDOCK REV 0.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 FREDERICK HATCH (WPC-154) DRYDOCK AVAILABILITY FY2025
ITEMDESCRIPTIONUNIT PRICEUNITQTYEXTENDED PRICE
D-001Hull Plating, InspectJOB1$0.00
D-002Tanks and Voids, Inspect and PreserveJOB1$0.00
D-003Sewage and Grey Water System, Clean and InspectJOB1ERROR:#VALUE!
D-004Stern Tube Interiors, PreserveJOB1ERROR:#VALUE!
D-005Rudder Assemblies, Inspect and RepairJOB1ERROR:#VALUE!
D-006Stabilizing Fins, Inspect and RepairJOB1ERROR:#VALUE!
D-007Propulsion Shafting System, Inspect and RepairJOB1ERROR:#VALUE!
D-008Bow Thruster Propeller and Tunnel, Inspect and RepairJOB1ERROR:#VALUE!
D-009HVAC Duct System, CleanJOB1ERROR:#VALUE!
D-010Machinery Ventilation System, CleanJOB1ERROR:#VALUE!
D-011ASW/Firemain System Components, Renew/OverhaulJOB1ERROR:#VALUE!
D-012Impressed Current Cathodic Protection (ICCP) and Anti-Fouling System, Inspect and MaintainJOB1ERROR:#VALUE!
D-013Stern Launch Door, Inspect and PreserveJOB1ERROR:#VALUE!
D-014Electrical Power Distribution System, Thermographic Inspection (450 VAC And Below)JOB1ERROR:#VALUE!
D-015DrydockingJOB1ERROR:#VALUE!
D-016Temporary Services, Provide - CutterJOB1ERROR:#VALUE!
D-017U/W Body, PreserveJOB1ERROR:#VALUE!
D-018Freeboard, PreserveJOB1ERROR:#VALUE!
D-019Weatherdecks, PreserveJOB1ERROR:#VALUE!
D-020Superstructure, PreserveJOB1ERROR:#VALUE!
D-021Mast, PreserveJOB1ERROR:#VALUE!
D-022Louver Assembly, OverhaulJOB1ERROR:#VALUE!
D-023Watertight Closures, AssessJOB1ERROR:#VALUE!
D-024Sea Trial Performance, Support, ProvideJOB1ERROR:#VALUE!
O-00AComposite Labor RateHour0ERROR:#VALUE!
D-00BGFP ReportNSPEANSP
D-00CTravel and PerdiemJOB1$0.00
O-00ZLaydaysDay5ERROR:#VALUE!
Total Price of Definite ItemsERROR:#VALUE!
Total Price of Option ItemsERROR:#VALUE!
Total Price of Definite and Optional ItemsERROR:#VALUE!
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:Hour2706$0.00
Over and Above/Growth Labor Rate
Unit Price: $.00_; Quantity: 2706 ; Unit of Issue: Hour; Extended Price: $____________
OA/G-002Over and Above/Growth Material Markup/Handling Fee$104,398.74%ERROR:#VALUE!
Unit Price: $104,398.74; Quantity: 1; Unit of Issue: Percent ________%;
Extended Price: [$104,398.74 X percentage quoted]: $______________
Total Price for Over and Above/GrowthERROR:#VALUE!

Foreseeble Costs

FORESEEABLE COST WORKSHEET
USCGC FREDERICK HATCHFY25
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:US NAVAL ACTIVITIES VICTOR WHARF PIER 3 SANTA RITA GU 96915
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=2
C. A multiplied by B:AxB=C=2
D. Travel cost per trip:D=

Massey, Marc A CIV: 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.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 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=

Massey, Marc A CIV: 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.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=$51.04
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=12

Strawbridge, Tracey CIV: Do Not Change this cell unless Drydock is less than 50 driving miles from Homeport. Then enter 0.

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=$8,896.44
(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=12
B. Number of Homeport Visits:B=2
C Mileage to homeport = (Roundtrip Ticket Cost)C=

Massey, Marc A CIV: 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 Massey, Marc A CIV: Contractor enters name here Massey, Marc A CIV: Contractors shall utilize https://www.gsa.gov/travel/plan-book/per-diem-rates/per-diem-rates-lookup to estimate per diem rates Massey, Marc A CIV: 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.

Massey, Marc A CIV: Contractor shall utilize: https://nauticalcharts.noaa.gov/publications/docs/distances.pdf http://ports.com/sea-route/ Massey, Marc A CIV: 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.

Strawbridge, Tracey CIV: Do Not Change this cell unless Drydock is less than 50 driving miles from Homeport. Then enter 0.

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$8,896.44
6. Crew Transportation Home Visit$0.00
Total Cost of Distance Factors:$8,896.44
Total Contractor Quoted/Proposal Price:ERROR:#VALUE!
TOTAL EVALUATED QUOTE/PRICEERROR:#VALUE!

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