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_1
Issued by

About this file

This is a Construction Cost Estimate template in CSI (Construction Specifications Institute) format for federal construction project 663A4-23-201, "Replace 40 Ton Condenser Bldg 200" at VA Puget Sound Medical Center - AMLK Campus in Tacoma, Washington. The spreadsheet is designed for contractors to submit detailed cost breakdowns organized by 50 CSI divisions, with prefilled divisions serving as examples that contractors may modify or supplement with additional line items as needed.

The template includes a summary page where contractors must fill in company name, date, and overhead/profit percentages for both prime contractors (with placeholder rates of 10% overhead and 10% profit) and subcontractors (5% overhead and 11% profit), along with sales tax (6%) and builder's risk/performance bonds (2%). The three sample divisions provided show cumulative costs: Division 1 (General Requirements) at $50.00, Division 2 (Existing Conditions) at $59.48 with subcontractor markups applied, and Division 3 (Concrete Work) at $64.45 with different subcontractor rates, resulting in a hard cost total of $173.93 and a final contract total of $214.66. All other divisions (5, 6, 7, 10, 13, 22, 23, 26) are currently empty, allowing contractors to populate costs as required. The spreadsheet contains automated formulas that self-populate the summary page and all division tabs based on individual division entries and the overhead/profit rates established on the summary page, with exceptions for cases where different subcontractors have varying rates or when the prime performs work directly.

View the file

Other files

Show all 12

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 .