Attachment 1 Bid Schedule Roofing (MS Excel Interactive Document).xlsx
XLSX spreadsheet 21 KB Posted
- Attached to
- Roofing IDIQ- Plains Area - South
- Solicitation number
- 12805B21R0003
View the file
Other files
Show all 24
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
Price Eval Summary
| Attachment 1 - Interactive Bid Schedule | ||||
| The Spreadsheet will automatically calcluate the Total Evaluated Annual Amount Estimate for each option CLIN once you enter values in "FFP Labor Rates" tab and "Materials and Equipment" tab | ||||
| Contractor shall enter amounts from cells E12, E14, E16, E18, and E20 to Solicitation Page 4, B.3 to the corresponding "Schedule of Items" for each CLIN. | ||||
| CLIN | Description | Quantity | Unit of Issue | Evaluated Contract Price |
0001 Base Year Roofing 1 Dollars $1,250,000.00
1001 1st Option Roofing 1 Dollars $1,281,250.00
2001 2nd Option Roofing 1 Dollars $1,313,281.25
3001 3rd Option Roofing 1 Dollars $1,346,113.28
4001 4th Option Roofing 1 Dollars $1,379,766.11
Evaluated Contract Total with All Options $6,570,410.64
FFP Labor Rates Offers shall enter a Firm-Fixed-Price (FFP) Fully Burdened Labor Rate into EVERY labor category for ALL contract years, as indicated in C.1.2.1. Every "Yellow" block in this sheet shall be populated.
| Base Year | 1st Option | ||||||
| Direct Labor Category | Estimated Hours | Proposed FFP Fully Burdened Labor Hourly Rate | Total | Direct Labor Category | Estimated Hours | Proposed FFP Fully Burdened Labor Hourly Rate | Total |
| On-Site Superintendent | 3120 | $0.00 | On-Site Superintendent | 3120 | $0.00 | ||
| Roofer | 5200 | $0.00 | Roofer | 5200 | $0.00 | ||
| Laborer - General | 5200 | $0.00 | Laborer - General | 5200 | $0.00 | ||
| Painter | 480 | $0.00 | Painter | 480 | $0.00 | ||
| Carpenter | 480 | $0.00 | Carpenter | 480 | $0.00 | ||
| Truck Driver - Dump | 120 | $0.00 | Truck Driver - Dump | 120 | $0.00 | ||
| Operator - Steer/Skid Loader | 120 | $0.00 | Operator - Steer/Skid Loader | 120 | $0.00 | ||
| Operator - Crane | 240 | $0.00 | Operator - Crane | 240 | $0.00 | ||
| Operator - Forklift | 240 | $0.00 | Operator - Forklift | 240 | $0.00 | ||
| Truck Driver - Semi | 120 | $0.00 | Truck Driver - Semi | 120 | $0.00 | ||
| Electrician | 240 | $0.00 | Electrician | 240 | $0.00 | ||
| Plumber | 240 | $0.00 | Plumber | 240 | $0.00 | ||
| Pipefitter | 240 | $0.00 | Pipefitter | 240 | $0.00 | ||
| Sheet Metal Worker | 240 | $0.00 | Sheet Metal Worker | 240 | $0.00 | ||
| Welder | 120 | $0.00 | Welder | 120 | $0.00 | ||
| Heat & Frost Insulator | 120 | $0.00 | Heat & Frost Insulator | 120 | $0.00 | ||
| Asbestos Worker | 120 | $0.00 | Asbestos Worker | 120 | $0.00 | ||
| Architect | 100 | $0.00 | Architect | 100 | $0.00 | ||
| Mechanical Engineer | 100 | $0.00 | Mechanical Engineer | 100 | $0.00 | ||
| Electrical Engineer | 100 | $0.00 | Electrical Engineer | 100 | $0.00 | ||
| Civil Engineer | 60 | $0.00 | Civil Engineer | 60 | $0.00 | ||
| Structural Engineer | 60 | $0.00 | Structural Engineer | 60 | $0.00 | ||
| CADD Operator | 100 | $0.00 | CADD Operator | 100 | $0.00 |
Total $0.00 Total $0.00
| 2nd Option | 3rd Option | ||||||
| Direct Labor Category | Estimated Hours | Proposed FFP Fully Burdened Labor Hourly Rate | Total | Direct Labor Category | Estimated Hours | Proposed FFP Fully Burdened Labor Hourly Rate | Total |
| On-Site Superintendent | 3120 | $ - 0 | On-Site Superintendent | 3120 | $ - 0 | ||
| Roofer | 5200 | $ - 0 | Roofer | 5200 | $ - 0 | ||
| Laborer - General | 5200 | $ - 0 | Laborer - General | 5200 | $ - 0 | ||
| Painter | 480 | $ - 0 | Painter | 480 | $ - 0 | ||
| Carpenter | 480 | $ - 0 | Carpenter | 480 | $ - 0 | ||
| Truck Driver - Dump | 120 | $ - 0 | Truck Driver - Dump | 120 | $ - 0 | ||
| Operator - Steer/Skid Loader | 120 | $ - 0 | Operator - Steer/Skid Loader | 120 | $ - 0 | ||
| Operator - Crane | 240 | $ - 0 | Operator - Crane | 240 | $ - 0 | ||
| Operator - Forklift | 240 | $ - 0 | Operator - Forklift | 240 | $ - 0 | ||
| Truck Driver - Semi | 120 | $ - 0 | Truck Driver - Semi | 120 | $ - 0 | ||
| Electrician | 240 | $ - 0 | Electrician | 240 | $ - 0 | ||
| Plumber | 240 | $ - 0 | Plumber | 240 | $ - 0 | ||
| Pipefitter | 240 | $ - 0 | Pipefitter | 240 | $ - 0 | ||
| Sheet Metal Worker | 240 | $ - 0 | Sheet Metal Worker | 240 | $ - 0 | ||
| Welder | 120 | $ - 0 | Welder | 120 | $ - 0 | ||
| Heat & Frost Insulator | 120 | $ - 0 | Heat & Frost Insulator | 120 | $ - 0 | ||
| Asbestos Worker | 120 | $ - 0 | Asbestos Worker | 120 | $ - 0 | ||
| Architect | 100 | $ - 0 | Architect | 100 | $ - 0 | ||
| Mechanical Engineer | 100 | $ - 0 | Mechanical Engineer | 100 | $ - 0 | ||
| Electrical Engineer | 100 | $ - 0 | Electrical Engineer | 100 | $ - 0 | ||
| Civil Engineer | 60 | $ - 0 | Civil Engineer | 60 | $ - 0 | ||
| Structural Engineer | 60 | $ - 0 | Structural Engineer | 60 | $ - 0 | ||
| CADD Operator | 100 | $ - 0 | CADD Operator | 100 | $ - 0 |
Total $0.00 Total $0.00
| 4th Option | |||
| Direct Labor Category | Estimated Hours | Proposed FFP Fully Burdened Labor Hourly Rate | Total |
| On-Site Superintendent | 3120 | $0.00 | |
| Roofer | 5200 | $0.00 | |
| Laborer - General | 5200 | $0.00 | |
| Painter | 480 | $0.00 | |
| Carpenter | 480 | $0.00 | |
| Truck Driver - Dump | 120 | $0.00 | |
| Operator - Steer/Skid Loader | 120 | $0.00 | |
| Operator - Crane | 240 | $0.00 | |
| Operator - Forklift | 240 | $0.00 | |
| Truck Driver - Semi | 120 | $0.00 | |
| Electrician | 240 | $0.00 | |
| Plumber | 240 | $0.00 | |
| Pipefitter | 240 | $0.00 | |
| Sheet Metal Worker | 240 | $0.00 | |
| Welder | 120 | $0.00 | |
| Heat & Frost Insulator | 120 | $0.00 | |
| Asbestos Worker | 120 | $0.00 | |
| Architect | 100 | $0.00 | |
| Mechanical Engineer | 100 | $0.00 | |
| Electrical Engineer | 100 | $0.00 | |
| Civil Engineer | 60 | $0.00 | |
| Structural Engineer | 60 | $0.00 | |
| CADD Operator | 100 | $0.00 |
Total $0.00
Material and Equipment Material and Equipment Overhead and Profit Rate
| Offers shall enter a Firm-Fixed-Price (FFP) Material and Equipment Overhead and Profit Rate for ALL contract years, as indicated in C.1.2.2. Every "Yellow" block in this sheet shall be populated. |
| Offers shall not adjust the Estimated Dollar Values listed in Column C, or adjust the forumlas. |
CLIN Description Estimated Dollar Value Material and Equipment Overhead and Profit Rate Overhead and Profit Rate Applied Evaluated Contract Price
0001 Base Year Material and Equipment $1,250,000.00 $0.00 $1,250,000.00
1001 1st Option Year Material and Equipment $1,281,250.00 $0.00 $1,281,250.00
2001 2nd Option Year Material and Equipment $1,313,281.25 $0.00 $1,313,281.25
3001 3rd Option Year Material and Equipment $1,346,113.28 $0.00 $1,346,113.28
4001 4th Option Year Material and Equipment $1,379,766.11 $0.00 $1,379,766.11
Total $6,570,410.64
File details come from the government source that posted it. Updated .