S02-S02 West Roxbury 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 cost breakdown template for the Base Offer submission related to solicitation 523-25-003 for Bulk Oxygen Corrections at three Department of Veterans Affairs Medical Centers in Massachusetts (Brockton, Jamaica Plain, and West Roxbury). The template is structured to capture labor costs, material costs, and total costs organized by the 16 MasterFormat divisions applicable to construction projects, including General Requirements, Concrete, Masonry, Metals, Thermal & Moisture Protection, Doors and Windows, Finishes, Fire Suppression, Plumbing, HVAC, Electrical, Communications, Electronic Safety & Security, Earthwork, Exterior Improvements, Utilities, and Transportation.
The document provides fields for offerors to enter labor costs by division and material costs by division, with automatic calculation of total division costs. The template includes calculation mechanisms for overhead percentage, profit percentage, and bond percentage applied sequentially to the division subtotals, with final summation to generate the Total Base Offer Cost. The document includes sample examples demonstrating how to populate labor details (with labor categories, hourly rates, hours worked, and totals) and materials and equipment details (with line items, rates, units, and totals). The contract requires all labor, selective demolition, equipment, material, supervision, and disposal for correcting NFPA deficiencies in existing bulk oxygen storage tanks, with a period of performance of 275 calendar days from Notice to Proceed issuance.
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 .