Attachment_L-4_ALICE_COST_TEMPLATES.xls

XLS spreadsheet 644 KB Posted Jul 28, 2016

Attached to: Aircraft Maintenance Logistics Integration Configuration Management and Engineering (ALICE) Procurement
Solicitation number: NNJ16556087R
Issued by: National Aeronautics and Space Administration Johnson Space Center

About this file

From the source

Attachment L-4 ALICE COST TEMPLATES

View the file

Other files

File	Type	Posted
ALICE_Q A_Part_6_.pdf	PDF	Aug 18, 2016
Updated_Section_H_(8-3-2016).pdf	PDF	Aug 3, 2016
Updated-Attachment_J-2_Award_Fee_-_Fixed_Fee_Draft_Plan_(8-3-2016).pdf	PDF	Aug 3, 2016
ALICE_Q A_Part_5_.pdf	PDF	Aug 2, 2016
ALICE_Cost_Charts.pdf	PDF	Jul 28, 2016
ALICE_-_Lync_Announcement.pdf	PDF	Jul 28, 2016
Alice_Interested_Parties-7-28.pdf	PDF	Jul 28, 2016
Example_Attachment_L-2-1_Prime_and_Subcontractor_Past_Performance_Matrix_2016-07-26.xlsx	XLSX spreadsheet	Jul 27, 2016
Example_Attachment_L-2-3_Past_Performance_Narrative_2016-06-06.pdf	PDF	Jul 27, 2016
Example_Attachment_L-2-2_Joint_Venture_Past_Performance_Matrix_2016-07-26.xlsx	XLSX spreadsheet	Jul 27, 2016
ALICE_Preproposal_Conference_Charts.pdf	PDF	Jul 27, 2016
Alice_Interested_Parties-7-18.pdf	PDF	Jul 19, 2016
ALICE_Questions_and_Answers_-4.pdf	PDF	Jul 19, 2016
ALICE_Attachment_1.pdf	PDF	Jul 5, 2016
Attachment_L-3_Past_Performance_Questionaire.docx	DOCX document	Jul 5, 2016
Attachment_L-1 _Resource_Planning_Document.pptx	PPTX presentation	Jul 5, 2016
J-3-3_Life_Support_Asset_listing.pdf	PDF	Jul 5, 2016
Attachment_L-2-1_Prime_and_Subcontractor_Past_Performance_Matrix.xlsx	XLSX spreadsheet	Jul 5, 2016
ALICE_Cover_Letter_(7-5-2016).pdf	PDF	Jul 5, 2016
Attachment_L-2-3_Past_Performance_Narrative.docx	DOCX document	Jul 5, 2016
J-3-2_Calibration_Items_Asset_Listing.pdf	PDF	Jul 5, 2016
J-3-4_Item_Master_Report_for_Property_On_Hand.pdf	PDF	Jul 5, 2016
Attachment_L-4_ALICE_COST_TEMPLATES.xls	XLS spreadsheet	Jul 5, 2016
J-3-5_Equipment_Listing.xlsx	XLSX spreadsheet	Jul 5, 2016
J-3-6_LaRC_Property_List.xlsx	XLSX spreadsheet	Jul 5, 2016
Attachment_L-2-2_Joint_Venture_Past_Performance_Matrix.xlsx	XLSX spreadsheet	Jul 5, 2016
ALICE_Sections_A-M_(7-5-2016).pdf	PDF	Jul 5, 2016
Attachment_L-6_Past_Performance_Consent_Letter.docx	DOCX document	Jul 5, 2016
J-3-1_Support_Equipment_Asset_Listing.pdf	PDF	Jul 5, 2016
Attachment_L-5_Reserved.docx	DOCX document	Jul 5, 2016

Show all 30

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.

Contract form

&C&"Times New Roman,Bold"&11IDIQ CONTRACT RATES FORM &C&"Times New Roman,Bold"&11IDIQ CONTRACT RATES FORM &C&"Times New Roman,Bold"&11IDIQ CONTRACT RATES FORM &C&"Times New Roman,Bold"&11IDIQ CONTRACT RATES FORM &C&"Times New Roman,Bold"&11IDIQ CONTRACT RATES FORM &C&"Times New Roman,Bold"&11IDIQ CONTRACT RATES FORM

TRST - CF

		TECHNICAL RESOURCES SUMMARY TEMPLATE -- COMPLETION FORM (BASELINE EFFORT)
		Prime Contractor Name:
		Resources Prior To and After Efficiencies
		(Combined Resources for the Entire Team --
		Prime and ALL Subcontractors)
		NASA (JSC)
Standard Labor Category	Incumbent Retention % (Contract Year 1 Only)	Contract Year 1							Contract Year 2						Contract Year 3						Contract Year 4						Contract Year 5						Contract Year 1 Skill Mix Ratio	Contract Year 5 Skill Mix Ratio
				FTEs Before Efficiences	Hours Resources Basis Before Efficiences	FTEs After Efficiences	Proposed Hours After Efficiencies	Delta Fom Hours Resources Basis	Reference to Comprehensive Explanation of Efficiency in Volume I - Mission Suitability	FTEs Before Efficiences	Hours Resources Basis Before Efficiences	FTEs After Efficiences	Proposed Hours After Efficiencies	Delta Fom Hours Resources Basis	Reference to Comprehensive Explanation of Efficiency in Volume I - Mission Suitability	FTEs Before Efficiences	Hours Resources Basis Before Efficiences	FTEs After Efficiences	Proposed Hours After Efficiencies	Delta Fom Hours Resources Basis	Reference to Comprehensive Explanation of Efficiency in Volume I - Mission Suitability	FTEs Before Efficiences	Hours Resources Basis Before Efficiences	FTEs After Efficiences	Proposed Hours After Efficiencies	Delta Fom Hours Resources Basis	Reference to Comprehensive Explanation of Efficiency in Volume I - Mission Suitability	FTEs Before Efficiences	Hours Resources Basis Before Efficiences	FTEs After Efficiences	Proposed Hours After Efficiencies	Delta Fom Hours Resources Basis	Reference to Comprehensive Explanation of Efficiency in Volume I - Mission Suitability
					1860		Contract Year 1 Productive Hours per FTE				1860		Contract Year 2 Productive Hours per FTE				1860		Contract Year 3 Productive Hours per FTE				1864		Contract Year 4 Productive Hours per FTE				1864		Contract Year 5 Productive Hours per FTE
		Ex: Engineer III	100%	29	53,196	29	53,196	- 0	Paragraph x, Page xxx	29	53,196	29	53,196	- 0	CY 1 Efficiency Maintained	29	53,196	29	53,196	- 0	CY 1 Efficiency Maintained	29	53,310	29	53,310	- 0	CY 1 Efficiency Maintained	29	53,310	29	53,310	- 0	CY 1 Efficiency Maintained
		Accountant I																																	0.00	0.00
		Accountant II																																	0.00	0.00
		Accountant III																																	0.00	0.00
		Accountant IV																																	0.00	0.00
		Administrative Support I																																	0.00	0.00
		Administrative Support II																																	0.00	0.00
		Administrative Support III																																	0.00	0.00
		Aircraft Mechanic I																																	0.00	0.00
		Aircraft Mechanic II																																	0.00	0.00
		Aircraft Mechanic III																																	0.00	0.00
		Chief Engineer, Aviation Safety Office																																	0.00	0.00
		Contract Manager																																	0.00	0.00
		Data Analyst																																	0.00	0.00
		Designer																																	0.00	0.00
		Documentation Specialist																																	0.00	0.00
		Duty Officer																																	0.00	0.00
		Engineer I																																	0.00	0.00
		Engineer II																																	0.00	0.00
		Engineer III																																	0.00	0.00
		Engineering Team Lead																																	0.00	0.00
		Executive Manager																																	0.00	0.00
		Flight Engineer																																	0.00	0.00
		Forward Operating Location (FOL) Supervisor																																	0.00	0.00
		Ground and Simulator Instructor																																	0.00	0.00
		Loadmaster																																	0.00	0.00
		Logistics Coordinator																																	0.00	0.00
		Logistics Liason																																	0.00	0.00
		Logistics Manager																																	0.00	0.00
		Maintenance Controller																																	0.00	0.00
		Maintenance Helper																																	0.00	0.00
		Management Analyst																																	0.00	0.00
		Mission Manager																																	0.00	0.00
		Occupational Safety and Health Team Lead																																	0.00	0.00
		Occupational Safety and Health Specialist																																	0.00	0.00
		Pilot																																	0.00	0.00
		Production Controller																																	0.00	0.00
		Production Control Clerk																																	0.00	0.00
		Production Manager																																	0.00	0.00
		Project Manager I																																	0.00	0.00
		Project Manager II																																	0.00	0.00
		Project Manager III																																	0.00	0.00
		Project Pilot																																	0.00	0.00
		Purchasing Agent I																																	0.00	0.00
		Purchasing Agent II																																	0.00	0.00
		Purchasing Agent III																																	0.00	0.00
		Purchasing Agent IV																																	0.00	0.00
		Qaulity Control Deputy, Team Lead																																	0.00	0.00
		Quality Control Inspector																																	0.00	0.00
		Quality Control Team Lead																																	0.00	0.00
		Scheduler, Operations Duty Office																																	0.00	0.00
		Senior Scheduler and Planner																																	0.00	0.00
		Sensor Equipment Operator																																	0.00	0.00
		Shipping and Receiving Crew Lead																																	0.00	0.00
		Shipping and Receiving Specialist																																	0.00	0.00
		Team Lead, First Line Supervisor, Maintenance																																	0.00	0.00
		Technical Library Support Technician																																	0.00	0.00
		Test Director																																	0.00	0.00
		Training Specialist																																	0.00	0.00
		Warehouse Crew Lead																																	0.00	0.00
		Warehouse Manager, Transportation, Storage, and Distribution																																	0.00	0.00
		Warehouse Specialist																																	0.00	0.00
		Other: (Specify)		0.0	- 0			- 0		0.0	- 0			- 0		0.0				- 0		0.0				- 0		0.0				- 0			0.00	0.00
		Totals (Prime and All Subcontractors)		0.0	- 0		- 0	- 0		0.0	- 0		- 0	- 0		0.0	- 0		- 0	- 0		0.0	- 0		- 0	- 0		0.0	- 0		- 0	- 0			0.0%	0.0%
					Contract Year 1						Contract Year 2						Contract Year 3						Contract Year 4						Contract Year 5
		Non-Labor Resources (NLR) Cost			NLR Basis Before Efficiences	NLR After Efficiences	Delta From NLR Basis		Reference to Comprehensive Explanation of Efficiency in Volume I - Mission Suitability		NLR Basis Before Efficiences	NLR After Efficiences	Delta From NLR Basis		Reference to Comprehensive Explanation of Efficiency in Volume I - Mission Suitability		NLR Basis Before Efficiences	NLR After Efficiences	Delta From NLR Basis		Reference to Comprehensive Explanation of Efficiency in Volume I - Mission Suitability		NLR Basis Before Efficiences	NLR After Efficiences	Delta From NLR Basis		Reference to Comprehensive Explanation of Efficiency in Volume I - Mission Suitability		NLR Basis Before Efficiences	NLR After Efficiences	Delta From NLR Basis		Reference to Comprehensive Explanation of Efficiency in Volume I - Mission Suitability
		Materials			$ - 0	$ - 0	$ - 0				$ - 0	$ - 0	$ - 0				$ - 0	$ - 0	$ - 0				$ - 0	$ - 0	$ - 0				$ - 0	$ - 0	$ - 0
		Travel			$ - 0	$ - 0	$ - 0				$ - 0	$ - 0	$ - 0				$ - 0	$ - 0	$ - 0				$ - 0	$ - 0	$ - 0				$ - 0	$ - 0	$ - 0
		Training			$ - 0	$ - 0	$ - 0				$ - 0	$ - 0	$ - 0				$ - 0	$ - 0	$ - 0				$ - 0	$ - 0	$ - 0				$ - 0	$ - 0	$ - 0
		Consulting			$ - 0	$ - 0	$ - 0				$ - 0	$ - 0	$ - 0				$ - 0	$ - 0	$ - 0				$ - 0	$ - 0	$ - 0				$ - 0	$ - 0	$ - 0
		License/Maintenance			$ - 0	$ - 0	$ - 0				$ - 0	$ - 0	$ - 0				$ - 0	$ - 0	$ - 0				$ - 0	$ - 0	$ - 0				$ - 0	$ - 0	$ - 0
		Other Direct Cost (ODC)			$ - 0	$ - 0	$ - 0				$ - 0	$ - 0	$ - 0				$ - 0	$ - 0	$ - 0				$ - 0	$ - 0	$ - 0				$ - 0	$ - 0	$ - 0
		Total NLR Cost			$ - 0	$ - 0	$ - 0				$ - 0	$ - 0	$ - 0				$ - 0	$ - 0	$ - 0				$ - 0	$ - 0	$ - 0				$ - 0	$ - 0	$ - 0
		NOTE: Examples are highlighted in red font. IMPORTANT: Self-calculating formulas MUST BE PROVIDED for all grey shaded areas,
		whether or not in red font. Please remember to remove red highlighted examples from the templates in your official proposal submission.

LPT

Labor Pricing Template (LPT)
Prime Contractor Name:
Major Subcontractor Name:			Completion Form Baseline Effort
			Straight-Time Direct Labor Cost
NASA (JSC) Standard Labor Category	Contract Year 1	Contract Year 2	Contract Year 3	Contract Year 4	Contract Year 5	Total
						CY 1 - 5	Ref.
	100% of TRST - CF Straight-Time Hours Are Used For Each Contract Year.
Link From EPM Tab:	"TRST-CF" Tab and "OPT" Tab
EXAMPLE (Productive Hours): Engineer III	50,536	50,536	50,536	50,645	50,645	252,898
STRAIGHT-TIME PRODUCTIVE HOURS
Accountant I						- 0
Accountant II						- 0
Accountant III						- 0
Accountant IV						- 0
Administrative Support I						- 0
Administrative Support II						- 0
Administrative Support III						- 0
Aircraft Mechanic I						- 0
Aircraft Mechanic II						- 0
Aircraft Mechanic III						- 0
Chief Engineer, Aviation Safety Office						- 0
Contract Manager						- 0
Data Analyst						- 0
Designer						- 0
Documentation Specialist						- 0
Duty Officer						- 0
Engineer I						- 0
Engineer II						- 0
Engineer III						- 0
Engineering Team Lead						- 0
Executive Manager						- 0
Flight Engineer						- 0
Forward Operating Location (FOL) Supervisor						- 0
Ground and Simulator Instructor						- 0
Loadmaster						- 0
Logistics Coordinator						- 0
Logistics Liason						- 0
Logistics Manager						- 0
Maintenance Controller						- 0
Maintenance Helper						- 0
Management Analyst						- 0
Mission Manager						- 0
Occupational Safety and Health Team Lead						- 0
Occupational Safety and Health Specialist						- 0
Pilot						- 0
Production Controller						- 0
Production Control Clerk						- 0
Production Manager						- 0
Project Manager I						- 0
Project Manager II						- 0
Project Manager III						- 0
Project Pilot						- 0
Purchasing Agent I						- 0
Purchasing Agent II						- 0
Purchasing Agent III						- 0
Purchasing Agent IV						- 0
Qaulity Control Deputy, Team Lead						- 0
Quality Control Inspector						- 0
Quality Control Team Lead						- 0
Scheduler, Operations Duty Office						- 0
Senior Scheduler and Planner						- 0
Sensor Equipment Operator						- 0
Shipping and Receiving Crew Lead						- 0
Shipping and Receiving Specialist						- 0
Team Lead, First Line Supervisor, Maintenance						- 0
Technical Library Support Technician						- 0
Test Director						- 0
Training Specialist						- 0
Warehouse Crew Lead						- 0
Warehouse Manager, Transportation, Storage, and Distribution						- 0
Warehouse Specialist						- 0
Other: (Specify)						- 0
Total Productive Straight-Time Hours	- 0	- 0	- 0	- 0	- 0	- 0
Link From EPM Tab:	IRAP Tab	IRAP Tab	IRAP Tab	IRAP Tab	IRAP Tab
EXAMPLE (rates from IRAP tab): Engineer III	$ 26.72	from IRAP tab	from FBR tab	from FBR tab	from FBR tab
STRAIGHT-TIME DIRECT LABOR RATES
Accountant I
Accountant II
Accountant III
Accountant IV
Administrative Support I
Administrative Support II
Administrative Support III
Aircraft Mechanic I
Aircraft Mechanic II
Aircraft Mechanic III
Chief Engineer, Aviation Safety Office
Contract Manager
Data Analyst
Designer
Documentation Specialist
Duty Officer
Engineer I
Engineer II
Engineer III
Engineering Team Lead
Executive Manager
Flight Engineer
Forward Operating Location (FOL) Supervisor
Ground and Simulator Instructor
Loadmaster
Logistics Coordinator
Logistics Liason
Logistics Manager
Maintenance Controller
Maintenance Helper
Management Analyst
Mission Manager
Occupational Safety and Health Team Lead
Occupational Safety and Health Specialist
Pilot
Production Controller
Production Control Clerk
Production Manager
Project Manager I
Project Manager II
Project Manager III
Project Pilot
Purchasing Agent I
Purchasing Agent II
Purchasing Agent III
Purchasing Agent IV
Qaulity Control Deputy, Team Lead
Quality Control Inspector
Quality Control Team Lead
Scheduler, Operations Duty Office
Senior Scheduler and Planner
Sensor Equipment Operator
Shipping and Receiving Crew Lead
Shipping and Receiving Specialist
Team Lead, First Line Supervisor, Maintenance
Technical Library Support Technician
Test Director
Training Specialist
Warehouse Crew Lead
Warehouse Manager, Transportation, Storage, and Distribution
Warehouse Specialist
Other: (Specify)
EXAMPLE (FBL Cost): Engineer III	$ 1,350,088
STRAIGHT-TIME DIRECT LABOR COST
Accountant I						$ - 0
Accountant II						$ - 0
Accountant III						$ - 0
Accountant IV						$ - 0
Administrative Support I						$ - 0
Administrative Support II						$ - 0
Administrative Support III						$ - 0
Aircraft Mechanic I						$ - 0
Aircraft Mechanic II						$ - 0
Aircraft Mechanic III						$ - 0
Chief Engineer, Aviation Safety Office						$ - 0
Contract Manager						$ - 0
Data Analyst						$ - 0
Designer						$ - 0
Documentation Specialist						$ - 0
Duty Officer						$ - 0
Engineer I						$ - 0
Engineer II						$ - 0
Engineer III						$ - 0
Engineering Team Lead						$ - 0
Executive Manager						$ - 0
Flight Engineer						$ - 0
Forward Operating Location (FOL) Supervisor						$ - 0
Ground and Simulator Instructor						$ - 0
Loadmaster						$ - 0
Logistics Coordinator						$ - 0
Logistics Liason						$ - 0
Logistics Manager						$ - 0
Maintenance Controller						$ - 0
Maintenance Helper						$ - 0
Management Analyst						$ - 0
Mission Manager						$ - 0
Occupational Safety and Health Team Lead						$ - 0
Occupational Safety and Health Specialist						$ - 0
Pilot						$ - 0
Production Controller						$ - 0
Production Control Clerk						$ - 0
Production Manager						$ - 0
Project Manager I						$ - 0
Project Manager II						$ - 0
Project Manager III						$ - 0
Project Pilot						$ - 0
Purchasing Agent I						$ - 0
Purchasing Agent II						$ - 0
Purchasing Agent III						$ - 0
Purchasing Agent IV						$ - 0
Qaulity Control Deputy, Team Lead						$ - 0
Quality Control Inspector						$ - 0
Quality Control Team Lead						$ - 0
Scheduler, Operations Duty Office						$ - 0
Senior Scheduler and Planner						$ - 0
Sensor Equipment Operator						$ - 0
Shipping and Receiving Crew Lead						$ - 0
Shipping and Receiving Specialist						$ - 0
Team Lead, First Line Supervisor, Maintenance						$ - 0
Technical Library Support Technician						$ - 0
Test Director						$ - 0
Training Specialist						$ - 0
Warehouse Crew Lead						$ - 0
Warehouse Manager, Transportation, Storage, and Distribution						$ - 0
Warehouse Specialist						$ - 0
Other: (Specify)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Straight-Time Direct Labor Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
NOTE: Examples are highlighted in red font. IMPORTANT: Self-calculating formulas MUST BE PROVIDED for all grey shaded areas,
whether or not in red font. Please remember to remove red highlighted examples from the templates.

LPT - OT

Overtime Pricing Template (LPT - OT)
Prime Contractor Name:
Major Subcontractor Name:			Completion Form Baseline Effort
			Overtime Direct Labor Cost
NASA (JSC) Standard Labor Category	Contract Year 1	Contract Year 2	Contract Year 3	Contract Year 4	Contract Year 5	Total
						CY 1 - 5	Ref.
	100% of TRST - CF Overtime Hours Are Used For Each Contract Year.
Link From EPM Tab:	TRST - CF	TRST - CF	TRST - CF	TRST - CF	TRST - CF
EXAMPLE (Productive Hours): Engineer III	2,660	2,660	2,660	2,666	2,666	13,310
OVERTIME PRODUCTIVE HOURS
Program Manager						- 0
Manager						- 0
Senior Engineer Specialist						- 0
Engineer IV						- 0
Engineer III						- 0
Engineer II						- 0
Engineer I						- 0
Technical Professional III						- 0
Technical Professional II						- 0
Technical Professional I						- 0
Quality Assurance Specialist						- 0
Product Assurance Manager						- 0
Safety Manager						- 0
Safety Engineer						- 0
Quality Engineer						- 0
Software Quality Assuarance Engineer						- 0
Technicial III						- 0
Technicial II						- 0
Technicial I						- 0
IT Professional III						- 0
IT Professional II						- 0
IT Professional I						- 0
Business Specialist II						- 0
Business Specialist I						- 0
Administrative Specialist III						- 0
Administrative Specialist II						- 0
Administrative Specialist I						- 0
Other: (Specify)						- 0
Total Productive Overtime Hours	- 0	- 0	- 0	- 0		- 0
Link From EPM Tab:	IRAP Tab	IRAP Tab	IRAP Tab	IRAP Tab	IRAP Tab
EXAMPLE (rates from IRAP tab): Engineer III	$ 26.72	from IRAP tab	from FBR tab	from FBR tab	from FBR tab
OVERTIME DIRECT LABOR RATES
Program Manager
Manager
Senior Engineer Specialist
Engineer IV
Engineer III
Engineer II
Engineer I
Technical Professional III
Technical Professional II
Technical Professional I
Quality Assurance Specialist
Product Assurance Manager
Safety Manager
Safety Engineer
Quality Engineer
Software Quality Assuarance Engineer
Technicial III
Technicial II
Technicial I
IT Professional III
IT Professional II
IT Professional I
Business Specialist II
Business Specialist I
Administrative Specialist III
Administrative Specialist II
Administrative Specialist I
Other: (Specify)
EXAMPLE (FBL Cost): Engineer III	$ 71,057
OVERTIME DIRECT LABOR COST
Program Manager						$ - 0
Manager						$ - 0
Senior Engineer Specialist						$ - 0
Engineer IV						$ - 0
Engineer III						$ - 0
Engineer II						$ - 0
Engineer I						$ - 0
Technical Professional III						$ - 0
Technical Professional II						$ - 0
Technical Professional I						$ - 0
Quality Assurance Specialist						$ - 0
Product Assurance Manager						$ - 0
Safety Manager						$ - 0
Safety Engineer						$ - 0
Quality Engineer						$ - 0
Software Quality Assuarance Engineer						$ - 0
Technicial III						$ - 0
Technicial II						$ - 0
Technicial I						$ - 0
IT Professional III						$ - 0
IT Professional II						$ - 0
IT Professional I						$ - 0
Business Specialist II						$ - 0
Business Specialist I						$ - 0
Administrative Specialist III						$ - 0
Administrative Specialist II						$ - 0
Administrative Specialist I						$ - 0
Other: (Specify)						$ - 0
Total Overtime Direct Labor Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
NOTE: Examples are highlighted in red font. IMPORTANT: Self-calculating formulas MUST BE PROVIDED for all grey shaded areas,
whether or not in red font. Please remember to remove red highlighted examples from the templates.

MSCST

Major Subcontractor Cost Summary Template (MSCST)
Major Subcontractor Name:			Completion Form Baseline Effort
			Major Subcontractor Total Cost and Fee
	Contract Year 1	Contract Year 2	Contract Year 3	Contract Year 4	Contract Year 5	Total
Cost Element						CY 1 - 5
Direct Labor Hours:
Major Sub Straight-Time Hours	Link to Major Subcontractor's "LPT" Tab.					- 0
Major Sub Overtime Hours	Link to Major Subcontractor's "OPT" Tab.					- 0
Total Direct Labor Hours	- 0	- 0	- 0	- 0	- 0	- 0
Direct Labor Cost:
Major Sub Direct Labor Cost	Link to Major Subcontractor's "LPT" Tab.					$ - 0
Major Sub Overtime Cost	Link to Major Subcontractor's "OPT" Tab.					$ - 0
Total Direct Labor Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Overhead (OH) and Service Center (SC) Cost:
Major Sub OH or SC No. 1 (identify by name)
Base	*IMPORTANT* Provide the Formula used to Calculate the Overhead Base Dollars.					$ - 0
Rate						$ - 0
Sub-Total Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Major Sub OH or SC No. 2 (identify by name)
Base	*IMPORTANT* Provide the Formula used to Calculate the Overhead Base Dollars.					$ - 0
Rate						$ - 0
Sub-Total Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Major Sub OH or SC No. 3 (identify by name)
Base	*IMPORTANT* Provide the Formula used to Calculate the Overhead Base Dollars.					$ - 0
Rate						$ - 0
Sub-Total Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total OH and SC Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Non-Labor Resources (NLR) Cost
Materials						$ - 0
Travel						$ - 0
Training						$ - 0
Consulting						$ - 0
License/Maintenance						$ - 0
Other Direct Cost (ODC)						$ - 0
Total NLR Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Sub-Total Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
G&A Cost:
G&A Base	*IMPORTANT* Provide the Formula used to Calculate the G&A Base Dollars.					$ - 0
G&A Rate
Total G&A Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Facilities Capital Cost of Money (FCCOM):
FCCOM Base						$ - 0
FCCOM Rate
Total FCCOM Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Estimated Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Award Fee
Award Fee Base	*IMPORTANT* Provide the Formula used to Calculate the Award Fee Dollars.					$ - 0
Award Fee Rate
Total Award Fee Dollars	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Major Sub Estimated Cost and Fee	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
NOTE: IMPORTANT: Self-calculating formulas MUST BE PROVIDED for all grey shaded areas and where otherwise identified.

PCST

Prime Cost Summary Template (PCST)
Prime Contractor Name:			Completion Form Baseline Effort
			Prime Contractor Total Cost and Fee
	Contract Year 1	Contract Year 2	Contract Year 3	Contract Year 4	Contract Year 5	Total
Cost Element						CY 1 - 5
Direct Labor Hours:
Prime Contractor Straight-Time Hours	Link to Prime Contractor's "LPT" Tab					- 0
Prime Contractor Overtime Hours	Link to Prime Contractor's "OPT" Tab					- 0
Major Subcontractor Straight-Time Hours						- 0
Major Subcontractor Overtime Hours						- 0
Minor Subcontractor Straight-Time Hours						- 0
Minor Subcontractor Overtime Hours						- 0
Total Direct Labor Hours	- 0	- 0	- 0	- 0	- 0	- 0
Direct Labor Cost:
Prime Contractor Straight-Time Direct Labor Cost	Link to Prime Contractor's "LPT" Tab					$ - 0
Prime Contractor Overtime Direct Labor Cost	Link to Prime Contractor's "OPT" Tab					$ - 0
Total Direct Labor Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Overhead (OH) and Service Center (SC) Cost:
Prime Contractor OH or SC No. 1 (identify by name)	*IMPORTANT* Provide the Formula used to Calculate the Overhead Base Dollars.
Base						$ - 0
Rate						$ - 0
Sub-Total Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Prime Contractor OH or SC No. 2 (identify by name)	*IMPORTANT* Provide the Formula used to Calculate the Overhead Base Dollars.
Base						$ - 0
Rate						$ - 0
Sub-Total Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Prime Contractor OH or SC No. 3 (identify by name)	*IMPORTANT* Provide the Formula used to Calculate the Overhead Base Dollars.
Base						$ - 0
Rate						$ - 0
Sub-Total Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total OH and SC Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Subcontractor Cost:
Major Subcontractor No. 1 (identify by name)						$ - 0
Major Subcontractor No. 2 (identify by name)						$ - 0
Major Subcontractor No. 3 (identify by name)						$ - 0
Sub-Total Major Subcontractor Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Minor Subcontractor No. 1 (identify by name)						$ - 0
Minor Subcontractor No. 2 (identify by name)						$ - 0
Minor Subcontractor No. 3 (identify by name)						$ - 0
Sub-Total Minor Subcontractor Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Subcontractor Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Non-Labor Resources (NLR) Cost
Materials						$ - 0
Travel						$ - 0
Training						$ - 0
Consulting						$ - 0
License/Maintenance						$ - 0
Other Direct Cost (ODC)						$ - 0
Total NLR Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Sub-Total Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
G&A Cost:	*IMPORTANT* Provide the Formula used to Calculate the G&A Base Dollars.
G&A Base						$ - 0
G&A Rate
Total G&A Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Estimated Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Award Fee	*IMPORTANT* Provide the Formula used to Calculate the Award Fee Dollars.
Award Fee Base						$ - 0
Not-To-Exceed (NTE) Award Fee Rate
Total Award Fee Dollars	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Major Sub Estimated Cost and Fee	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
NOTE: IMPORTANT: Self-calculating formulas MUST BE PROVIDED for all grey shaded areas and where otherwise identified.

IRAP

Incumbency Retention and Pay Template (IRAP)
Prime Contractor Name:			.
Major Subcontractor Name:
[ ] Ellington Contract Year 1			[ ] El Paso Contract Year 1	[ ] Langley Contract Year 1
[ ] Ellington Contract Year 2			[ ] El Paso Contract Year 2	[ ] Langley Contract Year 2
[ ] Ellington Contract Year 3			[ ] El Paso Contract Year 3	[ ] Langley Contract Year 3
[ ] Ellington Contract Year 4			[ ] El Paso Contract Year 4	[ ] Langley Contract Year 4
[ ] Ellington Contract Year 5			[ ] El Paso Contract Year 5	[ ] Langley Contract Year 5
Unadjusted Base Direct Labor Rate	Data Source Used By Offeror	Offeror's Labor Category	NASA (JSC) Standard Labor Category	Incumbent Rentention % (Column 1)	Retention % of Incumbents at Current Direct Labor Rates (Column 2)	"Net" Incumbents Paid at Current Direct Labor Rates (Column 1 times Column 2)	% usage	Direct Labor Rate (Contract Year 1)	Basis of Direct Labor Rate (Offeror's Labor Category)
	Example: Engineer III
$ 28.76	Historical Incumbent Rate		EXAMPLE: Engineer III				63.75%	$ 28.76	ex: NASA RFP Data
$ - 0	WD Rate		EXAMPLE: Engineer III				0.00%	$ - 0	ex: WD No. 2005-2515, Revision 18 (July 8, 2015)
$ 21.80	Third Party Rate Data		EXAMPLE: Engineer III				15.00%	$ 22.37	ex: ERI (Data as of Aug 2015, escalated to Aug 2016)
$ 22.78	Contractor Rate Data	Labor Category 8	EXAMPLE: Engineer III				11.25%	$ 22.78	ex: Average Rate Data as of July 2016
$ 24.63	Contractor Rate Data	Labor Category 9	EXAMPLE: Engineer III				10.00%	$ 24.63	ex: Average Rate Data as of July 2016
			EXAMPLE: Engineer Composite III	75.00%	85.00%	63.75%	100.00%	$ 26.72
$ - 0	Historical Incumbent Rate		Accountant I				0.00%	$ - 0
$ - 0	WD Rate		Accountant I				0.00%	$ - 0
$ - 0	Third Party Rate Data		Accountant I				0.00%	$ - 0
$ - 0	Contractor Rate Data		Accountant I				0.00%	$ - 0
			Accountant I Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Accountant II				0.00%	$ - 0
$ - 0	WD Rate		Accountant II				0.00%	$ - 0
$ - 0	Third Party Rate Data		Accountant II				0.00%	$ - 0
$ - 0	Contractor Rate Data		Accountant II				0.00%	$ - 0
			Accountant II Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Accountant III				0.00%	$ - 0
$ - 0	WD Rate		Accountant III				0.00%	$ - 0
$ - 0	Third Party Rate Data		Accountant III				0.00%	$ - 0
$ - 0	Contractor Rate Data		Accountant III				0.00%	$ - 0
			Accountant III Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Accountant IV				0.00%	$ - 0
$ - 0	WD Rate		Accountant IV				0.00%	$ - 0
$ - 0	Third Party Rate Data		Accountant IV				0.00%	$ - 0
$ - 0	Contractor Rate Data		Accountant IV				0.00%	$ - 0
			Accountant IV Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Administrative Support I				0.00%	$ - 0
$ - 0	WD Rate		Administrative Support I				0.00%	$ - 0
$ - 0	Third Party Rate Data		Administrative Support I				0.00%	$ - 0
$ - 0	Contractor Rate Data		Administrative Support I				0.00%	$ - 0
			Administrative Support I Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Administrative Support II				0.00%	$ - 0
$ - 0	WD Rate		Administrative Support II				0.00%	$ - 0
$ - 0	Third Party Rate Data		Administrative Support II				0.00%	$ - 0
$ - 0	Contractor Rate Data		Administrative Support II				0.00%	$ - 0
			Administrative Support II Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Administrative Support III				0.00%	$ - 0
$ - 0	WD Rate		Administrative Support III				0.00%	$ - 0
$ - 0	Third Party Rate Data		Administrative Support III				0.00%	$ - 0
$ - 0	Contractor Rate Data		Administrative Support III				0.00%	$ - 0
			Administrative Support III Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Aircraft Mechanic I				0.00%	$ - 0
$ - 0	WD Rate		Aircraft Mechanic I				0.00%	$ - 0
$ - 0	Third Party Rate Data		Aircraft Mechanic I				0.00%	$ - 0
$ - 0	Contractor Rate Data		Aircraft Mechanic I				0.00%	$ - 0
			Aircraft Mechanic I Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Aircraft Mechanic II				0.00%	$ - 0
$ - 0	WD Rate		Aircraft Mechanic II				0.00%	$ - 0
$ - 0	Third Party Rate Data		Aircraft Mechanic II				0.00%	$ - 0
$ - 0	Contractor Rate Data		Aircraft Mechanic II				0.00%	$ - 0
			Aircraft Mechanic II Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Aircraft Mechanic III				0.00%	$ - 0
$ - 0	WD Rate		Aircraft Mechanic III				0.00%	$ - 0
$ - 0	Third Party Rate Data		Aircraft Mechanic III				0.00%	$ - 0
$ - 0	Contractor Rate Data		Aircraft Mechanic III				0.00%	$ - 0
			Aircraft Mechanic III Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Chief Engineer, Aviation Safety Office				0.00%	$ - 0
$ - 0	WD Rate		Chief Engineer, Aviation Safety Office				0.00%	$ - 0
$ - 0	Third Party Rate Data		Chief Engineer, Aviation Safety Office				0.00%	$ - 0
$ - 0	Contractor Rate Data		Chief Engineer, Aviation Safety Office				0.00%	$ - 0
			Chief Engineer, Aviation Safety Office Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Contract Manager				0.00%	$ - 0
$ - 0	WD Rate		Contract Manager				0.00%	$ - 0
$ - 0	Third Party Rate Data		Contract Manager				0.00%	$ - 0
$ - 0	Contractor Rate Data		Contract Manager				0.00%	$ - 0
			Contract Manager Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Data Analyst				0.00%	$ - 0
$ - 0	WD Rate		Data Analyst				0.00%	$ - 0
$ - 0	Third Party Rate Data		Data Analyst				0.00%	$ - 0
$ - 0	Contractor Rate Data		Data Analyst				0.00%	$ - 0
			Data Analyst Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Designer				0.00%	$ - 0
$ - 0	WD Rate		Designer				0.00%	$ - 0
$ - 0	Third Party Rate Data		Designer				0.00%	$ - 0
$ - 0	Contractor Rate Data		Designer				0.00%	$ - 0
			Designer Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Documentation Specialist				0.00%	$ - 0
$ - 0	WD Rate		Documentation Specialist				0.00%	$ - 0
$ - 0	Third Party Rate Data		Documentation Specialist				0.00%	$ - 0
$ - 0	Contractor Rate Data		Documentation Specialist				0.00%	$ - 0
			Documentation Specialist Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Duty Officer				0.00%	$ - 0
$ - 0	WD Rate		Duty Officer				0.00%	$ - 0
$ - 0	Third Party Rate Data		Duty Officer				0.00%	$ - 0
$ - 0	Contractor Rate Data		Duty Officer				0.00%	$ - 0
			Duty Officer Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Engineer I				0.00%	$ - 0
$ - 0	WD Rate		Engineer I				0.00%	$ - 0
$ - 0	Third Party Rate Data		Engineer I				0.00%	$ - 0
$ - 0	Contractor Rate Data		Engineer I				0.00%	$ - 0
			Engineer I Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Engineer II				0.00%	$ - 0
$ - 0	WD Rate		Engineer II				0.00%	$ - 0
$ - 0	Third Party Rate Data		Engineer II				0.00%	$ - 0
$ - 0	Contractor Rate Data		Engineer II				0.00%	$ - 0
			Engineer II Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Engineer III				0.00%	$ - 0
$ - 0	WD Rate		Engineer III				0.00%	$ - 0
$ - 0	Third Party Rate Data		Engineer III				0.00%	$ - 0
$ - 0	Contractor Rate Data		Engineer III				0.00%	$ - 0
			Engineer III Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Engineering Team Lead				0.00%	$ - 0
$ - 0	WD Rate		Engineering Team Lead				0.00%	$ - 0
$ - 0	Third Party Rate Data		Engineering Team Lead				0.00%	$ - 0
$ - 0	Contractor Rate Data		Engineering Team Lead				0.00%	$ - 0
			Engineering Team Lead Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Executive Manager				0.00%	$ - 0
$ - 0	WD Rate		Executive Manager				0.00%	$ - 0
$ - 0	Third Party Rate Data		Executive Manager				0.00%	$ - 0
$ - 0	Contractor Rate Data		Executive Manager				0.00%	$ - 0
			Executive Manager Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Flight Engineer				0.00%	$ - 0
$ - 0	WD Rate		Flight Engineer				0.00%	$ - 0
$ - 0	Third Party Rate Data		Flight Engineer				0.00%	$ - 0
$ - 0	Contractor Rate Data		Flight Engineer				0.00%	$ - 0
			Flight Engineer Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Forward Operating Location (FOL) Supervisor				0.00%	$ - 0
$ - 0	WD Rate		Forward Operating Location (FOL) Supervisor				0.00%	$ - 0
$ - 0	Third Party Rate Data		Forward Operating Location (FOL) Supervisor				0.00%	$ - 0
$ - 0	Contractor Rate Data		Forward Operating Location (FOL) Supervisor				0.00%	$ - 0
			FOL Supervisor Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Ground and Simulator Instructor				0.00%	$ - 0
$ - 0	WD Rate		Ground and Simulator Instructor				0.00%	$ - 0
$ - 0	Third Party Rate Data		Ground and Simulator Instructor				0.00%	$ - 0
$ - 0	Contractor Rate Data		Ground and Simulator Instructor				0.00%	$ - 0
			Ground and Simulator Instructor Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Loadmaster				0.00%	$ - 0
$ - 0	WD Rate		Loadmaster				0.00%	$ - 0
$ - 0	Third Party Rate Data		Loadmaster				0.00%	$ - 0
$ - 0	Contractor Rate Data		Loadmaster				0.00%	$ - 0
			Loadmaster Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Logistics Coordinator				0.00%	$ - 0
$ - 0	WD Rate		Logistics Coordinator				0.00%	$ - 0
$ - 0	Third Party Rate Data		Logistics Coordinator				0.00%	$ - 0
$ - 0	Contractor Rate Data		Logistics Coordinator				0.00%	$ - 0
			Logistics Coordinator Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Logistics Manager				0.00%	$ - 0
$ - 0	WD Rate		Logistics Manager				0.00%	$ - 0
$ - 0	Third Party Rate Data		Logistics Manager				0.00%	$ - 0
$ - 0	Contractor Rate Data		Logistics Manager				0.00%	$ - 0
			Logistics Manager Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Logistics Liason				0.00%	$ - 0
$ - 0	WD Rate		Logistics Liason				0.00%	$ - 0
$ - 0	Third Party Rate Data		Logistics Liason				0.00%	$ - 0
$ - 0	Contractor Rate Data		Logistics Liason				0.00%	$ - 0
			Logistics Liason Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Maintenance Controller				0.00%	$ - 0
$ - 0	WD Rate		Maintenance Controller				0.00%	$ - 0
$ - 0	Third Party Rate Data		Maintenance Controller				0.00%	$ - 0
$ - 0	Contractor Rate Data		Maintenance Controller				0.00%	$ - 0
			Maintenance Controller Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Maintenance Helper				0.00%	$ - 0
$ - 0	WD Rate		Maintenance Helper				0.00%	$ - 0
$ - 0	Third Party Rate Data		Maintenance Helper				0.00%	$ - 0
$ - 0	Contractor Rate Data		Maintenance Helper				0.00%	$ - 0
			Maintenance Helper Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Management Analyst				0.00%	$ - 0
$ - 0	WD Rate		Management Analyst				0.00%	$ - 0
$ - 0	Third Party Rate Data		Management Analyst				0.00%	$ - 0
$ - 0	Contractor Rate Data		Management Analyst				0.00%	$ - 0
			Management Analyst Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Mission Manager				0.00%	$ - 0
$ - 0	WD Rate		Mission Manager				0.00%	$ - 0
$ - 0	Third Party Rate Data		Mission Manager				0.00%	$ - 0
$ - 0	Contractor Rate Data		Mission Manager				0.00%	$ - 0
			Management Manager Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Occupational Safety and Health Team Lead				0.00%	$ - 0
$ - 0	WD Rate		Occupational Safety and Health Team Lead				0.00%	$ - 0
$ - 0	Third Party Rate Data		Occupational Safety and Health Team Lead				0.00%	$ - 0
$ - 0	Contractor Rate Data		Occupational Safety and Health Team Lead				0.00%	$ - 0
			Occ Safety and Health Team Lead Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Occupational Safety and Health Specialist				0.00%	$ - 0
$ - 0	WD Rate		Occupational Safety and Health Specialist				0.00%	$ - 0
$ - 0	Third Party Rate Data		Occupational Safety and Health Specialist				0.00%	$ - 0
$ - 0	Contractor Rate Data		Occupational Safety and Health Specialist				0.00%	$ - 0
			Occ Safety and Health Specialist Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Pilot				0.00%	$ - 0
$ - 0	WD Rate		Pilot				0.00%	$ - 0
$ - 0	Third Party Rate Data		Pilot				0.00%	$ - 0
$ - 0	Contractor Rate Data		Pilot				0.00%	$ - 0
			Pilot Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Production Controller				0.00%	$ - 0
$ - 0	WD Rate		Production Controller				0.00%	$ - 0
$ - 0	Third Party Rate Data		Production Controller				0.00%	$ - 0
$ - 0	Contractor Rate Data		Production Controller				0.00%	$ - 0
			Production Controller Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Production Control Clerk				0.00%	$ - 0
$ - 0	WD Rate		Production Control Clerk				0.00%	$ - 0
$ - 0	Third Party Rate Data		Production Control Clerk				0.00%	$ - 0
$ - 0	Contractor Rate Data		Production Control Clerk				0.00%	$ - 0
			Production Control Clerk Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Production Manager				0.00%	$ - 0
$ - 0	WD Rate		Production Manager				0.00%	$ - 0
$ - 0	Third Party Rate Data		Production Manager				0.00%	$ - 0
$ - 0	Contractor Rate Data		Production Manager				0.00%	$ - 0
			Production Manager Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Project Manager I				0.00%	$ - 0
$ - 0	WD Rate		Project Manager I				0.00%	$ - 0
$ - 0	Third Party Rate Data		Project Manager I				0.00%	$ - 0
$ - 0	Contractor Rate Data		Project Manager I				0.00%	$ - 0
			Project Manager I Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Project Manager II				0.00%	$ - 0
$ - 0	WD Rate		Project Manager II				0.00%	$ - 0
$ - 0	Third Party Rate Data		Project Manager II				0.00%	$ - 0
$ - 0	Contractor Rate Data		Project Manager II				0.00%	$ - 0
			Project Manager II Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Project Manager III				0.00%	$ - 0
$ - 0	WD Rate		Project Manager III				0.00%	$ - 0
$ - 0	Third Party Rate Data		Project Manager III				0.00%	$ - 0
$ - 0	Contractor Rate Data		Project Manager III				0.00%	$ - 0
			Project Manager III Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Project Pilot				0.00%	$ - 0
$ - 0	WD Rate		Project Pilot				0.00%	$ - 0
$ - 0	Third Party Rate Data		Project Pilot				0.00%	$ - 0
$ - 0	Contractor Rate Data		Project Pilot				0.00%	$ - 0
			Project Pilot Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Purchasing Agent I				0.00%	$ - 0
$ - 0	WD Rate		Purchasing Agent I				0.00%	$ - 0
$ - 0	Third Party Rate Data		Purchasing Agent I				0.00%	$ - 0
$ - 0	Contractor Rate Data		Purchasing Agent I				0.00%	$ - 0
			Purchasing Agent I Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Purchasing Agent II				0.00%	$ - 0
$ - 0	WD Rate		Purchasing Agent II				0.00%	$ - 0
$ - 0	Third Party Rate Data		Purchasing Agent II				0.00%	$ - 0
$ - 0	Contractor Rate Data		Purchasing Agent II				0.00%	$ - 0
			Purchasing II Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Purchasing Agent III				0.00%	$ - 0
$ - 0	WD Rate		Purchasing Agent III				0.00%	$ - 0
$ - 0	Third Party Rate Data		Purchasing Agent III				0.00%	$ - 0
$ - 0	Contractor Rate Data		Purchasing Agent III				0.00%	$ - 0
			Purchasing Agent III Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Purchasing Agent IV				0.00%	$ - 0
$ - 0	WD Rate		Purchasing Agent IV				0.00%	$ - 0
$ - 0	Third Party Rate Data		Purchasing Agent IV				0.00%	$ - 0
$ - 0	Contractor Rate Data		Purchasing Agent IV				0.00%	$ - 0
			Purchasing Agent IV Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Quality Control Deputy, Team Lead				0.00%	$ - 0
$ - 0	WD Rate		Quality Control Deputy, Team Lead				0.00%	$ - 0
$ - 0	Third Party Rate Data		Quality Control Deputy, Team Lead				0.00%	$ - 0
$ - 0	Contractor Rate Data		Quality Control Deputy, Team Lead				0.00%	$ - 0
			Quality Control Deputy, Team Lead Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Quality Control Inspector				0.00%	$ - 0
$ - 0	WD Rate		Quality Control Inspector				0.00%	$ - 0
$ - 0	Third Party Rate Data		Quality Control Inspector				0.00%	$ - 0
$ - 0	Contractor Rate Data		Quality Control Inspector				0.00%	$ - 0
			Quality Control Inspector Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Quality Control Team Lead				0.00%	$ - 0
$ - 0	WD Rate		Quality Control Team Lead				0.00%	$ - 0
$ - 0	Third Party Rate Data		Quality Control Team Lead				0.00%	$ - 0
$ - 0	Contractor Rate Data		Quality Control Team Lead				0.00%	$ - 0
			Quality Control Team Lead Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Scheduler, Operations Duty Office				0.00%	$ - 0
$ - 0	WD Rate		Scheduler, Operations Duty Office				0.00%	$ - 0
$ - 0	Third Party Rate Data		Scheduler, Operations Duty Office				0.00%	$ - 0
$ - 0	Contractor Rate Data		Scheduler, Operations Duty Office				0.00%	$ - 0
			Scheduler, Operations Duty Office Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Senior Scheduler and Planner				0.00%	$ - 0
$ - 0	WD Rate		Senior Scheduler and Planner				0.00%	$ - 0
$ - 0	Third Party Rate Data		Senior Scheduler and Planner				0.00%	$ - 0
$ - 0	Contractor Rate Data		Senior Scheduler and Planner				0.00%	$ - 0
			Senior Scheduler and Planner Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Sensor Equipment Operator				0.00%	$ - 0
$ - 0	WD Rate		Sensor Equipment Operator				0.00%	$ - 0
$ - 0	Third Party Rate Data		Sensor Equipment Operator				0.00%	$ - 0
$ - 0	Contractor Rate Data		Sensor Equipment Operator				0.00%	$ - 0
			Sensor Eequipment Operator Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Shipping and Receiving Crew Lead				0.00%	$ - 0
$ - 0	WD Rate		Shipping and Receiving Crew Lead				0.00%	$ - 0
$ - 0	Third Party Rate Data		Shipping and Receiving Crew Lead				0.00%	$ - 0
$ - 0	Contractor Rate Data		Shipping and Receiving Crew Lead				0.00%	$ - 0
			Shipping and Receiving Crew Lead Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Shipping and Receiving Specialist				0.00%	$ - 0
$ - 0	WD Rate		Shipping and Receiving Specialist				0.00%	$ - 0
$ - 0	Third Party Rate Data		Shipping and Receiving Specialist				0.00%	$ - 0
$ - 0	Contractor Rate Data		Shipping and Receiving Specialist				0.00%	$ - 0
			Shipping and Receiving Specialist Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Team Lead, First Line Supervisor, Maintenance				0.00%	$ - 0
$ - 0	WD Rate		Team Lead, First Line Supervisor, Maintenance				0.00%	$ - 0
$ - 0	Third Party Rate Data		Team Lead, First Line Supervisor, Maintenance				0.00%	$ - 0
$ - 0	Contractor Rate Data		Team Lead, First Line Supervisor, Maintenance				0.00%	$ - 0
			Team Lead, First Line Spvsr, Maint Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Technical Library Support Technician				0.00%	$ - 0
$ - 0	WD Rate		Technical Library Support Technician				0.00%	$ - 0
$ - 0	Third Party Rate Data		Technical Library Support Technician				0.00%	$ - 0
$ - 0	Contractor Rate Data		Technical Library Support Technician				0.00%	$ - 0
			Technical Library Support Technician Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Test Director				0.00%	$ - 0
$ - 0	WD Rate		Test Director				0.00%	$ - 0
$ - 0	Third Party Rate Data		Test Director				0.00%	$ - 0
$ - 0	Contractor Rate Data		Test Director				0.00%	$ - 0
			Test Director Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Training Specialist				0.00%	$ - 0
$ - 0	WD Rate		Training Specialist				0.00%	$ - 0
$ - 0	Third Party Rate Data		Training Specialist				0.00%	$ - 0
$ - 0	Contractor Rate Data		Training Specialist				0.00%	$ - 0
			Training Specialist Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Warehouse Crew Lead				0.00%	$ - 0
$ - 0	WD Rate		Warehouse Crew Lead				0.00%	$ - 0
$ - 0	Third Party Rate Data		Warehouse Crew Lead				0.00%	$ - 0
$ - 0	Contractor Rate Data		Warehouse Crew Lead				0.00%	$ - 0
			Warehouse Crew Lead Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Warehouse Manager, Transportation, Storage and Distrib				0.00%	$ - 0
$ - 0	WD Rate		Warehouse Manager, Transportation, Storage and Distrib				0.00%	$ - 0
$ - 0	Third Party Rate Data		Warehouse Manager, Transportation, Storage and Distrib				0.00%	$ - 0
$ - 0	Contractor Rate Data		Warehouse Manager, Transportation, Storage and Distrib				0.00%	$ - 0
			Wrhse Mgr, Trans, Strg and Distrib Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Warehouse Specialist				0.00%	$ - 0
$ - 0	WD Rate		Warehouse Specialist				0.00%	$ - 0
$ - 0	Third Party Rate Data		Warehouse Specialist				0.00%	$ - 0
$ - 0	Contractor Rate Data		Warehouse Specialist				0.00%	$ - 0
			Technical Library Support Technician Composite	0.00%	0.00%	0.00%	0.00%	$ - 0
$ - 0	Historical Incumbent Rate		Other: (Specify)				0.00%	$ - 0
$ - 0	WD Rate		Other: (Specify)				0.00%	$ - 0
$ - 0	Third Party Rate Data		Other: (Specify)				0.00%	$ - 0
$ - 0	Contractor Rate Data		Other: (Specify)				0.00%	$ - 0
			Other: (Specify) Composite	0.00%	0.00%	0.00%	0.00%	$ - 0

FBR

FULLY BURDENED RATES TEMPLATE (FBR)

Prime Contractor:

[ ] Ellington Contract Year 1

[ ] El Paso Contract Year 1

[ ] Langley Contract Year 1

Major Subcontractor:

[ ] Ellington Contract Year 2

[ ] El Paso Contract Year 2

[ ] Langley Contract Year 2

[ ] Ellington Contract Year 3

[ ] El Paso Contract Year 3

[ ] Langley Contract Year 3

[ ] Ellington Contract Year 4

[ ] El Paso Contract Year 4

[ ] Langley Contract Year 4

[ ] Ellington Contract Year 5

[ ] El Paso Contract Year 5

[ ] Langley Contract Year 5

Prime Completes the area highlighted below in blue

Major Subcontractor completes the area highlighted below in red

Subcontract Price Input Area (inputed here by prime)

NASA

Direct Labor

Overhead

G&A

Composite

Composite Overtime

Standard Labor Category (SLC)

Rate

Cost

Rate

Cost

FCCOM

Fee (sub only)

Other

Prime or Major Subcontractor FBR per hr

Subcontractor "A" FBR/hr*

Subcontractor "B" FBR/hr

Subcontractor "C" FBR/hr

Prime Burdens Rate /hr**

Subcontractor "A" FBR + Prime Burdened Rate/hr

Subcontractor "B" FBR + Prime Burdened Rate/hr

Subcontractor "C" FBR + Prime Burdened Rate/hr

% Usage Prime

% Usage Subcontractor "A"

% Usage Subcontractor "B"

% Usage Subcontractor "C"

Prime & Sub FBR /hr***

Prime & Sub FBR /hr

Link From EPM Tab:

IRAP Tab

OHT Tab

GAT Tab

EXAMPLE: Engineer II

26.72

36.78%

9.83

7.50%

2.74

- 0

39.28

Major Subcontractors Stop Here.

$ 59.50

$ 72.68

$ - 0

6.00%

$ 63.07

$ 77.04

$ - 0

80.00%

12.00%

8.00%

0.00%

$ 45.16

$ - 0

Accountant I

Accountant II

Accountant III

Accountant IV

Administrative Support I

Administrative Support II

Administrative Support III

Aircraft Mechanic I

Aircraft Mechanic II

Aircraft Mechanic III

Chief Engineer, Aviation Safety Office

Contract Manager

Data Analyst

Designer

Documentation Specialist

Duty Officer

Engineer I

Engineer II

Engineer III

Engineering Team Lead

Executive Manager

Flight Engineer

Forward Operating Location (FOL) Supervisor

Ground and Simulator Instructor

Loadmaster

Logistics Coordinator

Logistics Liason

Logistics Manager

Maintenance Controller

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 Nov 14, 2017.