S02_Base Offer Breakdown.xlsx

This is a Base Offer Breakdown cost template for federal construction projects. The spreadsheet is designed for offerors to submit detailed pricing for construction work organized by the 16 standard construction divisions, including General Requirements, Concrete, Masonry, Metals, Wood and Plastic, Thermal & Moisture Protection, Doors and Windows, Finishes, Specialties, Equipment, Furnishings, Special Construction, Conveying Equipment, Fire Suppression, Plumbing, HVAC, Electrical, Communications, Electronic Safety & Security, Earthwork, Exterior Improvements, Utilities, and Transportation. Offerors must separately itemize labor costs and material costs for each division, with the template automatically calculating total division costs and generating subtotals.

The template requires offerors to enter overhead percentage, profit percentage, and bond percentage, which are applied sequentially to the division subtotals to calculate the final Total Base Offer Cost. The spreadsheet includes sample labor detail lines showing labor categories with hourly rates and hours worked, as well as materials and equipment details with unit rates and quantities. The template is associated with solicitation 36C24126Q0173 for the "Z2NZ--631-19-002 Upgrade Steam Distribution System Phase II" project, which is being offered exclusively through the VISN 1 Construction MATOC by the Department of Veterans Affairs Veterans Health Administration Veterans Integrated Service Network 1, and only eligible VISN 1 Construction MATOC vendors are permitted to submit offers.