S02 Base Offer Breakdown.xlsx

XLSX spreadsheet 29 KB Posted

Attached to
523A5-18-371 Building 4 Elevator Replacement VAMC Brockton
Solicitation number
036C24126Q0250
Issued by

About this file

This is a Base Offer Cost Breakdown template for a construction project submitted as part of the solicitation for Building 4 Elevator Replacement at the Brockton VA Healthcare System Campus in Brockton, Massachusetts. The template is designed for offerors to submit detailed pricing by construction division using the MasterFormat classification system, which includes 24 divisions spanning general requirements, concrete, masonry, metals, wood and plastic, thermal and moisture protection, doors and windows, finishes, specialties, equipment, furnishings, special construction, conveying equipment, fire suppression, plumbing, HVAC, electrical, communications, electronic safety and security, earthwork, exterior improvements, utilities, and transportation.

Offerors must itemize labor costs and material costs separately for each division, with the template automatically calculating division totals and applying overhead, profit, and bond percentages to arrive at the total base offer cost. The template includes fields for offeror name and address, project number, project title, project location, date offer was prepared or submitted, and the overhead percentage, profit percentage, and bond percentage to be applied. A labor detail section requires specification of labor category, hourly rate, hours, and total cost per labor category within each division, while a materials and equipment details section requires specification of item description, rate, units, and total cost per item. The project involves modernization of two existing elevators (one passenger 3-stop and one service 3-stop elevator) with an estimated 365-calendar-day schedule from a tentative Notice to Proceed in May 2026, and requires all electrical, mechanical, and elevator work to be performed by Massachusetts-licensed contractors with appropriate certifications.

View the file

Other files

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Base Offer

Base Offer Cost Breakdown

Project Number:

Edward L Roy: VA assigned project #

Date:
Project Title
Edward L Roy: VA assigned Project TitleProject Location
Offeror Name
Offeror Street
Offeror CityStateZip

Item Description Labor Cost Edward L Roy: Enter all Labor Costs by Division

Material Cost
Edward L Roy: Enter all Material Costs by DivisionTotal Cost

Edward L Roy: This Column is the sum of the Division's Labor and Material Costs

Division 1General Requirements$ - 0$ - 0$ - 0
Division 2Existing Conditions- 0- 0- 0
Division 3Concrete- 0- 0- 0
Division 4Masonry- 0- 0- 0
Division 5Metals- 0- 0- 0
Division 6Wood and Plastic- 0- 0- 0
Division 7Thermal & Moisture Protect- 0- 0- 0
Division 8Doors and Windows- 0- 0- 0
Division 9Finishes- 0- 0- 0
Division 10Specialties- 0- 0- 0
Division 11Equipment- 0- 0- 0
Division 12Furnishings- 0- 0- 0
Division 13Special Construction- 0- 0- 0
Division 14Conveying Equipment- 0- 0- 0
Division 21Fire Suppression- 0- 0- 0
Division 22Plumbing- 0- 0- 0
Division 23HVAC- 0- 0- 0
Division 26Electrical- 0- 0- 0
Division 27Communications- 0- 0- 0
Division 28Electronic Safety & Security- 0- 0- 0
Division 31Earthwork- 0- 0- 0
Division 32Exterior Improvements- 0- 0- 0
Division 33Utilities- 0- 0- 0
Division 34Transportation Subtotal- 0- 0- 0
Division Subtotals :$ - 0$ - 0$ - 0

Overhead % 0.00% Edward L Roy: Enter Overhead % here. This % will be multiplied by the Division Total Cost Subtotal (cell F36).

Edward L Roy: Date Offer Prepared/Submitted

- 0
Profit %0.00%
Edward L Roy: Enter Profit % here.This % will be multiplied by the sum of the Division Total Cost subtotal (cell F36) plus the calculated Overhead (cell F38).- 0
Bond %0.00%

Edward L Roy: Enter Bond % here. This % will be multiplied by the sum of the Division Total Cost Subtotal (cell F36), the amount of calculated Overhead (cell F38) and the amount of calculated Profit (cell F39).

Edward L Roy: Enter all Labor Costs by Division

- 0
Overhead/Profit Subtotals :$ - 0

Edward L Roy: Sum of Overhead, Profit and Bond %.

Edward L Roy: Enter all Material Costs by Division Edward L Roy: This Column is the sum of the Division's Labor and Material Costs Total Base Offer Cost $ - 0 $ - 0 $ - 0

Labor Detail

Sample Example
DivisionLabor CategoryLabor RateHoursTotal
1Plumber$35.00123$4,305.00
1Laborer14.7570$1,032.50
$5,337.50

Materials and Equipment Details

Sample Example
DivisionItemRateUnitsTotal
1Pipe - 150'$1.50150$225.00
190 Degree Coupling$1.105$5.50
1Pump Rental - Hour$200.006$1,200.00
$1,430.50

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