Attachment 1 Bid Schedule (MS Excel Interactive Document Final).xlsx
XLSX spreadsheet 20 KB Posted
- Solicitation number
- 12805B20R0010
View the file
Other files
Show all 16
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 Mechanical, Electrical, and Plumbing 1 Dollars $1,800,000.00
1001 1st Option Mechanical, Electrical, and Plumbing 1 Dollars $1,800,000.00
2001 2nd Option Mechanical, Electrical, and Plumbing 1 Dollars $1,800,000.00
3001 3rd Option Mechancial, Electrical, and Plumbing 1 Dollars $1,800,000.00
4001 4th Option Mechanical, Electrical and Plumbing 1 Dollars $1,800,000.00
Evaluated Contract Total with All Options $9,000,000.00
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 | ||
| Carpenter | 1040 | $0.00 | Carpenter | 1040 | $0.00 | ||
| Electrician | 5200 | $0.00 | Electrician | 5200 | $0.00 | ||
| Laborer | 8320 | $0.00 | Laborer | 8320 | $0.00 | ||
| Plumber | 5200 | $0.00 | Plumber | 5200 | $0.00 | ||
| Painter | 1040 | $0.00 | Painter | 1040 | $0.00 | ||
| Pipefitter | 4160 | $0.00 | Pipefitter | 4160 | $0.00 | ||
| Sheet Metal Worker | 4160 | $0.00 | Sheet Metal Worker | 4160 | $0.00 | ||
| Truck Driver | 120 | $0.00 | Truck Driver | 120 | $0.00 | ||
| Asbestos Worker | 120 | $0.00 | Asbestos Worker | 120 | $0.00 | ||
| Concrete Finisher | 120 | $0.00 | Concrete Finisher | 120 | $0.00 | ||
| Operator- Backhoe/Excavator | 120 | $0.00 | Operator- Backhoe/Excavator | 120 | $0.00 | ||
| Operator- Skid Steer | 160 | $0.00 | Operator- Skid Steer | 160 | $0.00 | ||
| Heat& Frost Insulator | 2080 | $0.00 | Heat& Frost Insulator | 2080 | $0.00 | ||
| Welder | 3120 | $0.00 | Welder | 3120 | $0.00 | ||
| Architect | 60 | $0.00 | Architect | 60 | $0.00 | ||
| Mechanical Engineer | 100 | $0.00 | Mechanical Engineer | 100 | $0.00 | ||
| Electrical Engineer | 100 | $0.00 | Electrical Engineer | 100 | $0.00 | ||
| Plumbing Engineer | 100 | $0.00 | Plumbing 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.00 | On-Site Superintendent | 3120 | $0.00 | ||
| Carpenter | 1040 | $0.00 | Carpenter | 1040 | $0.00 | ||
| Electrician | 5200 | $0.00 | Electrician | 5200 | $0.00 | ||
| Laborer | 8320 | $0.00 | Laborer | 8320 | $0.00 | ||
| Plumber | 5200 | $0.00 | Plumber | 5200 | $0.00 | ||
| Painter | 1040 | $0.00 | Painter | 1040 | $0.00 | ||
| Pipefitter | 4160 | $0.00 | Pipefitter | 4160 | $0.00 | ||
| Sheet Metal Worker | 4160 | $0.00 | Sheet Metal Worker | 4160 | $0.00 | ||
| Truck Driver | 120 | $0.00 | Truck Driver | 120 | $0.00 | ||
| Asbestos Worker | 120 | $0.00 | Asbestos Worker | 120 | $0.00 | ||
| Concrete Finisher | 120 | $0.00 | Concrete Finisher | 120 | $0.00 | ||
| Operator- Backhoe/Excavator | 120 | $0.00 | Operator- Backhoe/Excavator | 120 | $0.00 | ||
| Operator- Skid Steer | 160 | $0.00 | Operator- Skid Steer | 160 | $0.00 | ||
| Heat& Frost Insulator | 2080 | $0.00 | Heat& Frost Insulator | 2080 | $0.00 | ||
| Welder | 3120 | $0.00 | Welder | 3120 | $0.00 | ||
| Architect | 60 | $0.00 | Architect | 60 | $0.00 | ||
| Mechanical Engineer | 100 | $0.00 | Mechanical Engineer | 100 | $0.00 | ||
| Electrical Engineer | 100 | $0.00 | Electrical Engineer | 100 | $0.00 | ||
| Plumbing Engineer | 100 | $0.00 | Plumbing 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
| 4th Option | |||
| Direct Labor Category | Estimated Hours | Proposed FFP Fully Burdened Labor Hourly Rate | Total |
| On-Site Superintendent | 3120 | $0.00 | |
| Carpenter | 1040 | $0.00 | |
| Electrician | 5200 | $0.00 | |
| Laborer | 8320 | $0.00 | |
| Plumber | 5200 | $0.00 | |
| Painter | 1040 | $0.00 | |
| Pipefitter | 4160 | $0.00 | |
| Sheet Metal Worker | 4160 | $0.00 | |
| Truck Driver | 120 | $0.00 | |
| Asbestos Worker | 120 | $0.00 | |
| Concrete Finisher | 120 | $0.00 | |
| Operator- Backhoe/Excavator | 120 | $0.00 | |
| Operator- Skid Steer | 160 | $0.00 | |
| Heat& Frost Insulator | 2080 | $0.00 | |
| Welder | 3120 | $0.00 | |
| Architect | 60 | $0.00 | |
| Mechanical Engineer | 100 | $0.00 | |
| Electrical Engineer | 100 | $0.00 | |
| Plumbing 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,800,000.00 $0.00 $1,800,000.00
1001 1st Option Year Material and Equipment $1,800,000.00 $0.00 $1,800,000.00
2001 2nd Option Year Material and Equipment $1,800,000.00 $0.00 $1,800,000.00
3001 3rd Option Year Material and Equipment $1,800,000.00 $0.00 $1,800,000.00
4001 4th Option Year Material and Equipment $1,800,000.00 $0.00 $1,800,000.00
Total $9,000,000.00
File details come from the government source that posted it. Updated .