Amend 3 - Attachment 1 Bid Schedule (MS Excel Interactive Document Final).xlsx
XLSX spreadsheet 20 KB Posted
- Attached to
- Mechanical-Electrical- Plumbing (MEP) IDIQ - BARC Federal contract opportunity
- Solicitation number
- 12305B24R0003
About this file
This document contains an interactive bid schedule for a five-year indefinite delivery indefinite quantity (IDIQ) contract opportunity with the Department of Agriculture Agricultural Research Service for mechanical, electrical, and plumbing services. Offerors are required to provide firm-fixed-price fully burdened labor rates for 27 labor categories for each contract year, as well as a firm-fixed-price material and equipment overhead and profit rate. The bid schedule automatically calculates total evaluated annual amounts once labor rates and material/equipment rates are entered. The total evaluated contract amount for the base CLIN is $9 million. Offerors must populate all applicable fields in the bid schedule and transfer amounts to the corresponding schedule of items.
View the file
Other files for this federal contract opportunity
Show all 19
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
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 5 Year Order Period Mechanical, Electrical, and Plumbing 1 Dollars $9,000,000.00
Evaluated Contract Total $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 | ||
| Steamfitter, Refrigeration, and Air Conditioning Mechanic | 5200 | $0.00 | Steamfitter, Refrigeration, and Air Conditioning Mechanic | 5200 | $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 | ||
| Steamfitter, Refrigeration, and Air Conditioning Mechanic | 5200 | $0.00 | Steamfitter, Refrigeration, and Air Conditioning Mechanic | 5200 | $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 | |
| Steamfitter, Refrigeration, and Air Conditioning Mechanic | 5200 | $0.00 |
| Total | $0.00 | |
| Total FFP Labor Rate | $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 5 Year Order Period Mechanical, Electrical, and Plumbing $9,000,000.00 $0.00 $9,000,000.00
Total $9,000,000.00
File details come from the government source that posted it. Updated .