Attachment 11 - 668-24-102 - Cost Division Breakout.xls

XLS spreadsheet 215 KB Posted Feb 27, 2026

Attached to: Y1DA--CON-NRM-668-24-102 Replace Windows Building 1 Federal contract opportunity
Solicitation number: 36C26026R0011
Issued by: Department of Veterans Affairs Veterans Health Administration Veterans Integrated Service Network 20

About this file

Written by GovTribe AI · Feb 27, 2026

This is a Construction Cost Estimate template in CSI (Construction Specifications Institute) Format for solicitation 668-24-102, "Replace Exterior Windows Building 1" at Mann-Grandstaff VA Medical Center in Spokane, Washington. The spreadsheet is designed to assist contractors in preparing detailed cost proposals by division using a prefilled structure that links individual division estimates to a summary page with automatic calculations for overhead, profit, sales tax, bonding, and risk.

The template includes six active CSI divisions: Division 01 (General Requirements), Division 02 (Existing Conditions), Division 07 (Thermal and Moisture Protection), Division 08 (Openings), Division 09 (Finishes), and Division 12 (Furnishings). Contractors may add missing items or additional divisions beyond those prefilled. The spreadsheet automatically calculates the hard cost total, applies configurable overhead and profit percentages for both prime contractors (10% overhead and 10% profit as defaults) and subcontractors (5% overhead and 11% profit as defaults), includes 6% Florida State Sales Tax, 2% Builder's Risk/Performance Bonds, and generates a final contract total. Key instructions specify that if prime contractors self-perform work, overhead and profit must be zeroed for that division to avoid double-counting, and if subcontractors have different rates, adjustments must be made at the division level while maintaining spreadsheet integrity. The form requires contractors to complete designated "Fill Here" fields including company name, date, estimator information, and percentage rates, with all other calculations auto-populating from division entries.

View the file

Other files for this federal contract opportunity

Other files attached to Y1DA--CON-NRM-668-24-102 Replace Windows Building 1, newest first.
File	Type	Posted
668-24-102 Technical Questions Consolidated Responses updated 4-3-2026.pdf	PDF	Apr 3, 2026
36C26026R0011 0004.docx	DOCX document	Apr 3, 2026
Attachment 11- Cost Division Breakout Version 1.xlsx	XLSX spreadsheet	Apr 3, 2026
82-1000 VA Spokane Windows HazMat Survey Report _no dwgs.pdf	PDF	Mar 26, 2026
36C26026R0011 - 668-24-102 - Questions with Consolidated Responses.pdf	PDF	Mar 26, 2026
24-046.2 MGVAMC Summer 2024 AHERA 3-Year Reinspection Rpt_.pdf	PDF	Mar 26, 2026
36C26026R0011_1 Solicitation Page 27.pdf	PDF	Mar 26, 2026
36C26026R0011 0003.docx	DOCX document	Mar 26, 2026
36C26026R0011 0002.docx	DOCX document	Mar 13, 2026
668-24-102 Pre-Bid Walk-Through Sign In.pdf	PDF	Mar 13, 2026
36C26026R0011 0001.docx	DOCX document	Mar 4, 2026
Attachment 13 - 668-24-102 - Site Visit Area Map - Revised.pdf	PDF	Mar 4, 2026
Attachment 13 - 668-24-102 - Site Visit Area Map.pdf	PDF	Feb 27, 2026
Attachment 6 - 668-22-102 - LEVEL 3 Window project VHA ICRA.pdf	PDF	Feb 27, 2026
Attachment 2 - 668-24-102 - BID SET DRAWINGS.pdf	PDF	Feb 27, 2026
36C26026R0011_1.docx	DOCX document	Feb 27, 2026
Attachment 12 - 668-24-102 - Spokane Wage Determination 1_23_26.pdf	PDF	Feb 27, 2026
Attachment 9 - 668-24-102 - Contractor Rules of Behavior.pdf	PDF	Feb 27, 2026
Attachment 4 - 668-24-102 - PCRA_VHA PCRA.pdf	PDF	Feb 27, 2026
Attachment 10 - 668-24-102 - Past Performance Questionnaire.docx	DOCX document	Feb 27, 2026
Attachment 8 - 668-24-102 - Limitations on Subcontracting-Construction.pdf	PDF	Feb 27, 2026
Attachment 7 - 668-24-102 - Hazardous Survey Report.pdf	PDF	Feb 27, 2026
Attachment 5 - 668-24-102 - LEVEL 2 Window project VHA ICRA.pdf	PDF	Feb 27, 2026
Attachment 3 - 668-24-102 - BID SET SPECIFICATIONS 2_18_26.pdf	PDF	Feb 27, 2026
Attachment 1 - 668-24-102 - CON SOW.pdf	PDF	Feb 27, 2026

Show all 25

On GovTribe

Work with this file on GovTribe

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

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 ESTIMATE		Date:
				Fill Here
	COMPANY
	Fill Here
	PROJECT
	668-24-102 - Replace Exterior Windows Bldg 1
	LOCATION		PROJECT NO.	663-21-100
	Mann-Grandstaff VA Medical Center, Spokane, WA
	DIVISION	DESCRIPTION	% by
Division	Division Total
	DIVISION 01	GENERAL REQUIREMENTS	45.7%	50.00
	DIVISION 02	EXISTING CONDITIONS	54.3%	59.48
	DIVISION 07	THERMAL AND MOISTURE PROTECTION	0.0%	- 0	FILL IN AS REQUIRED (this will link to the entire document)
	DIVISION 08	OPENINGS	0.0%	- 0
	DIVISION 09	FINISHES	0.0%	- 0
	DIVISION 12	FURNISHINGS	0.0%	- 0	GC Overhead	10.00%
					GC Profit	10.00%
	HARD COST TOTAL		100%	109.48	Sub Overhead	5.00%
					Sub Profit	11.00%
					Sales Tax	6.00%
	PRIME GENERAL CONTRACT OFFICE OVERHEAD (Fill in%)		10%	10.95	Risk/Bonding	2.00%
	SUBTOTAL			120.42
	PRIME GENERAL CONTRACTOR'S PROFIT(Fill in%)		10%	12.04	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
	SUBTOTAL			132.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 ESTIMATE			DATE
			Fill Here
PROJECT					BASIS FOR ESTIMATE
668-24-102 - Replace Exterior Windows Bldg 1					CODE A (No design completed)
LOCATION					CODE B (Preliminary design)
Mann-Grandstaff VA Medical Center, Spokane, WA					CODE C (Final design)
COMPANY		PROJECT NO.			OTHER (Specify)
Fill Here		663-21-100
DRAWING NO.	ESTIMATOR				CHECKED BY
	QUANTITY		LABOR		MATERIAL
ITEM DESCRIPTION	NO. UNITS	UNIT MEAS.	PER UNIT	TOTAL	PER UNIT	TOTAL	TOTAL COST
GENERAL REQUIREMENTS
				- 0		- 0	- 0
				- 0		- 0	- 0
Sample Input	2			- 0	10.00	20.00	20.00
Sample Input	3	1.00	10.00	30.00		- 0	30.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/MATERIALS				30.00		20.00
SUBTOTAL							50.00
Sub-Contractor's Overhead						0.00%	- 0
Sub-Contractor's Profit						0.00%	- 0
FL State Sales Tax						0.00%	- 0
TOTAL							$ 50.00

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

Div2

CONSTRUCTION COST ESTIMATE			DATE
			Fill Here
PROJECT					BASIS FOR ESTIMATE
668-24-102 - Replace Exterior Windows Bldg 1					CODE A (No design completed)
LOCATION					CODE B (Preliminary design)
Mann-Grandstaff VA Medical Center, Spokane, WA					CODE C (Final design)
COMPANY		PROJECT NO.			OTHER (Specify)
Fill Here		663-21-100
DRAWING NO.	ESTIMATOR				CHECKED BY
	QUANTITY		LABOR		MATERIAL
ITEM DESCRIPTION	NO. UNITS	UNIT MEAS.	PER UNIT	TOTAL	PER UNIT	TOTAL	TOTAL COST
EXISTING CONDITIONS
				- 0		- 0	- 0
				- 0		- 0	- 0
Sample Input	2			- 0	10.00	20.00	20.00
Sample Input	3		10.00	30.00		- 0	30.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/MATERIALS				30.00		20.00
SUBTOTAL							50.00
Sub-Contractor's Overhead						5.00%	2.50
Sub-Contractor's Profit						11.00%	5.78
FL State Sales Tax						6.00%	1.20
TOTAL							$ 59.48

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

Div7

CONSTRUCTION COST ESTIMATE			DATE
			Fill Here
PROJECT					BASIS FOR ESTIMATE
668-24-102 - Replace Exterior Windows Bldg 1					CODE A (No design completed)
LOCATION					CODE B (Preliminary design)
Mann-Grandstaff VA Medical Center, Spokane, WA					CODE C (Final design)
COMPANY		PROJECT NO.			OTHER (Specify)
Fill Here		663-21-100
DRAWING NO.	ESTIMATOR				CHECKED BY
	QUANTITY		LABOR		MATERIAL
ITEM DESCRIPTION	NO. UNITS	UNIT MEAS.	PER UNIT	TOTAL	PER UNIT	TOTAL	TOTAL 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 Overhead						5.00%	- 0
Sub-Contractor's Profit						11.00%	- 0
FL State Sales Tax						6.00%	- 0
TOTAL							$ - 0

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

Div8

CONSTRUCTION COST ESTIMATE			DATE
			Fill Here
PROJECT					BASIS FOR ESTIMATE
668-24-102 - Replace Exterior Windows Bldg 1					CODE A (No design completed)
LOCATION					CODE B (Preliminary design)
Mann-Grandstaff VA Medical Center, Spokane, WA					CODE C (Final design)
COMPANY		PROJECT NO.			OTHER (Specify)
Fill Here		663-21-100
DRAWING NO.	ESTIMATOR				CHECKED BY
	QUANTITY		LABOR		MATERIAL
ITEM DESCRIPTION	NO. UNITS	UNIT MEAS.	PER UNIT	TOTAL	PER UNIT	TOTAL	TOTAL COST
OPENINGS
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 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 Overhead						5.00%	- 0
Sub-Contractor's Profit						11.00%	- 0
FL State Sales Tax						6.00%	- 0
TOTAL							$ - 0

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

Div9

CONSTRUCTION COST ESTIMATE			DATE
			Fill Here
PROJECT					BASIS FOR ESTIMATE
668-24-102 - Replace Exterior Windows Bldg 1					CODE A (No design completed)
LOCATION					CODE B (Preliminary design)
Mann-Grandstaff VA Medical Center, Spokane, WA					CODE C (Final design)
COMPANY		PROJECT NO.			OTHER (Specify)
Fill Here		663-21-100
DRAWING NO.	ESTIMATOR				CHECKED BY
	QUANTITY		LABOR		MATERIAL
ITEM DESCRIPTION	NO. UNITS	UNIT MEAS.	PER UNIT	TOTAL	PER UNIT	TOTAL	TOTAL 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 Overhead						5.00%	- 0
Sub-Contractor's Profit						11.00%	- 0
FL State Sales Tax						6.00%	- 0
TOTAL							$ - 0

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

Div12

CONSTRUCTION COST ESTIMATE			DATE
			Fill Here
PROJECT					BASIS FOR ESTIMATE
668-24-102 - Replace Exterior Windows Bldg 1					CODE A (No design completed)
LOCATION					CODE B (Preliminary design)
Mann-Grandstaff VA Medical Center, Spokane, WA					CODE C (Final design)
COMPANY		PROJECT NO.			OTHER (Specify)
Fill Here		663-21-100
DRAWING NO.	ESTIMATOR				CHECKED BY
	QUANTITY		LABOR		MATERIAL
ITEM DESCRIPTION	NO. UNITS	UNIT MEAS.	PER UNIT	TOTAL	PER UNIT	TOTAL	TOTAL COST
FURNISHINGS
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 0		- 0	- 0
				- 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 Overhead						5.00%	- 0
Sub-Contractor's Profit						11.00%	- 0
FL State Sales Tax						6.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 Feb 27, 2026.