Attachment 1 - SAGINAW (WLIC 160B) DD FY 25 - Work Items.xls
XLS spreadsheet 89 KB Posted
- Solicitation number
- 70Z08525QIBCT0001
About this file
This file is a pricing schedule spreadsheet for the USCGC SAGINAW (WLIC-160B) drydock availability in FY2025, containing 71 line items for various ship repair and maintenance work. The work items include hull inspections, preservation work, tank cleaning, shaft and propeller maintenance, rudder assembly work, and various system overhauls and renewals. The spreadsheet is structured with definite items (D-prefix) and optional items (O-prefix), with each line item requiring unit pricing for one job unit.
The document includes labor rate information for multiple geographic locations and contains spaces for cost breakdowns including direct labor hours, material costs, and subcontractor information. This appears to be part of an Independent Government Estimate (IGE) that accounts for historical pricing data, COVID impacts, and inflation. The spreadsheet shows fields for composite labor rates, G&A factors, and profit factors, though no actual prices are filled in on the version provided.
View the file
Other files
Show all 11
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 SAGINAW (WLIC-160B) DRYDOCK AVAILABILITY FY2025 | |||||
| ITEM | DESCRIPTION | UNIT PRICE | UNIT | QTY | EXTENDED PRICE |
| D-001 | Fire Prevention Requirements | NSP | NSP | 1 | NSP |
| D-002 | Hull Plating, U/W Body, Inspect | JOB | 1 | $0.00 | |
| D-003 | Hull Plating, U/W Body, Ultrasonic Testing | JOB | 1 | $0.00 | |
| D-004 | Hull Plating, Freeboard, Ultrasonic Testing | JOB | 1 | $0.00 | |
| O-005 | U/W Body, Preserve, 100 percent | JOB | 1 | $0.00 | |
| D-006 | U/W Body, Preserve, Partial, Condition A | JOB | 1 | $0.00 | |
| O-007 | U/W Body, Preserve, Partial, Condition B | JOB | 1 | $0.00 | |
| O-008 | U/W Body, Preserve, Partial, Condition C | JOB | 1 | $0.00 | |
| D-009 | Hull Plating Freeboard, Preserve, Partial | JOB | 1 | $0.00 | |
| O-010 | Hull Plating Freeboard, Preserve, 100 Percent | JOB | 1 | $0.00 | |
| D-011 | Appendages, U/W, Leak Test | JOB | 1 | $0.00 | |
| D-012 | Propulsion Shaft Rope Guards, Inspect | JOB | 1 | $0.00 | |
| D-013 | Appendages, U/W, Internal, Preserve | JOB | 1 | $0.00 | |
| D-014 | Voids, Non-Accessible, Leak Test | JOB | 1 | $0.00 | |
| D-015 | Voids, Non-Accessible, Internal Surfaces, Preserve | JOB | 1 | $0.00 | |
| D-016 | Tanks, MP Fuel Service, Clean and Inspect | JOB | 1 | $0.00 | |
| D-017 | Tanks, Potable Water, Clean and Inspect | JOB | 1 | $0.00 | |
| D-018 | Tanks, Ballast, Clean and Inspect | JOB | 1 | $0.00 | |
| D-019 | Propulsion Shafting, Strain Gage Alignment, Inspect | JOB | 1 | $0.00 | |
| D-020 | Propulsion Shaft Seals (Mechanical), Clean and Inspect | JOB | 1 | $0.00 | |
| D-021 | Propulsion Shaft Seals (Inflatable), Overhaul and Inflatable Renewal | JOB | 1 | $0.00 | |
| D-022 | Propulsion Shafting; Remove, Inspect, and Reinstall | JOB | 1 | $0.00 | |
| D-023 | Propulsion Shaft Bearings, External, Check Clearances | JOB | 1 | $0.00 | |
| O-024 | Propulsion Shaft Bearings, External, Renew | JOB | 1 | $0.00 | |
| D-025 | Stern Tube Interior Surfaces, Preserve, 100 Percent | JOB | 1 | $0.00 | |
| D-026 | Propeller s, Remove, Inspect, and Reinstall | JOB | 1 | $0.00 | |
| D-027 | Keel Coolers, Clean, Inspect and Hydro | JOB | 1 | $0.00 | |
| D-028 | Fathometer Transducer, Renew | JOB | 1 | $0.00 | |
| D-029 | Sea Strainers, All Sizes, Renew | JOB | 1 | $0.00 | |
| D-030 | Sea Strainers, Duplex, All Sizes, Overhaul | JOB | 1 | $0.00 | |
| D-031 | Point of Use Potable Water Filters, Install | JOB | 1 | $0.00 | |
| D-032 | Rudder Assembly, Remove, Inspect And Reinstall | JOB | 1 | $0.00 | |
| D-033 | Rudders, Preserve, 100 Percent | JOB | 1 | $0.00 | |
| D-034 | Hull Fittings, Weight Handling Rigging Hardware, Inspect and Test | JOB | 1 | $0.00 | |
| D-035 | Spuds, Overhaul | JOB | 1 | $0.00 | |
| D-036 | Spud Wells, Preserve | JOB | 1 | $0.00 | |
| D-037 | Spud Wells, Inspect | JOB | 1 | $0.00 | |
| D-038 | Boat Davit, Inspect & Service | JOB | 1 | $0.00 | |
| D-039 | Sewage Holding Tanks, Clean and Inspect | JOB | 1 | $0.00 | |
| D-040 | Sewage Piping, Clean and Flush | JOB | 1 | $0.00 | |
| O-041 | Tanks (Sewage Holding), Preserve, 100 percent | JOB | 1 | $0.00 | |
| D-042 | Tanks (Sewage Holding), Preserve, Partial | JOB | 1 | $0.00 | |
| O-043 | Tanks, Ballast, Preserve, 100 Percent | JOB | 1 | $0.00 | |
| D-044 | Tanks, Ballast, Preserve, Partial | JOB | 1 | $0.00 | |
| D-045 | Tanks, MP Fuel Storage and Overflow, Preserve, Partial | JOB | 1 | $0.00 | |
| O-046 | Tanks, Potable Water Preserve, 100 Percent | JOB | 1 | $0.00 | |
| D-047 | Tanks, Potable Water, Preserve, Partial, | JOB | 1 | $0.00 | |
| D-048 | Decks – Exterior (Buoy or Construction Deck), Preserve 100% | JOB | 1 | $0.00 | |
| D-049 | Drydock | JOB | 1 | $0.00 | |
| D-050 | Temporary Services, Provide - Tender | JOB | 1 | $0.00 | |
| D-051 | Sea Trial Performance, Support, Provide | JOB | 1 | $0.00 | |
| D-052 | Lube Oil Storage Tank, Install | JOB | 1 | $0.00 | |
| D-053 | Remote Firemain Gauge Install | JOB | 1 | $0.00 | |
| D-054 | Buoy and Cargo Handling Crane, Shrink Wrap | JOB | 1 | $0.00 | |
| D-055 | Weather Deck Drain, Renew | JOB | 1 | $0.00 | |
| D-056 | Ballast Tank Striker, Renew | JOB | 1 | $0.00 | |
| D-057 | Cathodic Protection, Zinc Anodes, Renew, | JOB | 1 | $0.00 | |
| D-058 | Engine Room Alarm System, Groom | JOB | 1 | $0.00 | |
| O-059 | Lead-Based Paint, 100% Abatement, Perform | JOB | 1 | $0.00 | |
| D-060 | Longitudinal Stiffener, Renew | JOB | 1 | $0.00 | |
| D-061 | Upper Level Deck, Repair | JOB | 1 | $0.00 | |
| D-062 | Sea Chest Vent Piping, Renew | JOB | 1 | $0.00 | |
| D-063 | Deck Covering, Interior, Wet and Dry, Renew | JOB | 1 | $0.00 | |
| O-064 | Watertight Scuttle, External, Renew | JOB | 1 | $0.00 | |
| O-065 | Watertight Door, External, Renew | JOB | 1 | $0.00 | |
| D-066 | Overhaul MK-27 Gyrocompass | JOB | 1 | $0.00 | |
| D-067 | Liferail Stanchion, Renew | JOB | 1 | $0.00 | |
| D-068 | Engine Room Ventilation Fans, Overhaul | JOB | 1 | $0.00 | |
| D-069 | Propulsion Shafts Tachometer, Install | JOB | 1 | $0.00 | |
| D-070 | Fuel Oil (FO) Manifold Valves, Renew | JOB | 1 | $0.00 | |
| D-071 | 02 Level Deck Repair | JOB | 1 | $0.00 | |
| O-00A | Composite Labor Rate | Hour | 350 | 0 | |
| O-00A | 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 | ||||
| This Independent Government Estimate (IGE) was created using past pricing on similar projects using historical data from Contract Workbook Database. COVID impact on labor and supply chains and inflation are also taken into account |
&C(9/4/2024) Rev-0 - Page &P of &N
CostEstimateBreakdowns
| Composite Labor Rate | ||||||||||||||||||||||||
| Assumed G&A Factor | % | |||||||||||||||||||||||
| Assumed Profit Factor | % | 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
Sheet1
| Compatibility Report for 2b. SAGINAW IGE (WLIC 160B) DD FQ2 .xls | ||
| Run on 11/25/2024 10:50 | ||
| If the workbook is saved in an earlier file format or opened in an earlier version of Microsoft Excel, the listed features will not be available. | ||
| Significant loss of functionality | # of occurrences | Version |
| Some cells contain conditional formatting with the 'Stop if True' option cleared. Earlier versions of Excel do not recognize this option and will stop after the first true condition. | 1 | |
| CostEstimateBreakdowns'!A1 | Excel 97-2003 | |
| Some cells in this workbook contain data validation rules, which refer to values on other worksheets. These rules won't be saved. | 1 | |
| CostEstimateBreakdowns'!C1 | Excel 97-2003 |
CostEstimateBreakdowns'!A1 CostEstimateBreakdowns'!C1
File details come from the government source that posted it. Updated .