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

About this file

This is a Construction Cost Estimate template in CSI (Construction Specifications Institute) 50 Division format for a federal construction project. The document is designed to help contractors develop detailed cost proposals for PROJECT 668-24-103, Replace Buildings 1, 2, 3, and 31 Roofing Systems at Mann-Grandstaff VA Medical Center in Spokane, Washington. The template includes prefilled division sheets for Divisions 1 (General Requirements), 2 (Existing Conditions), and 3 (Concrete Work) with sample inputs to illustrate functionality, along with blank division tabs for Divisions 5, 6, 7, 10, 13, 22, 23, and 26 covering metals, wood/plastics/composites, thermal and moisture protection, specialties, special construction, plumbing, HVAC, and electrical work respectively.

The spreadsheet automatically calculates subtotals and applies user-defined overhead and profit percentages for both prime contractors and subcontractors, with default rates of 10% GC overhead, 10% GC profit, 5% subcontractor overhead, and 11% subcontractor profit. Additional calculation fields include sales tax at 6% and builder's risk/performance bonds at 2%. The summary page requires contractors to fill in date, company name, project number, and percentages for overhead and profit, with all other values auto-populating from the individual division tabs. The template accommodates the project's pricing structure which includes a base item for all work and four proposal deduct items for individual buildings, with the government retaining sole discretion on awarding deduct items based on available funding.

View the file

Other files

File Type Posted
36C26026R0081 0004.docx DOCX document
36C26026R0081 0003.docx DOCX document
36C26026R0081 0002.docx DOCX document
36C26026R0081 0001.docx DOCX document
Attachment 11 Wage Determination WA20260114.pdf PDF
Attachment 6 668-24-103 HAZ B3.pdf PDF
36C26026R0081_1.docx DOCX document
Attachment 8 Limitations on Subcontracting-Construction.pdf PDF
Attachment 5 668-24-103 HAZ B2.pdf PDF
Attachment 1 SOW.docx DOCX document
Attachment 7 668-24-103 HAZ B31.pdf PDF
Attachment 4 668-24-103 HAZ B1.pdf PDF
Attachment 3 Drawings.pdf PDF
Attachment 9 Past Performance Questionnaire.docx DOCX document
Attachment 2 Specifications.pdf PDF
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

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 .