S02_Itemized Cost Breakdown.xlsx

XLSX spreadsheet 29 KB Posted

Attached to
631-26-010 Abate and Upgrade Building 1 Common Area
Solicitation number
36C24126Q0357
Issued by

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 TitleProject Location
Offeror Name
Offeror Street
Offeror CityStateZip

Item Description Labor Cost Edward L Roy: Enter all Labor Costs by Division

Material Cost
Edward L Roy: Enter all Material Costs by DivisionTotal Cost

Edward L Roy: This Column is the sum of the Division's Labor and Material Costs

Division 1General Requirements$ - 0
Division 2Existing Conditions- 0
Division 3Concrete- 0
Division 4Masonry- 0
Division 5Metals- 0
Division 6Wood and Plastic- 0
Division 7Thermal & Moisture Protect- 0
Division 8Doors and Windows- 0
Division 9Finishes- 0
Division 10Specialties- 0
Division 11Equipment- 0
Division 12Furnishings- 0
Division 13Special Construction- 0
Division 14Conveying Equipment- 0
Division 21Fire Suppression- 0
Division 22Plumbing- 0
Division 23HVAC- 0
Division 26Electrical- 0
Division 27Communications- 0
Division 28Electronic Safety & Security- 0
Division 31Earthwork- 0
Division 32Exterior Improvements- 0
Division 33Utilities- 0
Division 34Transportation 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
DivisionLabor CategoryLabor RateHoursTotal
1Plumber$35.00123$4,305.00
1Laborer14.7570$1,032.50
$5,337.50

Materials and Equipment Details

Sample Example
DivisionItemRateUnitsTotal
1Pipe - 150'$1.50150$225.00
190 Degree Coupling$1.105$5.50
1Pump Rental - Hour$200.006$1,200.00
$1,430.50

File details come from the government source that posted it. Updated .