Attachment 8 - 663-21-100 - Division Price Schedule.xls

XLS spreadsheet 319 KB Posted

Attached to
S112--CON-NRM 663-21-100 UPGRADE EXTERNAL SECURITY SYSTEM FY26 Tier 1
Solicitation number
36C26026R0029
Issued by

About this file

This file is a Division Price Schedule spreadsheet template in CSI (Construction Specifications Institute) format for the Upgrade Exterior Security System project (663-21-100) at VA Puget Sound Medical Center in Seattle, Washington. The template provides a standardized framework for contractors to develop detailed cost estimates organized by construction divisions, including General Requirements (Division 01), Existing Conditions (Division 02), Thermal and Moisture Protection (Division 07), Finishes (Division 09), Specialties (Division 10), Electrical (Division 26), Communications (Division 27), Electronic Safety and Security (Division 28), Earthwork (Division 31), Exterior Improvements (Division 32), and Transportation (Division 34).

The spreadsheet contains prefilled division sheets with sample inputs demonstrating how to complete labor and material cost calculations by line item. Instructions direct contractors not to delete prefilled elements but to leave disagreed items blank and add suggested replacements at the division tab bottom. The template includes automatic calculation functions for subcontractor overhead (5.00%) and profit (11.00%), Washington State sales tax (6.00%), prime general contractor overhead (10.00%), prime profit (10.00%), and builder's risk/performance bonds (2.00%). The summary page consolidates all divisional costs and requires contractors to complete specific "Fill Here" fields including company name, date, basis for estimate, and design phase code (ranging from preliminary to final design). The current sample estimate demonstrates a hard cost total of $109.48 with a final contract total of $135.11 after applying all overhead, profit, and bonding percentages.

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 Divisions Cost Estimate CSI* Format tool to build your proposal. 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
663-21-100 - Upgrade Exterior Security System
LOCATIONPROJECT NO.663-21-100
VA Puget Sound Medical Center, Seattle, WA
DIVISIONDESCRIPTION% by
DivisionDivision Total
DIVISION 01GENERAL REQUIREMENTS45.7%50.00
DIVISION 02EXISTING CONDITIONS54.3%59.48
DIVISION 07THERMAL AND MOISTURE PROTECTION0.0%- 0FILL IN AS REQUIRED (this will link to the entire document)
DIVISION 09FINISHES0.0%- 0
DIVISION 10SPECIALTIES
DIVISION 26ELECTRICAL0.0%- 0
DIVISION 27COMMUNICATIONS0.0%- 0GC Overhead10.00%
DIVISION 28ELECTRONIC SAFETY AND SECURITY0.0%- 0GC Profit10.00%
DIVISION 31EARTHWORK0.0%- 0Sub Overhead5.00%
DIVISION 32EXTERIOR IMPROVEMENTS0.0%- 0Sub Profit11.00%
DIVISION 34TRANSPORTATION0.0%- 0Sales Tax6.00%
Risk/Bonding2.00%
HARD COST TOTAL100%109.48
This 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%10.95
SUBTOTAL120.42
PRIME GENERAL CONTRACTOR'S PROFIT(Fill in%)10%12.04
SUBTOTAL132.46
BUILDER'S RISK / PERFORMANCE BONDS (Fill in%)2%2.65
CONTRACT TOTAL$ 135.11

&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
663-21-100 - Upgrade Exterior Security SystemCODE A (No design completed)
LOCATIONCODE B (Preliminary design)
VA Puget Sound Medical Center, Seattle, 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
WA 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
663-21-100 - Upgrade Exterior Security SystemCODE A (No design completed)
LOCATIONCODE B (Preliminary design)
VA Puget Sound Medical Center, Seattle, 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
WA State Sales Tax6.00%1.20
TOTAL$ 59.48

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

Div7

CONSTRUCTION COST ESTIMATEDATE
Fill Here
PROJECTBASIS FOR ESTIMATE
663-21-100 - Upgrade Exterior Security SystemCODE A (No design completed)
LOCATIONCODE B (Preliminary design)
VA Puget Sound Medical Center, Seattle, 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
WA State Sales Tax6.00%- 0
TOTAL$ - 0

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

Div9

CONSTRUCTION COST ESTIMATEDATE
Fill Here
PROJECTBASIS FOR ESTIMATE
663-21-100 - Upgrade Exterior Security SystemCODE A (No design completed)
LOCATIONCODE B (Preliminary design)
VA Puget Sound Medical Center, Seattle, 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
FINISHES
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 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
WA 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
663-21-100 - Upgrade Exterior Security SystemCODE A (No design completed)
LOCATIONCODE B (Preliminary design)
VA Puget Sound Medical Center, Seattle, 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
WA State Sales Tax6.00%- 0
TOTAL$ - 0

Div26

CONSTRUCTION COST ESTIMATEDATE
Fill Here
PROJECTBASIS FOR ESTIMATE
663-21-100 - Upgrade Exterior Security SystemCODE A (No design completed)
LOCATIONCODE B (Preliminary design)
VA Puget Sound Medical Center, Seattle, 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
WA State Sales Tax6.00%- 0
TOTAL$ - 0

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

Div27

CONSTRUCTION COST ESTIMATEDATE
Fill Here
PROJECTBASIS FOR ESTIMATE
663-21-100 - Upgrade Exterior Security SystemCODE A (No design completed)
LOCATIONCODE B (Preliminary design)
VA Puget Sound Medical Center, Seattle, 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
COMMUNICATIONS
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 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
WA State Sales Tax6.00%- 0
TOTAL$ - 0

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

Div28

CONSTRUCTION COST ESTIMATEDATE
Fill Here
PROJECTBASIS FOR ESTIMATE
663-21-100 - Upgrade Exterior Security SystemCODE A (No design completed)
LOCATIONCODE B (Preliminary design)
VA Puget Sound Medical Center, Seattle, 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
ELECTRONIC SAFETY AND SECURITY
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 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
WA State Sales Tax6.00%- 0
TOTAL$ - 0

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

Div31

CONSTRUCTION COST ESTIMATEDATE
Fill Here
PROJECTBASIS FOR ESTIMATE
663-21-100 - Upgrade Exterior Security SystemCODE A (No design completed)
LOCATIONCODE B (Preliminary design)
VA Puget Sound Medical Center, Seattle, 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
EARTHWORK
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 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
WA State Sales Tax6.00%- 0
TOTAL$ - 0

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

Div32

CONSTRUCTION COST ESTIMATEDATE
Fill Here
PROJECTBASIS FOR ESTIMATE
663-21-100 - Upgrade Exterior Security SystemCODE A (No design completed)
LOCATIONCODE B (Preliminary design)
VA Puget Sound Medical Center, Seattle, 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
EXTERIOR IMPROVEMENTS
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 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
WA State Sales Tax6.00%- 0
TOTAL$ - 0

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

Div34

CONSTRUCTION COST ESTIMATEDATE
Fill Here
PROJECTBASIS FOR ESTIMATE
663-21-100 - Upgrade Exterior Security SystemCODE A (No design completed)
LOCATIONCODE B (Preliminary design)
VA Puget Sound Medical Center, Seattle, 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
TRANSPORTATION
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 0- 0- 0
- 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
WA 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 .