Attachment 9 - 663A4-23-201 - Division Cost Breakout.xls

XLS spreadsheet 316 KB Posted

Attached to
N041--CON-NRM-663A4-23-201 Replace 40 Ton Condenser BLDG 200
Solicitation number
36C26026R0035
Issued by

About this file

This is a Construction Cost Estimate template in CSI (Construction Specifications Institute) format for federal contracting purposes. The document is a spreadsheet-based tool designed to estimate costs for Project 663A4-23-201, which involves replacing a 40-ton condenser in Building 200 at VA Puget Sound Medical Center - AMLK Campus in Tacoma, Washington. The template is structured with individual division tabs corresponding to CSI divisions, including General Requirements (Division 01), Existing Conditions (Division 02), Concrete Work (Division 03), Metals (Division 05), Wood/Plastics/Composites (Division 06), Thermal and Moisture Protection (Division 07), Specialties (Division 10), Special Construction (Division 13), Plumbing (Division 22), HVAC (Division 23), and Electrical (Division 26).

The spreadsheet includes prefilled division sheets with sample inputs to illustrate functionality, though contractors are permitted to modify, delete, or add line items as necessary. Key features include automated calculation fields for labor and material costs, with subcontractor overhead and profit percentages applied at the division level (5-11 percent overhead, 11-15 percent profit depending on division). The summary page consolidates all division costs and applies prime contractor overhead (10 percent), profit (10 percent), sales tax (6 percent), and builder's risk/performance bonds (2 percent) to arrive at the contract total. The document explicitly notes that the spreadsheet contains formulas and recommends saving a copy before editing. All shaded areas are either linked to formulas or linked to other sections, requiring careful attention when making modifications. Contractors must complete designated "Fill Here" fields including company name, date, basis for estimate code, and drawing numbers.

View the file

Other files

Show all 22

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

Instructions

Use the information from the prefilled division sheets below to complete the 50 Divisions Cost Estimate CSI* Format tool to build your proposal. The information from the prefilled division sheets may not be all inclusive. The contractor is allowed to include any missing items from each division and is allowed to fill in other divisions that are not listed in the prefilled division sheets. If there is a disagreement with the prefilled division sheets, the contractor should not delete the element(s), but instead leave it blank and then include their suggested element(s) at the bottom of that division tab. Please note that on the summary page there is a place to fill in overhead and profit percentages for both the prime and the subcontractor that will self-populate the summary page and all the division tabs.

Exceptions:

(1) if each subcontractor has a different overhead and profit rates than the percentage placed on the summary page, an adjustment will have to be made to that specific division page. The spreadsheet will still calculate correctly.

(2) If the prime is self-performing the work for that division then the profit and overhead will need to be zeroed for that particular division, because the primes overhead and profit is already captured on the summary page.

The ktr is required to complete the areas marked "Fill Here" in the summary tab. The rest of the information in the summary tab will automatically tabulate from the individual division tabs except for the few exceptions listed above.
Divisions 1, 2, and 3 show sample inputs to illustrate how the spreadsheet works.
* CSI = Construction Specifications Institute

&L&"Verdana,Bold"Construction Cost Estimate &R&P of &N

Summary

CONSTRUCTION COST ESTIMATEDate:
Fill Here
COMPANY
Fill Here
PROJECT
663A4-23-201 - Replace 40 Ton Condenser Bldg 200
LOCATIONPROJECT NO.663-21-100
VA Puget Sound Medical Center - AMLK Campus, Tacoma, WA
DIVISIONDESCRIPTION% by
DivisionDivision Total
DIVISION 01GENERAL REQUIREMENTS28.7%50.00
DIVISION 02EXISTING CONDITIONS34.2%59.48
DIVISION 03CONCRETE WORK37.1%64.45FILL IN AS REQUIRED (this will link to the entire document)
DIVISION 05METALS- 0
DIVISION 06WOOD, PLASTICS AND COMPOSITES0.0%- 0
DIVISION 07THERMAL AND MOISTURE PROTECTION0.0%- 0GC Overhead10.00%
DIVISION 10SPECIALTIES0.0%- 0GC Profit10.00%
DIVISION 13SPECIAL CONSTRUCTION- 0Sub Overhead5.00%
DIVISION 22PLUMBING0.0%- 0Sub Profit11.00%
DIVISION 23HEATING, VENTILATING AND A/C0.0%- 0Sales Tax6.00%
DIVISION 26ELECTRICAL0.0%- 0Risk/Bonding2.00%
HARD COST TOTAL100%173.93This spreadsheet contains many formulas... please save a copy prior to editting in case you make a mistake. All shaded areas are either linked or contain formulas
PRIME GENERAL CONTRACT OFFICE OVERHEAD (Fill in%)10%17.39
SUBTOTAL191.32
PRIME GENERAL CONTRACTOR'S PROFIT(Fill in%)10%19.13
SUBTOTAL210.45
BUILDER'S RISK / PERFORMANCE BONDS (Fill in%)2%4.21
CONTRACT TOTAL$ 214.66

&L&"Verdana,Bold"Construction Cost Estimate &R&P of &N davisjam:

Percentages listed are place fillers. Please complete as required

Div1

CONSTRUCTION COST ESTIMATEDATE
Fill Here
PROJECTBASIS FOR ESTIMATE
663A4-23-201 - Replace 40 Ton Condenser Bldg 200CODE A (No design completed)
LOCATIONCODE B (Preliminary design)
VA Puget Sound Medical Center - AMLK Campus, Tacoma, WACODE C (Final design)
COMPANYPROJECT NO.OTHER (Specify)
Fill Here663-21-100
DRAWING NO.ESTIMATORCHECKED BY
QUANTITYLABORMATERIAL
ITEM DESCRIPTIONNO. UNITSUNIT MEAS.PER UNITTOTALPER UNITTOTALTOTAL COST
GENERAL REQUIREMENTS
- 0- 0- 0
- 0- 0- 0
Sample Input2- 010.0020.0020.00
Sample Input31.0010.0030.00- 030.00
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
TOTAL LABOR/MATERIALS30.0020.00
SUBTOTAL50.00
Sub-Contractor's Overhead0.00%- 0
Sub-Contractor's Profit0.00%- 0
FL State Sales Tax0.00%- 0
TOTAL$ 50.00

&L&"Verdana,Bold"Construction Cost Estimate &R&P of &N

Div2

CONSTRUCTION COST ESTIMATEDATE
Fill Here
PROJECTBASIS FOR ESTIMATE
663A4-23-201 - Replace 40 Ton Condenser Bldg 200CODE A (No design completed)
LOCATIONCODE B (Preliminary design)
VA Puget Sound Medical Center - AMLK Campus, Tacoma, WACODE C (Final design)
COMPANYPROJECT NO.OTHER (Specify)
Fill Here663-21-100
DRAWING NO.ESTIMATORCHECKED BY
QUANTITYLABORMATERIAL
ITEM DESCRIPTIONNO. UNITSUNIT MEAS.PER UNITTOTALPER UNITTOTALTOTAL COST
EXISTING CONDITIONS
- 0- 0- 0
- 0- 0- 0
Sample Input2- 010.0020.0020.00
Sample Input310.0030.00- 030.00
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
TOTAL LABOR/MATERIALS30.0020.00
SUBTOTAL50.00
Sub-Contractor's Overhead5.00%2.50
Sub-Contractor's Profit11.00%5.78
FL State Sales Tax6.00%1.20
TOTAL$ 59.48

&L&"Verdana,Bold"Construction Cost Estimate &R&P of &N

Div3

CONSTRUCTION COST ESTIMATEDATE
Fill Here
PROJECTBASIS FOR ESTIMATE
663A4-23-201 - Replace 40 Ton Condenser Bldg 200CODE A (No design completed)
LOCATIONCODE B (Preliminary design)
VA Puget Sound Medical Center - AMLK Campus, Tacoma, WACODE C (Final design)
COMPANYPROJECT NO.OTHER (Specify)
Fill Here663-21-100
DRAWING NO.ESTIMATORCHECKED BY
QUANTITYLABORMATERIAL
ITEM DESCRIPTIONNO. UNITSUNIT MEAS.PER UNITTOTALPER UNITTOTALTOTAL COST
CONCRETE WORK
- 0- 0- 0
- 0- 0- 0
Sample Input2- 010.0020.0020.00
Sample Input310.0030.00- 030.00
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
TOTAL LABOR/MATERIALS30.0020.00
SUBTOTAL50.00
Sub-Contractor's Overhead10.00%5.00
Sub-Contractor's Profit15.00%8.25
FL State Sales Tax6.00%1.20
TOTAL$ 64.45

&L&"Verdana,Bold"Construction Cost Estimate &R&P of &N

Div5

CONSTRUCTION COST ESTIMATEDATE
Fill Here
PROJECTBASIS FOR ESTIMATE
663A4-23-201 - Replace 40 Ton Condenser Bldg 200CODE A (No design completed)
LOCATIONCODE B (Preliminary design)
VA Puget Sound Medical Center - AMLK Campus, Tacoma, WACODE C (Final design)
COMPANYPROJECT NO.OTHER (Specify)
Fill Here663-21-100
DRAWING NO.ESTIMATORCHECKED BY
QUANTITYLABORMATERIAL
ITEM DESCRIPTIONNO. UNITSUNIT MEAS.PER UNITTOTALPER UNITTOTALTOTAL COST
METALS
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
TOTAL LABOR/MATERIALS- 0- 0
SUBTOTAL- 0
Sub-Contractor's Overhead10.00%- 0
Sub-Contractor's Profit15.00%- 0
FL State Sales Tax6.00%- 0
TOTAL$ - 0

Div6

CONSTRUCTION COST ESTIMATEDATE
Fill Here
PROJECTBASIS FOR ESTIMATE
663A4-23-201 - Replace 40 Ton Condenser Bldg 200CODE A (No design completed)
LOCATIONCODE B (Preliminary design)
VA Puget Sound Medical Center - AMLK Campus, Tacoma, WACODE C (Final design)
COMPANYPROJECT NO.OTHER (Specify)
Fill Here663-21-100
DRAWING NO.ESTIMATORCHECKED BY
QUANTITYLABORMATERIAL
ITEM DESCRIPTIONNO. UNITSUNIT MEAS.PER UNITTOTALPER UNITTOTALTOTAL COST
WOOD, PLASTICS AND COMPOSITES
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
TOTAL LABOR/MATERIALS- 0- 0
SUBTOTAL- 0
Sub-Contractor's Overhead5.00%- 0
Sub-Contractor's Profit11.00%- 0
FL State Sales Tax6.00%- 0
TOTAL$ - 0

&L&"Verdana,Bold"Construction Cost Estimate &R&P of &N

Div7

CONSTRUCTION COST ESTIMATEDATE
Fill Here
PROJECTBASIS FOR ESTIMATE
663A4-23-201 - Replace 40 Ton Condenser Bldg 200CODE A (No design completed)
LOCATIONCODE B (Preliminary design)
VA Puget Sound Medical Center - AMLK Campus, Tacoma, WACODE C (Final design)
COMPANYPROJECT NO.OTHER (Specify)
Fill Here663-21-100
DRAWING NO.ESTIMATORCHECKED BY
QUANTITYLABORMATERIAL
ITEM DESCRIPTIONNO. UNITSUNIT MEAS.PER UNITTOTALPER UNITTOTALTOTAL COST
THERMAL AND MOISTURE PROTECTION
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
TOTAL LABOR/MATERIALS- 0- 0
SUBTOTAL- 0
Sub-Contractor's Overhead5.00%- 0
Sub-Contractor's Profit11.00%- 0
FL State Sales Tax6.00%- 0
TOTAL$ - 0

&L&"Verdana,Bold"Construction Cost Estimate &R&P of &N

Div10

CONSTRUCTION COST ESTIMATEDATE
Fill Here
PROJECTBASIS FOR ESTIMATE
663A4-23-201 - Replace 40 Ton Condenser Bldg 200CODE A (No design completed)
LOCATIONCODE B (Preliminary design)
VA Puget Sound Medical Center - AMLK Campus, Tacoma, WACODE C (Final design)
COMPANYPROJECT NO.OTHER (Specify)
Fill Here663-21-100
DRAWING NO.ESTIMATORCHECKED BY
QUANTITYLABORMATERIAL
ITEM DESCRIPTIONNO. UNITSUNIT MEAS.PER UNITTOTALPER UNITTOTALTOTAL COST
SPECIALTIES
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
TOTAL LABOR/MATERIALS- 0- 0
SUBTOTAL$ - 0
Sub-Contractor's Overhead5.00%- 0
Sub-Contractor's Profit11.00%- 0
FL State Sales Tax6.00%- 0
TOTAL$ - 0

&L&"Verdana,Bold"Construction Cost Estimate &R&P of &N

Div13

CONSTRUCTION COST ESTIMATEDATE
Fill Here
PROJECTBASIS FOR ESTIMATE
663A4-23-201 - Replace 40 Ton Condenser Bldg 200CODE A (No design completed)
LOCATIONCODE B (Preliminary design)
VA Puget Sound Medical Center - AMLK Campus, Tacoma, WACODE C (Final design)
COMPANYPROJECT NO.OTHER (Specify)
Fill Here663-21-100
DRAWING NO.ESTIMATORCHECKED BY
QUANTITYLABORMATERIAL
ITEM DESCRIPTIONNO. UNITSUNIT MEAS.PER UNITTOTALPER UNITTOTALTOTAL COST
SPECIAL CONSTRUCTION
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
TOTAL LABOR/MATERIALS- 0- 0
SUBTOTAL$ - 0
Sub-Contractor's Overhead5.00%- 0
Sub-Contractor's Profit11.00%- 0
FL State Sales Tax6.00%- 0
TOTAL$ - 0

Div22

CONSTRUCTION COST ESTIMATEDATE
Fill Here
PROJECTBASIS FOR ESTIMATE
663A4-23-201 - Replace 40 Ton Condenser Bldg 200CODE A (No design completed)
LOCATIONCODE B (Preliminary design)
VA Puget Sound Medical Center - AMLK Campus, Tacoma, WACODE C (Final design)
COMPANYPROJECT NO.OTHER (Specify)
Fill Here663-21-100
DRAWING NO.ESTIMATORCHECKED BY
QUANTITYLABORMATERIAL
ITEM DESCRIPTIONNO. UNITSUNIT MEAS.PER UNITTOTALPER UNITTOTALTOTAL COST
PLUMBING
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
TOTAL LABOR/MATERIALS- 0- 0
SUBTOTAL$ - 0
Sub-Contractor's Overhead5.00%- 0
Sub-Contractor's Profit11.00%- 0
FL State Sales Tax6.00%- 0
TOTAL$ - 0

&L&"Verdana,Bold"Construction Cost Estimate &R&P of &N

Div23

CONSTRUCTION COST ESTIMATEDATE
Fill Here
PROJECTBASIS FOR ESTIMATE
663A4-23-201 - Replace 40 Ton Condenser Bldg 200CODE A (No design completed)
LOCATIONCODE B (Preliminary design)
VA Puget Sound Medical Center - AMLK Campus, Tacoma, WACODE C (Final design)
COMPANYPROJECT NO.OTHER (Specify)
Fill Here663-21-100
DRAWING NO.ESTIMATORCHECKED BY
QUANTITYLABORMATERIAL
ITEM DESCRIPTIONNO. UNITSUNIT MEAS.PER UNITTOTALPER UNITTOTALTOTAL COST
HEATING, VENTILATING AND A/C
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
TOTAL LABOR/MATERIALS- 0- 0
SUBTOTAL$ - 0
Sub-Contractor's Overhead5.00%- 0
Sub-Contractor's Profit11.00%- 0
FL State Sales Tax6.00%- 0
TOTAL$ - 0

&L&"Verdana,Bold"Construction Cost Estimate &R&P of &N

Div26

CONSTRUCTION COST ESTIMATEDATE
Fill Here
PROJECTBASIS FOR ESTIMATE
663A4-23-201 - Replace 40 Ton Condenser Bldg 200CODE A (No design completed)
LOCATIONCODE B (Preliminary design)
VA Puget Sound Medical Center - AMLK Campus, Tacoma, WACODE C (Final design)
COMPANYPROJECT NO.OTHER (Specify)
Fill Here663-21-100
DRAWING NO.ESTIMATORCHECKED BY
QUANTITYLABORMATERIAL
ITEM DESCRIPTIONNO. UNITSUNIT MEAS.PER UNITTOTALPER UNITTOTALTOTAL COST
ELECTRICAL
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
TOTAL LABOR/MATERIALS- 0- 0
SUBTOTAL- 0
Sub-Contractor's Overhead5.00%- 0
Sub-Contractor's Profit11.00%- 0
FL State Sales Tax6.00%- 0
TOTAL$ - 0

&L&"Verdana,Bold"Construction Cost Estimate &R&P of &N

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