Attatchment 2 MALLET Blank Section B SOSS revised.xlsx
XLSX spreadsheet 41 KB Posted
- Solicitation number
- 70Z08526QIBCT0002
About this file
This document is a detailed cost estimate spreadsheet for the drydock availability of the USCGC MALLET (WLIC-75B), scheduled for FY2026. The spreadsheet comprehensively itemizes 67 distinct work items related to ship repair and maintenance, including hull plating inspections, underwater body preservation, shaft and propeller maintenance, tank cleaning and preservation, cathodic protection renewal, and various structural repairs. The cost estimate template breaks down potential labor requirements across multiple skill categories such as shipfitters, welders, electricians, and technicians, with specific labor rate considerations for different geographic locations.
The associated federal contract opportunity is a combined synopsis/solicitation issued by the US Coast Guard for an unrestricted ship repair contract under NAICS code 336611, with a small business size standard of 1,300 employees. The solicitation (number 70Z08526QIBCT0002) seeks a contractor to provide comprehensive drydock repair services, using FAR Part 12 Acquisition of Commercial Items and FAR 13.5 Simplified Procedures. The procurement is structured as a Request for Quotation (RFQ) and will cover various technical maintenance and repair tasks for the vessel, with the work to be performed using commercial service standards.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attatchment2-BlankSectionBSOSS revised.xlsx | XLSX spreadsheet | |
| Amendment 70Z08526QIBCT0002A0002.pdf | ||
| Clarifications for Solicitation 70Z08526QIBCT0002.docx | DOCX document | |
| Amendment 70Z08526QIBCT0002A0001.pdf | ||
| Attachment 3 - Past Performance Information Form MALLET.docx | DOCX document | |
| Attatchment 1- Specs.pdf | ||
| 70Z08526QIBCT0002_Final.pdf | ||
| Attachment 4 - Request for Clarification Form.docx | DOCX document | |
| Attatchment 2- Blank Section B SOSS.xlsx | XLSX spreadsheet | |
| Attatchment 5.pdf |
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
| GOVERNMENT ESTIMATE FOR: |
| USCGC MALLET (WLIC-75B) DRYDOCK AVAILABILITY FY2026 |
| ITEM | DESCRIPTION | UNIT PRICE | UNIT | QTY | EXTENDED PRICE |
| D-001 | Fire Prevention Requirements | JOB | 1 | ||
| D-002 | Hull Plating, U/W Body, Inspect - Tender | JOB | 1 | ||
| D-003 | Hull Plating, U/W Body, Ultrasonic Testing - Tender | JOB | 1 | ||
| D-004 | U/W Body, Preserve, 100 percent - Tender | JOB | 1 | ||
| D-005 | Appendages, U/W, Leak Test - Tender | JOB | 1 | ||
| D-006 | Propulsion Shaft Rope Guards, Inspect | JOB | 1 | ||
| D-007 | Voids (Accessible, Weather Deck Exposed), Inspect - Tender | JOB | 1 | ||
| D-008 | Voids, Non-Accessible, Leak Test - Tender | JOB | 1 | ||
| O-009 | Voids, Non-Accessible, Internal Surfaces, Preserve | JOB | 1 | ||
| D-010 | Tanks, MP Fuel Service, Clean and Inspect - Tender | JOB | 1 | ||
| O-011 | Propulsion Shaft Seals, Mechanical Clean and Inspect | JOB | 1 | ||
| D-012 | Propulsion Shaft Seals, Mechanical Overhaul and Inflatable Renew | JOB | 1 | ||
| D-013 | Propulsion Shaft Bearings, External, Check Clearances | JOB | 1 | ||
| O-014 | Propulsion Shaft Bearings, External, Renew | JOB | 1 | ||
| D-015 | Propeller s, Remove, Inspect, and Reinstall | JOB | 1 | ||
| D-016 | Keel Coolers, Clean, Inspect and Hydro | JOB | 1 | ||
| D-017 | Compressed Air Receivers and System Valves, All, Clean, Inspect, Hydro and Lift - Tender | JOB | 1 | ||
| O-018 | Rudders, Preserve, 100 Percent | JOB | 1 | ||
| D-019 | Hull Fittings (Mooring and Towing), Inspect and Test - Tender | JOB | 1 | ||
| D-020 | Boat Boom, Inspect and Service - Tender | JOB | 1 | ||
| D-021 | Sewage Holding Tanks, Clean and Inspect - Tender | JOB | 1 | ||
| D-022 | Sewage Piping, Clean and Flush | JOB | 1 | ||
| D-023 | Tanks, Potable Water Preserve, 100 Percent - Tender | JOB | 1 | ||
| D-024 | Drydock - Tender | JOB | 1 | ||
| D-025 | Sea Trial Performance, Support, Provide | JOB | 1 | ||
| D-026 | Hull Plating, Side Scan, Ultrasonic Testing, Barge - Barge | JOB | 1 | ||
| D-027 | Hull Plating, Freeboard, Ultrasonic Testing - Barge | JOB | 1 | ||
| O-028 | Appendages, U/W, Internal, Preserve - Barge | JOB | 1 | ||
| O-029 | Voids, Non-Accessible, Internal Surfaces, Preserve - Barge | JOB | 1 | ||
| D-030 | Fathometer Transducer, General Maintenance - Barge | JOB | 1 | ||
| D-031 | U/W Body, Preserve, 100 percent - Barge | JOB | 1 | ||
| O-032 | Hull Plating Freeboard, Preserve, 100 Percent - Barge | JOB | 1 | ||
| D-033 | Cathodic Protection, Zinc Anodes, Renew - Barge | JOB | 1 | ||
| D-034 | Drydock - Barge | JOB | 1 | ||
| D-035 | Superstructure Plating Repair | JOB | 1 | ||
| D-036 | Fwd Rake Repair Barge | JOB | 1 | ||
| D-037 | Crew's Head Deck Plating, Repair | JOB | 1 | ||
| D-038 | Boom Rest Repair | JOB | 1 | ||
| D-039 | Sewage Shore Tie Riser, Renew | JOB | 1 | ||
| D-040 | Barge Quick Acting Watertight Scuttle, Renew | JOB | 1 | ||
| D-041 | External Deck Drains, Renew | JOB | 1 | ||
| D-042 | Tender Air Compressors, Renew | JOB | 1 | ||
| D-043 | Drop Ceiling, Renew and Abate | JOB | 1 | ||
| D-044 | Weathertight Doors and Frames, Renew | JOB | 1 | ||
| D-045 | Crew Racks, Renew | JOB | 1 | ||
| D-046 | Mechanical Chain Stoppers, Inspect and Service | JOB | 1 | ||
| D-047 | Temporary Services, Provide - Tender | JOB | 1 | ||
| D-048 | Decks – Exterior (Buoy or Construction Deck), Preserve 100% | JOB | 1 | ||
| D-049 | Deck Covering, Interior, Wet and Dry, Renew | JOB | 1 | ||
| D-050 | Propulsion Shafting; Remove, Inspect, and Reinstall | JOB | 1 | ||
| O-00A | Composite Labor Rate | Hour | |||
| O-00Z | Laydays | Day | 5 | ||
| Total Price of Definite Items | $0.00 | ||||
| Total Price of Option Items | $0.00 | ||||
| Total Price of Definite and Optional Items | $0.00 |
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 | WorkItemID | WIFileID | LoadData |
| D-001 | Hull Plating (Side Scan), Ultrasonic Testing - Barge | $ - 0 | 0 | 0 | 3998 | 1 | 67 | |||||||||||||||
| D-002 | U/W Body, Preserve (100%) - Barge | $ - 0 | 0 | 0 | 1705 | 1 | 32 | |||||||||||||||
| D-003 | Hull Plating Freeboard, Preserve – Partial - Barge | $ - 0 | 0 | 0 | 5236 | 1 | WLIC 75B | |||||||||||||||
| D-004 | Hull Plating Freeboard, Preserve “100%” - Barge | $ - 0 | 0 | 0 | 5404 | 1 | 65 | |||||||||||||||
| D-005 | Hull and Structural Plating (General) -10.2-Pound Steel, Renew - Barge | $ - 0 | 0 | 0 | 1762 | 1 | 1 | |||||||||||||||
| D-006 | Hull and Structural Plating (General) - 12.75-Pound Steel Plate, Renew - Barge | $ - 0 | 0 | 0 | 1763 | 1 | 85 | |||||||||||||||
| D-007 | Hull and Structural Plating (General) - 15.3-Pound Steel Plate, Renew - Barge | $ - 0 | 0 | 0 | 1764 | 1 | FY2021 | |||||||||||||||
| D-008 | Hull And Structural Plating (General) - 20.4-Pound Steel Plate, Renew - Barge | $ - 0 | 0 | 0 | 1765 | 1 | DD | |||||||||||||||
| D-009 | Hull and Structural Plating (General) - 7.5-Pound (3/16") Steel Plate, Renew - Barge | $ - 0 | 0 | 0 | 750 | 1 | cutter | |||||||||||||||
| D-010 | Hull and Structural Plating (General) - 7.65- Pound Steel Plate, Renew - Barge | $ - 0 | 0 | 0 | 2494 | 1 | MALLET (WLIC 75B) DD FQ2 NLR 21R0.doc | |||||||||||||||
| D-011 | Hull And Structural Plating (General) - Cracked Steel Welds, Repairs - Barge | $ - 0 | 0 | 0 | 2442 | 1 | ||||||||||||||||
| D-012 | Hull and Structural Plating -{Insert Plate Size (i.e. 1/2” or 5/16”, etc.) Steel Plate, Renew | $ - 0 | 0 | 0 | 754 | 1 | ||||||||||||||||
| D-013 | Hull and Structural Plating (General) - Degraded Weld (Steel), Repair - Barge | $ - 0 | 0 | 0 | 1212 | 1 | ||||||||||||||||
| D-014 | Propulsion Shaft Rope Guards, Inspect | $ - 0 | 0 | 0 | 10051 | 1 | ||||||||||||||||
| D-015 | Voids (Accessible, Weather Deck Exposed), Inspect- Barge | $ - 0 | 0 | 0 | 2447 | 1 | ||||||||||||||||
| D-016 | Voids (Non-Accessible), Leak Test | $ - 0 | 0 | 0 | 54 | 1 | ||||||||||||||||
| D-017 | Voids (Non-Accessible), Internal Surfaces, Preserve | $ - 0 | 0 | 0 | 67 | 1 | ||||||||||||||||
| D-018 | Tanks (MP Fuel Service), Clean and Inspect - Barge | $ - 0 | 0 | 0 | 9875 | 1 | ||||||||||||||||
| D-019 | Tanks (Potable Water), Clean and Inspect - Barge | $ - 0 | 0 | 0 | 75 | 1 | ||||||||||||||||
| D-020 | Propulsion Shafting; Remove, Inspect, and Reinstall | $ - 0 | 0 | 0 | 144 | 1 | ||||||||||||||||
| D-021 | Propulsion Shaft Seals, Mechanical Clean and Inspect | $ - 0 | 0 | 0 | 9798 | 1 | ||||||||||||||||
| D-022 | Propulsion Shaft Seals, Mechanical Overhaul and Inflatable Renew | $ - 0 | 0 | 0 | 9799 | 1 | ||||||||||||||||
| D-023 | Propulsion Shaft Bearings (External), Check Clearances | $ - 0 | 0 | 0 | 186 | 1 | ||||||||||||||||
| D-024 | Propulsion Shaft Bearings (External), Renew | $ - 0 | 0 | 0 | 194 | 1 | ||||||||||||||||
| D-025 | Stern Tube Interior Surfaces, Preserve 100% | $ - 0 | 0 | 0 | 526 | 1 | ||||||||||||||||
| D-026 | Propellers, Remove, Inspect, and Reinstall | $ - 0 | 0 | 0 | 212 | 1 | ||||||||||||||||
| D-027 | Keel Coolers, Clean, Inspect and Hydro | $ - 0 | 0 | 0 | 247 | 1 | ||||||||||||||||
| D-028 | Fathometer Transducer, Renew – Barge | $ - 0 | 0 | 0 | 9630 | 1 | ||||||||||||||||
| D-029 | Fathometer Transducer, General Maintenance | $ - 0 | 0 | 0 | 10101 | 1 | ||||||||||||||||
| D-030 | Rudder Assembly; Remove, Inspect And Reinstall | $ - 0 | 0 | 0 | 376 | 1 | ||||||||||||||||
| D-031 | Rudder(s), Preserve (“100%”) | $ - 0 | 0 | 0 | 1869 | 1 | ||||||||||||||||
| D-032 | Crossdeck Winch, Inspect and Test - Tender | $ - 0 | 0 | 0 | 7819 | 1 | ||||||||||||||||
| D-033 | Hull Fittings (Mooring and Towing), Inspect and Test - Barge | $ - 0 | 0 | 0 | 6604 | 1 | ||||||||||||||||
| D-034 | Boat Boom, Inspect and Service - Tender | $ - 0 | 0 | 0 | 2743 | 1 | ||||||||||||||||
| D-035 | CG 300 Crane Wire Rope, Renew | $ - 0 | 0 | 0 | 1638 | 1 | ||||||||||||||||
| D-036 | Sewage Holding Tank(s), Clean and Inspect - Tender | $ - 0 | 0 | 0 | 9873 | 1 | ||||||||||||||||
| D-037 | Tanks (Sewage Holding), Preserve “100%” - Tender | $ - 0 | 0 | 0 | 500 | 1 | ||||||||||||||||
| D-038 | Tanks (Sewage Holding), Preserve “Partial” - Tender | $ - 0 | 0 | 0 | 501 | 1 | ||||||||||||||||
| D-039 | Tanks (MP Fuel Service), Preserve “Partial”- Barge | $ - 0 | 0 | 0 | 5238 | 1 | ||||||||||||||||
| D-040 | Tanks (Potable Water), Preserve “100%” - Barge | $ - 0 | 0 | 0 | 2877 | 1 | ||||||||||||||||
| D-041 | Tanks (Potable Water), Preserve, Partial, - Barge | $ - 0 | 0 | 0 | 499 | 1 | ||||||||||||||||
| D-042 | Cathodic Protection, Zinc Anodes, Renew, - Barge | $ - 0 | 0 | 0 | 542 | 1 | ||||||||||||||||
| D-043 | Drydock - Barge | $ 4,300.00 | 140 | 4300 | $140.00 | $4,300.00 | 555 | 1 | ||||||||||||||
| D-044 | Temporary Services, Provide - Barge | $ - 0 | 0 | 0 | 556 | 1 | ||||||||||||||||
| D-045 | Sea Trial Performance, Support, Provide | $ - 0 | 0 | 0 | 563 | 1 | ||||||||||||||||
| D-046 | Barge, Diesel Engine Exhaust Piping, Commercial Clean | $ - 0 | 0 | 0 | 2843 | 3 | ||||||||||||||||
| D-047 | Spuds, Overhaul - Barge | $ - 0 | 0 | 0 | 5057 | 3 | ||||||||||||||||
| D-048 | Spud Wells, Preserve - Barge | $ - 0 | 0 | 0 | 5265 | 3 | ||||||||||||||||
| D-049 | Spud Wells, Inspect - Barge | $ - 0 | 0 | 0 | 2830 | 3 | ||||||||||||||||
| D-050 | Decks – Exterior (Buoy or Construction Deck), Preserve 100% | $ - 0 | 0 | 0 | 2865 | 3 | ||||||||||||||||
| D-051 | Deck Covering (Interior Wet/Dry), Renew | $ - 0 | 0 | 0 | 1731 | 1 | ||||||||||||||||
| D-052 | Lead-Based Paint and Asbestos-Containing Material, Perform Spot Abatement | $ - 0 | 0 | 0 | 9536 | 1 | ||||||||||||||||
| D-053 | Lead-Based Paint, Perform Spot Abatement | $ - 0 | 0 | 0 | 5053 | 1 | ||||||||||||||||
| D-054 | Propeller, Minor Repairs and Reconditioning, Perform | $ - 0 | 0 | 0 | 242 | 1 | ||||||||||||||||
| D-055 | Compressed Air Receivers and System Valves (All), Clean, Inspect, Hydro and Lift - Barge | $ - 0 | 0 | 0 | 347 | 1 | ||||||||||||||||
| D-056 | Sea Strainers (All Sizes), Renew | $ - 0 | 0 | 0 | 10000 | 0 | ||||||||||||||||
| D-057 | Fuel Valves, Renewal | $ - 0 | 0 | 0 | 10000 | 0 | ||||||||||||||||
| D-058 | Switchboard Circuit Breakers, Inspect and Repair/ Replace. | $ - 0 | 0 | 0 | 10000 | 0 | ||||||||||||||||
| D-059 | Compartment Insulation, Renew | $ - 0 | 0 | 0 | 10000 | 0 | ||||||||||||||||
| D-060 | Air Conditioning Plant, System Groom | $ - 0 | 0 | 0 | 10000 | 0 | ||||||||||||||||
| D-061 | Galley Range, Replace | $ - 0 | 0 | 0 | 10000 | 0 | ||||||||||||||||
| D-062 | Bridge Light Control Box, Repair | $ - 0 | 0 | 0 | 10000 | 0 | ||||||||||||||||
| D-063 | Door Framing (External), Renew | $ - 0 | 0 | 0 | 10000 | 0 | ||||||||||||||||
| D-064 | External Doors, Inspect and Repair | $ - 0 | 0 | 0 | 10000 | 0 | ||||||||||||||||
| D-065 | Crew Racks, Renew or Repair | $ - 0 | 0 | 0 | 10000 | 0 | ||||||||||||||||
| D-066 | Watertight Hatch (Barge), Renew | $ - 0 | 0 | 0 | 10000 | 0 | ||||||||||||||||
| D-067 | Vertical Ladder, Renew | $ - 0 | 0 | 0 | 10000 | 0 |
(09/28/2009)_x000D_ Page &P of &N
CostEstimateTemplate
| Composite Labor Rate | |||||||||||||||||
| Assumed G&A Factor | |||||||||||||||||
| Assumed Profit Factor | Direct Labor | Direct Material/Subs Cost | |||||||||||||||
| 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 | |||||
| DESCRIPTION | UNIT PRICE | Lab Rate | Area | ||||||||||||||
| $0 | 0 | $0 | 62 | Baltimore, MD | |||||||||||||
| $0 | 0 | $0 | 52 | Biloxi, MS | |||||||||||||
| $0 | 0 | $0 | 56 | Boston, MA | |||||||||||||
| $0 | 0 | $0 | 50 | Charleston, SC | |||||||||||||
| $0 | 0 | $0 | 60 | Corpus Christi, TX | |||||||||||||
| $0 | 0 | $0 | 64 | Honolulu, HI | |||||||||||||
| $0 | 0 | $0 | 55 | Houston, TX | |||||||||||||
| $0 | 0 | $0 | 56 | Los Angeles, CA | |||||||||||||
| $0 | 0 | $0 | 55 | Median Rate | |||||||||||||
| $0 | 0 | $0 | 55 | Median Rate | |||||||||||||
| $0 | 0 | $0 | 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 |
File details come from the government source that posted it. Updated .