Amend 2 - 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 for mechanical, electrical, and plumbing (MEP) services. The contract will be awarded by the Department of Agriculture's Agricultural Research Service and is identified as solicitation number 12305B24R0003. Bidders must provide firm-fixed-price fully burdened hourly labor rates for various craft labor categories for each contract year. They must also propose an overhead and profit rate to apply to estimated material and equipment costs. The bid schedule automatically calculates total evaluated prices. The apparent successful bidder will receive a single task order for an initial amount of $1.8 million to provide MEP services for the Plains Area Field Research Implementation and Information Delivery office.
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 | ||
| 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
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 .