Attachment H - Cost Breakdown by Division.xlsx

XLSX spreadsheet 36 KB Posted

Attached to
Y1DA--652-24-103 Increase Surgical Access Federal contract opportunity
Solicitation number
36C24626R0023
Issued by
Department of Veterans Affairs Veterans Health Administration Veterans Integrated Service Network 6

About this file

This is a cost breakdown template for the "Increase Surgical Access" project (652-24-103) at the VA Medical Center in Richmond, Virginia. The spreadsheet is designed for offerors to submit pricing proposals organized by the 34 CSI (Construction Specifications Institute) divisions, which include General Requirements, Concrete, Masonry, Metals, HVAC, Electrical, Plumbing, and other construction trades. Offerors must enter labor costs and material costs for each division, with the template automatically calculating total costs per division. The template accommodates a Base Offer and two alternatives, allowing offerors to present multiple pricing scenarios.

The cost breakdown structure requires offerors to calculate overhead, profit, and bond percentages applied to the division subtotals in a cascading manner. Division 11 (Equipment) requires a separate cost breakout. All totals flow to a final Base Offer cost and alternative costs, with fields for offeror name, address, project location, and date of submission. This is a template document with no populated cost data and is intended for use by contractors responding to the RFP issued by the Department of Veterans Affairs Veterans Health Administration Veterans Integrated Service Network 6 (VISN 6). The document contains instructional notes attributed to "Edward L Roy" indicating where offerors should enter specific cost information.

View the file

Other files for this federal contract opportunity

Other files attached to Y1DA--652-24-103 Increase Surgical Access, newest first.
File Type Posted
36C24626R0023 0002.docx DOCX document
Photos.zip ZIP file
Pre-Bid Site Visit Agenda.pdf PDF
36C24626R0023 0001.docx DOCX document
Site.Visit.Log.04.09.2026.pdf PDF
Attachment A - Drawings.pdf PDF
Attachment G - Site Visit.docx DOCX document
Attachment C - Specifications Vol 2.pdf PDF
36C24626R0023_2.docx DOCX document
Attachment K - Brand Name Justification for Hillrom_Redacted.pdf PDF
Attachment F - Past Performance Questionnaire.docx DOCX document
Attachment I - Submittal Register.xlsx XLSX spreadsheet
Attachment D - Specifications Vol 3.pdf PDF
Attachment B - Specifications Vol 1.pdf PDF
Attachment J - 27 52 23 Nurse Call and Code Blue Systems ASI.pdf PDF
Attachment E - Wage Determination VA20250155.pdf PDF
Show all 16

On GovTribe

Work with this file on GovTribe

  • 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: 652-24-103 Edward L Roy: VA assigned project #

Date:
Project TitleIncrease Surgical Access

Edward L Roy: VA assigned Project Title

Project LocationVA Medical Center, Richmond, Va.
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$ - 0$ - 0
Division 2Existing Conditions- 0- 0- 0
Division 3Concrete- 0- 0- 0
Division 4Masonry- 0- 0- 0
Division 5Metals- 0- 0- 0
Division 6Wood and Plastic- 0- 0- 0
Division 7Thermal & Moisture Protect- 0- 0- 0
Division 8Doors and Windows- 0- 0- 0
Division 9Finishes- 0- 0- 0
Division 10Specialties- 0- 0- 0
Division 11Equipment***- 0- 0- 0
Division 12Furnishings- 0- 0- 0
Division 13Special Construction- 0- 0- 0
Division 14Conveying Equipment- 0- 0- 0
Division 21Fire Suppression- 0- 0- 0
Division 22Plumbing- 0- 0- 0
Division 23HVAC- 0- 0- 0
Division 26Electrical- 0- 0- 0
Division 27Communications- 0- 0- 0
Division 28Electronic Safety & Security- 0- 0- 0
Division 31Earthwork- 0- 0- 0
Division 32Exterior Improvements- 0- 0- 0
Division 33Utilities- 0- 0- 0
Division 34Transportation 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

*** Breakout the cost of equipment

Alternative 1

Alternative 1 Offer Cost Breakdown

Project Number: 652-24-103 Edward L Roy: VA assigned project #

Date:
Project TitleIncrease Surgical Access

Edward L Roy: VA assigned Project Title

Project LocationVA Medical Center, Richmond, Va.
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$ - 0$ - 0
Division 2Existing Conditions- 0- 0- 0
Division 3Concrete- 0- 0- 0
Division 4Masonry- 0- 0- 0
Division 5Metals- 0- 0- 0
Division 6Wood and Plastic- 0- 0- 0
Division 7Thermal & Moisture Protect- 0- 0- 0
Division 8Doors and Windows- 0- 0- 0
Division 9Finishes- 0- 0- 0
Division 10Specialties- 0- 0- 0
Division 11Equipment***- 0- 0- 0
Division 12Furnishings- 0- 0- 0
Division 13Special Construction- 0- 0- 0
Division 14Conveying Equipment- 0- 0- 0
Division 21Fire Suppression- 0- 0- 0
Division 22Plumbing- 0- 0- 0
Division 23HVAC- 0- 0- 0
Division 26Electrical- 0- 0- 0
Division 27Communications- 0- 0- 0
Division 28Electronic Safety & Security- 0- 0- 0
Division 31Earthwork- 0- 0- 0
Division 32Exterior Improvements- 0- 0- 0
Division 33Utilities- 0- 0- 0
Division 34Transportation 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: Enter all Material Costs by Division Edward L Roy: This Column is the sum of the Division's Labor and Material Costs Total Alt. 1 Offer Cost $ - 0 $ - 0 $ - 0

*** Breakout the cost of equipment

Alternative 2

Alternative 2 Offer Cost Breakdown

Project Number: 652-24-103 Edward L Roy: VA assigned project #

Date:
Project TitleIncrease Surgical Access

Edward L Roy: VA assigned Project Title

Project LocationVA Medical Center, Richmond, Va.
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$ - 0$ - 0
Division 2Existing Conditions- 0- 0- 0
Division 3Concrete- 0- 0- 0
Division 4Masonry- 0- 0- 0
Division 5Metals- 0- 0- 0
Division 6Wood and Plastic- 0- 0- 0
Division 7Thermal & Moisture Protect- 0- 0- 0
Division 8Doors and Windows- 0- 0- 0
Division 9Finishes- 0- 0- 0
Division 10Specialties- 0- 0- 0
Division 11Equipment***- 0- 0- 0
Division 12Furnishings- 0- 0- 0
Division 13Special Construction- 0- 0- 0
Division 14Conveying Equipment- 0- 0- 0
Division 21Fire Suppression- 0- 0- 0
Division 22Plumbing- 0- 0- 0
Division 23HVAC- 0- 0- 0
Division 26Electrical- 0- 0- 0
Division 27Communications- 0- 0- 0
Division 28Electronic Safety & Security- 0- 0- 0
Division 31Earthwork- 0- 0- 0
Division 32Exterior Improvements- 0- 0- 0
Division 33Utilities- 0- 0- 0
Division 34Transportation 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: Enter all Material Costs by Division Edward L Roy: This Column is the sum of the Division's Labor and Material Costs Total Alt. 1 Offer Cost $ - 0 $ - 0 $ - 0

*** Breakout the cost of equipment

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