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_1
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 (50 Divisions CSI Format tool) for solicitation 668-24-102, which involves replacing exterior windows in Building 1 at Mann-Grandstaff VA Medical Center in Spokane, Washington. The template is designed for contractors to build detailed cost proposals by completing prefilled division sheets and a summary page. Contractors are permitted to include missing items from each division and add items to unlisted divisions; if disagreements exist with prefilled information, contractors should leave conflicting elements blank and include suggested alternatives. The spreadsheet contains automatic calculations linking individual division tabs to the summary page, with provisions for separate overhead and profit percentages for prime contractors (currently showing 10% overhead and 10% profit) and subcontractors (5% overhead and 11% profit), as well as sales tax (6%), risk/bonding (2%), and builder's risk/performance bonds (2%).

The template includes populated sample data in Divisions 1 (General Requirements - $50.00), 2 (Existing Conditions - $59.48), and empty templates for Divisions 7 (Thermal and Moisture Protection), 8 (Openings), 9 (Finishes), and 12 (Furnishings), with a combined hard cost total shown as $109.48 before overhead, profit, and bonding adjustments, resulting in a contract total of $135.11 in the example. Instructions specify that the KTR (Key Technical Representative) must complete "Fill Here" areas on the summary tab including company name, date, and overhead/profit percentages, while remaining fields will automatically populate from division-level inputs. The file cautions users to save a copy before editing due to extensive formulas throughout the spreadsheet.

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
Attachment 13 - 668-24-102 - Site Visit Area Map.pdf	PDF	Feb 27, 2026
36C26026R0011_1 Solicitation.docx	DOCX document	Feb 27, 2026
Attachment 3 - 668-24-102 - BID SET SPECIFICATIONS 2_18_26.pdf	PDF	Feb 27, 2026
Attachment 7 - 668-24-102 - Hazardous Survey Report.pdf	PDF	Feb 27, 2026
Attachment 10 - 668-24-102 - Past Performance Questionnaire.docx	DOCX document	Feb 27, 2026
Attachment 9 - 668-24-102 - Contractor Rules of Behavior.pdf	PDF	Feb 27, 2026
Attachment 6 - 668-22-102 - LEVEL 3 Window project VHA ICRA.pdf	PDF	Feb 27, 2026
Attachment 4 - 668-24-102 - PCRA_VHA PCRA.pdf	PDF	Feb 27, 2026
Attachment 2 - 668-24-102 - BID SET DRAWINGS.pdf	PDF	Feb 27, 2026
Attachment 1 - 668-24-102 - CON SOW.pdf	PDF	Feb 27, 2026
Attachment 8 - 668-24-102 - Limitations on Subcontracting-Construction.pdf	PDF	Feb 27, 2026
Attachment 5 - 668-24-102 - LEVEL 2 Window project VHA ICRA.pdf	PDF	Feb 27, 2026
Attachment 12 - 668-24-102 - Spokane Wage Determination 1_23_26.pdf	PDF	Feb 27, 2026

Show all 13

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.