ATTACHMENT 3A - EXCEL PRICING WORKBOOK - PRIME.xlsx

XLSX spreadsheet 593 KB Posted Mar 16, 2026

Attached to: KC-135 Center Console Refresh (CCR) Revision 2
Solicitation number: FA8105_CCR_Rev2
Issued by: Department of the Air Force Materiel Command Lifecycle Management Center Tinker Air Force Base

About this file

Written by GovTribe AI · Mar 16, 2026

This is an Excel pricing workbook template for the KC-135 Center Console Refresh (CCR) program, designed for prime contractors to submit cost and pricing data for a Cost Plus Incentive Fee (CPIF) and Fixed-Price (FFP) hybrid contract structure.

The template covers three CPIF CLINs (0001 Development, 0002 Simulator Kit, and 0003 Systems Integration Laboratory) and multiple FFP CLINs (X007-X021 for production items including A-Kits, B-Kits, support equipment, installations, configuration control, maintenance and repair support, technical orders, simulator kits, training, program management, and production spares). For CPIF CLINs, contractors must input direct labor categories with hourly rates, material costs, subcontractor costs, and Other Direct Costs (ODC), along with indirect rates for labor fringe, overhead, G&A, FCCOM, and target fee. For FFP CLINs, contractors propose unit prices multiplied by Best Estimated Quantities across a basic period (48 months) and six 12-month option periods. The workbook automatically calculates Total Evaluated Price (TEP) by linking proposed costs across worksheets and applying indirect rate multipliers. Key instructions require all dollar amounts rounded to two decimal places and percentage rates to four decimal places; format modifications to CPIF worksheets are permitted if properly linked; and material costs must align with the Consolidated Bill of Materials referenced in RFP Section L, with production spares limited to cumulative B-Kit component prices.

View the file

Other files

File	Type	Posted
Draft Solicitation - FA810526RB001 21 May 26.pdf	PDF	May 26, 2026
Draft Solicitation - FA810526RB001 21 May 26 (1).pdf	PDF	May 21, 2026
3. ATTACHMENT 3B - DRAFT EXCEL PRICING WORKBOOK - SUB UPDATED (P) - Draft.xlsx	XLSX spreadsheet	May 21, 2026
4. Attachment 4. KC-135 CCR DRAFT Section L - Instructions to Offerors (1).pdf	PDF	May 21, 2026
3. ATTACHMENT 3A - DRAFT EXCEL PRICING WORKBOOK - PRIME - UPDATED (P) - Draft.xlsx	XLSX spreadsheet	May 21, 2026
5. Attachment 5. KC-135 CCR DRAFT Section M - Evaluation Factors for Award.pdf	PDF	May 21, 2026
DRAFT Solicitation - FA810526RB001.pdf	PDF	Mar 16, 2026
Attachment 8 - DRAFT TM-86-01R Air Force Technical Manual Contract Requirements (TMCR)_REV2_7 July 2025.pdf	PDF	Mar 16, 2026
ATTACHMENT 3B - EXCEL PRICING WORKBOOK - SUB.xlsx	XLSX spreadsheet	Mar 16, 2026
KC-135 CCR Industry Day Flyer.pdf	PDF	Mar 16, 2026
DRAFT Exhibit A CCR Revision 2 CDRL Package.pdf	PDF	Mar 16, 2026
Attachment 9 - DCAA Preaward Survey of Prospective Contractor Accounting System Checklist.pdf	PDF	Mar 16, 2026
Attachment 4 - DRAFT CCR Section L - Instructions to Offerors (1).pdf	PDF	Mar 16, 2026
MEMO Draft Solicitation FA810526RB001.pdf	PDF	Mar 16, 2026
DRAFT SOW Appendix D DD2794_KC-135 CCR.pdf	PDF	Mar 16, 2026
Attachment 6 - DRAFT CCR Revision 2 Data Rights Assertion Matrix.pdf	PDF	Mar 16, 2026
Attachment 7 -DRAFT CCR DD254 - Feb 2026.pdf	PDF	Mar 16, 2026
Attachment 5 - DRAFT CCR Section M - Evaluation Factors for Award (1).pdf	PDF	Mar 16, 2026
Attachment 4 - DRAFT CCR Section L - Instructions to Offerors.pdf	PDF	Feb 27, 2026
Attachment 5 - DRAFT CCR Revision 2 Section M - Evaluation Factors for Award as of 25 Feb.pdf	PDF	Feb 27, 2026

Show all 20

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.

INSTRUCTIONS

Source Selection Information - See FAR 2.101 and 3.104

KC-135 Center Console Refresh (CCR) Source Selection

Attachment 3A, EPW - PRIME

Notes:

1. The worksheet tabs highlighted in yellow within Attachment 3A require Offeror input; the cells within each worksheet requiring input are highlighted in yellow

2. All proposed dollar amounts and labor rates shall be rounded to two decimal places. All proposed rates in percentages shall be rounded to four decimal places (ex. .0755 = 7.55%)

3. The Total Evaluated Price (TEP) is calculated by multiplying the Best Estimated Quantities (BEQs) by the amounts proposed for the FFP and CPIF CLINs. The TEP will automatically calculate in the "SUMMARY" worksheet

4. The Total Evaluated Price (TEP) by performance period will automatically calculate on the "TOTAL EVALUATED PRICE ROLLUP" worksheet

Instructions for completing this Pricing Matrix/Cost Model:

Pricing Matrix - FFP CLINs X007 - X016, X020, and X021:
1	Offerors are required to input the proposed unit prices into the "FFP CLINs X007-X021" worksheet in ALL yellow highlighted cells (Offeror Name in Cell B1 and dollar amounts in Columns F, J, N, R, V, Z, and AD)
2	Offerors are required to input the supporting information and proposed quantities/unit prices for the Production Spares for the B-Kit in the "SPARES-FFP CLIN X021 INPUTS" worksheet. The total amount by period will automatically populate the "FFP CLINs X007-X021" worksheet for CLIN X021
3	The extended price for CLINs X007 - X021 will be automatically calculated by multiplying the proposed unit price by the best estimated evaluation quantity
4	A subtotal price will be automatically calculated at the bottom of each contract period/year
5	The total proposed amounts for the FFP CLINs will automatically populate the "SUMMARY" worksheet, which will ultimately calculate the Total Evaluated Price (TEP)

Cost Model - CPIF CLINs 0001 - 0003:
1	Refer to the "Notes" on each CPIF worksheet for specific information/instructions
2	The format of the Cost Model worksheets entitled "PRIME CPIF RATES (ALL)", "PRIME CPIF RATE DESC (ALL)", "PRIME CPIF LABOR by TASK", "PRIME CPIF LABOR INPUTS", "PRIME CPIF TOTAL MATERIAL", "PRIME CPIF TOTAL SUB", "PRIME CPIF TOTAL ODC" and "CPIF CLIN 000X-TASK 1.XX INPUTS" may be revised by the Offeror as necessary; if revisions are made, Offerors shall ensure properly linking to corresponding worksheets
3	The "CPIF CLIN 000X-TASK 1.XX INPUTS" worksheets are linked to the "PRIME CPIF RATES (ALL)", "PRIME CPIF LABOR INPUTS", "PRIME CPIF TOTAL MATERIAL", "PRIME CPIF TOTAL SUB", and "PRIME CPIF TOTAL ODC" worksheets. Inputs in the "CPIF CLIN 000X-TASK 1.XX INPUTS" worksheets are not required, but the format of these worksheets may be revised, if necessary
4	The "CPIF CLIN 000X TOTAL" worksheets are linked to the "CPIF CLIN 000X-TASK 1.XX INPUTS" worksheets; no inputs are required, but the format of these worksheets should be revised to align with "CPIF 000X-TASK 1.XX INPUTS" worksheets, if necessary
5	The "CPIF CLIN 000X SUMMARY" worksheets includes links to the "CPIF CLIN 000X-TASK 1.XX INPUTS" worksheets; no inputs required
6	The total proposed amounts for the CPIF CLINs will automatically populate the "SUMMARY" worksheet, which will ultimately calculate the TEP; no inputs required
7	The minimum fees, maximum fees, and share ratios are provided by the Government in the "CPIF CLIN BREAKDOWN" worksheet. The CPIF CLIN breakout by Target Cost, Target Fee, Target FCCOM, and Target Price will automatically populate the "CPIF CLIN BREAKDOWN" worksheet for each CPIF CLIN based on the Offeror's inputs in the above worksheets; no inputs required.

CALCULATION METHODOLOGY

KC-135 CCR EXCEL PRICING WORKBOOK (EPW) - CALCULATION METHODOLOGY - PRIME OFFEROR
CLIN	CONTRACT TYPE	DESCRIPTION	CALCULATION METHODOLOGY
EMD
0001	CPIF	Development	Proposed target price for EMD CLIN 0001 based on inputs from EMD CPIF worksheets (lot price)
0002	CPIF	Simulator Kit	Proposed target price for EMD CLIN 0002 based on inputs from EMD CPIF worksheets (lot price)
0003	CPIF	Systems Integration Laboratory (SIL)	Proposed target price for EMD CLIN 0003 based on inputs from EMD CPIF worksheets (lot price)
0004	NSP	Contract Data Requirements Lists (CDRLs)	Not evaluated
0005	CR-NF	Travel - EMD	Not evaluated
0006	NSP	Data/Intellectual Property	Not evaluated
PRODUCTION
X007	FFP	Production A-Kits	Proposed unit price (fully burdened) multiplied by best estimated quantity of A-Kits for each performance period
X008	FFP	Production B-Kits	Proposed unit price (fully burdened) multiplied by best estimated quantity of B-Kits for each performance period
X009	FFP	Support Equipment	Proposed lot price (fully burdened) for Support Equipment for each performance period
X010	FFP	Installations	Proposed unit price (fully burdened) multiplied by best estimated quantity of Installations for each performance period
X011	FFP	Production Configuratiaon Control/Engineering Change Orders	Proposed monthly price (fully burdened) multiplied by quantity of months in the performance period
X012	FFP	Maintenance & Repair Support	Proposed monthly price (fully burdened) multiplied by quantity of months in the performance period
X013	FFP	Technical Orders	Proposed monthly price (fully burdened) multiplied by quantity of months in the performance period
X014	FFP	Simulator Kits	Proposed unit price (fully burdened) multiplied by best estimated quantity of Simulator Kits for each performance period
X015	FFP	SIL	Proposed unit price (fully burdened) multiplied by best estimated quantity of SILs for each performance period
X016	FFP	Training	Proposed monthly price (fully burdened) multiplied by quantity of months in the performance period
X017	NSP	Data - Production	Not evaluated
X018	CR-NF	Travel - Production	Not evaluated
X019	CR-NF	Over & Above (O&A)	Not evaluated
X020	FFP	Program Management - Production	Proposed monthly price (fully burdened) multiplied by quantity of months in the performance period
X021	FFP	Production Spares	Proposed unit price (fully burdened) multiplied by best estimated quantity of Production Spare Kits (unit price calculated by inputs in the "Spares-FFP CLIN X021 INPUTS" worksheet) for each performance period

SOURCE SELECTION INFORMATION - SEE FAR 2.101 and 3.104

SUMMARY

PRIME OFFEROR NAME

Notes: Proposed CLIN unit costs/prices are linked to the "CPIF CLIN 000X TOTAL" and "FFP CLINs X007 - X021" worksheets; no input required

	KC-135 Center Console Refresh (CCR) Competitive Pricing Matrix SUMMARY		Basic Period (48 months)	Option Period I Performance
(12 months)		Option Period II Performance
(12 months)		Option Period III Performance
(12 months)		Option Period IV Performance
(12 months)		Option Period V Performance
(12 months)		Option Period VI Performance

(12 months) CLIN Description Contract Type Unit of Issue Basic Period CLIN

Qty/BEQ Unit Price Extended Price Option Period I CLIN

Qty/BEQ Unit Price Extended Price Option Period II CLIN

Qty/BEQ Unit Price Extended Price Option Period III CLIN

Qty/BEQ Unit Price Extended Price Option Period IV CLIN

Qty/BEQ Unit Price Extended Price Option Period V CLIN Qty/BEQ Unit Price Extended Price Option Period VI CLIN Qty/BEQ Unit Price Extended

Price		TOTAL EVALUATED PRICE
	EMD				EMD				EMD				EMD				EMD				EMD				EMD				EMD
	Development	Cost Plus Incentive Fee (CPIF)	Lot	0001	1	$ - 0	$ - 0																									$ - 0
	Simulator Kit	CPIF	Lot	0002	1	$ - 0	$ - 0																									$ - 0
	Systems Integration Laboratory (SIL)	CPIF	Lot	0003	1	$ - 0	$ - 0																									$ - 0
	Data - EMD	Not Separately Priced (NSP)	N/A	0004
	Travel - EMD	Cost Reimbursable - No Fee (CR-NF)	N/A	0005
	Intellectual Property	NSP	N/A	0006
	PRODUCTION				PRODUCTION				PRODUCTION				PRODUCTION				PRODUCTION				PRODUCTION				PRODUCTION				PRODUCTION
	A-Kits - Production	FFP	Each	0007	16	$ - 0	$ - 0	1007	50	$ - 0	$ - 0	2007	50	$ - 0	$ - 0	3007	47	$ - 0	$ - 0	4007	45	$ - 0	$ - 0	5007	45	$ - 0	$ - 0	6007	53	$ - 0	$ - 0	$ - 0
	B-Kits - Production	FFP	Each	0008	12	$ - 0	$ - 0	1008	45	$ - 0	$ - 0	2008	45	$ - 0	$ - 0	3008	45	$ - 0	$ - 0	4008	45	$ - 0	$ - 0	5008	45	$ - 0	$ - 0	6008	53	$ - 0	$ - 0	$ - 0
	Support Equipment - Production	FFP	Lot	0009	1	$ - 0	$ - 0	1009	1	$ - 0	$ - 0	2009	1	$ - 0	$ - 0	3009	1	$ - 0	$ - 0	4009	1	$ - 0	$ - 0	5009	1	$ - 0	$ - 0	6009	1	$ - 0	$ - 0	$ - 0
	Installations	FFP	Each	0010				1010	12	$ - 0	$ - 0	2010	45	$ - 0	$ - 0	3010	45	$ - 0	$ - 0	4010	45	$ - 0	$ - 0	5010	45	$ - 0	$ - 0	6010	45	$ - 0	$ - 0	$ - 0
	Production Configuratiaon Control/Engineering Change Orders	FFP	Month	0011				1011	12	$ - 0	$ - 0	2011	12	$ - 0	$ - 0	3011	12	$ - 0	$ - 0	4011	12	$ - 0	$ - 0	5011	12	$ - 0	$ - 0	6011	12	$ - 0	$ - 0	$ - 0
	Maintenance & Repair Support - Production	FFP	Month	0012				1012	12	$ - 0	$ - 0	2012	12	$ - 0	$ - 0	3012	12	$ - 0	$ - 0	4012	12	$ - 0	$ - 0	5012	12	$ - 0	$ - 0	6012	12	$ - 0	$ - 0	$ - 0
	Technical Orders - Production	FFP	Month	0013				1013	12	$ - 0	$ - 0	2013	12	$ - 0	$ - 0	3013	12	$ - 0	$ - 0	4013	12	$ - 0	$ - 0	5013	12	$ - 0	$ - 0	6013	12	$ - 0	$ - 0	$ - 0
	Simulator Kits - Production	FFP	Each	0014	3	$ - 0	$ - 0	1014	6	$ - 0	$ - 0	2014	6	$ - 0	$ - 0	3014	6	$ - 0	$ - 0	4014				5014				6014				$ - 0
	SIL - Production	FFP	Each	0015				1015				2015	1	$ - 0	$ - 0	3015				4015				5015				6015		$ - 0		$ - 0
	Training	FFP	Month	0016	12	$ - 0	$ - 0	1016	12	$ - 0	$ - 0	2016	12	$ - 0	$ - 0	3016	12	$ - 0	$ - 0	4016	12	$ - 0	$ - 0	5016	12	$ - 0	$ - 0	6016	12	$ - 0	$ - 0	$ - 0
	Data - Production	NSP	N/A	0017				1017				2017				3017				4017				5017				6017
	Travel - Production	CR-NF	N/A	0018				1018				2018				3018				4018				5018				6018
	Over & Above	CR-NF	N/A	0019				1019				2019				3019				4019				8019				6019
	Program Management - Production	FFP	Month	0020	12	$ - 0	$ - 0	1020	12	$ - 0	$ - 0	2020	12	$ - 0	$ - 0	3020	12	$ - 0	$ - 0	4020	12	$ - 0	$ - 0	5020	12	$ - 0	$ - 0	6020	12	$ - 0	$ - 0	$ - 0
	Production Spares	FFP	Each	0021	2	$ - 0	$ - 0	1021	6	$ - 0	$ - 0	2021	7	$ - 0	$ - 0	3021	8	$ - 0	$ - 0	4021	10	$ - 0	$ - 0	5021	10	$ - 0	$ - 0	6021	7	$ - 0	$ - 0	$ - 0
						TOTAL	$ - 0			TOTAL	$ - 0			TOTAL	$ - 0			TOTAL	$ - 0			TOTAL	$ - 0			TOTAL	$ - 0			TOTAL	$ - 0	$ - 0	TOTAL EVALUATED PRICE

$ - 0 Double Check

TOTAL EVALUATED PRICE ROLLUP

PRIME OFFEROR	NAME
PERIOD OF PERFORMANCE	PRICE
ESTIMATED TOTAL PRICE FOR BASIC PERIOD (48 MONTHS)	$0.00
ESTIMATED TOTAL PRICE FOR OPTION PERIOD I (12 MONTHS)	$0.00
ESTIMATED TOTAL PRICE FOR OPTION PERIOD II (12 MONTHS)	$0.00
ESTIMATED TOTAL PRICE FOR OPTION PERIOD III (12 MONTHS)	$0.00
ESTIMATED TOTAL PRICE FOR OPTION PERIOD IV (12 MONTHS)	$0.00
ESTIMATED TOTAL PRICE FOR OPTION PERIOD V (12 MONTHS)	$0.00
ESTIMATED TOTAL PRICE FOR OPTION PERIOD VI (12 MONTHS)	$0.00
TOTAL EVALUATED PRICE (TEP) = (1) 4-YEAR BASIC PERIOD + (6) 1-YEAR OPTION PERIODS	$0.00

FFP CLINs X007-X021

PRIME OFFEROR NAME

Notes:

1. Insert proposed unit prices in all yellow-highlighted cells

2. All proposed prices shall be rounded to the nearest dollar

3. All proposed prices shall be proposed sufficiently to ensure adequate coverage of all labor costs, all subcontractor costs, all indirect costs, including G&A, COM, and so forth as well as prime and subcontractor profit in every contract out-year

4. No format changes on this worksheet are permitted

	KC-135 Center Console Refresh (CCR) Competitive Pricing Matrix FFP CLINS		Basic Period (48 months)	Option Period I Performance
(12 months)		Option Period II Performance
(12 months)		Option Period III Performance
(12 months)		Option Period IV Performance
(12 months)		Option Period V Performance
(12 months)		Option Period VI Performance

(12 months) CLIN Description Contract Type Unit of Issue Basic Period CLIN

BEQ

Unit Price Extended Price Option Period I CLIN

BEQ

Unit Price Extended Price Option Period II CLIN

BEQ

Unit Price Extended Price Option Period III CLIN

BEQ

Unit Price Extended Price Option Period IV CLIN

BEQ

Unit Price Extended Price Option Period V CLIN

BEQ

Unit Price Extended Price Option Period VI CLIN

BEQ

Unit Price Extended

Price		TOTAL EVALUATED PRICE - FFP
	PRODUCTION CLINs
	Production A-Kits	FFP	Each	0007	16	$ - 0	$ - 0	1007	50	$ - 0	$ - 0	2007	50	$ - 0	$ - 0	3007	47	$ - 0	$ - 0	4007	45	$ - 0	$ - 0	5007	45	$ - 0	$ - 0	6007	53	$ - 0	$ - 0	$ - 0
	Production B-Kits	FFP	Each	0008	12	$ - 0	$ - 0	1008	45	$ - 0	$ - 0	2008	45	$ - 0	$ - 0	3008	45	$ - 0	$ - 0	4008	45	$ - 0	$ - 0	5008	45	$ - 0	$ - 0	6008	53	$ - 0	$ - 0	$ - 0
	Production Support Equipment	FFP	Lot	0009	1	$ - 0	$ - 0	1009	1	$ - 0	$ - 0	2009	1	$ - 0	$ - 0	3009	1	$ - 0	$ - 0	4009	1	$ - 0	$ - 0	5009	1	$ - 0	$ - 0	6009	1	$ - 0	$ - 0	$ - 0
	Installations	FFP	Each	0010				1010	12	$ - 0	$ - 0	2010	45	$ - 0	$ - 0	3010	45	$ - 0	$ - 0	4010	45	$ - 0	$ - 0	5010	45	$ - 0	$ - 0	6010	45	$ - 0	$ - 0	$ - 0
	Production Configuration Control/Engineering Change Orders	FFP	Month	0011				1011	12	$ - 0	$ - 0	2011	12	$ - 0	$ - 0	3011	12	$ - 0	$ - 0	4011	12	$ - 0	$ - 0	5011	12	$ - 0	$ - 0	6011	12	$ - 0	$ - 0	$ - 0
	Maintenance & Repair Support (including Production SIL)	FFP	Month	0012				1012	12	$ - 0	$ - 0	2012	12	$ - 0	$ - 0	3012	12	$ - 0	$ - 0	4012	12	$ - 0	$ - 0	5012	12	$ - 0	$ - 0	6012	12	$ - 0	$ - 0	$ - 0
	Technical Orders	FFP	Month	0013				1013	12	$ - 0	$ - 0	2013	12	$ - 0	$ - 0	3013	12	$ - 0	$ - 0	4013	12	$ - 0	$ - 0	5013	12	$ - 0	$ - 0	6013	12	$ - 0	$ - 0	$ - 0
	Production Simulator Kits	FFP	Each	0014	3	$ - 0	$ - 0	1014	6	$ - 0	$ - 0	2014	6	$ - 0	$ - 0	3014	6	$ - 0	$ - 0	4014				5014				6014				$ - 0
	Production Software Integration Laboratory (SIL)	FFP	Each	0015				1015				2015	1	$ - 0	$ - 0	3015				4015				5015				6015				$ - 0
	Training	FFP	Month	0016	12	$ - 0	$ - 0	1016	12	$ - 0	$ - 0	2016	12	$ - 0	$ - 0	3016	12	$ - 0	$ - 0	4016	12	$ - 0	$ - 0	5016	12	$ - 0	$ - 0	6016	12	$ - 0	$ - 0	$ - 0
	Production Program Management	FFP	Month	0020	12	$ - 0	$ - 0	1020	12	$ - 0	$ - 0	2020	12	$ - 0	$ - 0	3020	12	$ - 0	$ - 0	4020	12	$ - 0	$ - 0	5020	12	$ - 0	$ - 0	6020	12	$ - 0	$ - 0	$ - 0
	Production Spares*	FFP	Each	0021	2	$ - 0	$ - 0	1021	6	$ - 0	$ - 0	2021	7	$ - 0	$ - 0	3021	8	$ - 0	$ - 0	4021	10	$ - 0	$ - 0	5021	10	$ - 0	$ - 0	6021	7	$ - 0	$ - 0	$ - 0
	*See 'SPARES-FFP CLIN X021 INPUTS' worksheet to input individual components of the spare B-Kits; the extended totals will automatically populate in cells F17, J17, N17, R17, V17, Z17, and AD17)					TOTAL FFP	$ - 0			TOTAL FFP	$ - 0			TOTAL FFP	$ - 0			TOTAL FFP	$ - 0			TOTAL FFP	$ - 0			TOTAL FFP	$ - 0			TOTAL FFP	$ - 0	$ - 0	TOTAL EVALUATED PRICE - FFP
																																$ - 0	Double Check
																																$ - 0	Difference should be $0

SPARES-FFP CLIN X021 INPUTS

	PRIME OFFEROR	NAME
Notes:
1. The Offeror is required to list the individual parts within the B-Kit below, along with unit pricing and quantities for the individual parts in each shipset; reference Statement of Work (SOW) Paragraph 13.7.1
2. The unit prices for B-Kit parts will be multiplied by the proposed quantity to arrive at a total amount for CLIN X021 LRU Spares for each performance period; the total proposed amount for CLIN X021 LRU Spares cannot exceed the total price for the individual B-Kit parts
3. The Offeror shall provide the required information in the table below (amend as necessary). Additional information may be provided in contractor format. If contractor format is utilized, the information shown in the table below must be included at a minimum.
4. The Offeror shall ensure the total proposed amounts by period properly link to the "FFP CLINs X007-X021" worksheet for CLIN X021
5. The total proposed price for CLIN X021 LRU Spares cannot exceed the cumulative price for the individual B-Kit parts

CLIN X021 - LRU Spares (for B-Kits)				Basic Period		Option Period I		Option Period II		Option Period III		Option Period IV		Option Period V		Option Period VI
NSN	P/N	Item Description	Qty	Unit Price	Extended	Unit Price	Extended	Unit Price	Extended	Unit Price	Extended	Unit Price	Extended	Unit Price	Extended	Unit Price	Extended
				$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
				$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
				$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
				$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
				$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
				$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
				$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
				$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
				$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
				$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
				$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
				$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
				$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
TOTAL					$0.00		$0.00		$0.00		$0.00		$0.00		$0.00		$0.00

PRIME CPIF RATES (ALL)

PRIME OFFEROR NAME

KC-135 Center Console Refresh (CCR) Prime Contractor Direct Labor and Indirect Rates

Notes:

1. The format of this worksheet may be revised as required to be consistent with the Prime Offeror's approved Accounting System to include, but not limited to, inserting additional labor categories and revising the indirect rate structure

2. The Prime Offeror shall propose labor rates and indirect rates in the yellow-highlighted cells below. All proposed labor rates shall be rounded to two (2) decimal places. All rates in percentages shall be rounded to four decimal places (ex. .0755 = 7.55%)

3. The Prime Offeror shall input the proposed rates and indirect rates below and ensure these cells are linked correctly to the relevant CPIF rate cells on the "CPIF CLIN 0001 - TASK 1.0X" INPUTS", "CPIF CLIN 0002 - TASK 1.0X INPUTS", and "CPIF CLIN 0003 - TASK 1.0X INPUTS" worksheets

4. The Prime Offeror shall provide descriptions of the labor categories and indirect rates in the "PRIME CPIF Rate Desc (All)" worksheet, in addition to base costs upon which indirect rates apply

5. The Prime Offeror shall ensure that all labor and indirect rate categories included in the proposal for EMD CLINs 0001, 0002, and 0003 are included in this worksheet

	Proposed Direct Labor Rates
	Basic (Year 1)	Basic (Year 2)	Basic (Year 3)	Basic (Year 4)
Labor Category	Hourly Rate	Hourly Rate	Hourly Rate	Hourly Rate
Insert all direct labor categories that apply (add more rows if necessary); make changes to below categories accordingly and ensure cells properly link to the 'CPIF CLIN 000X - TASK 1.XX INPUTS' worksheets for CLINs 0001,0002, and 0003

	Proposed Indirect Rates/Factors
Indirect Rate Category (Labor)	Basic (Year 1)	Basic (Year 2)	Basic (Year 3)	Basic (Year 4)
Insert all indirect categories that apply to labor costs; make changes to below categories accordingly and ensure cells properly link to the 'CPIF CLIN 000X - TASK 1.XX INPUTS' worksheets (Columns E, I, and M for CLINs 0001,0002, and 0003) and align with the rates reflected in the 'PRIME CPIF Rate Desc (All)' work sheet
Indirect Labor Category: [Labor Fringe]
Indirect Labor Category: [Labor Overhead]
Indirect Labor Category: [G&A]
Indirect Labor Category: [FCCOM]
Indirect Labor Category: [Target Fee]

	Proposed Subcontractor Rates/Factors (Burdens added by Prime to Subcontractor Costs)
Indirect Rate Category (Subcontractor)	Basic (Year 1)	Basic (Year 2)	Basic (Year 3)	Basic (Year 4)
Insert all indirect categories that the prime offeror will apply to subcontractor costs; make changes to below categories accordingly and ensure cells link properly to the 'CPIF CLIN 000X - TASK 1.XX INPUTS' worksheets (Columns E, I, and M for CLINs 0001, 0002, and 0003) and align with the rates reflected in the 'PRIME CPIF Rate Desc (All)' work sheet
Indirect Category: [Overhead]					`
Indirect Category: [G&A]
Indirect Category: [FCCOM]
Indirect Category: [Target Fee]

	Proposed Material Rates/Factors
Indirect Rate Category (Material)	Basic (Year 1)	Basic (Year 2)	Basic (Year 3)	Basic (Year 4)
Insert all indirect categories that apply to material costs; make changes to below categories accordingly and ensure cells link properly to the 'CPIF CLIN 000X - TASK 1.XX INPUTS' worksheets (Columns, E, I, and M for CLINs 0001, 0002, and 0003) and align with the rates reflected in the 'PRIME CPIF Rate Desc (All)' work sheet
Indirect Category: [Material Overhead]
Indirect Category: [G&A]
Indirect Category: [FCCOM]
Indirect Category: [Target Fee]

	Proposed Other Direct Cost (ODC) Rates/Factors
Indirect ODC Category (Other)	Basic (Year 1)	Basic (Year 2)	Basic (Year 3)	Basic (Year 4)
Insert all indirect categories that apply to ODC; make changes to below categories accordingly and ensure cells link properly to the 'CPIF CLIN 000X - TASK 1.XX INPUTS' worksheets (Columns, E, I, and M for CLINs 0001, 0002, and 0003) and align with the rates reflected in the 'PRIME CPIF Rate Desc (All)' work sheet
Indirect Category: [Overhead]
Indirect Category: [G&A]
Indirect Category: [FCCOM]
Indirect Category: [Target Fee]

PRIME CPIF RATE DESC (ALL)

PRIME OFFEROR NAME

KC-135 Center Console Refresh (CCR) Prime Contractor Direct Labor and Indirect Rates

Notes:

2. The Prime Offeror shall list all proposed labor categories and provide a summary description for each labor category

3. The Prime Offeror shall list all proposed indirect rate categories, and provide a summary description of each indirect rate category along with the base cost upon which the indirect rate is applied

4. The Prime Offeror shall ensure that all labor and indirect rate categories included in the proposal for EMD CLINs 0001, 0002, and 0003 are included in this worksheet

Labor Category and Indirect Rate Descriptions

Labor Category	Description
Example Labor Category: Systems Engineer/Integrator	Conducts comprehensive system-wide review and analysis of all aspects of the development life cycle. Provides expertise in the transition of legacy systems to modernized systems.
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

Indirect Rate Category	Description	Allocation Base (Provide the base upon which the Indirect Rate is applied)
Example: Labor Fringe	Includes employee retirement plans, health insurance, and paid time off for sick leave and vacation	The base for Labor Fringe is total direct labor costs
Labor Fringe
Overhead (Labor)
Overhead (Material)
Overhead (Subcontractor)
Overhead (ODC)
General & Administrative (G&A)
Facilities Capital Cost of Money (FCCOM)
Target Fee

PRIME CPIF LABOR by TASK

PRIME OFFEROR NAME

KC-135 Center Console Refresh (CCR) Prime Contractor Labor by Task

Notes:

1. The format of this worksheet shall be revised to include every WBS (at the sub-task level) with proposed labor (if a WBS does not include proposed labor, do not include below)

2. At the sub-WBS level, the Prime Offeror shall provide the task to be performed, the labor category proposed to perform this task, the number of Full-Time Equivalents (FTEs) and corresponding labor hours to be utilized, and rationale to support the proposed labor

3. An example input has been provided in the template below (for illustrative purposes only); offerors shall delete the example in their proposal submission

Task Number	Task	Labor Category	# FTEs/Hours	Rationale
Example - For Illustrative Purposes Only
1.01	Development Thru PDR
1.01.01	ADD TITLE HERE	ENGINEER I	2 FTEs x 1,784 hours	To develop engineering plans
		ENGINEER II		To evaluate engineering plans
		QUALITY SPECIALIST		To evaluate quality of the engineering plans

PRIME CPIF LABOR INPUTS

PRIME OFFEROR NAME

Notes:

1. The format of this worksheet should be revised as required to include all proposed labor by task

2. The Prime Offeror shall input the proposed labor categories and corresponding labor hours by task (at the sub-task level) in the yellow-highlighted cells below; ensure consistency with the "PRIME LABOR by TASK" worksheet

3. The Prime Offeror shall ensure that the proposed labor rates properly link to the corresponding labor rates reflected in the "PRIME-CPIF RATES (ALL)" worksheet

4. The Prime Offeror shall ensure that all labor categories included in the proposal for EMD CLINs 0001, 0002, and 0003 are included in this worksheet

CLIN 0001 DEVELOPMENT, TASK 1.01 DEVELOPMENT THROUGH PDR		PROPOSED COSTS/PRICES - LABOR			PROPOSED COSTS/PRICES - LABOR			PROPOSED COSTS/PRICES - LABOR			PROPOSED COSTS/PRICES - LABOR
		Basic Period (Year 1)			Basic Period (Year 2)			Basic Period (Year 3)			Basic Period (Year 4)
Labor Category	Task	Labor Hours	Labor Rates	Direct Labor Cost	Labor Hours	Labor Rates	Direct Labor Cost	Labor Hours	Labor Rates	Direct Labor Cost	Labor Hours	Labor Rates	Direct Labor Cost
Insert all labor categories that apply; add/delete rows as necessary and ensure cells in Columns E, I, and M are properly linked to the rates in the 'PRIME-CPIF RATES (ALL)' worksheet	Insert applicable task by labor category at sub-task level (ex. 1.01.01, 1.01.02, and so forth); ensure consistency with the 'PRIME LABOR by TASK' worksheet	Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet		Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet		Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet		Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet
Labor Category : [INSERT LABOR CATEGORY NAME HERE]	1.01.01	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]	1.01.02	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]	1.01.03	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
TOTAL DIRECT LABOR HOURS/COST		0		$0.00	0		$0.00	0		$0.00	0		$0.00

CLIN 0001 DEVELOPMENT, TASK 1.02 DEVELOPMENT FROM PDR TO CDR		PROPOSED COSTS/PRICES - LABOR			PROPOSED COSTS/PRICES - LABOR			PROPOSED COSTS/PRICES - LABOR			PROPOSED COSTS/PRICES - LABOR
		Basic Period (Year 1)			Basic Period (Year 2)			Basic Period (Year 3)			Basic Period (Year 4)
Labor Category	Task	Labor Hours	Labor Rates	Direct Labor Cost	Labor Hours	Labor Rates	Direct Labor Cost	Labor Hours	Labor Rates	Direct Labor Cost	Labor Hours	Labor Rates	Direct Labor Cost
Insert all labor categories that apply; add/delete rows as necessary and ensure cells in Columns E, I, and M are properly linked to the rates in the 'PRIME-CPIF RATES (ALL)' worksheet	Insert applicable task by labor category at sub-task level (ex. 1.01.01, 1.01.02, and so forth); ensure consistency with the 'PRIME LABOR by TASK' worksheet	Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet		Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet		Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet		Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet
0	1.02.01	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]	1.02.02	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]	1.02.03	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
TOTAL DIRECT LABOR HOURS/COST		0		$0.00	0		$0.00	0		$0.00	0		$0.00

CLIN 0001 DEVELOPMENT, TASK 1.03 SYSTEM TEST AND EVALUATION		PROPOSED COSTS/PRICES - LABOR			PROPOSED COSTS/PRICES - LABOR			PROPOSED COSTS/PRICES - LABOR			PROPOSED COSTS/PRICES - LABOR
		Basic Period (Year 1)			Basic Period (Year 2)			Basic Period (Year 3)			Basic Period (Year 4)
Labor Category	Task	Labor Hours	Labor Rates	Direct Labor Cost	Labor Hours	Labor Rates	Direct Labor Cost	Labor Hours	Labor Rates	Direct Labor Cost	Labor Hours	Labor Rates	Direct Labor Cost
Insert all labor categories that apply; add/delete rows as necessary and ensure cells in Columns E, I, and M are properly linked to the rates in the 'PRIME-CPIF RATES (ALL)' worksheet	Insert applicable task by labor category at sub-task level (ex. 1.01.01, 1.01.02, and so forth); ensure consistency with the 'PRIME LABOR by TASK' worksheet	Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet		Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet		Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet		Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet
Labor Category : [INSERT LABOR CATEGORY NAME HERE]	1.03.01	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]	1.03.02	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]	1.03.03	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
TOTAL DIRECT LABOR HOURS/COST		0		$0.00	0		$0.00	0		$0.00	0		$0.00

CLIN 0001 DEVELOPMENT, TASK 1.04 DEVELOPMENT KITS (COTS AND DEVELOPMENTAL)		PROPOSED COSTS/PRICES - LABOR			PROPOSED COSTS/PRICES - LABOR			PROPOSED COSTS/PRICES - LABOR			PROPOSED COSTS/PRICES - LABOR
		Basic Period (Year 1)			Basic Period (Year 2)			Basic Period (Year 3)			Basic Period (Year 4)
Labor Category	Task	Labor Hours	Labor Rates	Direct Labor Cost	Labor Hours	Labor Rates	Direct Labor Cost	Labor Hours	Labor Rates	Direct Labor Cost	Labor Hours	Labor Rates	Direct Labor Cost
Insert all labor categories that apply; add/delete rows as necessary and ensure cells in Columns E, I, and M are properly linked to the rates in the 'PRIME-CPIF RATES (ALL)' worksheet	Insert applicable task by labor category at sub-task level (ex. 1.01.01, 1.01.02, and so forth); ensure consistency with the 'PRIME LABOR by TASK' worksheet	Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet		Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet		Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet		Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet
0	1.04.01	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]	1.04.02	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]	1.04.03	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
TOTAL DIRECT LABOR HOURS/COST		0		$0.00	0		$0.00	0		$0.00	0		$0.00

CLIN 0001 DEVELOPMENT, TASK 1.05 PROTOTYPE SUPPORT, INSTALLATION, AND CHECKOUT		PROPOSED COSTS/PRICES - LABOR			PROPOSED COSTS/PRICES - LABOR			PROPOSED COSTS/PRICES - LABOR			PROPOSED COSTS/PRICES - LABOR
		Basic Period (Year 1)			Basic Period (Year 2)			Basic Period (Year 3)			Basic Period (Year 4)
Labor Category	Task	Labor Hours	Labor Rates	Direct Labor Cost	Labor Hours	Labor Rates	Direct Labor Cost	Labor Hours	Labor Rates	Direct Labor Cost	Labor Hours	Labor Rates	Direct Labor Cost
Insert all labor categories that apply; add/delete rows as necessary and ensure cells in Columns E, I, and M are properly linked to the rates in the 'PRIME-CPIF RATES (ALL)' worksheet	Insert applicable task by labor category at sub-task level (ex. 1.01.01, 1.01.02, and so forth); ensure consistency with the 'PRIME LABOR by TASK' worksheet	Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet		Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet		Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet		Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet
Labor Category : [INSERT LABOR CATEGORY NAME HERE]	1.05.01	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]	1.05.02	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]	1.05.03	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
TOTAL DIRECT LABOR HOURS/COST		0		$0.00	0		$0.00	0		$0.00	0		$0.00

CLIN 0001 DEVELOPMENT, TASK 1.06 QUALIFICATION, DEVELOPMENTAL, AND OPERATIONAL TESTING		PROPOSED COSTS/PRICES - LABOR			PROPOSED COSTS/PRICES - LABOR			PROPOSED COSTS/PRICES - LABOR			PROPOSED COSTS/PRICES - LABOR
		Basic Period (Year 1)			Basic Period (Year 2)			Basic Period (Year 3)			Basic Period (Year 4)
Labor Category	Task	Labor Hours	Labor Rates	Direct Labor Cost	Labor Hours	Labor Rates	Direct Labor Cost	Labor Hours	Labor Rates	Direct Labor Cost	Labor Hours	Labor Rates	Direct Labor Cost
Insert all labor categories that apply; add/delete rows as necessary and ensure cells in Columns E, I, and M are properly linked to the rates in the 'PRIME-CPIF RATES (ALL)' worksheet	Insert applicable task by labor category at sub-task level (ex. 1.01.01, 1.01.02, and so forth); ensure consistency with the 'PRIME LABOR by TASK' worksheet	Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet		Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet		Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet		Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet
Labor Category : [INSERT LABOR CATEGORY NAME HERE]	1.06.01	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]	1.06.02	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]	1.06.03	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
TOTAL DIRECT LABOR HOURS/COST		0		$0.00	0		$0.00	0		$0.00	0		$0.00

CLIN 0001 DEVELOPMENT, TASK 1.07 MATERIAL - DEVELOPMENT SPARES		PROPOSED COSTS/PRICES - LABOR			PROPOSED COSTS/PRICES - LABOR			PROPOSED COSTS/PRICES - LABOR			PROPOSED COSTS/PRICES - LABOR
		Basic Period (Year 1)			Basic Period (Year 2)			Basic Period (Year 3)			Basic Period (Year 4)
Labor Category	Task	Labor Hours	Labor Rates	Direct Labor Cost	Labor Hours	Labor Rates	Direct Labor Cost	Labor Hours	Labor Rates	Direct Labor Cost	Labor Hours	Labor Rates	Direct Labor Cost
Insert all labor categories that apply; add/delete rows as necessary and ensure cells in Columns E, I, and M are properly linked to the rates in the 'PRIME-CPIF RATES (ALL)' worksheet	Insert applicable task by labor category at sub-task level (ex. 1.01.01, 1.01.02, and so forth); ensure consistency with the 'PRIME LABOR by TASK' worksheet	Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet		Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet		Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet		Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet
Labor Category : [INSERT LABOR CATEGORY NAME HERE]	1.07.01	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]	1.07.02	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]	1.07.03	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
TOTAL DIRECT LABOR HOURS/COST		0		$0.00	0		$0.00	0		$0.00	0		$0.00

CLIN 0001 DEVELOPMENT, TASK 1.08 BLACK LABEL HARDWARE AND SOFTWARE CERTIFICATION		PROPOSED COSTS/PRICES - LABOR			PROPOSED COSTS/PRICES - LABOR			PROPOSED COSTS/PRICES - LABOR			PROPOSED COSTS/PRICES - LABOR
		Basic Period (Year 1)			Basic Period (Year 2)			Basic Period (Year 3)			Basic Period (Year 4)
Labor Category	Task	Labor Hours	Labor Rates	Direct Labor Cost	Labor Hours	Labor Rates	Direct Labor Cost	Labor Hours	Labor Rates	Direct Labor Cost	Labor Hours	Labor Rates	Direct Labor Cost
Insert all labor categories that apply; add/delete rows as necessary and ensure cells in Columns E, I, and M are properly linked to the rates in the 'PRIME-CPIF RATES (ALL)' worksheet	Insert applicable task by labor category at sub-task level (ex. 1.01.01, 1.01.02, and so forth); ensure consistency with the 'PRIME LABOR by TASK' worksheet	Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet		Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet		Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet		Insert proposed labor hours by labor category and sub-task	Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet
Labor Category : [INSERT LABOR CATEGORY NAME HERE]	1.08.01	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]	1.08.02	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]	1.08.03	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]		0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00

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 May 19, 2026.