Blank_Schedule_Heriberto_Hernandez.xlsx
XLSX spreadsheet 41 KB Posted
- Attached to
- USCGC HERIBERTO HERNANDEZ Federal contract opportunity
- Solicitation number
- 70Z08018QP4596800
About this file
SCHEDULE FOR USCGC HERIBERTO HERNANDEZ FY18 DS REPAIRS
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| HERIBERTO_HERNANDEZ_SPEC.pdf | ||
| Heriberto_Hernandez__Dockside_Combined_Synopsis_Solicitation.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
CPD Estimate
| PRICING SCHEDULE FOR: |
| USCGC Heriberto Hernandez (WPC-114) DOCKSIDE AVAILABILITY FY2018 |
| ITEM | DESCRIPTION | UNIT PRICE | UNIT | QTY | EXTENDED PRICE | ||
| D-001 | Bilges, Clean and Partial Preserve | $5,166 | JOB | 1 | $5,166 | AFC | 45 |
| D-002 | Tanks, Clean and Inspect | $19,285 | JOB | 1 | $19,285 | AFC | 45 |
| D-003 | Sewage and Grey Water System, Clean and Inspect | $32,200 | JOB | 1 | $32,200 | AFC | 45 |
| D-00A | GFP Report | NSP | EA | 1 | NSP | ||
| D-00B | Travel and Perdiem | $27,508 | Job | 1 | $27,508 | AFC | 45 |
| Total Price of Definate Items | $84,159 | AFC30 | $0 | ||||
| Total Price of Optional Items | $0 | AFC45 | $84,159 | ||||
| Total Price of Definate and Optional Items | $84,159 |
| Labor Rates for Growth Work | ||
| Electrician | 92 | $/hr |
| Machinest | 92 | $/hr |
| Rigger | 89 | $/hr |
| Welder/Brazer/Shipfitter | 88 | $/hr |
| Painter | 67 | $/hr |
| General Labor/Helper | 51 | $/hr |
| The price estimates for the jobs listed above are based on 1) a direct labor and material estimate, |
| stored in the APM's files, and 2) an estimated composite labor rate of 70 $/hr |
| which is the expected mean composite labor rate for the geographic area where the contract will be executed. |
| The estimated trade labor rates above were calculated by 1) normalizing a sample of BLS wage data for |
| those trades to that estimated composite labor rate and then 2) estimating how the contracted work |
| may be distributed, on average, across those trades. |
| Actual rates quoted by primes will vary based on 1) employee seniority, 2) the prime's home location |
| relative to the location where the contract will be executed, 3) the prime's subcontracting plans, |
| 4) the supply/demand balance of the labor market at the time of solicitation, and 5) variety of |
| other potential factors. The estimated labor rate prices should only be used as a rough guideline |
| for determining if pricing is fair and reasonable. Once the LPTA offer is identified, this estimate |
| can be further refined by PBPL ENG or PDM reps, as necessary, pending discussions with the offeror. |
Blank Schedule for FBO
| PRICING SCHEDULE FOR: |
| USCGC Heriberto Hernandez (WPC-114) DOCKSIDE AVAILABILITY FY2018 |
| ITEM | DESCRIPTION | UNIT PRICE | UNIT | QTY | EXTENDED PRICE |
| D-001 | Bilges, Clean and Partial Preserve | JOB | 1 | $0 | |
| D-002 | Tanks, Clean and Inspect | JOB | 1 | $0 | |
| D-003 | Sewage and Grey Water System, Clean and Inspect | JOB | 1 | $0 | |
| D-00A | GFP Report | NSP | EA | 1 | NSP |
| D-00B | Travel and Perdiem | Job | 1 | $0 | |
| Total Price of Definate Items | $0 | ||||
| Total Price of Optional Items | $0 | ||||
| Total Price of Definate and Optional Items | $0 |
| Labor Rates for Growth Work | |
| Electrician | $/hr |
| Machinest | $/hr |
| Rigger | $/hr |
| Welder/Brazer/Shipfitter | $/hr |
| Painter | $/hr |
| General Labor/Helper | $/hr |
| $/hr | |
| $/hr | |
| $/hr | |
| $/hr | |
| $/hr | |
| NOTE: Enter fully burdened labor rates for the trades listed above, as applicable to this contract. | |
| Add any additional trades/rates that may be applicable, as required, in the blanks provided. |
CPD Estimate-a
| PRICING SCHEDULE FOR: |
| USCGC Heriberto Hernandez (WPC-114) DOCKSIDE AVAILABILITY FY2018 |
| ITEM | DESCRIPTION | UNIT PRICE | UNIT | QTY | EXTENDED PRICE | ||
| D-001 | Bilges, Clean and Partial Preserve | $5,166 | JOB | 1 | $5,166 | AFC | 45 |
| D-002 | Tanks, Clean and Inspect | $19,285 | JOB | 1 | $19,285 | AFC | 45 |
| D-003 | Sewage and Grey Water System, Clean and Inspect | $32,200 | JOB | 1 | $32,200 | AFC | 45 |
| D-00A | GFP Report | NSP | EA | 1 | NSP | ||
| D-00B | Travel and Perdiem | $27,508 | Job | 1 | $27,508 | AFC | 45 |
| Total Price of Definate Items | $84,159 | AFC30 | $0 | ||||
| Total Price of Optional Items | $0 | AFC45 | $84,159 | ||||
| Total Price of Definate and Optional Items | $84,159 |
| The price estimates for the jobs listed above are based on 1) a direct labor and material estimate, |
| stored in the APM's files, and 2) an estimated composite labor rate of 70 $/hr |
| which is the expected mean composite labor rate for the geographic area where the contract will be executed. |
| ------------------------------------- |
Blank Schedule for FBOa
| PRICING SCHEDULE FOR: |
| USCGC Heriberto Hernandez (WPC-114) DOCKSIDE AVAILABILITY FY2018 |
| ITEM | DESCRIPTION | UNIT PRICE | UNIT | QTY | EXTENDED PRICE |
| D-001 | Bilges, Clean and Partial Preserve | JOB | 1 | $0 | |
| D-002 | Tanks, Clean and Inspect | JOB | 1 | $0 | |
| D-003 | Sewage and Grey Water System, Clean and Inspect | JOB | 1 | $0 | |
| D-00A | GFP Report | NSP | EA | 1 | NSP |
| D-00B | Travel and Perdiem | Job | 1 | $0 | |
| Total Price of Definate Items | $0 | ||||
| Total Price of Optional Items | $0 | ||||
| Total Price of Definate and Optional Items | $0 | ||||
| Composite Labor Rate for Growth Work | $/hr |
Offer Analysis Sheet
| Contractor 1 Extended Price | Contractor 2 Extended Price | Contractor 3 Extended Price | Contractor 4 Extended Price | Contractor 5 Extended Price | Contractor 6 Extended Price | |||||||||||||||||||||||
| 70 | 0.15 | 0.1 | ||||||||||||||||||||||||||
| CLIN | Description | Unit Price | Unit | QTY | Extended Price | |||||||||||||||||||||||
| D-001 | Bilges, Clean and Partial Preserve | $5,166 | Job | 1 | $5,166 | 48 | 1806 | 1276.8 | 0 | 168 | ||||||||||||||||||
| D-002 | Tanks, Clean and Inspect | $19,285 | Job | 1 | $19,285 | 232 | 3045 | 0 | 1624 | 812 | ||||||||||||||||||
| D-003 | Sewage and Grey Water System, Clean and Inspect | $32,200 | Job | 1 | $32,200 | 320 | 9800 | 0 | 6720 | 1120 | ||||||||||||||||||
| D-00A | GFP Report | NSP | EA | 1 | NSP | |||||||||||||||||||||||
| D-00B | Travel and Perdiem | $27,508 | Job | 1 | $27,508 | |||||||||||||||||||||||
| Total Price of Definate Items | $84,159 | $0 | -$84,159 | -100% | $0 | -$84,159 | -100% | $0 | -$84,159 | -100% | $0 | -$84,159 | -100% | $0 | -$84,159 | -100% | $0 | -$84,159 | -100% | |||||||||
| Total Price of Optional Items | $0 | $0 | $0 | ERROR:#DIV/0! | $0 | $0 | ERROR:#DIV/0! | $0 | $0 | ERROR:#DIV/0! | $0 | $0 | ERROR:#DIV/0! | $0 | $0 | ERROR:#DIV/0! | $0 | $0 | ERROR:#DIV/0! | |||||||||
| Total Price of Definate and Optional Items | $84,159 | $0 | -$84,159 | -100% | $0 | -$84,159 | -100% | $0 | -$84,159 | -100% | $0 | -$84,159 | -100% | $0 | -$84,159 | -100% | $0 | -$84,159 | -100% |
Source Data for Negotiations
| ESTIMATE SOURCE DATA DETAILS for USCGC Heriberto Hernandez (WPC-114) DOCKSIDE AVAILABILITY FY2018 | |||||||||||
| Unit | Extended | Hours | Labor Price | Material Price (ODCm) | Sub-svcs Price (ODCs) | Consumables Price (ODCc) | Estimate Description | ||||
| D-001 | Bilges, Clean and Partial Preserve | $5,166 | JOB | 1 | $5,166 | 48 | $3,360 | $1,596 | $0 | $210 | [1] bilges x 2b 2d(8h) + 38% ODCm (solvent, paint, etc) + 0% ODCs + 5% ODCc (rags, gloves, etc) |
| D-002 | Tanks, Clean and Inspect | $19,285 | JOB | 1 | $19,285 | 232 | $16,240 | $0 | $2,030 | $1,015 | 6 large tks[fuel svc/strg] x 2b 1.5d(8h) per tank + 5 small tks [ovrfl, OW,DO, aft void] x 2b 1d(8h) per tank + 1 EDG Tank [1b 1d(8h)] + 10% ODCs (diposal, etc) + 5% ODCc |
| D-003 | Sewage and Grey Water System, Clean and Inspect | $32,200 | JOB | 1 | $32,200 | 320 | $22,400 | $0 | $8,400 | $1,400 | 5b 5d(8h) sewage sys, 3b 5d(8h) grey wtr sys + 30% ODCs (temp bathrm/shower, disposal costs, etc) + 5% ODCc |
| Travel and Per Diem | $27,508 | Total | |||||||||
| Assume an average of 7 hotel rooms will be required per night (i.e. avg direct-labor-crew size, including supervisiors and/or ship superintendents, each individual gets a single hotel room). | |||||||||||
| Assume 187 $/day Total Per Diem Rate (daily room rate plus food rate, each individual above expends this each day.) | |||||||||||
| Assume 20 hotel nights will be needed (i.e. 1 night for each day of estimated duration, plus 1 night on front end for a travel day) | |||||||||||
| Assume 300 miles is the one-way road distance from the prime contractor's facility to the the contract performance loaction (e.g. cutter homeport, etc.). | |||||||||||
| Assume the contractor will drive 3 vehicles from his facility to the cutter, and assume each will be driven an additional 10 miles of local travel per day. | |||||||||||
| Based on the above, assume a combined total of 2370 miles will be put on all 3 vehicles. Assume that cost will be at the GSA milage rate of 0.56 $/mile. | |||||||||||
| Total Per Diem Cost (Hotel/Meals) = 7 rooms/meals x 187 $/day x 20 hotel nights = $26,180 | |||||||||||
| Total Travel Cost = 2370 total miles x 0.56 $/mile = $1,327 |
CWD Input Table
| CLIN | Item # per ORG | AFC | SWBS | Item Description | Spec Author | Spending Category | Spec # | NOUN | Unit | IGE Unit Price | Quantity | IGE Max Price | Growth Risk |
| D-001 | 45 | 631 | Bilges, Clean and Partial Preserve | Ward, James L | RM | BILGES | JOB | 5,166 | 1 | ||||
| D-002 | 45 | 120 | Tanks, Clean and Inspect | Ward, James L | RM | TANKS | JOB | 19,285 | 1 | ||||
| D-003 | 45 | 590 | Sewage and Grey Water System, Clean and Inspect | Ward, James L | RM | PIPING | JOB | 32,200 | 1 |
File details come from the government source that posted it.