Attachment 1 Bid Schedule Demo and Abatement Plains North.xlsx
XLSX spreadsheet 32 KB Posted
- Solicitation number
- 12805B22R0003
View the file
Other files
Show all 14
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, "Materials and Equipment" tab, and "ACM-Lead Testing" 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 1st Year Ordering Period Demo and Abatement 1 Dollars $302,000.00
1001 2nd Year Ordering Period Demo and Abatement 1 Dollars $302,000.00
2001 3rd Year Ordering Period Demo and Abatement 1 Dollars $302,000.00
3001 4th Year Ordering Period Demo and Abatement 1 Dollars $302,000.00
4001 5th Year Ordering Period Demo and Abatement 1 Dollars $302,000.00
Evaluated Contract Total with All Periods $1,510,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. | |||||||
| USDA Demo and Abatement - North | |||||||
| 1st Period | 2nd 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 | 2080 | $0.00 | On-Site Superintendent | 2080 | $0.00 | ||
| Roofer | 24 | $0.00 | Roofer | 24 | $0.00 | ||
| Carpenter | 24 | $0.00 | Carpenter | 24 | $0.00 | ||
| Electrician | 80 | $0.00 | Electrician | 80 | $0.00 | ||
| Laborer -General | 6300 | $0.00 | Laborer -General | 6300 | $0.00 | ||
| Plumber | 120 | $0.00 | Plumber | 120 | $0.00 | ||
| Painter | 24 | $0.00 | Painter | 24 | $0.00 | ||
| Pipefitter | 24 | $0.00 | Pipefitter | 24 | $0.00 | ||
| Sheet Metal Worker | 24 | $0.00 | Sheet Metal Worker | 24 | $0.00 | ||
| Truck Driver | 400 | $0.00 | Truck Driver | 400 | $0.00 | ||
| Asbestos/ ACM/ Lead Worker | 400 | $0.00 | Asbestos/ ACM/ Lead Worker | 400 | $0.00 | ||
| Concrete Finisher | 40 | $0.00 | Concrete Finisher | 40 | $0.00 | ||
| Operator- Backhoe/Excavator, etc. | 400 | $0.00 | Operator- Backhoe/Excavator, etc. | 400 | $0.00 | ||
| Operator- Skid Steer | 400 | $0.00 | Operator- Skid Steer | 400 | $0.00 | ||
| Heat& Frost Insulator | 24 | $0.00 | Heat& Frost Insulator | 24 | $0.00 | ||
| Welder | 24 | $0.00 | Welder | 24 | $0.00 | ||
| Architect | 40 | $0.00 | Architect | 40 | $0.00 | ||
| Mechanical Engineer | 80 | $0.00 | Mechanical Engineer | 80 | $0.00 | ||
| Electrical Engineer | 80 | $0.00 | Electrical Engineer | 80 | $0.00 | ||
| Plumbing Engineer | 80 | $0.00 | Plumbing Engineer | 80 | $0.00 | ||
| Civil Engineer | 40 | $0.00 | Civil Engineer | 40 | $0.00 | ||
| Structural Engineer | 40 | $0.00 | Structural Engineer | 40 | $0.00 | ||
| CADD Operator | 80 | $0.00 | CADD Operator | 80 | $0.00 |
Total $0.00 Total $0.00
| 3rd Period | 4th 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 | 2080 | $0.00 | On-Site Superintendent | 2080 | $0.00 | ||
| Roofer | 24 | $0.00 | Roofer | 24 | $0.00 | ||
| Carpenter | 24 | $0.00 | Carpenter | 24 | $0.00 | ||
| Electrician | 80 | $0.00 | Electrician | 80 | $0.00 | ||
| Laborer -General | 6300 | $0.00 | Laborer -General | 6300 | $0.00 | ||
| Plumber | 120 | $0.00 | Plumber | 120 | $0.00 | ||
| Painter | 24 | $0.00 | Painter | 24 | $0.00 | ||
| Pipefitter | 24 | $0.00 | Pipefitter | 24 | $0.00 | ||
| Sheet Metal Worker | 24 | $0.00 | Sheet Metal Worker | 24 | $0.00 | ||
| Truck Driver | 400 | $0.00 | Truck Driver | 400 | $0.00 | ||
| Asbestos/ ACM/ Lead Worker | 400 | $0.00 | Asbestos/ ACM/ Lead Worker | 400 | $0.00 | ||
| Concrete Finisher | 40 | $0.00 | Concrete Finisher | 40 | $0.00 | ||
| Operator- Backhoe/Excavator, etc. | 400 | $0.00 | Operator- Backhoe/Excavator, etc. | 400 | $0.00 | ||
| Operator- Skid Steer | 400 | $0.00 | Operator- Skid Steer | 400 | $0.00 | ||
| Heat& Frost Insulator | 24 | $0.00 | Heat& Frost Insulator | 24 | $0.00 | ||
| Welder | 24 | $0.00 | Welder | 24 | $0.00 | ||
| Architect | 40 | $0.00 | Architect | 40 | $0.00 | ||
| Mechanical Engineer | 80 | $0.00 | Mechanical Engineer | 80 | $0.00 | ||
| Electrical Engineer | 80 | $0.00 | Electrical Engineer | 80 | $0.00 | ||
| Plumbing Engineer | 80 | $0.00 | Plumbing Engineer | 80 | $0.00 | ||
| Civil Engineer | 40 | $0.00 | Civil Engineer | 40 | $0.00 | ||
| Structural Engineer | 40 | $0.00 | Structural Engineer | 40 | $0.00 | ||
| CADD Operator | 80 | $0.00 | CADD Operator | 80 | $0.00 |
Total $0.00 Total $0.00
| 5th Period | |||
| Direct Labor Category | Estimated Hours | Proposed FFP Fully Burdened Labor Hourly Rate | Total |
| On-Site Superintendent | 2080 | $0.00 | |
| Roofer | 24 | $0.00 | |
| Carpenter | 24 | $0.00 | |
| Electrician | 80 | $0.00 | |
| Laborer -General | 6300 | $0.00 | |
| Plumber | 120 | $0.00 | |
| Painter | 24 | $0.00 | |
| Pipefitter | 24 | $0.00 | |
| Sheet Metal Worker | 24 | $0.00 | |
| Truck Driver | 400 | $0.00 | |
| Asbestos/ ACM/ Lead Worker | 400 | $0.00 | |
| Concrete Finisher | 40 | $0.00 | |
| Operator- Backhoe/Excavator, etc. | 400 | $0.00 | |
| Operator- Skid Steer | 400 | $0.00 | |
| Heat& Frost Insulator | 24 | $0.00 | |
| Welder | 24 | $0.00 | |
| Architect | 40 | $0.00 | |
| Mechanical Engineer | 80 | $0.00 | |
| Electrical Engineer | 80 | $0.00 | |
| Plumbing Engineer | 80 | $0.00 | |
| Civil Engineer | 40 | $0.00 | |
| Structural Engineer | 40 | $0.00 | |
| CADD Operator | 80 | $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. |
| USDA Demo and Abatement - North | |||||
| CLIN | Description | Estimated Dollar Value | Material and Equipment Overhead and Profit Rate | Overhead and Profit Rate Applied | Evaluated Contract Price |
| 34% | |||||
| 0001 | 1st Year Material and Equipment | $210,000.00 | $0.00 | $210,000.00 |
1001 2nd Year Material and Equipment $210,000.00 $0.00 $210,000.00
2001 3rd Year Material and Equipment $210,000.00 $0.00 $210,000.00
3001 4th Year Material and Equipment $210,000.00 $0.00 $210,000.00
4001 5th Year Material and Equipment $210,000.00 $0.00 $210,000.00
Total $1,050,000.00
ACM-Lead Testing Asbestos-Containing Material (ACM) and Lead Testing Rate
| Offers shall enter a Firm-Fixed-Price (FFP) ACM and Lead Testing Overhead and Profit Rate for ALL contract years, as indicated in C.1.2.3. 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. |
| USDA Demo and Abatement - North | |||||
| CLIN | Description | Estimated Dollar Value | ACM/Lead Testing Overhead and Profit Rate | Overhead and Profit Rate Applied | Evaluated Contract Price |
| 15% | |||||
| 0001 | 1st Year Ordering Period ACM/Lead Testing Pricing | $92,000.00 | $0.00 | $92,000.00 |
0002 2nd Year Ordering Period ACM/Lead Testing Pricing $92,000.00 $0.00 $92,000.00
0003 3rd Year Ordering Period ACM/Lead Testing Pricing $92,000.00 $0.00 $92,000.00
0004 4th Year Ordering Period ACM/Lead Testing Pricing $92,000.00 $0.00 $92,000.00
0005 5th Year Ordering Period ACM/Lead Testing Pricing $92,000.00 $0.00 $92,000.00
Total $460,000.00
File details come from the government source that posted it. Updated .