S02_RFP Attachment Divisional Price Breakdown.xlsx
XLSX spreadsheet 23 KB Posted
- Solicitation number
- 36C24826Q0459
About this file
This is a Divisional Price Breakdown template for the Base Offer submission in response to RFP 36C24826R0112 for construction services at Bay Pines VAMC. The template is structured according to the MasterFormat 2004 classification system and requires offerors to provide itemized Labor Costs and Material Costs across 28 construction divisions, including General Requirements, Concrete, Masonry, Metals, HVAC, Electrical, Plumbing, and Earthwork, among others. Each division line item calculates a Total Cost as the sum of labor and material expenses, with a Division Subtotals row aggregating all costs.
The template incorporates overhead, profit, and bond calculations applied sequentially to the division subtotals. Offerors must enter the Overhead percentage, Profit percentage, and Bond percentage, which are then automatically calculated and summed to produce the Total Base Offer Cost. The spreadsheet is designed to enforce transparent cost accounting by explicitly separating labor and material components within each division and preventing lump-sum pricing. Project information fields include space for the project number (516-CSI-134), project title, location (Bay Pines VAMC, Bay Pines, Florida), offeror name and address, and the date the offer is prepared or submitted. This pricing template serves as the primary mechanism for Government price analysis of the base offer and must accompany all bids without exceptions or deviations from the required divisional structure.
View the file
Other files
Show all 18
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 .