RFP Attachment 4 - Cost Matrix Depot 20170228.xlsx

XLSX spreadsheet 103 KB Posted Jan 3, 2018

Attached to: Depot System Support
Solicitation number: N66001-16-R-0126
Issued by: Department of the Navy Information Warfare Systems Command

View the file

Other files

File	Type	Posted
N66001-16-R-0126 Depot RFP 20170301.pdf	PDF	Jan 3, 2018
N66001-16-R-0126 Amendment 2.pdf	PDF	Jan 3, 2018
Market Survey - Depot.pdf	PDF	Jan 3, 2018
RFP Attachment 5 - Reference Information Sheet.doc	DOC document	Jan 3, 2018
RFP Attachment 2- Desired Personnel Qualifications (Depot).pdf	PDF	Jan 3, 2018
PWS Depot 20161222 (Draft).pdf	PDF	Jan 3, 2018
RFP Attachment 7 - Wage Determination 15-5635.pdf	PDF	Jan 3, 2018
RFP Attachment 6 - Past Performance Questionnaire.doc	DOC document	Jan 3, 2018
RFP Attachment 5 - Reference Information Sheet 20170321A.doc	DOC document	Jan 3, 2018
N66001-16-R-0126 Amendment 1.pdf	PDF	Jan 3, 2018
RFP Attachment 2- Desired Personnel Qualifications (Depot) 20170321.pdf	PDF	Jan 3, 2018
RFP Attachment 3 - Rate Sheet.xlsx	XLSX spreadsheet	Jan 3, 2018
RFP Attachment 3 - Rate Sheet 20170320.xlsx	XLSX spreadsheet	Jan 3, 2018
RFP Attachment 1 - DD254 16R0126 dtd 20170210.pdf	PDF	Jan 3, 2018

Show all 14

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/ODC
Labor Fringe		Cost
Subcontracts		Fee
Subcontractor Handling		CPFF
Tavel/Misc. ODC and Shipping
G&A		CLIN 0005 Material
Material		Cost
Material Handling
		CLIN 0006 NSP CDRL	$0.00
Subtotal
COM		TOTAL OPTION 1
Fee/Profit

TOTAL

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

CLIN 0002 Material	CLIN 0008 Material
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-317.

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	SCA Occupational Code/Title	ST Rate	OT Rate	RT Hours	OT Hours	ST Amount	OT Amount	Cost Elements	RFP Labor Category	SCA Occupational Code/Title	ST Rate	OT Rate	RT Hours	OT Hours	ST 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	SCA Occupational Code/Title	ST Rate	OT Rate	RT Hours	OT Hours	ST Amount	OT Amount	Cost Elements	RFP Labor Category	SCA Occupational Code/Title	ST Rate	OT Rate	RT Hours	OT Hours	ST 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 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	SCA Occupational Code/Title	ST Rate	OT Rate	RT Hours	OT Hours	ST Amount	OT Amount	Cost Elements	RFP Labor Category	SCA Occupational Code/Title	ST Rate	OT Rate	RT Hours	OT Hours	ST 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	SCA Occupational Code/Title	ST Rate	OT Rate	RT Hours	OT Hours	ST Amount	OT Amount	Cost Elements	RFP Labor Category	SCA Occupational Code/Title	ST Rate	OT Rate	RT Hours	OT Hours	ST 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	SCA Occupational Code/Title	ST Rate	OT Rate	RT Hours	OT Hours	ST Amount	OT Amount	Cost Elements	RFP Labor Category	SCA Occupational Code/Title	ST Rate	OT Rate	RT Hours	OT Hours	ST 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.

File details come from the government source that posted it.