Attachment 10 Division Cost Breakout.xls

XLS spreadsheet 311 KB Posted

Attached to
Z2DA--CON-NRM 668-24-103 Replace Roofing Buildings 1, 2, 3, and 31
Solicitation number
36C26026R0081
Issued by

About this file

This is a construction cost estimate template formatted in CSI (Construction Specifications Institute) 50 Divisions format for use in submitting pricing proposals for federal construction contracts. The template is designed for Project 668-24-103, "Replace Buildings 1, 2, 3, and 31 Roofing Systems" at Mann-Grandstaff VA Medical Center in Spokane, Washington. The spreadsheet contains prefilled division sheets for Divisions 1 (General Requirements), 2 (Existing Conditions), and 3 (Concrete Work) that serve as sample inputs demonstrating how to use the tool, with contractors permitted to add missing items, additional divisions, or propose alternatives where disagreements exist with prefilled elements.

The template incorporates automated calculation fields for labor and material costs by division, with provisions for subcontractor overhead and profit percentages (default 5% and 11% respectively), sales tax (6%), and general contractor overhead and profit (both 10% default). The summary page automatically tabulates division costs and requires manual entry of company information, date, estimator details, and design basis code (no design completed through final design). Special instructions note that contractors may self-perform work with zeroed profit and overhead for that division, and that different subcontractor rates require individual division adjustments. The sample demonstrates a current hard cost total of $173.93 with a projected contract total of $214.66 including overhead, profit, and builder's risk/performance bonds at 2%.

View the file

Other files

Show all 11

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
668-24-103, Replace Buildings 1, 2, 3, and 31 Roofing Systems
LOCATIONPROJECT NO.668-24-103
Mann-Grandstaff VA Medical Center, Spokane, 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
668-24-103, Replace Buildings 1, 2, 3, and 31 Roofing SystemsCODE A (No design completed)
LOCATIONCODE B (Preliminary design)
Mann-Grandstaff VA Medical Center, Spokane, WACODE C (Final design)
COMPANYPROJECT NO.OTHER (Specify)
Fill Here668-24-103
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
668-24-103, Replace Buildings 1, 2, 3, and 31 Roofing SystemsCODE A (No design completed)
LOCATIONCODE B (Preliminary design)
Mann-Grandstaff VA Medical Center, Spokane, WACODE C (Final design)
COMPANYPROJECT NO.OTHER (Specify)
Fill Here668-24-103
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
668-24-103, Replace Buildings 1, 2, 3, and 31 Roofing SystemsCODE A (No design completed)
LOCATIONCODE B (Preliminary design)
Mann-Grandstaff VA Medical Center, Spokane, WACODE C (Final design)
COMPANYPROJECT NO.OTHER (Specify)
Fill Here668-24-103
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
668-24-103, Replace Buildings 1, 2, 3, and 31 Roofing SystemsCODE A (No design completed)
LOCATIONCODE B (Preliminary design)
Mann-Grandstaff VA Medical Center, Spokane, WACODE C (Final design)
COMPANYPROJECT NO.OTHER (Specify)
Fill Here668-24-103
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
668-24-103, Replace Buildings 1, 2, 3, and 31 Roofing SystemsCODE A (No design completed)
LOCATIONCODE B (Preliminary design)
Mann-Grandstaff VA Medical Center, Spokane, WACODE C (Final design)
COMPANYPROJECT NO.OTHER (Specify)
Fill Here668-24-103
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
668-24-103, Replace Buildings 1, 2, 3, and 31 Roofing SystemsCODE A (No design completed)
LOCATIONCODE B (Preliminary design)
Mann-Grandstaff VA Medical Center, Spokane, WACODE C (Final design)
COMPANYPROJECT NO.OTHER (Specify)
Fill Here668-24-103
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
668-24-103, Replace Buildings 1, 2, 3, and 31 Roofing SystemsCODE A (No design completed)
LOCATIONCODE B (Preliminary design)
Mann-Grandstaff VA Medical Center, Spokane, WACODE C (Final design)
COMPANYPROJECT NO.OTHER (Specify)
Fill Here668-24-103
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
668-24-103, Replace Buildings 1, 2, 3, and 31 Roofing SystemsCODE A (No design completed)
LOCATIONCODE B (Preliminary design)
Mann-Grandstaff VA Medical Center, Spokane, WACODE C (Final design)
COMPANYPROJECT NO.OTHER (Specify)
Fill Here668-24-103
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
668-24-103, Replace Buildings 1, 2, 3, and 31 Roofing SystemsCODE A (No design completed)
LOCATIONCODE B (Preliminary design)
Mann-Grandstaff VA Medical Center, Spokane, WACODE C (Final design)
COMPANYPROJECT NO.OTHER (Specify)
Fill Here668-24-103
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
668-24-103, Replace Buildings 1, 2, 3, and 31 Roofing SystemsCODE A (No design completed)
LOCATIONCODE B (Preliminary design)
Mann-Grandstaff VA Medical Center, Spokane, WACODE C (Final design)
COMPANYPROJECT NO.OTHER (Specify)
Fill Here668-24-103
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
668-24-103, Replace Buildings 1, 2, 3, and 31 Roofing SystemsCODE A (No design completed)
LOCATIONCODE B (Preliminary design)
Mann-Grandstaff VA Medical Center, Spokane, WACODE C (Final design)
COMPANYPROJECT NO.OTHER (Specify)
Fill Here668-24-103
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 .