Attachment 1 Bid Schedule General Construction (MS Excel Interactive Document).xlsx

XLSX spreadsheet 25 KB Posted

Attached to
General Construction IDIQ Federal contract opportunity
Solicitation number
12805B22R0007
Issued by
Department of Agriculture Agricultural Research Service Field Research Implementation and Information Delivery Plains Area

View the file

Other files for this federal contract opportunity

Show all 11

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.
CLINDescriptionQuantityUnit of IssueEvaluated Contract Price

0001 Base Year Ordering Period General Construction Pricing 1 Dollars $300,000.00

0001 2nd Year Ordering Period General Construction Pricing 1 Dollars $300,000.00

0001 3rd Year Ordering Period General Construction Pricing 1 Dollars $300,000.00

0001 4th Year Ordering Period General Construction Pricing 1 Dollars $300,000.00

0001 5th Year Ordering Period General Construction Pricing 1 Dollars $300,000.00

Evaluated Contract Total for all Ordering Periods $1,500,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 Year2nd Year
Direct Labor CategoryEstimated HoursProposed FFP Fully Burdened Labor Hourly RateTotalDirect Labor CategoryEstimated HoursProposed FFP Fully Burdened Labor Hourly RateTotal
On-Site Superintendent1200$0.00On-Site Superintendent1200$0.00
Boilermaker20$0.00Boilermaker20$0.00
Elevator Mechanic20$0.00Elevator Mechanic20$0.00
Ironworker, Ornamental60$0.00Ironworker, Ornamental60$0.00
Plumber550$0.00Plumber550$0.00
Pipefitter (HVAC Pipe Install Only)120$0.00Pipefitter (HVAC Pipe Install Only)120$0.00
Pipefitter (Excludes HVAC Pipe Install)120$0.00Pipefitter (Excludes HVAC Pipe Install)120$0.00
Sheet Metal Worker (HVAC Duct Install Only)120$0.00Sheet Metal Worker (HVAC Duct Install Only)120$0.00
Bricklayer60$0.00Bricklayer60$0.00
Carpenter (Excludes Form Work)500$0.00Carpenter (Excludes Form Work)500$0.00
Cement Mason/Concrete Finisher120$0.00Cement Mason/Concrete Finisher120$0.00
Electrician500$0.00Electrician500$0.00
Form Worker60$0.00Form Worker60$0.00
Insulator - Mechanical (Duct, Pipe & Mech)120$0.00Insulator - Mechanical (Duct, Pipe & Mech)120$0.00
Ironworker, Reinforcing60$0.00Ironworker, Reinforcing60$0.00
Ironworker, Structural60$0.00Ironworker, Structural60$0.00
Laborer: Common or General1000$0.00Laborer: Common or General1000$0.00
Laborer: Mason Tender - Brick120$0.00Laborer: Mason Tender - Brick120$0.00
Laborer: Mason Tender - Cement/Concrete120$0.00Laborer: Mason Tender - Cement/Concrete120$0.00
Laborer: Pipelayer120$0.00Laborer: Pipelayer120$0.00
Laborer: Roof Tearoff60$0.00Laborer: Roof Tearoff60$0.00
Operator: Backhoe/Excavator/Tractor60$0.00Operator: Backhoe/Excavator/Tractor60$0.00
Operator: Bobcat/Skid Steer/Skid Loader60$0.00Operator: Bobcat/Skid Steer/Skid Loader60$0.00
Operator: Bulldozer60$0.00Operator: Bulldozer60$0.00
Operator: Drill60$0.00Operator: Drill60$0.00
Operator: Forklift60$0.00Operator: Forklift60$0.00
Operator: Grader/Blade60$0.00Operator: Grader/Blade60$0.00
Operator: Loader60$0.00Operator: Loader60$0.00
Operator: Mechanic60$0.00Operator: Mechanic60$0.00
Operator: Paver (Asphalt, Aggregate, Concrete)60$0.00Operator: Paver (Asphalt, Aggregate, Concrete)60$0.00
Operator: Roller60$0.00Operator: Roller60$0.00
Painter (Brush, Roller, and Spray)500$0.00Painter (Brush, Roller, and Spray)500$0.00
Roofer60$0.00Roofer60$0.00
Sheet Metal Worker (Exludes HVAC Duct Install)120$0.00Sheet Metal Worker (Exludes HVAC Duct Install)120$0.00
Asbestos/ACM/Lead Worker100$0.00Asbestos/ACM/Lead Worker100$0.00
Tile Finisher120$0.00Tile Finisher120$0.00
Tile Setter120$0.00Tile Setter120$0.00
Truck Driver: Dump Truck120$0.00Truck Driver: Dump Truck120$0.00
Truck Driver: Flatbed Truck120$0.00Truck Driver: Flatbed Truck120$0.00
Truck Driver: Semi-Trailer Truck60$0.00Truck Driver: Semi-Trailer Truck60$0.00
Truck Driver: Water Truck60$0.00Truck Driver: Water Truck60$0.00
Welder500$0.00Welder500$0.00
Form Builder/Form Setter60$0.00Form Builder/Form Setter60$0.00
Civil Engineer10$0.00Civil Engineer10$0.00
Structural Engineer10$0.00Structural Engineer10$0.00
Power Equipment Operator: Tower Crane60$0.00Power Equipment Operator: Tower Crane60$0.00
Power Equipment Operator: Cranes with Pile Driving or Hydraulic 60 Tons and above60$0.00Power Equipment Operator: Cranes with Pile Driving or Hydraulic 60 Tons and above60$0.00
Power Equipment Operator: Hydraulic 59 Tons and Under60$0.00Power Equipment Operator: Hydraulic 59 Tons and Under60$0.00
Power Equipment Operator: Concrete Paving Finishing Machine60$0.00Power Equipment Operator: Concrete Paving Finishing Machine60$0.00

Total $0.00 Total $0.00

3rd Year4th Year
Direct Labor CategoryEstimated HoursProposed FFP Fully Burdened Labor Hourly RateTotalDirect Labor CategoryEstimated HoursProposed FFP Fully Burdened Labor Hourly RateTotal
On-Site Superintendent1200$ - 0On-Site Superintendent1200$ - 0
Boilermaker20$ - 0Boilermaker20$ - 0
Elevator Mechanic20$ - 0Elevator Mechanic20$ - 0
Ironworker, Ornamental60$ - 0Ironworker, Ornamental60$ - 0
Plumber550$ - 0Plumber550$ - 0
Pipefitter (HVAC Pipe Install Only)120$ - 0Pipefitter (HVAC Pipe Install Only)120$ - 0
Pipefitter (Excludes HVAC Pipe Install)120$ - 0Pipefitter (Excludes HVAC Pipe Install)120$ - 0
Sheet Metal Worker (HVAC Duct Install Only)120$ - 0Sheet Metal Worker (HVAC Duct Install Only)120$ - 0
Bricklayer60$ - 0Bricklayer60$ - 0
Carpenter (Excludes Form Work)500$ - 0Carpenter (Excludes Form Work)500$ - 0
Cement Mason/Concrete Finisher120$ - 0Cement Mason/Concrete Finisher120$ - 0
Electrician500$ - 0Electrician500$ - 0
Form Worker60$ - 0Form Worker60$ - 0
Insulator - Mechanical (Duct, Pipe & Mech)120$ - 0Insulator - Mechanical (Duct, Pipe & Mech)120$ - 0
Ironworker, Reinforcing60$ - 0Ironworker, Reinforcing60$ - 0
Ironworker, Structural60$ - 0Ironworker, Structural60$ - 0
Laborer: Common or General1000$ - 0Laborer: Common or General1000$ - 0
Laborer: Mason Tender - Brick120$ - 0Laborer: Mason Tender - Brick120$ - 0
Laborer: Mason Tender - Cement/Concrete120$ - 0Laborer: Mason Tender - Cement/Concrete120$ - 0
Laborer: Pipelayer120$ - 0Laborer: Pipelayer120$ - 0
Laborer: Roof Tearoff60$ - 0Laborer: Roof Tearoff60$ - 0
Operator: Backhoe/Excavator/Tractor60$ - 0Operator: Backhoe/Excavator/Tractor60$ - 0
Operator: Bobcat/Skid Steer/Skid Loader60$ - 0Operator: Bobcat/Skid Steer/Skid Loader60$ - 0
Operator: Bulldozer60$ - 0Operator: Bulldozer60$ - 0
Operator: Drill60$ - 0Operator: Drill60$ - 0
Operator: Forklift60$ - 0Operator: Forklift60$ - 0
Operator: Grader/Blade60$ - 0Operator: Grader/Blade60$ - 0
Operator: Loader60$ - 0Operator: Loader60$ - 0
Operator: Mechanic60$ - 0Operator: Mechanic60$ - 0
Operator: Paver (Asphalt, Aggregate, Concrete)60$ - 0Operator: Paver (Asphalt, Aggregate, Concrete)60$ - 0
Operator: Roller60$ - 0Operator: Roller60$ - 0
Painter (Brush, Roller, and Spray)500$ - 0Painter (Brush, Roller, and Spray)500$ - 0
Roofer60$ - 0Roofer60$ - 0
Sheet Metal Worker (Exludes HVAC Duct Install)120$ - 0Sheet Metal Worker (Exludes HVAC Duct Install)120$ - 0
Asbestos/ACM/Lead Worker100$ - 0Asbestos/ACM/Lead Worker100$ - 0
Tile Finisher120$ - 0Tile Finisher120$ - 0
Tile Setter120$ - 0Tile Setter120$ - 0
Truck Driver: Dump Truck120$ - 0Truck Driver: Dump Truck120$ - 0
Truck Driver: Flatbed Truck120$ - 0Truck Driver: Flatbed Truck120$ - 0
Truck Driver: Semi-Trailer Truck60$ - 0Truck Driver: Semi-Trailer Truck60$ - 0
Truck Driver: Water Truck60$ - 0Truck Driver: Water Truck60$ - 0
Welder500$ - 0Welder500$ - 0
Form Builder/Form Setter60$ - 0Form Builder/Form Setter60$ - 0
Civil Engineer10$ - 0Civil Engineer10$ - 0
Structural Engineer10$ - 0Structural Engineer10$ - 0
Power Equipment Operator: Tower Crane60$ - 0Power Equipment Operator: Tower Crane60$ - 0
Power Equipment Operator: Cranes with Pile Driving or Hydraulic 60 Tons and above60$ - 0Power Equipment Operator: Cranes with Pile Driving or Hydraulic 60 Tons and above60$ - 0
Power Equipment Operator: Hydraulic 59 Tons and Under60$ - 0Power Equipment Operator: Hydraulic 59 Tons and Under60$ - 0
Power Equipment Operator: Concrete Paving Finishing Machine60$ - 0Power Equipment Operator: Concrete Paving Finishing Machine60$ - 0

Total $0.00 Total $0.00

5th Year
Direct Labor CategoryEstimated HoursProposed FFP Fully Burdened Labor Hourly RateTotal
On-Site Superintendent1200$0.00
Boilermaker20$0.00
Elevator Mechanic20$0.00
Ironworker, Ornamental60$0.00
Plumber550$0.00
Pipefitter (HVAC Pipe Install Only)120$0.00
Pipefitter (Excludes HVAC Pipe Install)120$0.00
Sheet Metal Worker (HVAC Duct Install Only)120$0.00
Bricklayer60$0.00
Carpenter (Excludes Form Work)500$0.00
Cement Mason/Concrete Finisher120$0.00
Electrician500$0.00
Form Worker60$0.00
Insulator - Mechanical (Duct, Pipe & Mech)120$0.00
Ironworker, Reinforcing60$0.00
Ironworker, Structural60$0.00
Laborer: Common or General1000$0.00
Laborer: Mason Tender - Brick120$0.00
Laborer: Mason Tender - Cement/Concrete120$0.00
Laborer: Pipelayer120$0.00
Laborer: Roof Tearoff60$0.00
Operator: Backhoe/Excavator/Tractor60$0.00
Operator: Bobcat/Skid Steer/Skid Loader60$0.00
Operator: Bulldozer60$0.00
Operator: Drill60$0.00
Operator: Forklift60$0.00
Operator: Grader/Blade60$0.00
Operator: Loader60$0.00
Operator: Mechanic60$0.00
Operator: Paver (Asphalt, Aggregate, Concrete)60$0.00
Operator: Roller60$0.00
Painter (Brush, Roller, and Spray)500$0.00
Roofer60$0.00
Sheet Metal Worker (Exludes HVAC Duct Install)120$0.00
Asbestos/ACM/Lead Worker100$0.00
Tile Finisher120$0.00
Tile Setter120$0.00
Truck Driver: Dump Truck120$0.00
Truck Driver: Flatbed Truck120$0.00
Truck Driver: Semi-Trailer Truck60$0.00
Truck Driver: Water Truck60$0.00
Welder500$0.00
Form Builder/Form Setter60$0.00
Civil Engineer10$0.00
Structural Engineer10$0.00
Power Equipment Operator: Tower Crane60$0.00
Power Equipment Operator: Cranes with Pile Driving or Hydraulic 60 Tons and above60$0.00
Power Equipment Operator: Hydraulic 59 Tons and Under60$0.00
Power Equipment Operator: Concrete Paving Finishing Machine60$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 Year Ordering Period Material/Equipment Pricing $300,000.00 $0.00 $300,000.00

1001 2nd Year Ordering Period Material/Equipment Pricing $300,000.00 $0.00 $300,000.00

2001 3rd Year Ordering Period Material/Equipment Pricing $300,000.00 $0.00 $300,000.00

3001 4th Year Ordering Period Material/Equipment Pricing $300,000.00 $0.00 $300,000.00

4001 5th Year Ordering Period Material/Equipment Pricing $300,000.00 $0.00 $300,000.00

Total $1,500,000.00

File details come from the government source that posted it. Updated .