A07_Attachment_9_Cost_Template_Feb_2018_.xlsx

XLSX spreadsheet 97 KB Posted Apr 27, 2018

Attached to: Award Notice for The Next General Chemical Detector 1 (NGCD1), Aerosol & Vapor Chemical Agent Detector (AVCAD) 541712
Solicitation number: W911SR-17-R-0005
Issued by: Department of the Army Materiel Command Army Contracting Command Aberdeen Proving Ground

About this file

From the source

Attachment 9 Cost Template

View the file

Other files

File	Type	Posted
Government_Response_10_May.pdf	PDF	May 10, 2018
NGCD1_AVCAD_Amendment__27_April_2018.pdf	PDF	Apr 27, 2018
Attachment_4_-_40051-2C_TABLE_A-IV_TM_3-6665-441-23_and_P.XLSX	XLSX spreadsheet	Sep 21, 2017
Attachment_3_-_40051-2C_TABLE_A-II_TM_3-6665-441-10.xlsx	XLSX spreadsheet	Sep 21, 2017
Attachment_11_-_DDForm254_AVCAD_17_Aug_17_Signed.pdf	PDF	Sep 21, 2017
Attachment_9_7th_BETA_NGCD_1_Cost_Template,_.xlsx	XLSX spreadsheet	Sep 21, 2017
Attachment_12_-_Past_Performance_Questionnaire_01_Aug_2017_.docx	DOCX document	Sep 21, 2017
Attachment_10_-_Small_Business_Participation_Proposa_01_Aug_2017_l.docx	DOCX document	Sep 21, 2017
EXHIBIT_A_AVCAD_CDRLs_19_Sep_2017.pdf	PDF	Sep 21, 2017
Attachment_5_-_40051-2C_TABLE_A-III_TM_3-6665-441-40.xlsx	XLSX spreadsheet	Sep 21, 2017
Attachment_1_-_AVCAD_Performance_Specification_29AUG2017.pdf	PDF	Sep 21, 2017
W911SR-17-R-0005_RFP_NGCD1_AVCAD_21_Sep_2017.pdf	PDF	Sep 21, 2017
Attachment_2_-_AVCAD_Logistics_Product_Data_Selection_Worksheet.pdf	PDF	Sep 21, 2017
NGCD_1_Technical_Slides.pptx	PPTX presentation	Sep 21, 2017
NGCD_1_FPI(S)_Basics.pdf	PDF	Sep 21, 2017
Government_response_to_Questions_27_July_2017.pdf	PDF	Jul 27, 2017
A02_Attachment_4_Field_Maintenance_Manual.xlsx	XLSX spreadsheet	Jul 8, 2017
CDRLs_5_Jul_2017.pdf	PDF	Jul 8, 2017
A02_Attachment_9_Cost_Template.xlsx	XLSX spreadsheet	Jul 8, 2017
A02_SECTION_L_5_July.pdf	PDF	Jul 8, 2017
Attachment_1_Pspec_29JUN2017.pdf	PDF	Jul 8, 2017
A02_Attachment_3_Operator's_Maintenance_Manual_.xlsx	XLSX spreadsheet	Jul 8, 2017
B02_Section_M_7_July.pdf	PDF	Jul 8, 2017
A02_Attachment_2_-_Logistics_Product_Data_Selection_Worksheet.pdf	PDF	Jul 8, 2017
Draft_RFP.pdf	PDF	Jul 8, 2017
A02_Section_B_30_June_2017.xlsx	XLSX spreadsheet	Jul 8, 2017
A02_Attachment_10_Small_Business_Participation_Proposal_(Sample_Format).pdf	PDF	Jul 8, 2017
A02Attachment_5_Depot_Maintenance_Manual.xlsx	XLSX spreadsheet	Jul 8, 2017
Government_Response.pdf	PDF	Jun 26, 2017
Government_Response.pdf	PDF	Jun 21, 2017
13-Draft_AVCAD_section_L_2017420.pdf	PDF	May 12, 2017
NGCD1_AVCAD_Questions_and_Responses.xlsx	XLSX spreadsheet	May 4, 2017
13-Draft_AVCAD_section_L_2017420.pdf	PDF	Apr 28, 2017
17-Draft_AVCAD_Section_M_20170420.pdf	PDF	Apr 28, 2017
5-Attachment_1_-_Draft_AVCAD_Performance_Specification_20_Apr_2017.pdf	PDF	Apr 28, 2017
4-Draft_AVCAD_Section_C_-_PWS_20170420.pdf	PDF	Apr 28, 2017

Show all 36

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.

Changes from Previous Version

OFFERORS DO NOT NEED TO REDO COST PROPOSALS
Consider changing already started cost proposals to reflect these changes
Changed: Circular References in CPIF tabs for "Target CPIF" rows were corrected.
Changed: One year of escalation was added to Cons. & Spares
	Example:
		Cell AA8 Was:	=IF(S8="","",K8(1+$I$3)^1INDEX($E8:$H8,1,MATCH(S8,$E$3:$H$3,0)))
		Cell AA8 Is:	=IF(S8="","",K8(1+$I$3)^2INDEX($E8:$H8,1,MATCH(S8,$E$3:$H$3,0)))
	Cells Affected
		Columns Z through AG
Added: CLIN 0007AD on Summary and CPIF - EMD tabs

Summary

Period	CLIN	Description	Contract Type	(Initial) Target Cost	(Initial) Target Fee/Profit	Price	Notes
EMD Base Contract	0001	Aeresol Vapor Chemical De…	CPIF	<Sum>	ERROR:#VALUE!	$0
	0002	AVCAD with Alternate Aero…	CPIF	<Sum>	ERROR:#VALUE!	$0
	0003	System Support Package (S…	CPIF	<Sum>	ERROR:#VALUE!	$0
	0004	IPS	CPIF	<Sum>	ERROR:#VALUE!	$0
	0005	Accounting for Contract S…	FFP				←Usually NSP: If Proposed, Enter FFP Here
	0006	Contract Data Requirement…	NSP				←Not Separately Priced
Option 1 EMD AVCAD PQT Hardware	0007AA	AVCAD first delivery (24)	CPIF	<Sum>	ERROR:#VALUE!	$0	Total CPIF (not each)
	0007AB	AVCAD second delivery (36)	CPIF	<Sum>	ERROR:#VALUE!	$0	Total CPIF (not each)
	0007AC	AVCAD third delivery (15)	CPIF	<Sum>	ERROR:#VALUE!	$0	Total CPIF (not each)
	0007AD	IPS Option	CPIF	<Sum>	ERROR:#VALUE!	$0
	0008AA	SSP For 24 AVCAD	CPIF	<Sum>	ERROR:#VALUE!	$0	Total CPIF (not each)
	0008AB	SSP For 36 AVCAD	CPIF	<Sum>	ERROR:#VALUE!	$0	Total CPIF (not each)
	0008AC	SSP For 15 AVCAD	CPIF	<Sum>	ERROR:#VALUE!	$0	Total CPIF (not each)
Option 2 EMD Platform Integration	0009AA	Shipboard Platform (2)	CPIF	<Sum>	ERROR:#VALUE!	$0	Total CPIF (not each)
	0009AB	NBCRV (2)	CPIF	<Sum>	ERROR:#VALUE!	$0	Total CPIF (not each)
	0009AC	Unmanned Ground Vehicle (2)	CPIF	<Sum>	ERROR:#VALUE!	$0	Total CPIF (not each)
	0009AD	Joint Assault Bridge (2)	CPIF	<Sum>	ERROR:#VALUE!	$0	Total CPIF (not each)
	0009AE	ABRAMS Tank (2)	CPIF	<Sum>	ERROR:#VALUE!	$0	Total CPIF (not each)
	0009AF	AMPV (2)	CPIF	<Sum>	ERROR:#VALUE!	$0	Total CPIF (not each)
	0009AG	Fixed-wing aircraft (2)	CPIF	<Sum>	ERROR:#VALUE!	$0	Total CPIF (not each)
	0009AH	Rotary-wing aircraft (2)	CPIF	<Sum>	ERROR:#VALUE!	$0	Total CPIF (not each)
Option 3 TM	0010	Depot Maintenance Manual	CPIF	<Sum>	ERROR:#VALUE!	$0
Option 4 LRIP	0011AA	AVCAD first delivery (68)	FPI(S)			$0	Enter initial target cost and profit here for total FPI(S) (not each)
	0011AB	AVCAD second delivery (60)	FPI(S)			$0	Enter initial target cost and profit here for total FPI(S) (not each)
	0012AA	SSP for PVT testing	FPI(S)			$0	Enter initial target cost and profit here.
	0012AB	SSP for MOT testing	FPI(S)			$0	Enter initial target cost and profit here.
	0013AA	TM update	FPI(S)			$0	Enter initial target cost and profit here.
	0013AB	Logistics/Maintenance Dem…	FPI(S)			$0	Enter initial target cost and profit here.
	0013AC	Training Course update De…	FPI(S)			$0	Enter initial target cost and profit here.
	0014	Consumable and Spare Parts	FPI(S)	$0	$0	$0
	0015	Technical Support	CPIF	<Sum>	ERROR:#VALUE!	$0
	0016AA	Shipboard Platform (2)	FPI(S)			$0	Enter initial target cost and profit here for total FPI(S) (not each)
	0016AB	NBCRV (2)	FPI(S)			$0	Enter initial target cost and profit here for total FPI(S) (not each)
	0016AC	Unmanned Ground Vehicle (2)	FPI(S)			$0	Enter initial target cost and profit here for total FPI(S) (not each)
	0016AD	Joint Assault Bridge (2)	FPI(S)			$0	Enter initial target cost and profit here for total FPI(S) (not each)
	0016AE	ABRAMS Tank (2)	FPI(S)			$0	Enter initial target cost and profit here for total FPI(S) (not each)
	0016AF	AMPV (2)	FPI(S)			$0	Enter initial target cost and profit here for total FPI(S) (not each)
	0016AG	Fixed-wing aircraft (2)	FPI(S)			$0	Enter initial target cost and profit here for total FPI(S) (not each)
	0016AH	Rotary-wing aircraft (2)	FPI(S)			$0	Enter initial target cost and profit here for total FPI(S) (not each)
	0017	AVCAD Warranty	FFP			$0
Option 5 Full Rate Production, 1st Year	0018AA	AVCAD Hardware	FPI(S)	ERROR:#NUM!	ERROR:#NUM!	$0
	0018AB	AVCAD Warranty	FFP			$0
	0018AC	Consumables and Spare Parts	FPI(S)	$0	$0	$0
	0018AD	Shipboard	FPI(S)	$0	$0	$0
	0018AE	NBCRV	FPI(S)	$0	$0	$0
	0018AF	Unmanned Ground Vehicle	FPI(S)	$0	$0	$0
	0018AG	Joint Assault Bridge	FPI(S)	$0	$0	$0
	0018AH	ABRAMS Tank	FPI(S)	$0	$0	$0
	0018AJ	AMPV	FPI(S)	$0	$0	$0
	0018AK	Fixed-wing aircraft	FPI(S)	$0	$0	$0
	0018AL	Rotary-wing aircraft	FPI(S)	$0	$0	$0
	0019	Technical Support	CPIF	<Sum>	ERROR:#VALUE!	$0
Option 6 Full Rate Production, 2nd Year	0020AA	AVCAD Hardware	FPI(S)	ERROR:#NUM!	ERROR:#NUM!	$0
	0020AB	AVCAD Warranty	FFP			$0
	0020AC	Consumables and Spare Parts	FPI(S)	$0	$0	$0
	0020AD	Shipboard	FPI(S)	$0	$0	$0
	0020AE	NBCRV	FPI(S)	$0	$0	$0
	0020AF	Unmanned Ground Vehicle	FPI(S)	$0	$0	$0
	0020AG	Joint Assault Bridge	FPI(S)	$0	$0	$0
	0020AH	ABRAMS Tank	FPI(S)	$0	$0	$0
	0020AJ	AMPV	FPI(S)	$0	$0	$0
	0020AK	Fixed-wing aircraft	FPI(S)	$0	$0	$0
	0020AL	Rotary-wing aircraft	FPI(S)	$0	$0	$0
	0021	Technical Support	CPIF	<Sum>	ERROR:#VALUE!	$0
Option 7 Full Rate Production, 3rd Year	0022AA	AVCAD Hardware	FPI(S)	ERROR:#NUM!	ERROR:#NUM!	$0
	0022AB	AVCAD Warranty	FFP			$0
	0022AC	Consumables and Spare Parts	FPI(S)	$0	$0	$0
	0022AD	Shipboard	FPI(S)	$0	$0	$0
	0022AE	NBCRV	FPI(S)	$0	$0	$0
	0022AF	Unmanned Ground Vehicle	FPI(S)	$0	$0	$0
	0022AG	Joint Assault Bridge	FPI(S)	$0	$0	$0
	0022AH	ABRAMS Tank	FPI(S)	$0	$0	$0
	0022AJ	AMPV	FPI(S)	$0	$0	$0
	0022AK	Fixed-wing aircraft	FPI(S)	$0	$0	$0
	0022AL	Rotary-wing aircraft	FPI(S)	$0	$0	$0
	0023	Technical Support	CPIF	<Sum>	ERROR:#VALUE!	$0
Option 8 Full Rate Production, 4th Year	0024AA	AVCAD Hardware	FPI(S)	ERROR:#NUM!	ERROR:#NUM!	$0
	0024AB	AVCAD Warranty	FFP			$0
	0024AC	Consumables and Spare Parts	FPI(S)	$0	$0	$0
	0024AD	Shipboard	FPI(S)	$0	$0	$0
	0024AE	NBCRV	FPI(S)	$0	$0	$0
	0024AF	Unmanned Ground Vehicle	FPI(S)	$0	$0	$0
	0024AG	Joint Assault Bridge	FPI(S)	$0	$0	$0
	0024AH	ABRAMS Tank	FPI(S)	$0	$0	$0
	0024AJ	AMPV	FPI(S)	$0	$0	$0
	0024AK	Fixed-wing aircraft	FPI(S)	$0	$0	$0
	0024AL	Rotary-wing aircraft	FPI(S)	$0	$0	$0
	0025	Technical Support	CPIF	<Sum>	ERROR:#VALUE!	$0
Option 9 Full Rate Production, 5th Year	0026AA	AVCAD Hardware	FPI(S)	ERROR:#NUM!	ERROR:#NUM!	$0
	0026AB	AVCAD Warranty	FFP			$0
	0026AC	Consumables and Spare Parts	FPI(S)	$0	$0	$0
	0026AD	Shipboard	FPI(S)	$0	$0	$0
	0026AE	NBCRV	FPI(S)	$0	$0	$0
	0026AF	Unmanned Ground Vehicle	FPI(S)	$0	$0	$0
	0026AG	Joint Assault Bridge	FPI(S)	$0	$0	$0
	0026AH	ABRAMS Tank	FPI(S)	$0	$0	$0
	0026AJ	AMPV	FPI(S)	$0	$0	$0
	0026AK	Fixed-wing aircraft	FPI(S)	$0	$0	$0
	0026AL	Rotary-wing aircraft	FPI(S)	$0	$0	$0
	0027	Technical Support	CPIF	<Sum>	ERROR:#VALUE!	$0
Option 10 Full Rate Production, 6th Year	0028AA	AVCAD Hardware	FPI(S)	ERROR:#NUM!	ERROR:#NUM!	$0
	0028AB	AVCAD Warranty	FFP			$0
	0028AC	Consumables and Spare Parts	FPI(S)	$0	$0	$0
	0028AD	Shipboard	FPI(S)	$0	$0	$0
	0028AE	NBCRV	FPI(S)	$0	$0	$0
	0028AF	Unmanned Ground Vehicle	FPI(S)	$0	$0	$0
	0028AG	Joint Assault Bridge	FPI(S)	$0	$0	$0
	0028AH	ABRAMS Tank	FPI(S)	$0	$0	$0
	0028AJ	AMPV	FPI(S)	$0	$0	$0
	0028AK	Fixed-wing aircraft	FPI(S)	$0	$0	$0
	0028AL	Rotary-wing aircraft	FPI(S)	$0	$0	$0
	0029	Technical Support	CPIF	<Sum>	ERROR:#VALUE!	$0
Option 11	0030	Spare and consumable TDP	FFP				Enter FFP here.
Proposed Price						$0

CPIF - EMD

	CLIN 0001			CLIN 0002			CLIN 0003			CLIN 0004			CLIN 0007AA			CLIN 0007AB			CLIN 0007AC			CLIN 0007AD			CLIN 0008AA			CLIN 0008AB			CLIN 0008AC			CLIN 0009AA			CLIN 0009AB			CLIN 0009AC			CLIN 0009AD			CLIN 0009AE			CLIN 0009AF
	AVCAD			AVCAD with Alt. Aerosol Design			SSP for CLIN 0001 & 0002			IPS			AVCAD 1st Delivery (24 Total)			AVCAD 2nd Delivery (36 Total)			AVCAD 3rd Delivery (15 Total)			IPS Option			System Support Package, 24 AVCADs			System Support Package, 36 AVCADs			System Support Package, 15 AVCADs			Shipboard Platform (2 total)			NBCRV (2 total)			Unmanned Ground Vehicle (2 total)			Joint Assault Bridge (2 total)			ABRAMS Tank (2 total)			AMPV (2 total)
Labor	Hours/Units	Rate	Dollars	Hours/Units	Rate	Dollars	Hours/Units	Rate	Dollars	Hours/Units	Rate	Dollars	Hours/Units	Rate	Dollars	Hours/Units	Rate	Dollars	Hours/Units	Rate	Dollars	Hours/Units	Rate	Dollars	Hours/Units	Rate	Dollars	Hours/Units	Rate	Dollars	Hours/Units	Rate	Dollars	Hours/Units	Rate	Dollars	Hours/Units	Rate	Dollars	Hours/Units	Rate	Dollars	Hours/Units	Rate	Dollars	Hours/Units	Rate	Dollars	Hours/Units
Labor Category 1	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0
Labor Category 2	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0
Labor Category 3	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0
Labor Category 4	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0
Labor Category 5	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0
Labor Category 6	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0
Labor Category 7	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0
Labor Category 8	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0
Labor Category 9	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0
Labor Category 10	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0
Labor Category…	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0
Subtotal, Direct Labor	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0
Fringe (Allocation Base)		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate
Overhead (Allocation Base)		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate
Labor	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0

Subcontracts
Subcontractor 1 (Contract Type)	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>
Subcontractor 2 (Contract Type)	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>
Subcontractor…	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>
Subtotal, Subcontracts	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0
Sub Handling		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0
Subcontracts	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0

Materials (may reference BOM)
Material 1	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0
Material 2	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0
Material 3	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0
Material…	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0
Subtotal, Materials			$0			$0			$0			$0			$0			$0			$0			$0			$0			$0			$0			$0			$0			$0			$0			$0
Material Handling		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0
Materials			$0			$0			$0			$0			$0			$0			$0			$0			$0			$0			$0			$0			$0			$0			$0			$0

Travel (See "EMD Travel" Tab) <ref> <ref> <ref> <ref> <ref> <ref> <ref> <ref> <ref> <ref> <ref> <ref> <ref> <ref> <ref> <ref> <ref> <ref> <ref> <ref>

ODCs
ODC 1	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0
ODC 2	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0
ODC 3	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0
ODC…	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0
Subtotal, ODCs			$0			$0			$0			$0			$0			$0			$0			$0			$0			$0			$0			$0			$0			$0			$0			$0

G&A

Allocation Base

<sum>

G&A

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

Target Cost

<Sum>

Incentive Fee

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

Target CPIF

ERROR:#VALUE!

Min Fee

ERROR:#VALUE!

Max Fee

ERROR:#VALUE!

EMD Travel

CPIF Travel	Number of		Duration	R/T	Per Diem		Daily Car Rental	Other per Trip	Total					Total Cost
	People	Trips	Days	Airfare	Lodging	M&IE			Airfare	Lodging	M&IE	Rental	Other
CLIN #: From <Origin> to <Destination> 1									$0	$0	$0	$0	$0	$0
CLIN #: From <Origin> to <Destination> 2									$0	$0	$0	$0	$0	$0
CLIN #: From <Origin> to <Destination> 3									$0	$0	$0	$0	$0	$0
CLIN #: From <Origin> to <Destination> 4									$0	$0	$0	$0	$0	$0
CLIN #: From <Origin> to <Destination> 5									$0	$0	$0	$0	$0	$0
CLIN #: From <Origin> to <Destination> 6									$0	$0	$0	$0	$0	$0
CLIN #: From <Origin> to <Destination> 7									$0	$0	$0	$0	$0	$0
CLIN #: From <Origin> to <Destination> 8									$0	$0	$0	$0	$0	$0
CLIN #: From <Origin> to <Destination> 9									$0	$0	$0	$0	$0	$0
CLIN#: From <Origin> to <Destination>…									$0	$0	$0	$0	$0	$0
Total									$0	$0	$0	$0	$0	$0

AVCAD FRP

		Element		Value		Description		CLIN:	0018AA, FRP 1		0020AA, FRP 2		0022AA, FRP 3		0024AA, FRP 4		0026AA, FRP 5		0028AA, FRP 6
EITHER 1) Input the cost of 3,200 Units and the "Cost Improvement Slope", OR 2) Manually input target costs for each ordering point (e.g. 1, 50, 200, etc.).		Total Cost of 3,200 Units				Estimated total cost to produce 3,200 units.		Order Point	Weight	Value	Weight	Value	Weight	Value	Weight	Value	Weight	Value	Weight	Value
							Average Costs	1	0.00%	ERROR:#NUM!	0.00%	ERROR:#NUM!	0.00%	ERROR:#NUM!	0.00%	ERROR:#NUM!	0.00%	ERROR:#NUM!	0.00%	ERROR:#NUM!
		Cost Improvement Slope				Used to calculate range pricing, which approximately reduces marginal initial target costs by [1-slope] percent per doubling of units.		50	0.00%	ERROR:#NUM!	0.00%	ERROR:#NUM!	0.00%	ERROR:#NUM!	0.00%	ERROR:#NUM!	0.00%	ERROR:#NUM!	0.00%	ERROR:#NUM!
								200	0.04%	ERROR:#NUM!	0.00%	ERROR:#NUM!	0.00%	ERROR:#NUM!	0.00%	ERROR:#NUM!	0.00%	ERROR:#NUM!	0.00%	ERROR:#NUM!
								800	19.23%	ERROR:#NUM!	0.00%	ERROR:#NUM!	0.00%	ERROR:#NUM!	0.00%	ERROR:#NUM!	0.00%	ERROR:#NUM!	0.00%	ERROR:#NUM!
								1,600	49.96%	ERROR:#NUM!	0.16%	ERROR:#NUM!	0.16%	ERROR:#NUM!	0.16%	ERROR:#NUM!	0.16%	ERROR:#NUM!	0.16%	ERROR:#NUM!
		"A" Variable		ERROR:#NUM!		Theoretic cost of unit 1.		3,200	30.77%	ERROR:#NUM!	14.55%	ERROR:#NUM!	14.55%	ERROR:#NUM!	14.55%	ERROR:#NUM!	14.55%	ERROR:#NUM!	14.55%	ERROR:#NUM!
		"b" Variable		ERROR:#NUM!		ln(slope) / ln(2)		6,400	0.00%	ERROR:#NUM!	49.84%	ERROR:#NUM!	49.84%	ERROR:#NUM!	49.84%	ERROR:#NUM!	49.84%	ERROR:#NUM!	49.84%	ERROR:#NUM!
		Escalation				Applied annually.		8,600	0.00%	ERROR:#NUM!	35.45%	ERROR:#NUM!	35.45%	ERROR:#NUM!	35.45%	ERROR:#NUM!	35.45%	ERROR:#NUM!	35.45%	ERROR:#NUM!
								Evaluation Wtd. Avg. Cost		ERROR:#NUM!		ERROR:#NUM!		ERROR:#NUM!		ERROR:#NUM!		ERROR:#NUM!		ERROR:#NUM!
								x Evaluation Quantity		1,600		6,711		6,711		6,711		6,711		6,710
		Units	Target Cost		Section B: Total Initial Target Cost Calculation			Evaluation Initial Target Cost		ERROR:#NUM!		ERROR:#NUM!		ERROR:#NUM!		ERROR:#NUM!		ERROR:#NUM!		ERROR:#NUM!
	FRP Year 1	1	ERROR:#NUM!		Range	Total Initial Target Cost		Target Profit		ERROR:#NUM!		ERROR:#NUM!		ERROR:#NUM!		ERROR:#NUM!		ERROR:#NUM!		ERROR:#NUM!
		50	ERROR:#NUM!		1 - 49	ERROR:#NUM!		FPI(S) Evaluation Price		ERROR:#NUM!		ERROR:#NUM!		ERROR:#NUM!		ERROR:#NUM!		ERROR:#NUM!		ERROR:#NUM!
		200	ERROR:#NUM!		50 - 199	ERROR:#NUM!
		800	ERROR:#NUM!		200 - 799	ERROR:#NUM!
		1,600	ERROR:#NUM!		800 - 1,599	ERROR:#NUM!		Pink Highlights: Values were changed from the initial request for proposal.
		3,200	ERROR:#NUM!		1,600 - 3,199	ERROR:#NUM!
		6,400	ERROR:#NUM!		3,200 - 6,399	ERROR:#NUM!
		8,600	ERROR:#NUM!		6,400 - 8,600	ERROR:#NUM!
	FRP Year 2	1	ERROR:#NUM!
		50	ERROR:#NUM!		1 - 49	ERROR:#NUM!
		200	ERROR:#NUM!		50 - 199	ERROR:#NUM!
		800	ERROR:#NUM!		200 - 799	ERROR:#NUM!
		1,600	ERROR:#NUM!		800 - 1,599	ERROR:#NUM!
		3,200	ERROR:#NUM!		1,600 - 3,199	ERROR:#NUM!
		6,400	ERROR:#NUM!		3,200 - 6,399	ERROR:#NUM!
		8,600	ERROR:#NUM!		6,400 - 8,600	ERROR:#NUM!
	FRP Year 3	1	ERROR:#NUM!
		50	ERROR:#NUM!		1 - 49	ERROR:#NUM!
		200	ERROR:#NUM!		50 - 199	ERROR:#NUM!
		800	ERROR:#NUM!		200 - 799	ERROR:#NUM!
		1,600	ERROR:#NUM!		800 - 1,599	ERROR:#NUM!
		3,200	ERROR:#NUM!		1,600 - 3,199	ERROR:#NUM!
		6,400	ERROR:#NUM!		3,200 - 6,399	ERROR:#NUM!
		8,600	ERROR:#NUM!		6,400 - 8,600	ERROR:#NUM!
	FRP Year 4	1	ERROR:#NUM!
		50	ERROR:#NUM!		1 - 49	ERROR:#NUM!
		200	ERROR:#NUM!		50 - 199	ERROR:#NUM!
		800	ERROR:#NUM!		200 - 799	ERROR:#NUM!
		1,600	ERROR:#NUM!		800 - 1,599	ERROR:#NUM!
		3,200	ERROR:#NUM!		1,600 - 3,199	ERROR:#NUM!
		6,400	ERROR:#NUM!		3,200 - 6,399	ERROR:#NUM!
		8,600	ERROR:#NUM!		6,400 - 8,600	ERROR:#NUM!
	FRP Year 5	1	ERROR:#NUM!
		50	ERROR:#NUM!		1 - 49	ERROR:#NUM!
		200	ERROR:#NUM!		50 - 199	ERROR:#NUM!
		800	ERROR:#NUM!		200 - 799	ERROR:#NUM!
		1,600	ERROR:#NUM!		800 - 1,599	ERROR:#NUM!
		3,200	ERROR:#NUM!		1,600 - 3,199	ERROR:#NUM!
		6,400	ERROR:#NUM!		3,200 - 6,399	ERROR:#NUM!
		8,600	ERROR:#NUM!		6,400 - 8,600	ERROR:#NUM!
	FRP Year 6	1	ERROR:#NUM!
		50	ERROR:#NUM!		1 - 49	ERROR:#NUM!
		200	ERROR:#NUM!		50 - 199	ERROR:#NUM!
		800	ERROR:#NUM!		200 - 799	ERROR:#NUM!
		1,600	ERROR:#NUM!		800 - 1,599	ERROR:#NUM!
		3,200	ERROR:#NUM!		1,600 - 3,199	ERROR:#NUM!
		6,400	ERROR:#NUM!		3,200 - 6,399	ERROR:#NUM!
		8,600	ERROR:#NUM!		6,400 - 8,600	ERROR:#NUM!

Visual Representation of Initial Target Costs for Year 1

1 50 200 800 1600 3200 6400 8600 0 0 0 0 0 0 0 0 Units Ordered

Total Initial Target Cost (Millions)

Cons. & Spares MTBF (hours actively in use) Gilson, Benjamin C Mr CIV USA: Government:

Mean Time Before Failure (MTBF): Input the estimated average number of hours that the AVCAD would be used before the consumable or spare part would need to be replaced.

Annual Escalation

QUANTITY CALCULATION

Quantity Range Logic

Total Initial Target Cost Calculation

Initial Target Cost per Unit: FY 2018

AVCAD Usage (Thousands of Hours)

Usage/AVCAD/Year (hours):

500

Min:

101

501

1,000

FY 2019

FY 2020

FY 2021

FY 2022

FY 2023

FY 2024

FY 2025

FY 2026

CLIN:

0014

0018AC

0020AC

0022AC

0024AC

0026AC

0028AC

Part Name

Part Description

Max:

100

500

1,000

102

1,712

7,529

13,347

19,114

24,982

FY 2019

FY 2020

FY 2021

FY 2022

FY 2023

FY 2024

FY 2025

FY 2026

LRIP

FRP 1

FRP 2

FRP 3

FRP 4

FRP 5

FRP 6

e.g. USB Cord USB 3.0 3ft. 4,250 $5.49 $5.19 $4.99 $4.91 0 9 24 403 1,772 3,140 4,497 5,878 1 1 101 1000 1000 1000 1000 $49 $132 $2,092 $8,701 $15,417 $22,080 $28,861

Initial Target Cost		$0	$0	$0	$0	$0	$0	$0
Initial Target Profit	0.00%	$0	$0	$0	$0	$0	$0	$0
Target Price		$0	$0	$0	$0	$0	$0	$0

AVCAD Warranty Enter a percentage that will be used to calculate warranty Firm Fixed Prices, based on the rate below multiplied by Initial Target Costs of AVCAD Full Rate Production.

Warranty FFP %
CLIN:	0017	0018AB	0020AB	0022AB	0024AB	0026AB	0028AB
	LRIP	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6
Initial Target Cost	$0	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!	ERROR:#NUM!
Warranty FFP Percentage	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
Warranty Eval. Price	$0	$0	$0	$0	$0	$0	$0

Integration Kits FRP

	Escalation Rate:
	FPI(S) Profit %
	Initial Target Cost, Full Rate Production (each)				Evaluation Weight			Wtd. Avg. Cost	Evaluation Quantity	Eval. Initial Target Cost	Eval. Initial Target Profit	Eval Price
	Platform Integration Kit	1-100	101-500	501-1000	1-100	101-500	501-1000
FRP Year 1	Shipboard				95.0%	2.5%	2.5%	$0	30	$0	$0	$0
	NBCRV				2.5%	17.9%	79.6%	$0	675	$0	$0	$0
	Unmanned Ground Vehicle				2.5%	80.4%	17.1%	$0	300	$0	$0	$0
	Joint Assault Bridge				95.0%	2.5%	2.5%	$0	30	$0	$0	$0
	ABRAMS Tank				3.0%	94.5%	2.5%	$0	225	$0	$0	$0
	AMPV				95.0%	2.5%	2.5%	$0	30	$0	$0	$0
	Fixed-wing aircraft				95.0%	2.5%	2.5%	$0	30	$0	$0	$0
	Rotary-wing aircraft				95.0%	2.5%	2.5%	$0	30	$0	$0	$0
FRP Year 2	Shipboard	$0	$0	$0	95.0%	2.5%	2.5%	$0	30	$0	$0	$0
	NBCRV	$0	$0	$0	2.5%	17.9%	79.6%	$0	675	$0	$0	$0
	Unmanned Ground Vehicle	$0	$0	$0	2.5%	80.4%	17.1%	$0	300	$0	$0	$0
	Joint Assault Bridge	$0	$0	$0	95.0%	2.5%	2.5%	$0	30	$0	$0	$0
	ABRAMS Tank	$0	$0	$0	3.0%	94.5%	2.5%	$0	225	$0	$0	$0
	AMPV	$0	$0	$0	95.0%	2.5%	2.5%	$0	30	$0	$0	$0
	Fixed-wing aircraft	$0	$0	$0	95.0%	2.5%	2.5%	$0	30	$0	$0	$0
	Rotary-wing aircraft	$0	$0	$0	95.0%	2.5%	2.5%	$0	30	$0	$0	$0
FRP Year 3	Shipboard	$0	$0	$0	95.0%	2.5%	2.5%	$0	30	$0	$0	$0
	NBCRV	$0	$0	$0	2.5%	17.9%	79.6%	$0	675	$0	$0	$0
	Unmanned Ground Vehicle	$0	$0	$0	2.5%	80.4%	17.1%	$0	300	$0	$0	$0
	Joint Assault Bridge	$0	$0	$0	95.0%	2.5%	2.5%	$0	30	$0	$0	$0
	ABRAMS Tank	$0	$0	$0	3.0%	94.5%	2.5%	$0	225	$0	$0	$0
	AMPV	$0	$0	$0	95.0%	2.5%	2.5%	$0	30	$0	$0	$0
	Fixed-wing aircraft	$0	$0	$0	95.0%	2.5%	2.5%	$0	30	$0	$0	$0
	Rotary-wing aircraft	$0	$0	$0	95.0%	2.5%	2.5%	$0	30	$0	$0	$0
FRP Year 4	Shipboard	$0	$0	$0	95.0%	2.5%	2.5%	$0	30	$0	$0	$0
	NBCRV	$0	$0	$0	2.5%	17.9%	79.6%	$0	675	$0	$0	$0
	Unmanned Ground Vehicle	$0	$0	$0	2.5%	80.4%	17.1%	$0	300	$0	$0	$0
	Joint Assault Bridge	$0	$0	$0	95.0%	2.5%	2.5%	$0	30	$0	$0	$0
	ABRAMS Tank	$0	$0	$0	3.0%	94.5%	2.5%	$0	225	$0	$0	$0
	AMPV	$0	$0	$0	95.0%	2.5%	2.5%	$0	30	$0	$0	$0
	Fixed-wing aircraft	$0	$0	$0	95.0%	2.5%	2.5%	$0	30	$0	$0	$0
	Rotary-wing aircraft	$0	$0	$0	95.0%	2.5%	2.5%	$0	30	$0	$0	$0
FRP Year 5	Shipboard	$0	$0	$0	95.0%	2.5%	2.5%	$0	30	$0	$0	$0
	NBCRV	$0	$0	$0	2.5%	17.9%	79.6%	$0	675	$0	$0	$0
	Unmanned Ground Vehicle	$0	$0	$0	2.5%	80.4%	17.1%	$0	300	$0	$0	$0
	Joint Assault Bridge	$0	$0	$0	95.0%	2.5%	2.5%	$0	30	$0	$0	$0
	ABRAMS Tank	$0	$0	$0	3.0%	94.5%	2.5%	$0	225	$0	$0	$0
	AMPV	$0	$0	$0	95.0%	2.5%	2.5%	$0	30	$0	$0	$0
	Fixed-wing aircraft	$0	$0	$0	95.0%	2.5%	2.5%	$0	30	$0	$0	$0
	Rotary-wing aircraft	$0	$0	$0	95.0%	2.5%	2.5%	$0	30	$0	$0	$0
FRP Year 6	Shipboard	$0	$0	$0	95.0%	2.5%	2.5%	$0	30	$0	$0	$0
	NBCRV	$0	$0	$0	2.5%	17.9%	79.6%	$0	675	$0	$0	$0
	Unmanned Ground Vehicle	$0	$0	$0	2.5%	80.4%	17.1%	$0	300	$0	$0	$0
	Joint Assault Bridge	$0	$0	$0	95.0%	2.5%	2.5%	$0	30	$0	$0	$0
	ABRAMS Tank	$0	$0	$0	3.0%	94.5%	2.5%	$0	225	$0	$0	$0
	AMPV	$0	$0	$0	95.0%	2.5%	2.5%	$0	30	$0	$0	$0
	Fixed-wing aircraft	$0	$0	$0	95.0%	2.5%	2.5%	$0	30	$0	$0	$0
	Rotary-wing aircraft	$0	$0	$0	95.0%	2.5%	2.5%	$0	30	$0	$0	$0

CPIF - Tech Support

	LRIP (CLIN 0015)			Full Rate Production Year 1 (CLIN 0019)			Full Rate Production Year 2 (CLIN 0021)			Full Rate Production Year 3 (CLIN 0023)			Full Rate Production Year 4 (CLIN 0025)			Full Rate Production Year 5 (CLIN 0027)			Full Rate Production Year 6 (CLIN 0029)
Labor	Hours/Units	Rate	Dollars	Hours/Units	Rate	Dollars	Hours/Units	Rate	Dollars	Hours/Units	Rate	Dollars	Hours/Units	Rate	Dollars	Hours/Units	Rate	Dollars	Hours/Units	Rate	Dollars
Labor Category 1	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0
Labor Category 2	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0
Labor Category 3	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0
Labor Category 4	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0
Labor Category 5	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0
Labor Category 6	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0
Labor Category 7	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0
Labor Category 8	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0
Labor Category 9	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0
Labor Category 10	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0
Labor Category…	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0
Subtotal, Direct Labor	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0
Fringe (Allocation Base)		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate
Overhead (Allocation Base)		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate		0.00%	base*rate
Labor	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0

Subcontracts
Subcontractor 1 (Contract Type)	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>
Subcontractor 2 (Contract Type)	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>
Subcontractor…	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>	<Ref>		<Ref>
Subtotal, Subcontracts	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0
Sub Handling		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0
Subcontracts	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0	0		$0

Materials (may reference BOM)
Material 1	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0
Material 2	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0
Material 3	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0
Material…	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0
Subtotal, Materials			$0			$0			$0			$0			$0			$0			$0
Material Handling		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0		0.00%	$0
Materials			$0			$0			$0			$0			$0			$0			$0

Travel (See "Tech Support Travel" Tab) <ref> <ref> <ref> <ref> <ref> <ref> <ref>

ODCs
ODC 1	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0
ODC 2	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0
ODC 3	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0
ODC…	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0
Subtotal, ODCs			$0			$0			$0			$0			$0			$0			$0

G&A

Allocation Base

<sum>

G&A

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

Target Cost

<Sum>

Incentive Fee

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

<rate>

ERROR:#VALUE!

Target CPIF

ERROR:#VALUE!

Min Fee

ERROR:#VALUE!

Max Fee

ERROR:#VALUE!

Tech Support Travel

CPIF Travel	Number of		Duration	R/T	Per Diem		Daily Car Rental	Other per Trip	Total					Total Cost
	People	Trips	Days	Airfare	Lodging	M&IE			Airfare	Lodging	M&IE	Rental	Other
CLIN#: From <Origin> to <Destination> 1									$0	$0	$0	$0	$0	$0
CLIN#: From <Origin> to <Destination> 2									$0	$0	$0	$0	$0	$0
CLIN#: From <Origin> to <Destination> 3									$0	$0	$0	$0	$0	$0
CLIN#: From <Origin> to <Destination> 4									$0	$0	$0	$0	$0	$0
CLIN#: From <Origin> to <Destination> 5									$0	$0	$0	$0	$0	$0
CLIN#: From <Origin> to <Destination> 6									$0	$0	$0	$0	$0	$0
CLIN#: From <Origin> to <Destination> 7									$0	$0	$0	$0	$0	$0
CLIN#: From <Origin> to <Destination> 8									$0	$0	$0	$0	$0	$0
CLIN#: From <Origin> to <Destination> 9									$0	$0	$0	$0	$0	$0
CLIN#: From <Origin> to <Destination>…									$0	$0	$0	$0	$0	$0
Total									$0	$0	$0	$0	$0	$0

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.