S02_Base Offer Breakdown.xlsx

This is a Base Offer Cost Breakdown template for a construction project to upgrade the steam distribution system at VA Central Western Massachusetts Healthcare System Edward P Boland Campus (Solicitation Number: 36C24126Q0173). The template requires offerors to provide project identification information, including the VA-assigned project number and title, offeror details (name, street address, city, state, zip), and project location. Costs must be broken down by construction divisions following the MasterFormat standard, spanning Division 1 (General Requirements) through Division 34 (Transportation), with separate columns for labor costs, material costs, and total costs per division.

The template includes structured sections for detailed labor calculations (listing labor categories, hourly rates, hours worked, and totals) and materials and equipment details (itemizing materials with unit rates, quantities, and totals). Offerors must calculate division subtotals, then apply overhead, profit, and bond percentages sequentially to arrive at the total base offer cost. The document provides sample examples for labor detail (plumber and laborer rates) and materials and equipment details (pipe, couplings, and pump rental) to guide proper cost entry. All fields are currently populated with zero placeholders, requiring complete cost data entry from responding contractors.