8_Contractor_Pricing_Submission_SbAST.xls

XLS spreadsheet 154 KB Posted Aug 31, 2009

Attached to: Small Business Acquisition & Sustainment Tool (SbAST) Federal contract opportunity
Solicitation number: fa8530-09-R-22309
Issued by: Department of the Air Force Materiel Command Lifecycle Management Center Robins Air Force Base

About this file

From the source

Contractor Pricing Submission

View the file

Other files for this federal contract opportunity

Other files attached to Small Business Acquisition & Sustainment Tool (SbAST), newest first.
File	Type	Posted
Questions and Answers 28 June 2010.pdf	PDF	Jun 28, 2010
Questions and Answers 16.pdf	PDF	May 18, 2010
Questions and Answers 20 Jan 2010.pdf	PDF	Jan 20, 2010
Questions and Answers 13 Jan 2010.pdf	PDF	Jan 13, 2010
Questions and Answers 19 Nov 2009.pdf	PDF	Nov 19, 2009
Questions and Answers 16 November 2009.pdf	PDF	Nov 16, 2009
Questions and Answers 12 Nov 2009.pdf	PDF	Nov 12, 2009
2_CDRLS_SbAST.pdf	PDF	Nov 6, 2009
FA853009R22309______0002.pdf	PDF	Nov 6, 2009
16_Appendix C_SbAST.doc	DOC document	Nov 6, 2009
8_Contractor_Pricing_Submission_SbAST.xls	XLS spreadsheet	Nov 6, 2009
15_TEP Calculation Example_SbAST.pdf	PDF	Nov 6, 2009
Questions and Answers 3 Nov 2009.pdf	PDF	Nov 3, 2009
FA853009R22309______0003.pdf	PDF	Oct 30, 2009
Questions and Answers 29 Oct 2009.pdf	PDF	Oct 29, 2009
Questions and Answers 28 Oct 2009.pdf	PDF	Oct 28, 2009
Questions and Answers 23 Oct 2009.pdf	PDF	Oct 23, 2009
FA853009R22309______0001.pdf	PDF	Oct 20, 2009
Questions and Answers 20 Oct 2009.pdf	PDF	Oct 20, 2009
Questions and Answers 25 Sept 2009.pdf	PDF	Sep 25, 2009
Questions and Answers 16 Sept 2009.pdf	PDF	Sep 16, 2009
Interested Parties.pdf	PDF	Sep 14, 2009
Questions and Answers 14 Sept 2009.pdf	PDF	Sep 14, 2009
Questions and Answers 9 Sept 2009.pdf	PDF	Sep 9, 2009
Questions and Answers 3 Sept 2009.pdf	PDF	Sep 3, 2009
11_CDRL Attachment_SbAST.doc	DOC document	Aug 31, 2009
5_Reqts_Traceability_Matrix_SbAST.xls	XLS spreadsheet	Aug 31, 2009
FA853009R22309.pdf	PDF	Aug 31, 2009
4_Labor Categories_SbASTl.xls	XLS spreadsheet	Aug 31, 2009
3_DD254_SbAST.pdf	PDF	Aug 31, 2009
1_PWS_SbAST.doc	DOC document	Aug 31, 2009
12_Client Authorization Letter_SbAST.doc	DOC document	Aug 31, 2009
9_Clause Matrix_SbAST.xls	XLS spreadsheet	Aug 31, 2009
14 _FACT SHEET_Subcontractor_SbAST.DOC	DOC document	Aug 31, 2009
2_CDRLS_SbAST.pdf	PDF	Aug 31, 2009
10_ Subcontractor_Teaming_Consent_Form _SbAST.doc	DOC document	Aug 31, 2009
6_Minimum_Capabilities_Matrixes_SbAST.xls	XLS spreadsheet	Aug 31, 2009

Show all 37

On GovTribe

Work with this file on GovTribe

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

	INSTRUCTIONS AND ADDITIONAL INFORMATION FOR THE NTE FFP LABOR RATES, NTE T&M RATES, AND THE NTE FACTORS
		INSTRUCTIONS AND TEP WORKSHEETS
1	THE OFFERORS PRICING WORKSHEETS CONSIST OF THE FOLLOWING WORKSHEETS: (1) LABOR_WKLD_MAT_DIST%
	(2) PRIME_ADDON_FACTORS (3) PRIME_FP_RATE_SHEET (4) PRIME_T&M_LH_RATE_SHEET (5) SUB_ADDON_FACTORS
	(6) SUB_FP_RATE_SHEET (7) SUB_T&M_LH_RATE_SHEET. THE OFFEROR MUST COMPLETE ALL SEVEN WORKSHEETS .
	THE OFFEROR MUST SUBMIT SEPARATE LABOR RATE SPREADSHEETS AS FOLLOWS: ONE (1) FOR THE PRIME
	CONTRACTOR AND ONE (1) SPREADSHEET REFLECTING COMPOSITE RATES COMPRISING ALL CRITICAL SUBCONTRACTORS
	AND NO MORE THAN ONE NON-CRITICAL SUBCONTRACTOR AS DEFINED IN RFP CLAUSE L-900 (2) (f) (iii).
2	THE FFP LABOR RATES WILL BE LOADED LABOR RATES; INCLUDING LABOR OVERHEAD; G&A, AND COST OF MONEY,
	EXCLUDING PROFIT OR FEE. THESE RATES WILL BE FIXED THROUGH THE COST LINE. FOR EACH LABOR CATEGORY,
	IT IS ANTICIPATED THAT THE PROPOSED FP AND T&M/LH RATES WILL BE THE SAME THROUGH THE COST LINE.
	T&M/LH RATES WILL BE FULLY LOADED LABOR RATES; INCLUDING LABOR OVERHEAD, G&A, COST OF MONEY, AND FEE.
3	THE OFFEROR WILL POPULATE THE PRIME'S NOT TO EXCEED (NTE) FFP LABOR RATES ON THE PRIME-FP_RATE_SHEET.
	THE OFFEROR WILL POPULATE THE SUBCONTRACTOR COMPOSITE NOT TO EXCEED (NTE) FFP LABOR RATES ON THE
	SUB_FP_RATE_SHEET. NOTE: FP LABOR RATES WILL BE LOADED LABOR RATES; INCLUDING LABOR OVERHEAD, G&A,
	AND COST OF MONEY, EXCLUDING PROFIT OR FEE.
4	THE OFFEROR WILL POPULATE THE PRIME'S NOT TO EXCEED (NTE) T&M/LH LABOR RATES ON THE PRIME_T&M_LH_RATE_SHEET.
	THE OFFEROR WILL POPULATE THE SUBCONTRACTOR COMPOSITE NOT TO EXCEED (NTE) T&M/LH LABOR RATES ON THE
	SUB_T&M_LH_RATE_SHEET. NOTE: T&M/LH RATES WILL BE FULLY LOADED RATES, INCLUDING LABOR OVERHEAD, G&A,
	COST OF MONEY, AND FEE.
5	OFFEROR WILL POPULATE THE LABOR_WKLD_MAT_DIST% WORKSHEET WITH PERCENTAGE OF WORKLOAD AND
	MATERIAL DISTRIBUTION BETWEEN PRIME AND A COMPOSITE OF SUBCONTRACTOR TEAM MEMBERS. THE OFFEROR
	WILL FILL IN EACH LABOR CATEGORY WITH A PERCENTAGE ESTIMATE OF HOW MUCH FP AND T&M/LH LABOR AND
	MATERIAL WILL BE REQUIRED BETWEEN PRIME AND SUBCONTRACTOR COMPOSITE TO MEET ALL PROGRAM
	REQUIREMENTS.NOTE: TOTAL PERCENTAGE AMOUNT FOR EACH LABOR CATEGORY AND MATERIAL DISTRIBUTION MUST
	ADD UP TO 100%.
6	OFFEROR WILL POPULATE THE PRIME_ADDON_FACTOR AND SUB_ADDON_FACTOR WORKSHEETS WITH THEIR ADDON
	FACTORS FOR MATERIAL HANDLING AND SUBCONTRACTOR ADDON FACTORS. THESE FACTORS WILL BE USED TO
	CALCULATE THE NTE TEP.
7	THE GOVERNMENT'S NOTIONAL HOURS USED IN THE TEP COMPUTATION WILL NOT BE FURNISHED TO THE OFFERORS.
	THE TOTAL EVALUATED PRICE WILL BE COMPUTED BY THE GOVERNMENT; IT WILL NOT BE DEVELOPED BY THE OFFEROR
	THE OFFEROR ONLY NEED TO POPULATE THEIR PROPOSED WORK LOAD/MATERIAL DISTRIBUTION PERCENTAGES,
	ADD-ON FACTORS, FIXED-PRICE AND TIME & MATERIAL/LABOR HOUR LABOR RATES.

Labor_Wkld_Mat_Dist%

Note:	Decimal may not extend beyond 1 decimal place.
	The total for the prime plus all subcontracts must equal 100% for each Labor Category and the Material Distribution.
	This spreadsheet may not be modified in any fashion. (Only populate cells under % and do not rename worksheet.)
				FP		T&M/LH
		Labor Category	Level	Prime %	Sub %	Prime %	Sub %
1	LC-1	Electronic Technician	1
2	LC-1	Electronic Technician	2
3	LC-1	Electronic Technician	3
4	LC-2	Electrical Assembler
5	LC-3	Mechanical Technician	1
6	LC-3	Mechanical Technician	2
7	LC-3	Mechanical Technician	3
8	LC-4	Engineering Technician	1
9	LC-4	Engineering Technician	2
10	LC-4	Engineering Technician	3
11	LC-5	Aircraft Avionics Technician	1
12	LC-5	Aircraft Avionics Technician	2
13	LC-5	Aircraft Avionics Technician	3
14	LC-6	Supply Technician
15	LC-7	Computer Resources Manager Specialist
16	LC-8	Engineering Data Specialist
17	LC-9	Engineering Data Management Specialist
18	LC-10	Configuration Control Technician
19	LC-11	Draftsman / CAD Operator
20	LC-12	Drafting Technician
21	LC-13	Data Entry Clerk
22	LC-14	Documentation / Technical Writer
23	LC-15	Librarian
24	LC-16	Sheet Metal Mechanic
25	LC-17	Aircraft Mechanic
26	LC-18	Master Machinist
27	LC-19	Machinist
28	LC-20	Sheet Metal Mechanic
29	LC-21	Flight Line Attendant
30	LC-22	Painter
31	LC-23	Depainter, Aircraft & Components
32	LC-24	Tool & Parts Attendant
33	LC-25	Computer System Analyst	1
34	LC-25	Computer System Analyst	2
35	LC-26	Computer Scientist	1
36	LC-26	Computer Scientist	2
37	LC-26	Computer Scientist	3
38	LC-27	Database Architect / Manager
39	LC-28	Database Specialist
40	LC-29	Computer Programmer
41	LC-30	Engineer, Quality Assurance	1
42	LC-30	Engineer, Quality Assurance	2
43	LC-30	Engineer, Quality Assurance	3
44	LC-31	Engineer, Reliability and Maintainability	1
45	LC-31	Engineer, Reliability and Maintainability	2
46	LC-31	Engineer, Reliability and Maintainability	3
47	LC-32	Engineer, Aerospace	1
48	LC-32	Engineer, Aerospace	2
49	LC-32	Engineer, Aerospace	3
50	LC-33	Engineer, Computer	1
51	LC-33	Engineer, Computer	2
52	LC-33	Engineer, Computer	3
53	LC-34	Engineer, Computer Systems	1
54	LC-34	Engineer, Computer Systems	2
55	LC-34	Engineer, Computer Systems	3
56	LC-35	Engineer, Electrical	1
57	LC-35	Engineer, Electrical	2
58	LC-35	Engineer, Electrical	3
59	LC-36	Engineer, Electronics	1
60	LC-36	Engineer, Electronics	2
61	LC-36	Engineer, Electronics	3
62	LC-37	Engineer, Environmental	1
63	LC-37	Engineer, Environmental	2
64	LC-37	Engineer, Environmental	3
65	LC-38	Engineer, Industrial	1
66	LC-38	Engineer, Industrial	2
67	LC-38	Engineer, Industrial	3
68	LC-39	Engineer, General	1
69	LC-39	Engineer, General	2
70	LC-39	Engineer, General	3
71	LC-40	Engineer, Materials	1
72	LC-40	Engineer, Materials	2
73	LC-40	Engineer, Materials	3
74	LC-41	Engineer, Mechanical	1
75	LC-41	Engineer, Mechanical	2
76	LC-41	Engineer, Mechanical	3
77	LC-42	Engineer, Mechanical, Ground Vehicle	1
78	LC-42	Engineer, Mechanical, Ground Vehicle	2
79	LC-42	Engineer, Mechanical, Ground Vehicle	3
80	LC-43	Engineer, Manufacturing	1
81	LC-43	Engineer, Manufacturing	2
82	LC-43	Engineer, Manufacturing	3
83	LC-44	Engineer, Logistics	1
84	LC-44	Engineer, Logistics	2
85	LC-44	Engineer, Logistics	3
86	LC-45	Engineer, Software	1
87	LC-45	Engineer, Software	2
88	LC-45	Engineer, Software	3
89	LC-46	Engineer, Specification	1
90	LC-46	Engineer, Specification	2
91	LC-46	Engineer, Specification	3
92	LC-47	Engineer, System	1
93	LC-47	Engineer, System	2
94	LC-47	Engineer, System	3
95	LC-48	Engineer, Test	1
96	LC-48	Engineer, Test	2
97	LC-48	Engineer, Test	3
98	LC-49	Engineer, Test, Non-Destructive	1
99	LC-49	Engineer, Test, Non-Destructive	2
100	LC-49	Engineer, Test, Non-Destructive	3
101	LC-50	Integrated Logistics Support (ILS) Specialist
102	LC-51	Logistician
103	LC-52	Manager, Contract / Subcontract
104	LC-53	Manager, Finance
105	LC-54	Manager, ILS
106	LC-55	Manager, Program
107	LC-56	Quality Assurance Specialist
108	LC-57	Manager, Design Configuration
109	LC-58	Program Manager, Technical Data
110	LC-59	Project Leader, Technical Data
111	LC-60	Management Assistant
112	LC-61	Senior Technical Writer/Editor
113	LC-62	Technical Writer/Editor
114	LC-63	Associate Technical Writer/Editor
115	LC-64	Quality Control Manager
116	LC-65	Quality Control Technician
117	LC-66	Senior Technical Illustrator
118	LC-67	Technical Illustrator
119	LC-68	Associate Technical Illustrator
120	LC-69	Database Administrator
121	LC-70	Data Entry Technician
122	LC-71	Senior Configuration Data Management Specialist (Tech Manual Management Officer {TMMO})
123	LC-72	Configuration Data Management Specialist
124	LC-73	Technical Content Configuration Manager
125	LC-74	Senior Distribution and Storage Management Specialist
126	LC-75	Distribution and Storage Management Specialist
127	LC-76	System Administrator
128	LC-77	Computer Specialist
129	LC-78	Technical Order Librarian
130	LC-79	Loadmaster
131	LC-80	Flight Engineer
132	LC-81	Navigator
133	LC-82	Co-pilot
134	LC-83	Pilot
135	LC-84	Functional/Operational Check Flight Pilot
136		Material Distribution %

Prime_AddOn_Factors

Contractor Name:
Contractor Address:
Contractor Address:
Note:	Decimal may not extend beyond 4 decimal places.
	This spreadsheet may not be modified in any fashion. (Only populate cells under each year and do not rename worksheet.)
Contract Type	Factor	Year 1 Factor	Year 2 Factor	Year 3 Factor	Year 4 Factor	Year 5 Factor	Year 6 Factor	Year 7 Factor
FP	Material Handling
FP	Subcontractor Add-On
T&M/LH	Subcontractor Add-On
FP	Overtime
T&M/LH	Overtime
FP	Crisis Pay
T&M/LH	Crisis Pay
	OCONUS Adjustment Factors:
1	Germany
2	Western Europe, Excluding Germany
3	England
4	Middle East
5	Mediterranean Region
6	Central/South America
7	Far East
8	Hawaii
9	Alaska
Material Handling, Crisis Pay, and Overtime Factors: These factors shall apply against material, crisis pay, and/or overtime. These factors should incorporate all normal charges (including, but not limited to, G&A and Cost of Money, etc.) allowed for these specific costs. Fee/profit will be proposed at the D/TO level for FP/LH and CR orders; therefore, FP/LH and CR factors should not include any fee/profit.
Subcontractor Add-On Factor: This factor shall apply against subcontracted costs. This factor should incorporate all normal charges (including, but not limited to, G&A and Cost of Money, etc.) allowed for these specific charges. Fee/profit will be proposed at the D/TO level for FP/LH and CR orders; therefore, FP/LH and CR factors should not include any fee/profit.
OCONUS Adjustment Factor: These factors shall apply against OCONUS labor. These factors should incorporate any unique charges allowable for these specific costs. Fee/profit will be proposed at the D/TO level for FP/LH and CR orders; therefore, FP/LH and CR factors should not include any fee/profit.

Prime_FP_Rate_Sheet

		Labor Category (Prime-JV Rates)	Level	Year 1	Year 2	Year 3	Year 4	Year 5
1	LC-1	Electronic Technician	1
2	LC-1	Electronic Technician	2
3	LC-1	Electronic Technician	3
4	LC-2	Electrical Assembler
5	LC-3	Mechanical Technician	1
6	LC-3	Mechanical Technician	2
7	LC-3	Mechanical Technician	3
8	LC-4	Engineering Technician	1
9	LC-4	Engineering Technician	2
10	LC-4	Engineering Technician	3
11	LC-5	Aircraft Avionics Technician	1
12	LC-5	Aircraft Avionics Technician	2
13	LC-5	Aircraft Avionics Technician	3
14	LC-6	Supply Technician
15	LC-7	Computer Resources Manager Specialist
16	LC-8	Engineering Data Specialist
17	LC-9	Engineering Data Management Specialist
18	LC-10	Configuration Control Technician
19	LC-11	Draftsman / CAD Operator
20	LC-12	Drafting Technician
21	LC-13	Data Entry Clerk
22	LC-14	Documentation / Technical Writer
23	LC-15	Librarian
24	LC-16	Sheet Metal Mechanic
25	LC-17	Aircraft Mechanic
26	LC-18	Master Machinist
27	LC-19	Machinist
28	LC-20	Sheet Metal Mechanic
29	LC-21	Flight Line Attendant
30	LC-22	Painter
31	LC-23	Depainter, Aircraft & Components
32	LC-24	Tool & Parts Attendant
33	LC-25	Computer System Analyst	1
34	LC-25	Computer System Analyst	2
35	LC-26	Computer Scientist	1
36	LC-26	Computer Scientist	2
37	LC-26	Computer Scientist	3
38	LC-27	Database Architect / Manager
39	LC-28	Database Specialist
40	LC-29	Computer Programmer
41	LC-30	Engineer, Quality Assurance	1
42	LC-30	Engineer, Quality Assurance	2
43	LC-30	Engineer, Quality Assurance	3
44	LC-31	Engineer, Reliability and Maintainability	1
45	LC-31	Engineer, Reliability and Maintainability	2
46	LC-31	Engineer, Reliability and Maintainability	3
47	LC-32	Engineer, Aerospace	1
48	LC-32	Engineer, Aerospace	2
49	LC-32	Engineer, Aerospace	3
50	LC-33	Engineer, Computer	1
51	LC-33	Engineer, Computer	2
52	LC-33	Engineer, Computer	3
53	LC-34	Engineer, Computer Systems	1
54	LC-34	Engineer, Computer Systems	2
55	LC-34	Engineer, Computer Systems	3
56	LC-35	Engineer, Electrical	1
57	LC-35	Engineer, Electrical	2
58	LC-35	Engineer, Electrical	3
59	LC-36	Engineer, Electronics	1
60	LC-36	Engineer, Electronics	2
61	LC-36	Engineer, Electronics	3
62	LC-37	Engineer, Environmental	1
63	LC-37	Engineer, Environmental	2
64	LC-37	Engineer, Environmental	3
65	LC-38	Engineer, Industrial	1
66	LC-38	Engineer, Industrial	2
67	LC-38	Engineer, Industrial	3
68	LC-39	Engineer, General	1
69	LC-39	Engineer, General	2
70	LC-39	Engineer, General	3
71	LC-40	Engineer, Materials	1
72	LC-40	Engineer, Materials	2
73	LC-40	Engineer, Materials	3
74	LC-41	Engineer, Mechanical	1
75	LC-41	Engineer, Mechanical	2
76	LC-41	Engineer, Mechanical	3
77	LC-42	Engineer, Mechanical, Ground Vehicle	1
78	LC-42	Engineer, Mechanical, Ground Vehicle	2
79	LC-42	Engineer, Mechanical, Ground Vehicle	3
80	LC-43	Engineer, Manufacturing	1
81	LC-43	Engineer, Manufacturing	2
82	LC-43	Engineer, Manufacturing	3
83	LC-44	Engineer, Logistics	1
84	LC-44	Engineer, Logistics	2
85	LC-44	Engineer, Logistics	3
86	LC-45	Engineer, Software	1
87	LC-45	Engineer, Software	2
88	LC-45	Engineer, Software	3
89	LC-46	Engineer, Specification	1
90	LC-46	Engineer, Specification	2
91	LC-46	Engineer, Specification	3
92	LC-47	Engineer, System	1
93	LC-47	Engineer, System	2
94	LC-47	Engineer, System	3
95	LC-48	Engineer, Test	1
96	LC-48	Engineer, Test	2
97	LC-48	Engineer, Test	3
98	LC-49	Engineer, Test, Non-Destructive	1
99	LC-49	Engineer, Test, Non-Destructive	2
100	LC-49	Engineer, Test, Non-Destructive	3
101	LC-50	Integrated Logistics Support (ILS) Specialist
102	LC-51	Logistician
103	LC-52	Manager, Contract / Subcontract
104	LC-53	Manager, Finance
105	LC-54	Manager, ILS
106	LC-55	Manager, Program
107	LC-56	Quality Assurance Specialist
108	LC-57	Manager, Design Configuration
109	LC-58	Program Manager, Technical Data
110	LC-59	Project Leader, Technical Data
111	LC-60	Management Assistant
112	LC-61	Senior Technical Writer/Editor
113	LC-62	Technical Writer/Editor
114	LC-63	Associate Technical Writer/Editor
115	LC-64	Quality Control Manager
116	LC-65	Quality Control Technician
117	LC-66	Senior Technical Illustrator
118	LC-67	Technical Illustrator
119	LC-68	Associate Technical Illustrator
120	LC-69	Database Administrator
121	LC-70	Data Entry Technician
122	LC-71	Senior Configuration Data Management Specialist (Tech Manual Management Officer {TMMO})
123	LC-72	Configuration Data Management Specialist
124	LC-73	Technical Content Configuration Manager
125	LC-74	Senior Distribution and Storage Management Specialist
126	LC-75	Distribution and Storage Management Specialist
127	LC-76	System Administrator
128	LC-77	Computer Specialist
129	LC-78	Technical Order Librarian
130	LC-79	Loadmaster
131	LC-80	Flight Engineer
132	LC-81	Navigator
133	LC-82	Co-pilot
134	LC-83	Pilot
135	LC-84	Functional/Operational Check Flight Pilot

&C&"Arial,Bold"&20&A

Prime_T&M_LH_Rate_Sheet

		Labor Category (Prime-JV Rates)	Level	Year 1	Year 2	Year 3	Year 4	Year 5
1	LC-1	Electronic Technician	1
2	LC-1	Electronic Technician	2
3	LC-1	Electronic Technician	3
4	LC-2	Electrical Assembler
5	LC-3	Mechanical Technician	1
6	LC-3	Mechanical Technician	2
7	LC-3	Mechanical Technician	3
8	LC-4	Engineering Technician	1
9	LC-4	Engineering Technician	2
10	LC-4	Engineering Technician	3
11	LC-5	Aircraft Avionics Technician	1
12	LC-5	Aircraft Avionics Technician	2
13	LC-5	Aircraft Avionics Technician	3
14	LC-6	Supply Technician
15	LC-7	Computer Resources Manager Specialist
16	LC-8	Engineering Data Specialist
17	LC-9	Engineering Data Management Specialist
18	LC-10	Configuration Control Technician
19	LC-11	Draftsman / CAD Operator
20	LC-12	Drafting Technician
21	LC-13	Data Entry Clerk
22	LC-14	Documentation / Technical Writer
23	LC-15	Librarian
24	LC-16	Sheet Metal Mechanic
25	LC-17	Aircraft Mechanic
26	LC-18	Master Machinist
27	LC-19	Machinist
28	LC-20	Sheet Metal Mechanic
29	LC-21	Flight Line Attendant
30	LC-22	Painter
31	LC-23	Depainter, Aircraft & Components
32	LC-24	Tool & Parts Attendant
33	LC-25	Computer System Analyst	1
34	LC-25	Computer System Analyst	2
35	LC-26	Computer Scientist	1
36	LC-26	Computer Scientist	2
37	LC-26	Computer Scientist	3
38	LC-27	Database Architect / Manager
39	LC-28	Database Specialist
40	LC-29	Computer Programmer
41	LC-30	Engineer, Quality Assurance	1
42	LC-30	Engineer, Quality Assurance	2
43	LC-30	Engineer, Quality Assurance	3
44	LC-31	Engineer, Reliability and Maintainability	1
45	LC-31	Engineer, Reliability and Maintainability	2
46	LC-31	Engineer, Reliability and Maintainability	3
47	LC-32	Engineer, Aerospace	1
48	LC-32	Engineer, Aerospace	2
49	LC-32	Engineer, Aerospace	3
50	LC-33	Engineer, Computer	1
51	LC-33	Engineer, Computer	2
52	LC-33	Engineer, Computer	3
53	LC-34	Engineer, Computer Systems	1
54	LC-34	Engineer, Computer Systems	2
55	LC-34	Engineer, Computer Systems	3
56	LC-35	Engineer, Electrical	1
57	LC-35	Engineer, Electrical	2
58	LC-35	Engineer, Electrical	3
59	LC-36	Engineer, Electronics	1
60	LC-36	Engineer, Electronics	2
61	LC-36	Engineer, Electronics	3
62	LC-37	Engineer, Environmental	1
63	LC-37	Engineer, Environmental	2
64	LC-37	Engineer, Environmental	3
65	LC-38	Engineer, Industrial	1
66	LC-38	Engineer, Industrial	2
67	LC-38	Engineer, Industrial	3
68	LC-39	Engineer, General	1
69	LC-39	Engineer, General	2
70	LC-39	Engineer, General	3
71	LC-40	Engineer, Materials	1
72	LC-40	Engineer, Materials	2
73	LC-40	Engineer, Materials	3
74	LC-41	Engineer, Mechanical	1
75	LC-41	Engineer, Mechanical	2
76	LC-41	Engineer, Mechanical	3
77	LC-42	Engineer, Mechanical, Ground Vehicle	1
78	LC-42	Engineer, Mechanical, Ground Vehicle	2
79	LC-42	Engineer, Mechanical, Ground Vehicle	3
80	LC-43	Engineer, Manufacturing	1
81	LC-43	Engineer, Manufacturing	2
82	LC-43	Engineer, Manufacturing	3
83	LC-44	Engineer, Logistics	1
84	LC-44	Engineer, Logistics	2
85	LC-44	Engineer, Logistics	3
86	LC-45	Engineer, Software	1
87	LC-45	Engineer, Software	2
88	LC-45	Engineer, Software	3
89	LC-46	Engineer, Specification	1
90	LC-46	Engineer, Specification	2
91	LC-46	Engineer, Specification	3
92	LC-47	Engineer, System	1
93	LC-47	Engineer, System	2
94	LC-47	Engineer, System	3
95	LC-48	Engineer, Test	1
96	LC-48	Engineer, Test	2
97	LC-48	Engineer, Test	3
98	LC-49	Engineer, Test, Non-Destructive	1
99	LC-49	Engineer, Test, Non-Destructive	2
100	LC-49	Engineer, Test, Non-Destructive	3
101	LC-50	Integrated Logistics Support (ILS) Specialist
102	LC-51	Logistician
103	LC-52	Manager, Contract / Subcontract
104	LC-53	Manager, Finance
105	LC-54	Manager, ILS
106	LC-55	Manager, Program
107	LC-56	Quality Assurance Specialist
108	LC-57	Manager, Design Configuration
109	LC-58	Program Manager, Technical Data
110	LC-59	Project Leader, Technical Data
111	LC-60	Management Assistant
112	LC-61	Senior Technical Writer/Editor
113	LC-62	Technical Writer/Editor
114	LC-63	Associate Technical Writer/Editor
115	LC-64	Quality Control Manager
116	LC-65	Quality Control Technician
117	LC-66	Senior Technical Illustrator
118	LC-67	Technical Illustrator
119	LC-68	Associate Technical Illustrator
120	LC-69	Database Administrator
121	LC-70	Data Entry Technician
122	LC-71	Senior Configuration Data Management Specialist (Tech Manual Management Officer {TMMO})
123	LC-72	Configuration Data Management Specialist
124	LC-73	Technical Content Configuration Manager
125	LC-74	Senior Distribution and Storage Management Specialist
126	LC-75	Distribution and Storage Management Specialist
127	LC-76	System Administrator
128	LC-77	Computer Specialist
129	LC-78	Technical Order Librarian
130	LC-79	Loadmaster
131	LC-80	Flight Engineer
132	LC-81	Navigator
133	LC-82	Co-pilot
134	LC-83	Pilot
135	LC-84	Functional/Operational Check Flight Pilot

&C&"Arial,Bold"&20&A

Sub_AddOn_Factors

Contractor Name:
Contractor Address:
Contractor Address:
Note:	Decimal may not extend beyond 4 decimal places.
	This spreadsheet may not be modified in any fashion. (Only populate cells under each year and do not rename worksheet.)
Contract Type	Factor	Year 1 Factor	Year 2 Factor	Year 3 Factor	Year 4 Factor	Year 5 Factor	Year 6 Factor	Year 7 Factor
FP	Material Handling
FP	Subcontractor Add-On
T&M/LH	Subcontractor Add-On
FP	Overtime
T&M/LH	Overtime
FP	Crisis Pay
T&M/LH	Crisis Pay
	OCONUS Adjustment Factors:
1	Germany
2	Western Europe, Excluding Germany
3	England
4	Middle East
5	Mediterranean Region
6	Central/South America
7	Far East
8	Hawaii
9	Alaska
Material Handling, Crisis Pay, and Overtime Factors: These factors shall apply against material, crisis pay, and/or overtime. These factors should incorporate all normal charges (including, but not limited to, G&A and Cost of Money, etc.) allowed for these specific costs. Fee/profit will be proposed at the D/TO level for FP/LH and CR orders; therefore, FP/LH and CR factors should not include any fee/profit.
Subcontractor Add-On Factor: This factor shall apply against subcontracted costs. This factor should incorporate all normal charges (including, but not limited to, G&A and Cost of Money, etc.) allowed for these specific charges. Fee/profit will be proposed at the D/TO level for FP/LH and CR orders; therefore, FP/LH and CR factors should not include any fee/profit.
OCONUS Adjustment Factor: These factors shall apply against OCONUS labor. These factors should incorporate any unique charges allowable for these specific costs. Fee/profit will be proposed at the D/TO level for FP/LH and CR orders; therefore, FP/LH and CR factors should not include any fee/profit.

Sub_FP_Rate_Sheet

		Labor Category (Sub Rates)	Level	Year 1	Year 2	Year 3	Year 4	Year 5
1	LC-1	Electronic Technician	1
2	LC-1	Electronic Technician	2
3	LC-1	Electronic Technician	3
4	LC-2	Electrical Assembler
5	LC-3	Mechanical Technician	1
6	LC-3	Mechanical Technician	2
7	LC-3	Mechanical Technician	3
8	LC-4	Engineering Technician	1
9	LC-4	Engineering Technician	2
10	LC-4	Engineering Technician	3
11	LC-5	Aircraft Avionics Technician	1
12	LC-5	Aircraft Avionics Technician	2
13	LC-5	Aircraft Avionics Technician	3
14	LC-6	Supply Technician
15	LC-7	Computer Resources Manager Specialist
16	LC-8	Engineering Data Specialist
17	LC-9	Engineering Data Management Specialist
18	LC-10	Configuration Control Technician
19	LC-11	Draftsman / CAD Operator
20	LC-12	Drafting Technician
21	LC-13	Data Entry Clerk
22	LC-14	Documentation / Technical Writer
23	LC-15	Librarian
24	LC-16	Sheet Metal Mechanic
25	LC-17	Aircraft Mechanic
26	LC-18	Master Machinist
27	LC-19	Machinist
28	LC-20	Sheet Metal Mechanic
29	LC-21	Flight Line Attendant
30	LC-22	Painter
31	LC-23	Depainter, Aircraft & Components
32	LC-24	Tool & Parts Attendant
33	LC-25	Computer System Analyst	1
34	LC-25	Computer System Analyst	2
35	LC-26	Computer Scientist	1
36	LC-26	Computer Scientist	2
37	LC-26	Computer Scientist	3
38	LC-27	Database Architect / Manager
39	LC-28	Database Specialist
40	LC-29	Computer Programmer
41	LC-30	Engineer, Quality Assurance	1
42	LC-30	Engineer, Quality Assurance	2
43	LC-30	Engineer, Quality Assurance	3
44	LC-31	Engineer, Reliability and Maintainability	1
45	LC-31	Engineer, Reliability and Maintainability	2
46	LC-31	Engineer, Reliability and Maintainability	3
47	LC-32	Engineer, Aerospace	1
48	LC-32	Engineer, Aerospace	2
49	LC-32	Engineer, Aerospace	3
50	LC-33	Engineer, Computer	1
51	LC-33	Engineer, Computer	2
52	LC-33	Engineer, Computer	3
53	LC-34	Engineer, Computer Systems	1
54	LC-34	Engineer, Computer Systems	2
55	LC-34	Engineer, Computer Systems	3
56	LC-35	Engineer, Electrical	1
57	LC-35	Engineer, Electrical	2
58	LC-35	Engineer, Electrical	3
59	LC-36	Engineer, Electronics	1
60	LC-36	Engineer, Electronics	2
61	LC-36	Engineer, Electronics	3
62	LC-37	Engineer, Environmental	1
63	LC-37	Engineer, Environmental	2
64	LC-37	Engineer, Environmental	3
65	LC-38	Engineer, Industrial	1
66	LC-38	Engineer, Industrial	2
67	LC-38	Engineer, Industrial	3
68	LC-39	Engineer, General	1
69	LC-39	Engineer, General	2
70	LC-39	Engineer, General	3
71	LC-40	Engineer, Materials	1
72	LC-40	Engineer, Materials	2
73	LC-40	Engineer, Materials	3
74	LC-41	Engineer, Mechanical	1
75	LC-41	Engineer, Mechanical	2
76	LC-41	Engineer, Mechanical	3
77	LC-42	Engineer, Mechanical, Ground Vehicle	1
78	LC-42	Engineer, Mechanical, Ground Vehicle	2
79	LC-42	Engineer, Mechanical, Ground Vehicle	3
80	LC-43	Engineer, Manufacturing	1
81	LC-43	Engineer, Manufacturing	2
82	LC-43	Engineer, Manufacturing	3
83	LC-44	Engineer, Logistics	1
84	LC-44	Engineer, Logistics	2
85	LC-44	Engineer, Logistics	3
86	LC-45	Engineer, Software	1
87	LC-45	Engineer, Software	2
88	LC-45	Engineer, Software	3
89	LC-46	Engineer, Specification	1
90	LC-46	Engineer, Specification	2
91	LC-46	Engineer, Specification	3
92	LC-47	Engineer, System	1
93	LC-47	Engineer, System	2
94	LC-47	Engineer, System	3
95	LC-48	Engineer, Test	1
96	LC-48	Engineer, Test	2
97	LC-48	Engineer, Test	3
98	LC-49	Engineer, Test, Non-Destructive	1
99	LC-49	Engineer, Test, Non-Destructive	2
100	LC-49	Engineer, Test, Non-Destructive	3
101	LC-50	Integrated Logistics Support (ILS) Specialist
102	LC-51	Logistician
103	LC-52	Manager, Contract / Subcontract
104	LC-53	Manager, Finance
105	LC-54	Manager, ILS
106	LC-55	Manager, Program
107	LC-56	Quality Assurance Specialist
108	LC-57	Manager, Design Configuration
109	LC-58	Program Manager, Technical Data
110	LC-59	Project Leader, Technical Data
111	LC-60	Management Assistant
112	LC-61	Senior Technical Writer/Editor
113	LC-62	Technical Writer/Editor
114	LC-63	Associate Technical Writer/Editor
115	LC-64	Quality Control Manager
116	LC-65	Quality Control Technician
117	LC-66	Senior Technical Illustrator
118	LC-67	Technical Illustrator
119	LC-68	Associate Technical Illustrator
120	LC-69	Database Administrator
121	LC-70	Data Entry Technician
122	LC-71	Senior Configuration Data Management Specialist (Tech Manual Management Officer {TMMO})
123	LC-72	Configuration Data Management Specialist
124	LC-73	Technical Content Configuration Manager
125	LC-74	Senior Distribution and Storage Management Specialist
126	LC-75	Distribution and Storage Management Specialist
127	LC-76	System Administrator
128	LC-77	Computer Specialist
129	LC-78	Technical Order Librarian
130	LC-79	Loadmaster
131	LC-80	Flight Engineer
132	LC-81	Navigator
133	LC-82	Co-pilot
134	LC-83	Pilot
135	LC-84	Functional/Operational Check Flight Pilot

&C&"Arial,Bold"&20&A

Sub_T&M_LH_Rate_Sheet

		Labor Category (Sub Rates)	Level	Year 1	Year 2	Year 3	Year 4	Year 5
1	LC-1	Electronic Technician	1
2	LC-1	Electronic Technician	2
3	LC-1	Electronic Technician	3
4	LC-2	Electrical Assembler
5	LC-3	Mechanical Technician	1
6	LC-3	Mechanical Technician	2
7	LC-3	Mechanical Technician	3
8	LC-4	Engineering Technician	1
9	LC-4	Engineering Technician	2
10	LC-4	Engineering Technician	3
11	LC-5	Aircraft Avionics Technician	1
12	LC-5	Aircraft Avionics Technician	2
13	LC-5	Aircraft Avionics Technician	3
14	LC-6	Supply Technician
15	LC-7	Computer Resources Manager Specialist
16	LC-8	Engineering Data Specialist
17	LC-9	Engineering Data Management Specialist
18	LC-10	Configuration Control Technician
19	LC-11	Draftsman / CAD Operator
20	LC-12	Drafting Technician
21	LC-13	Data Entry Clerk
22	LC-14	Documentation / Technical Writer
23	LC-15	Librarian
24	LC-16	Sheet Metal Mechanic
25	LC-17	Aircraft Mechanic
26	LC-18	Master Machinist
27	LC-19	Machinist
28	LC-20	Sheet Metal Mechanic
29	LC-21	Flight Line Attendant
30	LC-22	Painter
31	LC-23	Depainter, Aircraft & Components
32	LC-24	Tool & Parts Attendant
33	LC-25	Computer System Analyst	1
34	LC-25	Computer System Analyst	2
35	LC-26	Computer Scientist	1
36	LC-26	Computer Scientist	2
37	LC-26	Computer Scientist	3
38	LC-27	Database Architect / Manager
39	LC-28	Database Specialist
40	LC-29	Computer Programmer
41	LC-30	Engineer, Quality Assurance	1
42	LC-30	Engineer, Quality Assurance	2
43	LC-30	Engineer, Quality Assurance	3
44	LC-31	Engineer, Reliability and Maintainability	1
45	LC-31	Engineer, Reliability and Maintainability	2
46	LC-31	Engineer, Reliability and Maintainability	3
47	LC-32	Engineer, Aerospace	1
48	LC-32	Engineer, Aerospace	2
49	LC-32	Engineer, Aerospace	3
50	LC-33	Engineer, Computer	1
51	LC-33	Engineer, Computer	2
52	LC-33	Engineer, Computer	3
53	LC-34	Engineer, Computer Systems	1
54	LC-34	Engineer, Computer Systems	2
55	LC-34	Engineer, Computer Systems	3
56	LC-35	Engineer, Electrical	1
57	LC-35	Engineer, Electrical	2
58	LC-35	Engineer, Electrical	3
59	LC-36	Engineer, Electronics	1
60	LC-36	Engineer, Electronics	2
61	LC-36	Engineer, Electronics	3
62	LC-37	Engineer, Environmental	1
63	LC-37	Engineer, Environmental	2
64	LC-37	Engineer, Environmental	3
65	LC-38	Engineer, Industrial	1
66	LC-38	Engineer, Industrial	2
67	LC-38	Engineer, Industrial	3
68	LC-39	Engineer, General	1
69	LC-39	Engineer, General	2
70	LC-39	Engineer, General	3
71	LC-40	Engineer, Materials	1
72	LC-40	Engineer, Materials	2
73	LC-40	Engineer, Materials	3
74	LC-41	Engineer, Mechanical	1
75	LC-41	Engineer, Mechanical	2
76	LC-41	Engineer, Mechanical	3
77	LC-42	Engineer, Mechanical, Ground Vehicle	1
78	LC-42	Engineer, Mechanical, Ground Vehicle	2
79	LC-42	Engineer, Mechanical, Ground Vehicle	3
80	LC-43	Engineer, Manufacturing	1
81	LC-43	Engineer, Manufacturing	2
82	LC-43	Engineer, Manufacturing	3
83	LC-44	Engineer, Logistics	1
84	LC-44	Engineer, Logistics	2
85	LC-44	Engineer, Logistics	3
86	LC-45	Engineer, Software	1
87	LC-45	Engineer, Software	2
88	LC-45	Engineer, Software	3
89	LC-46	Engineer, Specification	1
90	LC-46	Engineer, Specification	2
91	LC-46	Engineer, Specification	3
92	LC-47	Engineer, System	1
93	LC-47	Engineer, System	2
94	LC-47	Engineer, System	3
95	LC-48	Engineer, Test	1
96	LC-48	Engineer, Test	2
97	LC-48	Engineer, Test	3
98	LC-49	Engineer, Test, Non-Destructive	1
99	LC-49	Engineer, Test, Non-Destructive	2
100	LC-49	Engineer, Test, Non-Destructive	3
101	LC-50	Integrated Logistics Support (ILS) Specialist
102	LC-51	Logistician
103	LC-52	Manager, Contract / Subcontract
104	LC-53	Manager, Finance
105	LC-54	Manager, ILS
106	LC-55	Manager, Program
107	LC-56	Quality Assurance Specialist
108	LC-57	Manager, Design Configuration
109	LC-58	Program Manager, Technical Data
110	LC-59	Project Leader, Technical Data
111	LC-60	Management Assistant
112	LC-61	Senior Technical Writer/Editor
113	LC-62	Technical Writer/Editor
114	LC-63	Associate Technical Writer/Editor
115	LC-64	Quality Control Manager
116	LC-65	Quality Control Technician
117	LC-66	Senior Technical Illustrator
118	LC-67	Technical Illustrator
119	LC-68	Associate Technical Illustrator
120	LC-69	Database Administrator
121	LC-70	Data Entry Technician
122	LC-71	Senior Configuration Data Management Specialist (Tech Manual Management Officer {TMMO})
123	LC-72	Configuration Data Management Specialist
124	LC-73	Technical Content Configuration Manager
125	LC-74	Senior Distribution and Storage Management Specialist
126	LC-75	Distribution and Storage Management Specialist
127	LC-76	System Administrator
128	LC-77	Computer Specialist
129	LC-78	Technical Order Librarian
130	LC-79	Loadmaster
131	LC-80	Flight Engineer
132	LC-81	Navigator
133	LC-82	Co-pilot
134	LC-83	Pilot
135	LC-84	Functional/Operational Check Flight Pilot

&C&"Arial,Bold"&20&A

File details come from the government source that posted it. Updated Nov 14, 2017.