S02 Base Offer Breakdown.xlsx
XLSX spreadsheet 29 KB Posted
- Solicitation number
- 036C24126Q0250
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 Title | Project Location | ||
| Offeror Name | |||
| Offeror Street | |||
| Offeror City | State | Zip |
Item Description Labor Cost Edward L Roy: Enter all Labor Costs by Division
| Material Cost | |
| Edward L Roy: Enter all Material Costs by Division | Total Cost |
Edward L Roy: This Column is the sum of the Division's Labor and Material Costs
| Division 1 | General Requirements | $ - 0 | $ - 0 | $ - 0 |
| Division 2 | Existing Conditions | - 0 | - 0 | - 0 |
| Division 3 | Concrete | - 0 | - 0 | - 0 |
| Division 4 | Masonry | - 0 | - 0 | - 0 |
| Division 5 | Metals | - 0 | - 0 | - 0 |
| Division 6 | Wood and Plastic | - 0 | - 0 | - 0 |
| Division 7 | Thermal & Moisture Protect | - 0 | - 0 | - 0 |
| Division 8 | Doors and Windows | - 0 | - 0 | - 0 |
| Division 9 | Finishes | - 0 | - 0 | - 0 |
| Division 10 | Specialties | - 0 | - 0 | - 0 |
| Division 11 | Equipment | - 0 | - 0 | - 0 |
| Division 12 | Furnishings | - 0 | - 0 | - 0 |
| Division 13 | Special Construction | - 0 | - 0 | - 0 |
| Division 14 | Conveying Equipment | - 0 | - 0 | - 0 |
| Division 21 | Fire Suppression | - 0 | - 0 | - 0 |
| Division 22 | Plumbing | - 0 | - 0 | - 0 |
| Division 23 | HVAC | - 0 | - 0 | - 0 |
| Division 26 | Electrical | - 0 | - 0 | - 0 |
| Division 27 | Communications | - 0 | - 0 | - 0 |
| Division 28 | Electronic Safety & Security | - 0 | - 0 | - 0 |
| Division 31 | Earthwork | - 0 | - 0 | - 0 |
| Division 32 | Exterior Improvements | - 0 | - 0 | - 0 |
| Division 33 | Utilities | - 0 | - 0 | - 0 |
| Division 34 | Transportation 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 | ||||
| Division | Labor Category | Labor Rate | Hours | Total |
| 1 | Plumber | $35.00 | 123 | $4,305.00 |
| 1 | Laborer | 14.75 | 70 | $1,032.50 |
| $5,337.50 |
Materials and Equipment Details
| Sample Example | ||||
| Division | Item | Rate | Units | Total |
| 1 | Pipe - 150' | $1.50 | 150 | $225.00 |
| 1 | 90 Degree Coupling | $1.10 | 5 | $5.50 |
| 1 | Pump Rental - Hour | $200.00 | 6 | $1,200.00 |
| $1,430.50 |
File details come from the government source that posted it. Updated .