S02-S02 Brockton Base Offer Breakdown.xlsx
XLSX spreadsheet 28 KB Posted
- Attached to
- 523-25-003 Bulk Oxygen Corrections
- Solicitation number
- 36C24126Q0398
About this file
This is a Base Offer Cost Breakdown template for construction pricing submission related to a federal contract opportunity. The spreadsheet is structured to capture labor and material costs organized by 26 construction divisions, including General Requirements, Concrete, Masonry, Metals, HVAC, Electrical, Plumbing, Fire Suppression, and Earthwork, among others. Offerors are required to enter labor costs and material costs for each division, with the template automatically calculating divisional totals, overhead percentages, profit percentages, and bond percentages to arrive at a Total Base Offer Cost. The template includes sample labor detail entries showing hourly rates multiplied by hours worked, and materials and equipment details showing unit rates multiplied by quantities.
The pricing template is associated with Solicitation Number 36C24126Q0398 for project 523-25-003 titled "Bulk Oxygen Corrections" at Veterans Affairs Medical Centers in Brockton, Jamaica Plain, and West Roxbury, Massachusetts. The work involves selective demolition, correction of NFPA deficiencies to existing bulk oxygen storage tanks, provision of all labor and equipment, and proper disposal, with a performance period of 275 calendar days from Notice to Proceed. The contracting agency is the Department of Veterans Affairs Veterans Health Administration Veterans Integrated Service Network 1. All cost entries in the template currently show zero values, indicating this is a blank form awaiting offeror completion.
View the file
Other files
Show all 30
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 .