Attachment 1 - Schedule of Services Bailey Barco DD.xls
XLS spreadsheet 86 KB Posted
- Attached to
- DRYDOCK: USCGC BAILEY BARCO DD FY25
- Solicitation number
- 70Z08025QPBPL0012
About this file
This is a pricing schedule template for the USCGC Bailey Barco (WPC-154) FY2025 drydock availability, accompanied by a foreseeable cost worksheet. The schedule includes 26 definite work items and 1 optional item covering tasks such as hull plating inspection, watertight closure assessment, propulsion system repairs, HVAC cleaning, and preservation work. The contract period is scheduled for 120 days from August 12, 2025 to December 9, 2025.
The pricing template includes provisions for over and above/growth work with 3,792 estimated labor hours and a material markup allowance based on $89,385. The foreseeable cost worksheet accounts for various factors including travel costs, per diem for 25 crew members and port engineer, family separation allowances for 11 crew members ($8.33 daily rate), and operational costs calculated at $44.90 per nautical mile. The work will be performed at 1300 Stedman Street, Ketchikan, AK 99901, with contract oversight from both a Port Engineer/COR and Contracting Officer based in Norfolk, VA.
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 BAILEY BARCO (WPC-154) DRYDOCK AVAILABILITY FY2025 | |||||
| ITEM | DESCRIPTION | UNIT PRICE | UNIT | QTY | EXTENDED PRICE |
| D-001 | Hull Plating, Inspect | JOB | 1 | $0.00 | |
| D-002 | Watertight Closures, Assess | JOB | 1 | $0.00 | |
| D-003 | Louver Assembly, Overhaul | JOB | 1 | $0.00 | |
| D-004 | Louvers and Covers, Moisture Eliminator, Preserve | JOB | 1 | $0.00 | |
| D-005 | Propulsion Shafting System, Inspect and Repair | JOB | 1 | $0.00 | |
| D-006 | ASW/Firemain System Components, Renew/Overhaul | JOB | 1 | $0.00 | |
| D-007 | Ship Service Diesel Generator(s), Clean & Inspect | JOB | 1 | $0.00 | |
| D-008 | Electrical Power Distribution System, Thermographic Inspection (450 VAC And Below) | JOB | 1 | $0.00 | |
| D-009 | Machinery Ventilation System, Clean | JOB | 1 | $0.00 | |
| D-010 | HVAC Duct System, Clean | JOB | 1 | $0.00 | |
| D-011 | Rudder Assemblies, Inspect and Repair | JOB | 1 | $0.00 | |
| D-012 | Stabilizing Fins, Inspect and Repair | JOB | 1 | $0.00 | |
| D-013 | Bow Thruster Propeller and Tunnel, Inspect and Repair | JOB | 1 | $0.00 | |
| D-014 | Stern Launch Door, Inspect and Preserve | JOB | 1 | $0.00 | |
| D-015 | Sewage and Grey Water System, Clean and Inspect | JOB | 1 | $0.00 | |
| D-016 | Bilge Surface, Clean and Inspect | JOB | 1 | $0.00 | |
| D-017 | Forward Void, Float Coat, Renew | JOB | 1 | $0.00 | |
| D-018 | Freeboard, Preserve | JOB | 1 | $0.00 | |
| D-019 | Weatherdecks, Preserve | JOB | 1 | $0.00 | |
| D-020 | U/W Body, Preserve | JOB | 1 | $0.00 | |
| D-021 | Impressed Current Cathodic Protection (ICCP) and Anti-Fouling System, Inspect and Maintain | JOB | 1 | $0.00 | |
| D-022 | Interior Wet Deck Coverings, Reseal | JOB | 1 | $0.00 | |
| D-023 | Interior Deck Covering (Carpeting), Renew | JOB | 1 | $0.00 | |
| D-024 | Drydocking | JOB | 1 | $0.00 | |
| D-025 | Temporary Services, Provide - Cutter | JOB | 1 | $0.00 | |
| D-026 | Sea Trial Performance, Support, Provide | JOB | 1 | $0.00 | |
| O-027 | Grey Water Tank, Preserve (Opt) | JOB | 1 | $0.00 | |
| O-00A | Composite Labor Rate | Hour | 0 | 0 | |
| D-00B | GFP Report | NSP | EA | NSP | |
| O-00Z | Laydays | Day | 5 | $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: | Hour | 3792 | $0.00 | |
| Over and Above/Growth Labor Rate | |||||
| Unit Price: $.00_; Quantity: 3792 ; Unit of Issue: Hour; Extended Price: $____________ | |||||
| OA/G-002 | Over and Above/Growth Material Markup/Handling Fee | $89,385.00 | % | % | $0.00 |
| Unit Price: $89,385.00; Quantity:1 ; Unit of Issue: Percent ________%; | |||||
| Extended Price: [$89,385.00 X percentage quoted]: $______________ | |||||
| Total Price for Over and Above/Growth | $0.00 |
&C(10/9/2024) Draft-00 - Page &P of &N
Foreseeable Costs
| FORESEEABLE COST WORKSHEET | ||
| USCGC BAILEY BARCO | FY25 | |
| 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: 1300 Stedman Street Ketchikan AK 99901 | ||
| NAUTICAL MILES BASED ON ROUND-TRIP (TO AND FROM) | ||
| NUMBER OF DAYS OF AVAILABILITY | 120 | |
| (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 NESU | B= | 10 |
| C. A multiplied by B: | AxB=C= | 10 |
| 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 Engineer | A= | 25 |
| B. Total number of day(s) in drydock. | B= | 120 |
| 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 travel | C= | |
| D. Per diem cost at place of performance, per day | D= | $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= | $44.90 |
| C. A multiplied by B= C | C= | $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= | 11 |
| B. Number of Days for Availability minus 30 days if availability is greather than 30 days: | B= | 90 |
| C. A multiplied by B = C (Daily FSA rate of $8.33) | C= | $8,246.70 |
| (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= | 11 |
| 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. Cutter Cost Operations Factors | $0.00 | |
| 5. Family Separation Allowance | $8,246.70 | |
| 6. Crew Transportation Home Visit | $0.00 | |
| Total Cost of Distance Factors: | $8,246.70 | |
| Total Contractor Quoted/Proposal Price: | $0.00 | |
| TOTAL EVALUATED QUOTE/PRICE | $0.00 |
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 Rate | 55 | |||||||||||||||||||||||
| Assumed G&A Factor | 15% | |||||||||||||||||||||||
| Assumed Profit Factor | 10% | Direct Labor | Direct Material/Subs Cost | |||||||||||||||||||||
| ITEM | DESCRIPTION | UNIT PRICE | Sub-Contracted (put a "1" in the blank) | Total Labor Hours | Total Material & Subs (cost + G&A + profit) | Eng Tech | Machinest/Pipe Fitter | Electrician | Shipfitter | Welder | Firewatch | Insulator/Lagger | Painter | Gen Labor/Helper/Rigger | Supt/QA/NDT | Mat/Sub Cost 1 | Mat/Sub Cost 2 | Mat/Sub Cost 3 | Mat/Sub Cost 4 | Lab Rate | Area | WorkItemID | WIFileID | LoadData |
| 62 | Baltimore, MD | |||||||||||||||||||||||
| 52 | Biloxi, MS | |||||||||||||||||||||||
| 56 | Boston, MA | |||||||||||||||||||||||
| 50 | Charleston, SC | |||||||||||||||||||||||
| 60 | Corpus Christi, TX | |||||||||||||||||||||||
| 51 | Hampton Roads | |||||||||||||||||||||||
| 64 | Honolulu, HI | |||||||||||||||||||||||
| 55 | Houston, TX | |||||||||||||||||||||||
| 56 | Los Angeles, CA | |||||||||||||||||||||||
| 55 | Median Rate | |||||||||||||||||||||||
| 49 | Miami | |||||||||||||||||||||||
| 50 | Narragansett Bay, RI | |||||||||||||||||||||||
| 55 | New London, CN | |||||||||||||||||||||||
| 45 | New Orleans | |||||||||||||||||||||||
| 62 | NYNY | |||||||||||||||||||||||
| 49 | Panama City, FL | |||||||||||||||||||||||
| 60 | Philadelphia, PA | |||||||||||||||||||||||
| 51 | Portland, ME | |||||||||||||||||||||||
| 57 | Portland, OR | |||||||||||||||||||||||
| 55 | San Diego, CA | |||||||||||||||||||||||
| 67 | San Francisco, CA | |||||||||||||||||||||||
| 55 | Santa Barbara, CA | |||||||||||||||||||||||
| 55 | SE North Carolina | |||||||||||||||||||||||
| 65 | Seattle, WA | |||||||||||||||||||||||
| 48 | Tampa-St. Petersburg | |||||||||||||||||||||||
| 60 | Wilmington, DE |
&C(09/28/2009) Page &P of &N
CostEstimateTemplate
File details come from the government source that posted it. Updated .