S02-S02 Jamaica Plains 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 a base offer submission related to federal construction project 523-25-003 at Veterans Affairs Medical Centers in Massachusetts. The template is structured to capture labor costs, material costs, and total costs organized by 27 CSI (Construction Specifications Institute) divisions, ranging from General Requirements through Transportation. Each division requires separate line-item entries detailing labor categories with hourly rates and hours worked, as well as materials and equipment with unit rates and quantities.
The template provides fields for calculating overhead percentage, profit percentage, and bond percentage, which are applied sequentially to the division subtotals to arrive at the total base offer cost. The spreadsheet includes sample examples showing how to populate labor details (e.g., Plumber at $35.00/hour for 123 hours totaling $4,305.00) and materials and equipment details (e.g., Pipe at $1.50 per 150 feet totaling $225.00). Offerors must enter project identification information, their company details, and the date the offer was prepared. This template is designed for contractors bidding on the Bulk Oxygen Corrections project, which involves selective demolition, correcting NFPA deficiencies on existing bulk oxygen storage tanks, and associated work across three VA Medical Centers with a 275-calendar-day performance period.
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 .