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 mechanical-electrical-plumbing indefinite-delivery indefinite-quantity (MEP IDIQ) multiple award contract solicitation from the Department of Agriculture Agricultural Research Service Field Research Implementation and Information Delivery Plains Area. Offerors are required to provide firm-fixed-price fully burdened labor rates for various craft labor categories for the base year and four option years. They must also propose a firm-fixed-price material and equipment overhead and profit rate. The bid schedule automatically calculates total evaluated contract prices once labor rates and overhead rates are entered. The total evaluated price for the base CLIN is $1,800,000. Offerors are instructed to copy pricing details from the bid schedule to their responses. The solicitation number is 12305B24R0003 and is for MEP services.
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 $1,800,000.00
Evaluated Contract Total $1,800,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 5 Year Order Period Mechanical, Electrical, and Plumbing $1,800,000.00 $0.00 $1,800,000.00
Total $1,800,000.00
File details come from the government source that posted it. Updated .