Attachment 1 Bid Schedule Fire Protection.xlsx
XLSX spreadsheet 22 KB Posted
- Attached to
- IDIQ Fire Protection - North
- Solicitation number
- 12805B22R0001
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 ordering period 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 Period - Fire Protection IDIQ 1 Dollars $450,000.00
1001 1st Ordering Period Fire Protection IDIQ 1 Dollars $450,000.00
2001 2nd Ordering Period Fire Protection IDIQ 1 Dollars $450,000.00
3001 3rd Ordering Period Fire Protection IDIQ 1 Dollars $450,000.00
4001 4th Ordering Period Fire Protection IDIQ 1 Dollars $450,000.00
Evaluated Contract Total with All Ordering Periods $2,250,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 Period | 1st Ordering Period | ||||||
| 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 | 270 | $0.00 | On-Site Superintendent | 270 | $0.00 | $0.00 | |
| Roofer | 60 | $0.00 | Roofer | 60 | $0.00 | $0.00 | |
| Laborer - General | 600 | $0.00 | Laborer - General | 600 | $0.00 | $0.00 | |
| Painter | 100 | $0.00 | Painter | 100 | $0.00 | $0.00 | |
| Carpenter | 70 | $0.00 | Carpenter | 70 | $0.00 | $0.00 | |
| Electrician | 30 | $0.00 | Electrician | 30 | $0.00 | $0.00 | |
| Electricial Controls Technician | 200 | $0.00 | Electricial Controls Technician | 200 | $0.00 | $0.00 | |
| Fire Alarm System Mechanic | 1000 | $0.00 | Fire Alarm System Mechanic | 1000 | $0.00 | $0.00 | |
| Fire Alarm System Installer | 450 | $0.00 | Fire Alarm System Installer | 450 | $0.00 | $0.00 | |
| Fire Alarm Technician | 200 | $0.00 | Fire Alarm Technician | 200 | $0.00 | $0.00 | |
| Fire Sprinkler Technician | 750 | $0.00 | Fire Sprinkler Technician | 750 | $0.00 | $0.00 | |
| Fire Systems Specialist | 750 | $0.00 | Fire Systems Specialist | 750 | $0.00 | $0.00 | |
| Plumber | 15 | $0.00 | Plumber | 15 | $0.00 | $0.00 | |
| Pipefitter | 15 | $0.00 | Pipefitter | 15 | $0.00 | $0.00 | |
| Sheet Metal Worker | 60 | $0.00 | Sheet Metal Worker | 60 | $0.00 | $0.00 | |
| Welder | 15 | $0.00 | Welder | 15 | $0.00 | $0.00 | |
| Asbestos Worker | 30 | $0.00 | Asbestos Worker | 30 | $0.00 | $0.00 | |
| Architect | 15 | $0.00 | Architect | 15 | $0.00 | $0.00 | |
| Fire Protection Engineer | 150 | $0.00 | Fire Protection Engineer | 150 | $0.00 | $0.00 | |
| Fire Protection Consultant | 50 | $0.00 | Fire Protection Consultant | 50 | $0.00 | $0.00 | |
| Mechanical Engineer | 10 | $0.00 | Mechanical Engineer | 10 | $0.00 | $0.00 | |
| Electrical Engineer | 5 | $0.00 | Electrical Engineer | 5 | $0.00 | $0.00 | |
| Civil Engineer | 10 | $0.00 | Civil Engineer | 10 | $0.00 | $0.00 | |
| Estimator | 60 | $0.00 | Estimator | 60 | $0.00 | $0.00 | |
| Commissioning Agent | 25 | $0.00 | Commissioning Agent | 25 | $0.00 | $0.00 | |
| Structural Engineer | 10 | $0.00 | Structural Engineer | 10 | $0.00 | $0.00 | |
| CADD Operator | 80 | $0.00 | CADD Operator | 80 | $0.00 | $0.00 | |
| Clerical/WP/Typing | 100 | $0.00 | Clerical/WP/Typing | 100 | $0.00 | $0.00 |
Total $0.00 Total $0.00
| 2nd Ordering Period | 3rd Ordering Period | ||||||
| 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 | 270 | $0.00 | $0.00 | On-Site Superintendent | 270 | $0.00 | $0.00 |
| Roofer | 60 | $0.00 | $0.00 | Roofer | 60 | $0.00 | $0.00 |
| Laborer - General | 600 | $0.00 | $0.00 | Laborer - General | 600 | $0.00 | $0.00 |
| Painter | 100 | $0.00 | $0.00 | Painter | 100 | $0.00 | $0.00 |
| Carpenter | 70 | $0.00 | $0.00 | Carpenter | 70 | $0.00 | $0.00 |
| Electrician | 30 | $0.00 | $0.00 | Electrician | 30 | $0.00 | $0.00 |
| Electricial Controls Technician | 200 | $0.00 | $0.00 | Electricial Controls Technician | 200 | $0.00 | $0.00 |
| Fire Alarm System Mechanic | 1000 | $0.00 | $0.00 | Fire Alarm System Mechanic | 1000 | $0.00 | $0.00 |
| Fire Alarm System Installer | 450 | $0.00 | $0.00 | Fire Alarm System Installer | 450 | $0.00 | $0.00 |
| Fire Alarm Technician | 200 | $0.00 | $0.00 | Fire Alarm Technician | 200 | $0.00 | $0.00 |
| Fire Sprinkler Technician | 750 | $0.00 | $0.00 | Fire Sprinkler Technician | 750 | $0.00 | $0.00 |
| Fire Systems Specialist | 750 | $0.00 | $0.00 | Fire Systems Specialist | 750 | $0.00 | $0.00 |
| Plumber | 15 | $0.00 | $0.00 | Plumber | 15 | $0.00 | $0.00 |
| Pipefitter | 15 | $0.00 | $0.00 | Pipefitter | 15 | $0.00 | $0.00 |
| Sheet Metal Worker | 60 | $0.00 | $0.00 | Sheet Metal Worker | 60 | $0.00 | $0.00 |
| Welder | 15 | $0.00 | $0.00 | Welder | 15 | $0.00 | $0.00 |
| Asbestos Worker | 30 | $0.00 | $0.00 | Asbestos Worker | 30 | $0.00 | $0.00 |
| Architect | 15 | $0.00 | $0.00 | Architect | 15 | $0.00 | $0.00 |
| Fire Protection Engineer | 150 | $0.00 | $0.00 | Fire Protection Engineer | 150 | $0.00 | $0.00 |
| Fire Protection Consultant | 50 | $0.00 | $0.00 | Fire Protection Consultant | 50 | $0.00 | $0.00 |
| Mechanical Engineer | 10 | $0.00 | $0.00 | Mechanical Engineer | 10 | $0.00 | $0.00 |
| Electrical Engineer | 5 | $0.00 | $0.00 | Electrical Engineer | 5 | $0.00 | $0.00 |
| Civil Engineer | 10 | $0.00 | $0.00 | Civil Engineer | 10 | $0.00 | $0.00 |
| Estimator | 60 | $0.00 | $0.00 | Estimator | 60 | $0.00 | $0.00 |
| Commissioning Agent | 25 | $0.00 | $0.00 | Commissioning Agent | 25 | $0.00 | $0.00 |
| Structural Engineer | 10 | $0.00 | $0.00 | Structural Engineer | 10 | $0.00 | $0.00 |
| CADD Operator | 80 | $0.00 | $0.00 | CADD Operator | 80 | $0.00 | $0.00 |
| Clerical/WP/Typing | 100 | $0.00 | $0.00 | Clerical/WP/Typing | 100 | $0.00 | $0.00 |
Total $0.00 Total $0.00
| 4th Ordering Period | |||
| Direct Labor Category | Estimated Hours | Proposed FFP Fully Burdened Labor Hourly Rate | Total |
| On-Site Superintendent | 270 | $0.00 | $0.00 |
| Roofer | 60 | $0.00 | $0.00 |
| Laborer - General | 600 | $0.00 | $0.00 |
| Painter | 100 | $0.00 | $0.00 |
| Carpenter | 70 | $0.00 | $0.00 |
| Electrician | 30 | $0.00 | $0.00 |
| Electricial Controls Technician | 200 | $0.00 | $0.00 |
| Fire Alarm System Mechanic | 1000 | $0.00 | $0.00 |
| Fire Alarm System Installer | 450 | $0.00 | $0.00 |
| Fire Alarm Technician | 200 | $0.00 | $0.00 |
| Fire Sprinkler Technician | 750 | $0.00 | $0.00 |
| Fire Systems Specialist | 750 | $0.00 | $0.00 |
| Plumber | 15 | $0.00 | $0.00 |
| Pipefitter | 15 | $0.00 | $0.00 |
| Sheet Metal Worker | 60 | $0.00 | $0.00 |
| Welder | 15 | $0.00 | $0.00 |
| Asbestos Worker | 30 | $0.00 | $0.00 |
| Architect | 15 | $0.00 | $0.00 |
| Fire Protection Engineer | 150 | $0.00 | $0.00 |
| Fire Protection Consultant | 50 | $0.00 | $0.00 |
| Mechanical Engineer | 10 | $0.00 | $0.00 |
| Electrical Engineer | 5 | $0.00 | $0.00 |
| Civil Engineer | 10 | $0.00 | $0.00 |
| Estimator | 60 | $0.00 | $0.00 |
| Commissioning Agent | 25 | $0.00 | $0.00 |
| Structural Engineer | 10 | $0.00 | $0.00 |
| CADD Operator | 80 | $0.00 | $0.00 |
| Clerical/WP/Typing | 100 | $0.00 | $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 Period Material and Equipment $450,000.00 $0.00 $450,000.00
1001 1st Ordering Period Year Material and Equipment $450,000.00 $0.00 $450,000.00
2001 2nd Ordering Period Year Material and Equipment $450,000.00 $0.00 $450,000.00
3001 3rd Ordering Period Year Material and Equipment $450,000.00 $0.00 $450,000.00
4001 4th Ordering Period Year Material and Equipment $450,000.00 $0.00 $450,000.00
Total $2,250,000.00
File details come from the government source that posted it. Updated .