FRANK_DREW_(WLM_175)_DS_JCC_15ER0_(Blank).xlsx
XLSX spreadsheet 27 KB Posted
- Attached to
- USCGC FRANK DREW (WLM 557) Dock Side Repairs
- Solicitation number
- HSCG85-15-Q-P45026
About this file
SUPPLIES/SERVICES AND PRICES/COSTS
View the file
Other files
| File | Type | Posted |
|---|---|---|
| USCGC_FRANK_DREW_-_Award_-_Contract_Number_HSCG85-15-C-P45026.pdf | ||
| FRANK_DREW_(WLM_175)_DS_JCC_15R0.docx | DOCX document | |
| CGC_FRANK_DREW_SOLICITATION_(12022014).docx | DOCX document | |
| PAST_PERFORMANCE_QUESTIONAIRE.docx | DOCX document |
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: | APM | LTJG Jonathan Copley |
| USCGC FRANK DREW (WLM-175) DOCKSIDE AVAILABILITY FY2015 | Date Spec Due | 7-Oct-14 |
| Date Est Due | 7-Oct-14 |
| ITEM | DESCRIPTION | UNIT PRICE | UNIT | QTY | EXTENDED PRICE |
| D-001 | Tanks (Hydraulic Oil Stowage and Service), Clean and Inspect | $0.00 | JOB | 1 | $0.00 |
| D-002 | Tanks (Potable Water), Clean and Inspect | $0.00 | JOB | 1 | $0.00 |
| D-003 | Tanks (Ballast), Clean and Inspect | $0.00 | JOB | 1 | $0.00 |
| D-004 | Tanks (Dirty Oil and Waste), Clean and Inspect | $0.00 | JOB | 1 | $0.00 |
| D-005 | Circuit Breakers (60 Hz), Inspect and Test | $0.00 | JOB | 1 | $0.00 |
| D-006 | Vent Ducts (Engine and Motor Room All), Commercial Cleaning | $0.00 | JOB | 1 | $0.00 |
| D-007 | Vent Ducts (Galley and Pantry Room All), Commercial Cleaning | $0.00 | JOB | 1 | $0.00 |
| D-008 | Vent Ducts (Laundry Exhaust), Commercial Cleaning | $0.00 | JOB | 1 | $0.00 |
| D-009 | Hydraulic Chain Stoppers, Inspect and Service - Tier II | $0.00 | JOB | 1 | $0.00 |
| D-010 | Crossdeck Winches, Inspect and Service – Tier II | $0.00 | JOB | 1 | $0.00 |
| D-011 | Hydraulic Inhaul Winch, Inspect and Service - Tier II | $0.00 | JOB | 1 | $0.00 |
| D-012 | Buoy Crane, Inspect and Service – Tier II | $0.00 | JOB | 1 | $0.00 |
| D-013 | Deck Machinery/Weight Handling Gear, Preserve - Tier I | $0.00 | JOB | 1 | $0.00 |
| O-014 | Tanks (Ballast), Preserve “Partial” – (O) | $0.00 | JOB | 1 | $0.00 |
| O-015 | Tanks (Dirty Oil and Waste), Preserve “Partial” – (O) | $0.00 | JOB | 1 | $0.00 |
| D-016 | Handrails and Stanchions, Renew | $0.00 | JOB | 1 | $0.00 |
| D-017 | Bilges (Machinery Space) - Engineroom, Preserve | $0.00 | JOB | 1 | $0.00 |
| D-018 | Power Assisted Griping System, Remove | $0.00 | JOB | 1 | $0.00 |
| D-019 | Vent Ducts (All Other), Commercial Cleaning | $0.00 | JOB | 1 | $0.00 |
| D-020 | Main Drainage Deck Box Renew | $0.00 | JOB | 1 | $0.00 |
| D-021 | Sounding Tube Deck Box, Renew | $0.00 | JOB | 1 | $0.00 |
| D-022 | Buoy Deck Cleats, Modification | $0.00 | JOB | 1 | $0.00 |
| O-023 | Remove the constant tension function from the 175 WLM buoy handling crane and main winch. – (O) | $0.00 | JOB | 1 | $0.00 |
| D-024 | Main Diesel Engine (MDE) Exhaust Piping, Commercial Clean | $0.00 | JOB | 1 | $0.00 |
| D-025 | Ship Service Diesel Generator (SSDG) Exhaust Piping, Commercial Clean | $0.00 | JOB | 1 | $0.00 |
| O-026 | Tanks (Potable Water), Preserve “Partial” - (O) | $0.00 | JOB | 1 | $0.00 |
| D-027 | Buoy Deck Equipment Emergency Brake Release Hand Pump, Modify | $0.00 | JOB | 1 | $0.00 |
| O-00A | Composite Labor Rate | $ - 0 | Hour | 630 | $ - 0 |
| D-00B | GFP Report | NSP | EA | NSP | |
| D-00C | Travel and Perdiem | $0.00 | JOB | 1 | $0.00 |
| O-00Z | Laydays | $500.00 | Day | 5 | $2,500.00 |
| Total Price of Definite Items | $0.00 | ||||
| Total Price of Option Items | $0.00 | ||||
| Total Price of Definite and Optional Items | $0.00 |
| Remarks: |
| Was unable to locate the following RWI/TCTO Specs, And need CSMP specs as indicated. |
Brief DesCrption (Include hyperlink to CSMP exported fm FLS) SME Tasked Date Spec Done Type Date Est Done
(10/7/2014)_x000D_ Rev-0 - Page &P of &N
CostEstimateBreakdowns
| Composite Labor Rate | 55 | LTJG Jonathan Copley | ||||||||||||||||||||||||
| Assumed G&A Factor | 15% | 7-Oct-14 | ||||||||||||||||||||||||
| Assumed Profit Factor | 10% | 7-Oct-14 | 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 | ||
| D-001 | Tanks (Hydraulic Oil Stowage and Service), Clean and Inspect | $ - 0 | 0 | 0 | 62 | Baltimore, MD | 69 | 1 | 27 | |||||||||||||||||
| D-002 | Tanks (Potable Water), Clean and Inspect | $ 5,900.00 | 1 | 0 | 45 | 0 | 52 | Biloxi, MS | 75 | 1 | 15 | |||||||||||||||
| D-003 | Tanks (Ballast), Clean and Inspect | $ 9,000.00 | 1 | 0 | 30 | 0 | 56 | Boston, MA | 3996 | 1 | WLM 175 | |||||||||||||||
| D-004 | Tanks (Dirty Oil and Waste), Clean and Inspect | $ 14,000.00 | 1 | 0 | 45 | 0 | 50 | Charleston, SC | 81 | 1 | 0 | |||||||||||||||
| D-005 | Circuit Breakers (60 Hz), Inspect and Test | $ 6,200.00 | 1 | 0 | 45 | 0 | 60 | Corpus Christi, TX | 917 | 1 | 5 | |||||||||||||||
| D-006 | Vent Ducts (Engine and Motor Room All), Commercial Cleaning | $ 30,000.00 | 1 | 0 | 45 | 0 | 51 | Hampton Roads | 300 | 1 | 61 | |||||||||||||||
| D-007 | Vent Ducts (Galley and Pantry Room All), Commercial Cleaning | $ 9,500.00 | 1 | 0 | 45 | 0 | 64 | Honolulu, HI | 301 | 1 | FY2015 | |||||||||||||||
| D-008 | Vent Ducts (Laundry Exhaust), Commercial Cleaning | $ 9,500.00 | 1 | 0 | 45 | 0 | 55 | Houston, TX | 302 | 1 | DS | |||||||||||||||
| D-009 | Hydraulic Chain Stoppers, Inspect and Service - Tier II | $ 5,500.00 | 1 | 0 | 45 | 0 | 56 | Los Angeles, CA | 4004 | 1 | C | |||||||||||||||
| D-010 | Crossdeck Winches, Inspect and Service – Tier II | $ 28,000.00 | 1 | 0 | 45 | 0 | 55 | Median Rate | 2860 | 1 | FRANK DREW (WLM 175) DS JCC 15R0.doc | |||||||||||||||
| D-011 | Hydraulic Inhaul Winch, Inspect and Service - Tier II | $ 30,000.00 | 1 | 0 | 45 | 0 | 49 | Miami | 5157 | 1 | ||||||||||||||||
| D-012 | Buoy Crane, Inspect and Service – Tier II | $ 38,000.00 | 1 | 0 | 45 | 0 | 50 | Narragansett Bay, RI | 2652 | 1 | ||||||||||||||||
| D-013 | Deck Machinery/Weight Handling Gear, Preserve - Tier I | $ 150,000.00 | 1 | 0 | 45 | 0 | 55 | New London, CN | 2934 | 1 | ||||||||||||||||
| D-014 | Tanks (Ballast), Preserve “Partial” – (O) | $ 25,000.00 | 1 | 0 | 45 | 0 | 45 | New Orleans | 489 | 1 | ||||||||||||||||
| O-014 | Tanks (Dirty Oil and Waste), Preserve “Partial” – (O) | $ 30,000.00 | 1 | 0 | 45 | 0 | 62 | NYNY | 493 | 1 | ||||||||||||||||
| O-015 | Handrails and Stanchions, Renew | $ 5,500.00 | 1 | 0 | 45 | 0 | 49 | Panama City, FL | 683 | 1 | ||||||||||||||||
| D-017 | Bilges (Machinery Space) - Engineroom, Preserve | $ 8,000.00 | 1 | 0 | 45 | 0 | 60 | Philadelphia, PA | 5139 | 1 | ||||||||||||||||
| D-018 | Power Assisted Griping System, Remove | $ 55,000.00 | 1 | 0 | 45 | 0 | 51 | Portland, ME | 2864 | 1 | ||||||||||||||||
| D-019 | Vent Ducts (All Other), Commercial Cleaning | $ 28,000.00 | 1 | 0 | 45 | 0 | 57 | Portland, OR | 303 | 1 | ||||||||||||||||
| D-020 | Main Drainage Deck Box Renew | $ 106,000.00 | 1 | 0 | 45 | 0 | 55 | San Diego, CA | 10000 | 0 | ||||||||||||||||
| D-021 | Sounding Tube Deck Box, Renew | $ 3,159.00 | 1 | 0 | 45 | 0 | 67 | San Francisco, CA | 10000 | 0 | ||||||||||||||||
| D-022 | Buoy Deck Cleats, Modification | $ 10,352.00 | 1 | 0 | 45 | 0 | 55 | Santa Barbara, CA | 10000 | 0 | ||||||||||||||||
| D-023 | Remove the constant tension function from the 175 WLM buoy handling crane and main winch. – (O) | $ 30,000.00 | 1 | 0 | 45 | 0 | 55 | SE North Carolina | 10000 | 0 | ||||||||||||||||
| O-023 | Main Diesel Engine (MDE) Exhaust Piping, Commercial Clean | $ 8,820.00 | 1 | 0 | 45 | 0 | 65 | Seattle, WA | 6583 | 1 | ||||||||||||||||
| D-025 | Ship Service Diesel Generator (SSDG) Exhaust Piping, Commercial Clean | $ 22,000.00 | 1 | 0 | 45 | 0 | 48 | Tampa-St. Petersburg | 693 | 1 | ||||||||||||||||
| D-026 | Tanks (Potable Water), Preserve “Partial” | $ 17,000.00 | 1 | 0 | 45 | 0 | 60 | Wilmington, DE | 499 | 1 | ||||||||||||||||
| O-026 | Tanks (Potable Water), Preserve “Partial” - (O) | $ 19,000.00 | 1 | 0 | 45 | 0 | 1615 | 1 | ||||||||||||||||||
| $ 7,500.00 | 1 | 45 | ||||||||||||||||||||||||
| 0 | ||||||||||||||||||||||||||
| $ 48,000.00 | 1 | |||||||||||||||||||||||||
| 0 | ||||||||||||||||||||||||||
| 0 |
(09/28/2009)_x005F_x000D__x000D_ Page &P of &N
CostEstimateTemplate
| Composite Labor Rate | 55 | LTJG Jonathan Copley | ||||||||||||||||||
| Assumed G&A Factor | 15% | 7-Oct-14 | ||||||||||||||||||
| Assumed Profit Factor | 10% | 7-Oct-14 | 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 | |||||||||||||||||
| $5,900 | 1 | 0 | 45 | $0 | 62 | Baltimore, MD | ||||||||||||||
| $9,000 | 1 | 0 | 30 | $0 | 52 | Biloxi, MS | ||||||||||||||
| $14,000 | 1 | 0 | 45 | $0 | 56 | Boston, MA | ||||||||||||||
| $6,200 | 1 | 0 | 45 | $0 | 50 | Charleston, SC | ||||||||||||||
| $30,000 | 1 | 0 | 45 | $0 | 60 | Corpus Christi, TX | ||||||||||||||
| $9,500 | 1 | 0 | 45 | $0 | 64 | Honolulu, HI | ||||||||||||||
| $9,500 | 1 | 0 | 45 | $0 | 55 | Houston, TX | ||||||||||||||
| $5,500 | 1 | 0 | 45 | $0 | 56 | Los Angeles, CA | ||||||||||||||
| $28,000 | 1 | 0 | 45 | $0 | 55 | Median Rate | ||||||||||||||
| $30,000 | 1 | 0 | 45 | $0 | 55 | Median Rate | ||||||||||||||
| $38,000 | 1 | 0 | 45 | $0 | 50 | Narragansett Bay, RI | ||||||||||||||
| 150000 | 1 | 45 | 55 | New London, CN | ||||||||||||||||
| 25000 | 1 | 45 | 45 | New Orleans | ||||||||||||||||
| O-014 | 30000 | 1 | 45 | 62 | NYNY | |||||||||||||||
| O-015 | 5500 | 1 | 45 | 49 | Panama City, FL | |||||||||||||||
| 8000 | 1 | 45 | 60 | Philadelphia, PA | ||||||||||||||||
| 55000 | 1 | 45 | 51 | Portland, ME | ||||||||||||||||
| 28000 | 1 | 45 | 57 | Portland, OR | ||||||||||||||||
| 106000 | 1 | 45 | 55 | San Diego, CA | ||||||||||||||||
| 3159 | 1 | 45 | 67 | San Francisco, CA | ||||||||||||||||
| 10352 | 1 | 45 | 55 | Santa Barbara, CA | ||||||||||||||||
| 30000 | 1 | 45 | 55 | SE North Carolina | ||||||||||||||||
| O-023 | 8820 | 1 | 45 | 65 | Seattle, WA | |||||||||||||||
| 22000 | 1 | 45 | 48 | Tampa-St. Petersburg | ||||||||||||||||
| 17000 | 1 | 45 | 60 | Wilmington, DE | ||||||||||||||||
| O-026 | Tanks (Potable Water), Preserve “Partial” - (O) | 19000 | 1 | 45 | ||||||||||||||||
| 7500 | 1 | 45 | ||||||||||||||||||
| 0 | ||||||||||||||||||||
| 48000 | 1 | |||||||||||||||||||
| 0 | ||||||||||||||||||||
| 0 |
File details come from the government source that posted it. Updated .