RFP Attachment 8 - Cost Matrix N66001-18-R-0110.xlsx

XLSX spreadsheet 125 KB Posted Jul 9, 2019

Attached to: Special Projects and Electronics Systems
Solicitation number: N66001-18-R-0110
Issued by: Department of the Navy Information Warfare Systems Command

About this file

Written by GovTribe AI · Dec 30, 2023

This document contains a cost proposal template and instructions for a federal contract opportunity. The template outlines cost elements for labor, materials, overhead, and other direct costs for the Special Projects and Electronics Systems solicitation from the Department of the Navy Information Warfare Systems Command. The template includes sections for prime contractor and subcontractor labor rates and costs by fiscal year, indirect rate tables, and formulas to calculate cost of money, fee amounts, and total cost plus fixed fee. It provides a framework for offerors to populate their own proposed costs according to the instructions.

View the file

Other files

File	Type	Posted
N66001-18-R-0110 RFP Amendment 0003.pdf	PDF	Jul 9, 2019
Attachment_6-Past_Performance_Questionnaire.pdf	PDF	Jul 9, 2019
N66001-18-R-0110 RFP Amendment 0006 (0012).pdf	PDF	Jul 9, 2019
N66001-18-R-0110 RFP Amendment 0002.pdf	PDF	Jul 9, 2019
N66001-18-R-0110 RFP Amendment 0001.pdf	PDF	Jul 9, 2019
N66001-18-R-0110 RFP Amendment 0005 (0007).pdf	PDF	Jul 9, 2019
Attachment_7-SB_Participation.docx	DOCX document	Jul 9, 2019
N66001-18-R-0110_RFP-Special_Projects.pdf	PDF	Jul 9, 2019
Attachment_5-Reference_Information_Sheet.docx	DOCX document	Jul 9, 2019
N66001-18-R-0110 RFP Amendment 0007 (0013).pdf	PDF	Jul 9, 2019
Attachment 1 - Security Classification DD 254.pdf	PDF	Jul 9, 2019
N66001-18-R-0110 RFP Amendment 0004.pdf	PDF	Jul 9, 2019
Attachment_4-Org_Exp_Matrix.doc	DOC document	Jul 9, 2019
Attachment_2-Rate_Sheet.xlsx	XLSX spreadsheet	Jul 9, 2019
Attachment_3-Desired_Personnel_Qualifications.docx	DOCX document	Jul 9, 2019

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

Try for free Login

Text version

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

Cost Summary

Solicitation Number:

Prime Offeror:

Subcontractors:

DCAA & DCMA Point of Contact Information:

ELEMENT	PROPOSED	OPTION 1
Labor		ELEMENT	PROPOSED
Labor O/H		CLIN 0004 Services
Labor Fringe		Cost
Subcontracts		Fee
Subcontractor Handling		CPFF
ODC
G&A		CLIN 0005 ODC
		Cost
Subtotal
COM		CLIN 0006 NSP CDRL	$0.00
Fee/Profit
		TOTAL OPTION 1
TOTAL

BASE PERIOD		OPTION 2
ELEMENT	PROPOSED	ELEMENT	PROPOSED
CLIN 0001 Services		CLIN 0007 Services
Cost		Cost
Fee		Fee
CPFF		CPFF

CLIN 0002 ODC	CLIN 0008 ODC
Cost	Cost

CLIN 0003 NSP CDRL $0.00 CLIN 0009 NSP CDRL $0.00

TOTAL BASE PERIOD TOTAL OPTION 2

Note: Numbers added to demonstrate the functionality of the spreadsheet; all values and labor catagories should be replaced in accordance with the offeror's information and in accordance with the instructions in Provision L-TXT-12.

Year I

Solicitation Number:
Prime Offeror:
Subcontractors:
Indirect Rate Elements	RATES
Overhead - Contractor Site A (KTR FY 1)	0.00%
Overhead-Contractor Site A (KTR FY 2)	0.00%
Overhead - Government Site B (KTR FY 1)	0.00%
Overhead - Government Site B (KTR FY 2)	0.00%
Fringe Benefits	0.00%
G&A (KTR FY 1)	0.00%
G&A (KTR FY 2)	0.00%
Material and Handling	0.00%
Other Indirect Rate Specified by Offeror	0.00%
Other Indirect Rate Specified by Offeror	0.00%
Other Indirect Rate Specified by Offeror	0.00%
Other Indirect Rate Specified by Offeror	0.00%
COM	0.00%
Fee On Sub	0.00%
Fee on Prime	0.00%
			Contractor's Fiscal Year 1									Contractor's Fiscal Year 2
Cost Elements	RFP Labor Category	Additional Code/Title	RT Rate	OT Rate	RT Hours	OT Hours	RT Amount	OT Amount	Cost Elements	RFP Labor Category	Additional Code/Title	RT Rate	OT Rate	RT Hours	OT Hours	RT Amount	OT Amount
Prime Contractor Labor Cost									Prime Contractor Labor Cost
Prime Contractor Direct Labor - Contractor Site									Prime Contractor Direct Labor - Contractor Site
Named Personnel / Bid Code	PM	NA	$ 1.00	$ 1.00	1	1	$ 1.00	$ 1.00
Unnamed Personnel	Laborer	5233	$ 1.00	$ 1.00	1.0	1.0	$ 1.00	$ 1.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
Total Contractor Site
							$ 2.00	$ 2.00
Prime Contractor Direct Labor - Government Site

	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 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 Government Site	$ - 0	$ - 0	Total Government Site	$ - 0	$ - 0

Total Direct Labor Cost		2.0	2.0	$ 2.00	$ 2.00	Total Direct Labor Cost		0.0	0.0	$ - 0	$ - 0
Prime Contractor Indirect Labor Cost						Prime Contractor Indirect Labor Cost
Overhead - Contractor Site A (KTR FY 1)	0.00%			$ - 0	$ - 0	Overhead-Contractor Site A (KTR FY 2)	0.00%			$ - 0	$ - 0
Overhead - Government Site B (KTR FY 1)	0.00%			$ - 0	$ - 0	Overhead - Government Site B (KTR FY 2)	0.00%			$ - 0	$ - 0
Fringe Benefits	0.00%			$ - 0	$ - 0	Fringe Benefits	0.00%			$ - 0	$ - 0
Material and Handling	0.00%			$ - 0	$ - 0	G&A (KTR FY 2)	0.00%			$ - 0	$ - 0
	ERROR:#N/A						ERROR:#N/A
	ERROR:#N/A						ERROR:#N/A
	ERROR:#N/A						ERROR:#N/A
Total Indirect Labor Cost					$ - 0	Total Indirect Labor Cost					$ - 0

Total Prime Contractor Labor Cost $ 4.00 Total Prime Contractor Labor Cost $ - 0

Subcontractor Labor Cost									Subcontractor Labor Cost
Subcontractors - Contractor Site									Subcontractors - Contractor Site
Cost Elements	RFP Labor Category	WD Code	ST Rate	OT Rate	ST Hours	OT Hours	ST Amount	OT Amount	Cost Elements	RFP Labor Category	WD Code	ST Rate	OT Rate	ST Hours	OT Hours	ST Amount	OT Amount
None							$ - 0	$ - 0	None							$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
Subcontractors - Government Site List the Subcontractor & Name of Person									Subcontractors - Government Site List the Subcontractor & Name of Person
							$ - 0	$ - 0								$ - 0	$ - 0
ACE/Joe Smith	PM	NA	$ 50.00	$ 70.00	50.0	20.0	$ 2,500.00	$ 1,400.00	ACE/Joe Smith	PM	NA	$ 50.00	$ 70.00	50.0	20.0	$ 2,500.00	$ 1,400.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	$ - 0								$ - 0	$ - 0

Total Subcontractor proposed cost and fee 50 20 $ 2,500.00 $ 1,400.00 Total Subcontractor proposed cost and fee 50 20 $ 2,500.00 $ 1,400.00

Prime contractor pass through (not including fee)				Prime contractor pass through (not including fee)
Material and Handling	0.00%	$ - 0	$ - 0	Material and Handling	0.00%	$ - 0	$ - 0
G&A (KTR FY 1)	0.00%	$ - 0	$ - 0	G&A (KTR FY 2)	0.00%	$ - 0	$ - 0
	ERROR:#N/A				ERROR:#N/A
Total pass through (not including fee)			$ - 0	Total pass through (not including fee)			$ - 0
Total Subcontractor Cost including pass through			$ 3,900.00	Total Subcontractor Cost including pass through			$ 3,900.00

Total Labor Cost (Prime and Subcontractor Labor) 52 22 $ 3,904.00 Total Labor Cost (Prime and Subcontractor Labor) 50 20 $ 3,900.00

Fixed Fee			Fixed Fee
Fee On Sub	0.00%	$ - 0	Fee On Sub	0.00%	$ - 0
Fee on Prime	0.00%	$ - 0	Fee on Prime	0.00%	$ - 0
Total Fee (for Prime and Subcontractor Labor)		$ - 0	Total Fee (for Prime and Subcontractor Labor)		$ - 0

Total Labor Cost Plus Fixed Fee (CPFF) $ 3,904.00 Total Labor Cost Plus Fixed Fee (CPFF) $ 3,900.00

Material (BASE Amount)		$ 100,000.00	Material (BASE Amount)		$ 100,000.00
Material and Handling	0.00%	$ - 0	Material and Handling	0.00%	$ - 0
	ERROR:#N/A			ERROR:#N/A
	ERROR:#N/A			ERROR:#N/A
Total Material		$ 100,000.00	Total Material		$ 100,000.00

ODC/Travel/Shipping (BASE Amount)		$ 2,500.00	ODC/Travel/Shipping (BASE Amount)		$ 2,500.00
G&A (KTR FY 1)	0.00%	$ - 0	G&A (KTR FY 2)	0.00%	$ - 0
	ERROR:#N/A			ERROR:#N/A
Total ODC/Travel		$ 2,500.00	Total ODC/Travel		$ 2,500.00

Total ODCs $ 102,500.00 Total ODCs $ 102,500.00

COM 0.00% 15 COM 0.00% 15

Total CPFF (Labor and ODCs)	$ 106,404.00	Total CPFF (Labor and ODCs)	$ 106,400.00
Grand Total
Input rates for the applicable period
Place formula in this cell. Rate or factor to be utilized must come from the rate corresponding with the rate category drop down menu.
Do not manipulate this cell
Offeror input via dropdown menu for cells in column "B" or direct input in other cells
If offeror controlled cells within the yellow highlighted areas are changed, the offeror must ensure the summation formula includes the newly created rows.
Note: Numbers added to demonstrate the functionality of the spreadsheet; all values and labor categories should be replaced in accordance with the offeror's information and in accordance with the instructions in Provision L-317.
The rates populating the Yellow highlighted B Column cells are pulled from the Green Chart titled "RATES". The rates input into the RATES table must be accurate. The contractor also has to ensure the yellow cells are calling the correct rate corresponding with the pulldown rate selected by the contractor.
The contractor only needs to use both FY periods within each contract period if rates change in the middle of the contract period, otherwise leave the "FY 2" cost template blank.
"Other Indirect Rate" shall be updated by the offeror, if needed.

Year II

Solicitation Number:
Prime Offeror:
Subcontractors:
Indirect Rate Elements	RATES
Overhead - Contractor Site A (KTR FY 2)	0.00%
Overhead-Contractor Site A (KTR FY 3)	0.00%
Overhead - Government Site B (KTR FY 1)	0.00%
Overhead - Government Site B (KTR FY 2)	0.00%
Fringe Benefits	0.00%
G&A (KTR FY 2)	0.00%
G&A (KTR FY 3)	0.00%
Material and Handling	0.00%
Other Indirect Rate Specified by Offeror	0.00%
Other Indirect Rate Specified by Offeror	0.00%
Other Indirect Rate Specified by Offeror	0.00%
Other Indirect Rate Specified by Offeror	0.00%
COM	0.00%
Fee On Sub	0.00%
Fee on Prime	0.00%
			Contractor's Fiscal Year 2									Contractor's Fiscal Year 3
Cost Elements	RFP Labor Category	Additional Code/Title	RT Rate	OT Rate	RT Hours	OT Hours	RT Amount	OT Amount	Cost Elements	RFP Labor Category	Additional Code/Title	RT Rate	OT Rate	RT Hours	OT Hours	RT Amount	OT Amount
Prime Contractor Labor Cost									Prime Contractor Labor Cost
Prime Contractor Direct Labor - Contractor Site									Prime Contractor Direct Labor - Contractor Site
Named Personnel / Bid Code	PM	NA	$ 1.00	$ 1.00	1	1	$ 1.00	$ 1.00
Unnamed Personnel	Laborer	5233	$ 1.00	$ 1.00	1.0	1.0	$ 1.00	$ 1.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
Total Contractor Site
							$ 2.00	$ 2.00
Prime Contractor Direct Labor - Government Site

	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 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 Government Site	$ - 0	$ - 0	Total Government Site	$ - 0	$ - 0

Total Direct Labor CoRT		2.0	2.0	$ 2.00	$ 2.00	Total Direct Labor CoRT		0.0	0.0	$ - 0	$ - 0
Prime Contractor Indirect Labor Cost						Prime Contractor Indirect Labor Cost
Overhead - Contractor Site A (KTR FY 2)	0.00%			$ - 0	$ - 0	Overhead-Contractor Site A (KTR FY 3)	0.00%			$ - 0	$ - 0
Overhead - Government Site B (KTR FY 2)	0.00%			$ - 0	$ - 0	Overhead - Government Site B (KTR FY 3)	ERROR:#N/A			ERROR:#N/A	ERROR:#N/A
Fringe Benefits	0.00%			$ - 0	$ - 0	Fringe Benefits	0.00%			$ - 0	$ - 0
Material and Handling	0.00%			$ - 0	$ - 0	G&A (KTR FY 3)	0.00%			ERROR:#N/A	ERROR:#N/A
	ERROR:#N/A						ERROR:#N/A
	ERROR:#N/A						ERROR:#N/A
	ERROR:#N/A						ERROR:#N/A
Total Indirect Labor Cost					$ - 0	Total Indirect Labor Cost					ERROR:#N/A

Total Prime Contractor Labor Cost $ 4.00 Total Prime Contractor Labor Cost ERROR:#N/A

Subcontractor Labor Cost									Subcontractor Labor Cost
Subcontractors - Contractor Site									Subcontractors - Contractor Site
Cost Elements	RFP Labor Category	WD Code	ST Rate	OT Rate	ST Hours	OT Hours	ST Amount	OT Amount	Cost Elements	RFP Labor Category	WD Code	ST Rate	OT Rate	ST Hours	OT Hours	ST Amount	OT Amount
None							$ - 0	$ - 0	None							$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
Subcontractors - Government Site List the Subcontractor & Name of Person									Subcontractors - Government Site List the Subcontractor & Name of Person
							$ - 0	$ - 0								$ - 0	$ - 0
ACE/Joe Smith	PM	NA	$ 50.00	$ 70.00	50.0	20.0	$ 2,500.00	$ 1,400.00	ACE/Joe Smith	PM	NA	$ 50.00	$ 70.00	50.0	20.0	$ 2,500.00	$ 1,400.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	$ - 0								$ - 0	$ - 0

Total Subcontractor proposed cost and fee 50 20 $ 2,500.00 $ 1,400.00 Total Subcontractor proposed cost and fee 50 20 $ 2,500.00 $ 1,400.00

Prime contractor pass through (not including fee)				Prime contractor pass through (not including fee)
Material and Handling	0.00%	$ - 0	$ - 0	Material and Handling	0.00%	$ - 0	$ - 0
G&A (KTR FY 2)	0.00%	$ - 0	$ - 0	G&A (KTR FY 3)	0.00%	$ - 0	$ - 0
	ERROR:#N/A				ERROR:#N/A
Total pass through (not including fee)			$ - 0	Total pass through (not including fee)			$ - 0
Total Subcontractor Cost including pass through			$ 3,900.00	Total Subcontractor Cost including pass through			$ 3,900.00

Total Labor Cost (Prime and Subcontractor Labor) 52 22 $ 3,904.00 Total Labor Cost (Prime and Subcontractor Labor) 50 20 ERROR:#N/A

Fixed Fee			Fixed Fee
Fee On Sub	0.00%	$ - 0	Fee On Sub	0.00%	$ - 0
Fee on Prime	0.00%	$ - 0	Fee on Prime	0.00%	ERROR:#N/A
Total Fee (for Prime and Subcontractor Labor)		$ - 0	Total Fee (for Prime and Subcontractor Labor)		ERROR:#N/A

Total Labor Cost Plus Fixed Fee (CPFF) $ 3,904.00 Total Labor Cost Plus Fixed Fee (CPFF) ERROR:#N/A

Material (BASE Amount)		$ 100,000.00	Material (BASE Amount)		$ 100,000.00
Material and Handling	0.00%	$ - 0	Material and Handling	0.00%	$ - 0
	ERROR:#N/A			ERROR:#N/A
	ERROR:#N/A			ERROR:#N/A
Total Material		$ 100,000.00	Total Material		$ 100,000.00

ODC/Travel/Shipping (BASE Amount)		$ 2,500.00	ODC/Travel/Shipping (BASE Amount)		$ 2,500.00
G&A (KTR FY 2)	0.00%	$ - 0	G&A (KTR FY 3)	0.00%	$ - 0
	ERROR:#N/A			ERROR:#N/A
Total ODC/Travel		$ 2,500.00	Total ODC/Travel		$ 2,500.00

Total ODCs $ 102,500.00 Total ODCs $ 102,500.00

COM 0.00% 15 COM 0.00% 15

Total CPFF (Labor and ODCs)	$ 106,404.00	Total CPFF (Labor and ODCs)	ERROR:#N/A
Grand Total
Input rates for the applicable period
Place formula in this cell. Rate or factor to be utilized must come from the rate corresponding with the rate category drop down menu.
Do not manipulate this cell
Offeror input via dropdown menu for cells in column "B" or direct input in other cells
If offeror controlled cells within the yellow highlighted areas are changed, the offeror must ensure the summation formula includes the newly created rows.
Note: Numbers added to demonstrate the functionality of the spreadsheet; all values and labor categories should be replaced in accordance with the offeror's information and in accordance with the instructions in Provision L-317.
The rates populating the Yellow highlighted B Column cells are pulled from the Green Chart titled "RATES". The rates input into the RATES table must be accurate. The contractor also has to ensure the yellow cells are calling the correct rate corresponding with the pulldown rate selected by the contractor.
The contractor only needs to use both FY periods within each contract period if rates change in the middle of the contract period, otherwise leave the "FY 2" cost template blank.
"Other Indirect Rate" shall be updated by the offeror, if needed.

Year III

Solicitation Number:
Prime Offeror:
Subcontractors:
Indirect Rate Elements	RATES
Overhead - Contractor Site A (KTR FY 3)	0.00%
Overhead-Contractor Site A (KTR FY 4)	0.00%
Overhead - Government Site B (KTR FY 1)	0.00%
Overhead - Government Site B (KTR FY 2)	0.00%
Fringe Benefits	0.00%
G&A (KTR FY 3)	0.00%
G&A (KTR FY 4)	0.00%
Material and Handling	0.00%
Other Indirect Rate Specified by Offeror	0.00%
Other Indirect Rate Specified by Offeror	0.00%
Other Indirect Rate Specified by Offeror	0.00%
Other Indirect Rate Specified by Offeror	0.00%
COM	0.00%
Fee On Sub	0.00%
Fee on Prime	0.00%
			Contractor's Fiscal Year 3									Contractor's Fiscal Year 4
Cost Elements	RFP Labor Category	Additional Code/Title	RT Rate	OT Rate	RT Hours	OT Hours	RT Amount	OT Amount	Cost Elements	RFP Labor Category	Additional Code/Title	RT Rate	OT Rate	RT Hours	OT Hours	RT Amount	OT Amount
Prime Contractor Labor Cost									Prime Contractor Labor Cost
Prime Contractor Direct Labor - Contractor Site									Prime Contractor Direct Labor - Contractor Site
Named Personnel / Bid Code	PM	NA	$ 1.00	$ 1.00	1	1	$ 1.00	$ 1.00
Unnamed Personnel	Laborer	5233	$ 1.00	$ 1.00	1.0	1.0	$ 1.00	$ 1.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
Total Contractor Site
							$ 2.00	$ 2.00
Prime Contractor Direct Labor - Government Site

	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 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 Government Site	$ - 0	$ - 0	Total Government Site	$ - 0	$ - 0

Total Direct Labor Cost		2.0	2.0	$ 2.00	$ 2.00	Total Direct Labor Cost		0.0	0.0	$ - 0	$ - 0
Prime Contractor Indirect Labor Cost						Prime Contractor Indirect Labor Cost
Overhead - Contractor Site A (KTR FY 3)	0.00%			$ - 0	$ - 0	Overhead-Contractor Site A (KTR FY 4)	0.00%			$ - 0	$ - 0
Overhead - Government Site B (KTR FY 3)	ERROR:#N/A			ERROR:#N/A	ERROR:#N/A	Overhead - Government Site B (KTR FY 4)	ERROR:#N/A			ERROR:#N/A	ERROR:#N/A
Fringe Benefits	0.00%			$ - 0	$ - 0	Fringe Benefits	0.00%			$ - 0	$ - 0
Material and Handling	0.00%			ERROR:#N/A	ERROR:#N/A	G&A (KTR FY 4)	0.00%			ERROR:#N/A	ERROR:#N/A
	ERROR:#N/A						ERROR:#N/A
	ERROR:#N/A						ERROR:#N/A
	ERROR:#N/A						ERROR:#N/A
Total Indirect Labor Cost					ERROR:#N/A	Total Indirect Labor Cost					ERROR:#N/A

Total Prime Contractor Labor Cost ERROR:#N/A Total Prime Contractor Labor Cost ERROR:#N/A

Subcontractor Labor Cost									Subcontractor Labor Cost
Subcontractors - Contractor Site									Subcontractors - Contractor Site
Cost Elements	RFP Labor Category	WD Code	ST Rate	OT Rate	ST Hours	OT Hours	ST Amount	OT Amount	Cost Elements	RFP Labor Category	WD Code	ST Rate	OT Rate	ST Hours	OT Hours	ST Amount	OT Amount
None							$ - 0	$ - 0	None							$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
Subcontractors - Government Site List the Subcontractor & Name of Person									Subcontractors - Government Site List the Subcontractor & Name of Person
							$ - 0	$ - 0								$ - 0	$ - 0
ACE/Joe Smith	PM	NA	$ 50.00	$ 70.00	50.0	20.0	$ 2,500.00	$ 1,400.00	ACE/Joe Smith	PM	NA	$ 50.00	$ 70.00	50.0	20.0	$ 2,500.00	$ 1,400.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	$ - 0								$ - 0	$ - 0

Total Subcontractor proposed cost and fee 50 20 $ 2,500.00 $ 1,400.00 Total Subcontractor proposed cost and fee 50 20 $ 2,500.00 $ 1,400.00

Prime contractor pass through (not including fee)				Prime contractor pass through (not including fee)
Material and Handling	0.00%	$ - 0	$ - 0	Material and Handling	0.00%	$ - 0	$ - 0
G&A (KTR FY 3)	0.00%	$ - 0	$ - 0	G&A (KTR FY 4)	0.00%	$ - 0	$ - 0
	ERROR:#N/A				ERROR:#N/A
Total pass through (not including fee)			$ - 0	Total pass through (not including fee)			$ - 0
Total Subcontractor Cost including pass through			$ 3,900.00	Total Subcontractor Cost including pass through			$ 3,900.00

Total Labor Cost (Prime and Subcontractor Labor) 52 22 ERROR:#N/A Total Labor Cost (Prime and Subcontractor Labor) 50 20 ERROR:#N/A

Fixed Fee			Fixed Fee
Fee On Sub	0.00%	$ - 0	Fee On Sub	0.00%	$ - 0
Fee on Prime	0.00%	ERROR:#N/A	Fee on Prime	0.00%	ERROR:#N/A
Total Fee (for Prime and Subcontractor Labor)		ERROR:#N/A	Total Fee (for Prime and Subcontractor Labor)		ERROR:#N/A

Total Labor Cost Plus Fixed Fee (CPFF) ERROR:#N/A Total Labor Cost Plus Fixed Fee (CPFF) ERROR:#N/A

Material (BASE Amount)		$ 100,000.00	Material (BASE Amount)		$ 100,000.00
Material and Handling	0.00%	$ - 0	Material and Handling	0.00%	$ - 0
	ERROR:#N/A			ERROR:#N/A
	ERROR:#N/A			ERROR:#N/A
Total Material		$ 100,000.00	Total Material		$ 100,000.00

ODC/Travel/Shipping (BASE Amount)		$ 2,500.00	ODC/Travel/Shipping (BASE Amount)		$ 2,500.00
G&A (KTR FY 3)	0.00%	$ - 0	G&A (KTR FY 4)	0.00%	$ - 0
	ERROR:#N/A			ERROR:#N/A
Total ODC/Travel		$ 2,500.00	Total ODC/Travel		$ 2,500.00

Total ODCs $ 102,500.00 Total ODCs $ 102,500.00

COM 0.00% 15 COM 0.00% 15

Total CPFF (Labor and ODCs)	ERROR:#N/A	Total CPFF (Labor and ODCs)	ERROR:#N/A
Grand Total
Input rates for the applicable period
Place formula in this cell. Rate or factor to be utilized must come from the rate corresponding with the rate category drop down menu.
Do not manipulate this cell
Offeror input via dropdown menu for cells in column "B" or direct input in other cells
If offeror controlled cells within the yellow highlighted areas are changed, the offeror must ensure the summation formula includes the newly created rows.
Note: Numbers added to demonstrate the functionality of the spreadsheet; all values and labor categories should be replaced in accordance with the offeror's information and in accordance with the instructions in Provision L-317.
The rates populating the Yellow highlighted B Column cells are pulled from the Green Chart titled "RATES". The rates input into the RATES table must be accurate. The contractor also has to ensure the yellow cells are calling the correct rate corresponding with the pulldown rate selected by the contractor.
The contractor only needs to use both FY periods within each contract period if rates change in the middle of the contract period, otherwise leave the "FY 2" cost template blank.
"Other Indirect Rate" shall be updated by the offeror, if needed.

Year IV

Solicitation Number:
Prime Offeror:
Subcontractors:
Indirect Rate Elements	RATES
Overhead - Contractor Site A (KTR FY 4)	0.00%
Overhead-Contractor Site A (KTR FY 5)	0.00%
Overhead - Government Site B (KTR FY 1)	0.00%
Overhead - Government Site B (KTR FY 2)	0.00%
Fringe Benefits	0.00%
G&A (KTR FY 4)	0.00%
G&A (KTR FY 5)	0.00%
Material and Handling	0.00%
Other Indirect Rate Specified by Offeror	0.00%
Other Indirect Rate Specified by Offeror	0.00%
Other Indirect Rate Specified by Offeror	0.00%
Other Indirect Rate Specified by Offeror	0.00%
COM	0.00%
Fee On Sub	0.00%
Fee on Prime	0.00%
			Contractor's Fiscal Year 4									Contractor's Fiscal Year 5
Cost Elements	RFP Labor Category	Additional Code/Title	RT Rate	OT Rate	RT Hours	OT Hours	RT Amount	OT Amount	Cost Elements	RFP Labor Category	Additional Code/Title	RT Rate	OT Rate	RT Hours	OT Hours	RT Amount	OT Amount
Prime Contractor Labor Cost									Prime Contractor Labor Cost
Prime Contractor Direct Labor - Contractor Site									Prime Contractor Direct Labor - Contractor Site
Named Personnel / Bid Code	PM	NA	$ 1.00	$ 1.00	1	1	$ 1.00	$ 1.00
Unnamed Personnel	Laborer	5233	$ 1.00	$ 1.00	1.0	1.0	$ 1.00	$ 1.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
Total Contractor Site
							$ 2.00	$ 2.00
Prime Contractor Direct Labor - Government Site

	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 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 Government Site	$ - 0	$ - 0	Total Government Site	$ - 0	$ - 0

Total Direct Labor Cost		2.0	2.0	$ 2.00	$ 2.00	Total Direct Labor Cost		0.0	0.0	$ - 0	$ - 0
Prime Contractor Indirect Labor Cost						Prime Contractor Indirect Labor Cost
Overhead - Contractor Site A (KTR FY 4)	0.00%			$ - 0	$ - 0	Overhead-Contractor Site A (KTR FY 5)	0.00%			$ - 0	$ - 0
Overhead - Government Site B (KTR FY 4)	ERROR:#N/A			ERROR:#N/A	ERROR:#N/A	Overhead - Government Site B (KTR FY 5)	ERROR:#N/A			ERROR:#N/A	ERROR:#N/A
Fringe Benefits	0.00%			$ - 0	$ - 0	Fringe Benefits	0.00%			$ - 0	$ - 0
Material and Handling	0.00%			ERROR:#N/A	ERROR:#N/A	G&A (KTR FY 5)	0.00%			ERROR:#N/A	ERROR:#N/A
	ERROR:#N/A						ERROR:#N/A
	ERROR:#N/A						ERROR:#N/A
	ERROR:#N/A						ERROR:#N/A
Total Indirect Labor Cost					ERROR:#N/A	Total Indirect Labor Cost					ERROR:#N/A

Total Prime Contractor Labor Cost ERROR:#N/A Total Prime Contractor Labor Cost ERROR:#N/A

Subcontractor Labor Cost									Subcontractor Labor Cost
Subcontractors - Contractor Site									Subcontractors - Contractor Site
Cost Elements	RFP Labor Category	WD Code	ST Rate	OT Rate	ST Hours	OT Hours	ST Amount	OT Amount	Cost Elements	RFP Labor Category	WD Code	ST Rate	OT Rate	ST Hours	OT Hours	ST Amount	OT Amount
None							$ - 0	$ - 0	None							$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
Subcontractors - Government Site List the Subcontractor & Name of Person									Subcontractors - Government Site List the Subcontractor & Name of Person
							$ - 0	$ - 0								$ - 0	$ - 0
ACE/Joe Smith	PM	NA	$ 50.00	$ 70.00	50.0	20.0	$ 2,500.00	$ 1,400.00	ACE/Joe Smith	PM	NA	$ 50.00	$ 70.00	50.0	20.0	$ 2,500.00	$ 1,400.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	$ - 0								$ - 0	$ - 0

Total Subcontractor proposed cost and fee 50 20 $ 2,500.00 $ 1,400.00 Total Subcontractor proposed cost and fee 50 20 $ 2,500.00 $ 1,400.00

Prime contractor pass through (not including fee)				Prime contractor pass through (not including fee)
Material and Handling	0.00%	$ - 0	$ - 0	Material and Handling	0.00%	$ - 0	$ - 0
G&A (KTR FY 4)	0.00%	$ - 0	$ - 0	G&A (KTR FY 5)	0.00%	$ - 0	$ - 0
	ERROR:#N/A				ERROR:#N/A
Total pass through (not including fee)			$ - 0	Total pass through (not including fee)			$ - 0
Total Subcontractor Cost including pass through			$ 3,900.00	Total Subcontractor Cost including pass through			$ 3,900.00

Total Labor Cost (Prime and Subcontractor Labor) 52 22 ERROR:#N/A Total Labor Cost (Prime and Subcontractor Labor) 50 20 ERROR:#N/A

Fixed Fee			Fixed Fee
Fee On Sub	0.00%	$ - 0	Fee On Sub	0.00%	$ - 0
Fee on Prime	0.00%	ERROR:#N/A	Fee on Prime	0.00%	ERROR:#N/A
Total Fee (for Prime and Subcontractor Labor)		ERROR:#N/A	Total Fee (for Prime and Subcontractor Labor)		ERROR:#N/A

Total Labor Cost Plus Fixed Fee (CPFF) ERROR:#N/A Total Labor Cost Plus Fixed Fee (CPFF) ERROR:#N/A

Material (BASE Amount)		$ 100,000.00	Material (BASE Amount)		$ 100,000.00
Material and Handling	0.00%	$ - 0	Material and Handling	0.00%	$ - 0
	ERROR:#N/A			ERROR:#N/A
	ERROR:#N/A			ERROR:#N/A
Total Material		$ 100,000.00	Total Material		$ 100,000.00

ODC/Travel/Shipping (BASE Amount)		$ 2,500.00	ODC/Travel/Shipping (BASE Amount)		$ 2,500.00
G&A (KTR FY 4)	0.00%	$ - 0	G&A (KTR FY 5)	0.00%	$ - 0
	ERROR:#N/A			ERROR:#N/A
Total ODC/Travel		$ 2,500.00	Total ODC/Travel		$ 2,500.00

Total ODCs $ 102,500.00 Total ODCs $ 102,500.00

COM 0.00% 15 COM 0.00% 15

Total CPFF (Labor and ODCs)	ERROR:#N/A	Total CPFF (Labor and ODCs)	ERROR:#N/A
Grand Total
Input rates for the applicable period
Place formula in this cell. Rate or factor to be utilized must come from the rate corresponding with the rate category drop down menu.
Do not manipulate this cell
Offeror input via dropdown menu for cells in column "B" or direct input in other cells
If offeror controlled cells within the yellow highlighted areas are changed, the offeror must ensure the summation formula includes the newly created rows.
Note: Numbers added to demonstrate the functionality of the spreadsheet; all values and labor categories should be replaced in accordance with the offeror's information and in accordance with the instructions in Provision L-317.
The rates populating the Yellow highlighted B Column cells are pulled from the Green Chart titled "RATES". The rates input into the RATES table must be accurate. The contractor also has to ensure the yellow cells are calling the correct rate corresponding with the pulldown rate selected by the contractor.
The contractor only needs to use both FY periods within each contract period if rates change in the middle of the contract period, otherwise leave the "FY 2" cost template blank.
"Other Indirect Rate" shall be updated by the offeror, if needed.

Year V

Solicitation Number:
Prime Offeror:
Subcontractors:
Indirect Rate Elements	RATES
Overhead - Contractor Site A (KTR FY 5)	0.00%
Overhead-Contractor Site A (KTR FY 6)	0.00%
Overhead - Government Site B (KTR FY 1)	0.00%
Overhead - Government Site B (KTR FY 2)	0.00%
Fringe Benefits	0.00%
G&A (KTR FY 5)	0.00%
G&A (KTR FY 6)	0.00%
Material and Handling	0.00%
Other Indirect Rate Specified by Offeror	0.00%
Other Indirect Rate Specified by Offeror	0.00%
Other Indirect Rate Specified by Offeror	0.00%
Other Indirect Rate Specified by Offeror	0.00%
COM	0.00%
Fee On Sub	0.00%
Fee on Prime	0.00%
			Contractor's Fiscal Year 5									Contractor's Fiscal Year 6
Cost Elements	RFP Labor Category	Additional Code/Title	RT Rate	OT Rate	RT Hours	OT Hours	RT Amount	OT Amount	Cost Elements	RFP Labor Category	Additional Code/Title	RT Rate	OT Rate	RT Hours	OT Hours	RT Amount	OT Amount
Prime Contractor Labor Cost									Prime Contractor Labor Cost
Prime Contractor Direct Labor - Contractor Site									Prime Contractor Direct Labor - Contractor Site
Named Personnel / Bid Code	PM	NA	$ 1.00	$ 1.00	1	1	$ 1.00	$ 1.00
Unnamed Personnel	Laborer	5233	$ 1.00	$ 1.00	1.0	1.0	$ 1.00	$ 1.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
Total Contractor Site
							$ 2.00	$ 2.00
Prime Contractor Direct Labor - Government Site

	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 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 Government Site	$ - 0	$ - 0	Total Government Site	$ - 0	$ - 0

Total Direct Labor Cost		2.0	2.0	$ 2.00	$ 2.00	Total Direct Labor Cost		0.0	0.0	$ - 0	$ - 0
Prime Contractor Indirect Labor Cost						Prime Contractor Indirect Labor Cost
Overhead - Contractor Site A (KTR FY 5)	0.00%			$ - 0	$ - 0	Overhead-Contractor Site A (KTR FY 6)	0.00%			$ - 0	$ - 0
Overhead - Government Site B (KTR FY 5)	ERROR:#N/A			ERROR:#N/A	ERROR:#N/A	Overhead - Government Site B (KTR FY 6)	ERROR:#N/A			ERROR:#N/A	ERROR:#N/A
Fringe Benefits	0.00%			$ - 0	$ - 0	Fringe Benefits	0.00%			$ - 0	$ - 0
Material and Handling	0.00%			ERROR:#N/A	ERROR:#N/A	G&A (KTR FY 6)	0.00%			ERROR:#N/A	ERROR:#N/A
	ERROR:#N/A						ERROR:#N/A
	ERROR:#N/A						ERROR:#N/A
	ERROR:#N/A						ERROR:#N/A
Total Indirect Labor Cost					ERROR:#N/A	Total Indirect Labor Cost					ERROR:#N/A

Total Prime Contractor Labor Cost ERROR:#N/A Total Prime Contractor Labor Cost ERROR:#N/A

Subcontractor Labor Cost									Subcontractor Labor Cost
Subcontractors - Contractor Site									Subcontractors - Contractor Site
Cost Elements	RFP Labor Category	WD Code	ST Rate	OT Rate	ST Hours	OT Hours	ST Amount	OT Amount	Cost Elements	RFP Labor Category	WD Code	ST Rate	OT Rate	ST Hours	OT Hours	ST Amount	OT Amount
None							$ - 0	$ - 0	None							$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
Subcontractors - Government Site List the Subcontractor & Name of Person									Subcontractors - Government Site List the Subcontractor & Name of Person
							$ - 0	$ - 0								$ - 0	$ - 0
ACE/Joe Smith	PM	NA	$ 50.00	$ 70.00	50.0	20.0	$ 2,500.00	$ 1,400.00	ACE/Joe Smith	PM	NA	$ 50.00	$ 70.00	50.0	20.0	$ 2,500.00	$ 1,400.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	$ - 0								$ - 0	$ - 0

Total Subcontractor proposed cost and fee 50 20 $ 2,500.00 $ 1,400.00 Total Subcontractor proposed cost and fee 50 20 $ 2,500.00 $ 1,400.00

Prime contractor pass through (not including fee)				Prime contractor pass through (not including fee)
Material and Handling	0.00%	$ - 0	$ - 0	Material and Handling	0.00%	$ - 0	$ - 0
G&A (KTR FY 5)	0.00%	$ - 0	$ - 0	G&A (KTR FY 6)	0.00%	$ - 0	$ - 0
	ERROR:#N/A				ERROR:#N/A
Total pass through (not including fee)			$ - 0	Total pass through (not including fee)			$ - 0
Total Subcontractor Cost including pass through			$ 3,900.00	Total Subcontractor Cost including pass through			$ 3,900.00

Total Labor Cost (Prime and Subcontractor Labor) 52 22 ERROR:#N/A Total Labor Cost (Prime and Subcontractor Labor) 50 20 ERROR:#N/A

Fixed Fee			Fixed Fee
Fee On Sub	0.00%	$ - 0	Fee On Sub	0.00%	$ - 0
Fee on Prime	0.00%	ERROR:#N/A	Fee on Prime	0.00%	ERROR:#N/A
Total Fee (for Prime and Subcontractor Labor)		ERROR:#N/A	Total Fee (for Prime and Subcontractor Labor)		ERROR:#N/A

Total Labor Cost Plus Fixed Fee (CPFF) ERROR:#N/A Total Labor Cost Plus Fixed Fee (CPFF) ERROR:#N/A

Material (BASE Amount)		$ 100,000.00	Material (BASE Amount)		$ 100,000.00
Material and Handling	0.00%	$ - 0	Material and Handling	0.00%	$ - 0
	ERROR:#N/A			ERROR:#N/A
	ERROR:#N/A			ERROR:#N/A
Total Material		$ 100,000.00	Total Material		$ 100,000.00

ODC/Travel/Shipping (BASE Amount)		$ 2,500.00	ODC/Travel/Shipping (BASE Amount)		$ 2,500.00
Overhead - Contractor Site A (KTR FY 5)	0.00%	$ - 0	G&A (KTR FY 6)	0.00%	$ - 0
	ERROR:#N/A			ERROR:#N/A
Total ODC/Travel		$ 2,500.00	Total ODC/Travel		$ 2,500.00

Total ODCs $ 102,500.00 Total ODCs $ 102,500.00

COM 0.00% 15 COM 0.00% 15

Total CPFF (Labor and ODCs)	ERROR:#N/A	Total CPFF (Labor and ODCs)	ERROR:#N/A
Grand Total
Input rates for the applicable period
Place formula in this cell. Rate or factor to be utilized must come from the rate corresponding with the rate category drop down menu.
Do not manipulate this cell
Offeror input via dropdown menu for cells in column "B" or direct input in other cells
If offeror controlled cells within the yellow highlighted areas are changed, the offeror must ensure the summation formula includes the newly created rows.
Note: Numbers added to demonstrate the functionality of the spreadsheet; all values and labor categories should be replaced in accordance with the offeror's information and in accordance with the instructions in Provision L-317.
The rates populating the Yellow highlighted B Column cells are pulled from the Green Chart titled "RATES". The rates input into the RATES table must be accurate. The contractor also has to ensure the yellow cells are calling the correct rate corresponding with the pulldown rate selected by the contractor.
The contractor only needs to use both FY periods within each contract period if rates change in the middle of the contract period, otherwise leave the "FY 2" cost template blank.
"Other Indirect Rate" shall be updated by the offeror, if needed.

Year VI

Solicitation Number:
Prime Offeror:
Subcontractors:
Indirect Rate Elements	RATES
Overhead - Contractor Site A (KTR FY 6)	0.00%
Overhead-Contractor Site A (KTR FY 7)	0.00%
Overhead - Government Site B (KTR FY 1)	0.00%
Overhead - Government Site B (KTR FY 2)	0.00%
Fringe Benefits	0.00%
G&A (KTR FY 6)	0.00%
G&A (KTR FY 7)	0.00%
Material and Handling	0.00%
Other Indirect Rate Specified by Offeror	0.00%
Other Indirect Rate Specified by Offeror	0.00%
Other Indirect Rate Specified by Offeror	0.00%
Other Indirect Rate Specified by Offeror	0.00%
COM	0.00%
Fee On Sub	0.00%
Fee on Prime	0.00%
			Contractor's Fiscal Year 6									Contractor's Fiscal Year 7
Cost Elements	RFP Labor Category	Additional Code/Title	RT Rate	OT Rate	RT Hours	OT Hours	RT Amount	OT Amount	Cost Elements	RFP Labor Category	Additional Code/Title	RT Rate	OT Rate	RT Hours	OT Hours	RT Amount	OT Amount
Prime Contractor Labor Cost									Prime Contractor Labor Cost
Prime Contractor Direct Labor - Contractor Site									Prime Contractor Direct Labor - Contractor Site
Named Personnel / Bid Code	PM	NA	$ 1.00	$ 1.00	1	1	$ 1.00	$ 1.00
Unnamed Personnel	Laborer	5233	$ 1.00	$ 1.00	1.0	1.0	$ 1.00	$ 1.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
Total Contractor Site
							$ 2.00	$ 2.00
Prime Contractor Direct Labor - Government Site

	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 0	$ - 0		$ - 0	$ - 0
	$ - 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 Government Site	$ - 0	$ - 0	Total Government Site	$ - 0	$ - 0

Total Direct Labor Cost		2.0	2.0	$ 2.00	$ 2.00	Total Direct Labor Cost		0.0	0.0	$ - 0	$ - 0
Prime Contractor Indirect Labor Cost						Prime Contractor Indirect Labor Cost
Overhead - Contractor Site A (KTR FY 5)	ERROR:#N/A			ERROR:#N/A	ERROR:#N/A	Overhead-Contractor Site A (KTR FY 6)	ERROR:#N/A			ERROR:#N/A	ERROR:#N/A
Overhead - Government Site B (KTR FY 5)	ERROR:#N/A			ERROR:#N/A	ERROR:#N/A	Overhead - Government Site B (KTR FY 6)	ERROR:#N/A			ERROR:#N/A	ERROR:#N/A
Fringe Benefits	0.00%			$ - 0	$ - 0	Fringe Benefits	0.00%			$ - 0	$ - 0
Material and Handling	0.00%			ERROR:#N/A	ERROR:#N/A	G&A (KTR FY 6)	0.00%			ERROR:#N/A	ERROR:#N/A
	ERROR:#N/A						ERROR:#N/A
	ERROR:#N/A						ERROR:#N/A
	ERROR:#N/A						ERROR:#N/A
Total Indirect Labor Cost					ERROR:#N/A	Total Indirect Labor Cost					ERROR:#N/A

Total Prime Contractor Labor Cost ERROR:#N/A Total Prime Contractor Labor Cost ERROR:#N/A

Subcontractor Labor Cost									Subcontractor Labor Cost
Subcontractors - Contractor Site									Subcontractors - Contractor Site
Cost Elements	RFP Labor Category	WD Code	ST Rate	OT Rate	ST Hours	OT Hours	ST Amount	OT Amount	Cost Elements	RFP Labor Category	WD Code	ST Rate	OT Rate	ST Hours	OT Hours	ST Amount	OT Amount
None							$ - 0	$ - 0	None							$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
							$ - 0	$ - 0								$ - 0	$ - 0
Subcontractors - Government Site List the Subcontractor & Name of Person									Subcontractors - Government Site List the Subcontractor & Name of Person
							$ - 0	$ - 0								$ - 0	$ - 0
ACE/Joe Smith	PM	NA	$ 50.00	$ 70.00	50.0	20.0	$ 2,500.00	$ 1,400.00	ACE/Joe Smith	PM	NA	$ 50.00	$ 70.00	50.0	20.0	$ 2,500.00	$ 1,400.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	$ - 0								$ - 0	$ - 0

Total Subcontractor proposed cost and fee 50 20 $ 2,500.00 $ 1,400.00 Total Subcontractor proposed cost and fee 50 20 $ 2,500.00 $ 1,400.00

Prime contractor pass through (not including fee)				Prime contractor pass through (not including fee)
Material and Handling	0.00%	$ - 0	$ - 0	Material and Handling	0.00%	$ - 0	$ - 0
G&A (KTR FY 5)	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	G&A (KTR FY 6)	0.00%	$ - 0	$ - 0
	ERROR:#N/A				ERROR:#N/A
Total pass through (not including fee)			ERROR:#N/A	Total pass through (not including fee)			$ - 0
Total Subcontractor Cost including pass through			ERROR:#N/A	Total Subcontractor Cost including pass through			$ 3,900.00

Total Labor Cost (Prime and Subcontractor Labor) 52 22 ERROR:#N/A Total Labor Cost (Prime and Subcontractor Labor) 50 20 ERROR:#N/A

Fixed Fee			Fixed Fee
Fee On Sub	0.00%	ERROR:#N/A	Fee On Sub	0.00%	$ - 0
Fee on Prime	0.00%	ERROR:#N/A	Fee on Prime	0.00%	ERROR:#N/A
Total Fee (for Prime and Subcontractor Labor)		ERROR:#N/A	Total Fee (for Prime and Subcontractor Labor)		ERROR:#N/A

Total Labor Cost Plus Fixed Fee (CPFF) ERROR:#N/A Total Labor Cost Plus Fixed Fee (CPFF) ERROR:#N/A

Material (BASE Amount)		$ 100,000.00	Material (BASE Amount)		$ 100,000.00
Material and Handling	0.00%	$ - 0	Material and Handling	0.00%	$ - 0
	ERROR:#N/A			ERROR:#N/A
	ERROR:#N/A			ERROR:#N/A
Total Material		$ 100,000.00	Total Material		$ 100,000.00

ODC/Travel/Shipping (BASE Amount)		$ 2,500.00	ODC/Travel/Shipping (BASE Amount)		$ 2,500.00
Overhead - Contractor Site A (KTR FY 5)	ERROR:#N/A	ERROR:#N/A	G&A (KTR FY 6)	0.00%	$ - 0
	ERROR:#N/A			ERROR:#N/A
Total ODC/Travel		ERROR:#N/A	Total ODC/Travel		$ 2,500.00

Total ODCs ERROR:#N/A Total ODCs $ 102,500.00

COM 0.00% 15 COM 0.00% 15

Total CPFF (Labor and ODCs)	ERROR:#N/A	Total CPFF (Labor and ODCs)	ERROR:#N/A
Grand Total
Input rates for the applicable period
Place formula in this cell. Rate or factor to be utilized must come from the rate corresponding with the rate category drop down menu.
Do not manipulate this cell
Offeror input via dropdown menu for cells in column "B" or direct input in other cells
If offeror controlled cells within the yellow highlighted areas are changed, the offeror must ensure the summation formula includes the newly created rows.
Note: Numbers added to demonstrate the functionality of the spreadsheet; all values and labor categories should be replaced in accordance with the offeror's information and in accordance with the instructions in Provision L-317.

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated Dec 30, 2023.