S02 Attachment 22_Base Offer Price Breakdown_1 Page_Excel Form.xlsx
XLSX spreadsheet 23 KB Posted
- Solicitation number
- 36C24826Q0453
About this file
This is a Base Offer Price Breakdown form, an Excel template used for pricing submissions on federal construction projects. The form is structured to capture detailed cost information for the Edward L Roy VA project, organized by the 2020 MasterFormat Division system covering all major construction trades from General Requirements (Division 1) through Transportation (Division 34). Contractors are required to enter labor costs and material costs separately for each division, with the form automatically calculating total costs per division.
The pricing template includes mechanisms for calculating overhead, profit, and bond percentages applied cumulatively to the division subtotals, ultimately generating a Total Base Offer Cost. The form explicitly directs offerors to provide detailed price breakdowns to avoid lump sum pricing, supporting government cost analysis. All cost entries default to zero, requiring complete population by the offeror. The template requires contractor identification information including name, street address, city, state, and zip code, along with project number and title fields. This form applies to the VA Medical Center West Palm Beach IR Cath Lab renovation project (Project Number 548-CSI-139), a bid-build construction project involving demolition and renovation of approximately 2,110 square feet to create a Hybrid OR space compliant with VA design standards and the Surgical and Endovascular Services Design Guide.
View the file
Other files
Show all 36
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
Offerors shall provide additional price breakdown to avoiding lump sum, etc. This price offer breakdown is the overall base offer price for Government price analysis
File details come from the government source that posted it. Updated .