S02_Itemized Cost Breakdown.xlsx
XLSX spreadsheet 29 KB Posted
- Solicitation number
- 36C24126Q0357
About this file
This is an itemized cost breakdown template for construction projects submitted as part of federal contract proposals. The spreadsheet is designed for offerors to itemize labor and material costs across 24 construction divisions aligned with the MasterFormat classification system, including General Requirements, Concrete, Masonry, Metals, Wood and Plastic, Thermal and Moisture Protection, Doors and Windows, Finishes, Specialties, Equipment, Furnishings, Special Construction, Conveying Equipment, Fire Suppression, Plumbing, HVAC, Electrical, Communications, Electronic Safety and Security, Earthwork, Exterior Improvements, Utilities, and Transportation. The template requires offerors to enter labor costs by division, material costs by division, and calculate total divisional costs by summing labor and material expenses.
The breakdown accommodates overhead, profit, and bond percentages that are applied sequentially to generate the total base offer cost. The template includes sample calculations demonstrating how to structure labor detail entries (with labor categories, hourly rates, and hours worked) and materials and equipment details (with item descriptions, rates, units, and extended totals). All divisions are currently populated with zero values pending actual cost data entry by the offeror. This form is associated with solicitation 36C24126Q0357 for abatement and upgrade work in Building 1 Common Area under the Department of Veterans Affairs Veterans Health Administration Veterans Integrated Service Network 1.
View the file
Other files
Show all 15
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 | ||
| Division 2 | Existing Conditions | - 0 | ||
| Division 3 | Concrete | - 0 | ||
| Division 4 | Masonry | - 0 | ||
| Division 5 | Metals | - 0 | ||
| Division 6 | Wood and Plastic | - 0 | ||
| Division 7 | Thermal & Moisture Protect | - 0 | ||
| Division 8 | Doors and Windows | - 0 | ||
| Division 9 | Finishes | - 0 | ||
| Division 10 | Specialties | - 0 | ||
| Division 11 | Equipment | - 0 | ||
| Division 12 | Furnishings | - 0 | ||
| Division 13 | Special Construction | - 0 | ||
| Division 14 | Conveying Equipment | - 0 | ||
| Division 21 | Fire Suppression | - 0 | ||
| Division 22 | Plumbing | - 0 | ||
| Division 23 | HVAC | - 0 | ||
| Division 26 | Electrical | - 0 | ||
| Division 27 | Communications | - 0 | ||
| Division 28 | Electronic Safety & Security | - 0 | ||
| Division 31 | Earthwork | - 0 | ||
| Division 32 | Exterior Improvements | - 0 | ||
| Division 33 | Utilities | - 0 | ||
| Division 34 | Transportation Subtotal | - 0 | ||
| Division Subtotals : | $ - 0 | $ - 0 | $ - 0 |
Overhead % 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 % | ||
| 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 % |
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 .