7-Bid Tab Spreadsheet.xlsx

This is a bid tab spreadsheet for two infrastructure projects in Utah: the Hoytsville Bridge and Road Widening project and the Weber Canyon Bridge project. The Hoytsville project involves constructing a new bridge, demolishing the existing bridge, widening the roadway from twenty-five feet to thirty-four feet, and applying a three-inch asphalt overlay for approximately 3,500 linear feet. The Weber Canyon project requires constructing a new bridge approximately sixty feet north of the existing structure, constructing new road alignment, and demolishing the existing bridge and reclaiming the old roadway. Schedule 1 (Hoytsville Road) contains 28 line items plus one alternative bid item for a boulder retaining wall for an access road, encompassing work categories such as mobilization, traffic control, demolition, embankment work, asphalt paving, bridge construction, guardrails, riprap, and revegetation. Schedule 2 (Weber Canyon Road) contains 28 line items covering similar work categories tailored to the specific project requirements.

Bidders are required to enter unit prices in the green cells (Column E) of the spreadsheet for each line item across both schedules and submit their bids via BONFIRE. The spreadsheet provides estimated quantities for each item, including quantities ranging from lump sum (LS) entries for mobilization, traffic control, demolition work, and specialized tasks, to measured quantities for items such as asphalt removal (87,500 square feet in Schedule 1), embankment fill (4,400 cubic yards in Schedule 1 and 2,800 cubic yards in Schedule 2), hot mix asphalt pavement (1,850 cubic yards in Schedule 1 and 50 cubic yards in Schedule 2), W-beam guardrail (1,100 linear feet in Schedule 1), and riprap (400 cubic yards in Schedule 1). The total bid price will be calculated as the sum of Schedule 1 and Schedule 2, with an option to include the alternative bid item for a total bid price that incorporates both schedules plus the alternative.