Attachment 0002 LSFS-1 Cost Price Template.xlsx

XLSX spreadsheet 122 KB Posted Jul 21, 2022

Attached to: ACC-RSA Logistic Support Facility Services (LSFS-1) Federal contract opportunity
Solicitation number: W58RGZ-22-R-0090
Issued by: Department of the Army Materiel Command Contracting Command Redstone Arsenal

View the file

Other files for this federal contract opportunity

Other files attached to ACC-RSA Logistic Support Facility Services (LSFS-1), newest first.
File	Type	Posted
Consolidated Draft RFP Questions_Answers-Responses_01Sep2022_Clean.pdf	PDF	Sep 19, 2022
W58RGZ-22-R-0090 DRAFT RFP Revised 25 Jul 2022.pdf	PDF	Jul 25, 2022
Exhibit A Contract Data Requirements List (CDRL).pdf	PDF	Jul 21, 2022
Attachment 0008 Section C - Description_Specification.pdf	PDF	Jul 21, 2022
Atttachment 0016 Pre-Award Survey of Prospective Contractor Accounting System Checklist.pdf	PDF	Jul 21, 2022
Attachment 0009 Past Performance Questionnaire.docx	DOCX document	Jul 21, 2022
Attachment 0005 LSFS-1 Labor Category Requirement.xlsx	XLSX spreadsheet	Jul 21, 2022
Attachment 0001 Document Summary List (DSL).pdf	PDF	Jul 21, 2022
Attachment 0007 Section M-Evaluation Factors for Award.pdf	PDF	Jul 21, 2022
Attachment 0003 DD254 Security Classification (Draft).pdf	PDF	Jul 21, 2022
W58RGZ-22-R-0090 DRAFT RFP.pdf	PDF	Jul 21, 2022
Attachment 0015 Cage Code and Cognizant DCMA_DCAA Info.xlsx	XLSX spreadsheet	Jul 21, 2022
Attachment 0014 Sample Order 2.pdf	PDF	Jul 21, 2022
Attachment 0013 Sample Order 1.pdf	PDF	Jul 21, 2022
Attachment 0012 LSFMA Performance Cost Report.pdf	PDF	Jul 21, 2022
Attachment 0011 Draft RFP Questions_Answers Form.xlsx	XLSX spreadsheet	Jul 21, 2022
Attachment 0010 Industry Questions.xlsx	XLSX spreadsheet	Jul 21, 2022
Attachment 0006 Section L- Instructions_ Conditions and Notices to Offerors.pdf	PDF	Jul 21, 2022
Attachment 0004 Performance Work Statement.pdf	PDF	Jul 21, 2022

Show all 19

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

On each TAB, enter the requested data in the yellow highlighted cells. The offeror may edit the worksheet to accomodate the offeror's normal accounting and estimating practices but the general format shall remain intact for evaluation and contract administration purposes. TABs have been pre-populated with formulas to aid the offeror in calculating the proposed price. The offeror is responsible for ensuring that all calculations within each TAB are accurate and reflective of the offeror's proposed price.

STEP 1	TAB CPFF Labor Category Mapping:	The labor category mapping is intended for use in populating the offeror's proposed base labor rates into the Prime CPFF Labor Rate Table.
		Instructions:
		1. Provide the offeror's contractor fiscal year (CFY) from and to dates.
		2. Provide the proposed mapping of RFP provided IDIQ labor categories to the offeror's contractor/corporate labor categories with minimum education and experience to demonstrate that the offeror is proposing qualified CPFF personnel for the effort. There are 75 rows available for detailing the offeror's contractor/corporate labor categories etc. If more than 75 rows are needed, insert additional rows ensuring the formulas for calculating the "Base Direct Labor Rates" are updated to include the added rows. Also, verify the added rows are included in the calculation of the total of the allocation percentages in the "Percentage Total" row at the bottom of the Labor Category Mapping Total.
		3. If a particular CPFF IDIQ labor category is a composite of more than one of the offeror’s contractor/corporate labor categories, the offeror shall provide the calculation of the composite with the assigned weightings, identifying percentages the contractor/corporate labor categories are anticipated to work in the RFP labor categories. If a particular CPFF IDIQ labor category is comprised of only one contractor/corporate labor category, the offeror shall provide the crosswalk to the offeror’s single contractor/corporate labor category and assign a weighting of 100 percent. Ensure the "Percentage Total" equals 100%. If a "No" is identified in the "Percentage Total = 100" row, ensure: (i)the allocation percentages are correctly identified to contractor/corporate labor categories and (ii)the calculation of the allocation percentage, in the "Percentage Total" row, includes any added rows.
		4. Provide the offeror's proposed base labor rate by contract year for every CPFF IDIQ labor category identified.
		5. The labor rates, identified in the "Base Direct Labor Rates" row shall be used to populate the Prime CPFF Labor Rate Table.

STEP 2	TAB Prime CPFF Labor Rate Table	The prime contractor's proposed direct labor base rates (unburdened labor rates) on CPFF orders shall not exceed the base labor rates by contract year/calendar year proposed as part of the basic IDIQ contract and as identified in this table. The Prime CPFF Labor Rate Table shall contain prime direct labor costs only. No subcontract costs or non-labor costs shall be included in the Labor Rate Tables.
		Instructions:
		1. Identify the applicable CFYs for proposed base labor rates and allocation by CFY used to calculate Calendar Year (CY) 2023 base labor rates.
		2. Provide the offeror's proposed escalation for each contract year.
		3. Input formulas into the worksheet to show how the CPFF base labor rates from the row "Base Direct Labor Rates" of TAB Category Mapping are utilized to calculate base labor rates by contract year. Formulas shall link the TAB Labor Category Mapping to TAB CPFF Labor Rate Table.
		4. This TAB has been prepopulated with formulas to apply the proposed base labor rate by IDIQ labor category to the RFP provided labor hours.

STEP 3	TAB Prime FFP Labor Rate Table	The prime contractor's proposed direct labor base rates (unburdened labor rates) on FFP orders shall not exceed the base labor rates by contract year proposed as part of the basic IDIQ contract and as identified in this table. The Prime FFP Labor Rate Table shall contain prime direct labor costs only. No subcontract costs or non-labor costs shall be included in the Labor Rate Tables.
		Instructions:
		1. Provide the offeror's proposed base labor rate by contract year for every FFP IDIQ labor category identified.
		2. This TAB has been prepopulated with formulas to apply the proposed base labor rate by IDIQ labor category to the RFP provided labor hours.

STEP 4	TAB Prime Wrap Rate Tables	INDIRECT RATE TABLE Instructions: This table shall be used to show the conversion of indirect rates/burdens and FCCOM by CFY to contract year.
		1. Input the offeror's CFY from and to dates.
		2. Provide the offeror's proposed indirect rates/burdens and FCCOM by CFY, identifying the CFY (change the "X" in "CFY X" to the actual CFY year) in the INDIRECT RATE TABLE The offeror shall ensure that its proposed indirect rates are proposed in accordance with the offeror's normal accounting practices.
		3. Input formulas to show the conversion of CFY rates to the contract year rates/calendar year rates. The resulting contract year rates are the rates that shall be used in the FCCOM Rate Table and used in the build-up of proposed wrap rates.

IDIQ RATE TABLE- PRIME'S DIRECT LABOR WRAP RATES Instructions: The prime contractor's proposed direct labor wrap rates on orders shall not exceed the wrap rates by contract year proposed as part of the basic IDIQ contract and as identified in this IDIQ Rate Table.

1. Provide the build-up of the offeror's proposed direct labor wrap rate. The wrap rate shall include all indirect rates to be applied to direct labor costs but shall exclude fee/profit. Applying the Direct Labor Wrap Rate by contract year to direct labor costs shall yield the total fully burdened labor costs for that contract year.

2. Use formulas to link the indirect rates by contract year from the INDIRECT RATE TABLE to the IDIQ RATE TABLE for the Direct Labor Wrap Rate to show the build-up of the proposed wrap rate.

The prime contractor's proposed direct labor wrap rates on orders shall not exceed the wrap rates by contract year proposed as part of the basic IDIQ contract and as identified in the IDIQ Rate Table below.

IDIQ RATE TABLE- PRIME'S ODC/MATERIAL WRAP RATES Instructions: The prime contractor's proposed Material/ODC wrap rates on orders shall not exceed the wrap rates by contract year proposed as part of the basic IDIQ contract and as identified in this IDIQ Rate Table.

1. Provide the build-up of the offeror's proposed ODC/Material wrap rate. The wrap rate shall include all indirect rates to be applied to Material/ODC but shall exclude fee/profit. Applying the Material/ODC Wrap Rate by contract year to non-labor costs shall yield the total Material/ODC costs for that contract year.

2. Use formulas to link the indirect rates by contract year from the INDIRECT RATE TABLE to the IDIQ RATE TABLE for the Material/ODC Wrap Rate to show the build-up of the proposed wrap rate.

IDIQ RATE TABLE- PRIME'S FCCOM RATE Instructions: The prime contractor's proposed FCCOM rates on orders shall not exceed the FCCOM rates by contract year proposed as part of the basic IDIQ contract and as identified in this IDIQ Rate Table.

1. Provide the offeror's proposed FCCOM rate.

2. Use formulas to link the indirect rates by contract year from the INDIRECT RATE TABLE to the IDIQ RATE TABLE for the FCCOM Rate.

STEP 5	TAB Prime Profit-Fee-Storage Tables	IDIQ RATE TABLE- PRIME CPFF Fee % Instructions: The prime contractor's fee percentages proposed on CPFF orders shall not exceed the fee percentage proposed as part of the the basic IDIQ contract and as identified in this table.
		1. Input the offeror's CPFF fee percentage by contract year.

IDIQ RATE TABLE- PRIME FFP Profit % Instructions: The prime contractor's profit percentages proposed on FFP orders shall not exceed the profit percentage proposed as part of the the basic IDIQ contract and as identified in this table.

1. Input the offeror's FFP profit percentage by contract year

IDIQ RATE TABLE- PRIME STORAGE RATE Instructions: The prime contractor's storage rates proposed on FFP orders shall not exceed the storage rate proposed as part of the basic IDIQ contract and as identified in this table.

1. Input the offeror's storage rate ($/square foot) by contract year

2. This table has been pre-populated with formulas to apply the proposed storage rate ($/square foot) to the RFP provided square feet for USG evaluation purposes.

STEP 6 TAB Total Proposed The TAB has been pre-polulated with formulas to calculate the Total Proposed Price from the IDIQ Rate Tables. The offeror is responsible for ensuring that all calculations within each TAB are accurate and reflective of the offeror's proposed price.

1. CPFF Labor Category Mapping

Labor Category Mapping

LSF-1

Offeror Name:

Offeror CAGE:

STEP 1: CPFF Labor Category Mapping

This labor mapping mapping table is intended for use in the development of the Prime CPFF Labor Rate Table.

The offeror is responsible for ensuring that all calculations within this worksheet are accurate and reflective of the offeror's proposed price.

Red text is shown as an example only. The offeror shall ensure that red text amounts are not included in the offeror's proposed price.

		Contractor Fiscal Year (CFY)
		From:	1 January 2023
		To:	31 December 2023	Base Direct Labor Rates =		$ 12.50	$ 15.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Contractor/Corporate Labor Category	Contractor/Corporate Labor Category Description	Years of Experience	Education	Labor Rate	RFP Lbr Categories	Example Category- Analyst II	Example Category- Engineer	Program Manager	Program Manager II	Program Manager III	Program Manager IV	Program Analyst I	Program Analyst II	Program Analyst III	Engineering Manager	Mechanical Engineer I	Mechanical Engineer II	Mechanical Engineer III	Stress Analyst	Systems Analyst I	Systems Analyst II	Systems Engineer	Technical Writer	Configuration Mgmt Analyst	Configuration Data Manager	Electrical Engineer I	Electrical Engineer II	Electrical Engineer Lead/III	Engineering Aide	Manufacturing Engineer	ILS Manager	Parts Clerk	Material Handler	Warehouse Specialist (Warehouse Worker)	Shipping/Receiving/ Supply/Stock Clerk	Warehouse Supervisor	Production Supervisor	Production Control Clerk (01270)	Structural Installer	Structural Installer Lead	Structural Fabricator	Structural Fabricator Lead	Aerospace Structural Welder	Laser Machine Operator	Aircraft Mechanic	Aircraft Mechanic II	Aircraft Mechanic Lead	Avionics Mechanic	Avionics Mechanic Lead
Example- Analyst Category 1	Example Description	5	Bachelor's	$12.00		50%
Example- Analyst Category 2	Example Description	4	Bachelor's	$13.00		50%
Example- Engineer 2	Example Description	8	Bachelor's	$15.00			100%

Percentage Total	100%	100%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%
Percentage Total = 100%	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No

2. Prime CPFF Labor Rate Table

Prime CPFF Labor Rate Table

LSF-1

Prime Offeror Name:

Prime Offeror CAGE:

STEP 2: Prime CPFF Labor Rate Table

The prime contractor's proposed direct labor base rates (unburdened labor rates) on CPFF orders shall not exceed the base labor rates by contract year proposed as part of the basic IDIQ contract and as identified in the IDIQ Rate Table below.

The offeror is responsible for ensuring that all calculations within this worksheet are accurate and reflective of the offeror's proposed price.

Red text is shown as an example only. The offeror shall ensure that red text amounts are not included in the offeror's proposed price.
	EXAMPLE IDIQ RATE TABLE
	CY 2023
Labor Category	Base Labor Rate

Author: Author: The rates in this column shall match those calculated in the TAB Labor Category Mapping for each RFP labor category.

Input formulas to link the rates in this column to the TAB Labor Category Mapping.	Base Labor Rate ($/Hr)	Composite Base Labor Rate
($/Hr)	RFP Provided Labor Hours for USG Evaluation Purposes	CPFF Prime Labor

2.00% Author: Author:

Offeror's Proposed Escalation Rate Insert applicable contractor fiscal year (CFY)>>>> 0.67 Author: Author:

Offeror's CFY 1 allocation

CFY 2023 CFY 2024 0.33

Author: Author:

Offeror's CFY 2 allocation

Example Category- Analyst II	$12.50	$12.75	$12.58	11000.00	$138,417
Example Category- Engineer	$15.00	$15.30	$15.10	8000.00	$120,800.00

IDIQ RATE TABLE-

PRIME CPFF LABOR RATE TABLE

	Calendar Year (CY) 2023	CY 2024	CY 2025	CY 2026	CY 2027	CY 2028	CY 2029	CY 2030
IDIQ Labor Category	Base Labor Rate

Author: Author: The rates in this column shall match those calculated in the TAB Labor Category Mapping for each RFP labor category.

Input formulas to link the rates in this column to the TAB Labor Category Mapping.	Base Labor Rate ($/Hr)	Composite Base Labor Rate
($/Hr)	RFP Provided Labor Hours for USG Evaluation Purposes	CPFF Prime Labor
($)	Base Labor Rate
($/Hr)	RFP Provided Labor Hours for USG Evaluation Purposes	CPFF Prime Labor
($)	Base Labor Rate
($/Hr)	RFP Provided Labor Hours for USG Evaluation Purposes	CPFF Prime Labor
($)	Base Labor Rate
($/Hr)	RFP Provided Labor Hours for USG Evaluation Purposes	CPFF Prime Labor
($)	Base Labor Rate
($/Hr)	RFP Provided Labor Hours for USG Evaluation Purposes	CPFF Prime Labor
($)	Base Labor Rate
($/Hr)	RFP Provided Labor Hours for USG Evaluation Purposes	CPFF Prime Labor
($)	Base Labor Rate
($/Hr)	RFP Provided Labor Hours for USG Evaluation Purposes	CPFF Prime Labor
($)	Base Labor Rate
($/Hr)	RFP Provided Labor Hours for USG Evaluation Purposes	CPFF Prime Labor

0.00% Author: Author:

Offeror's Proposed Escalation Rate 0.00% Author: Author:

Offeror's Proposed Escalation Rate Insert applicable contractor fiscal year (CFY)>>>> 0.00 Author: Author:

Offeror's CFY 1 allocation

CFY XXXX CFY XXXX 0.00

Offeror's CFY 2 allocation

Offeror's Proposed Escalation Rate Author: Author:

Offeror's Proposed Escalation Rate Author: Author: The rates in this column shall match those calculated in the TAB Labor Category Mapping for each RFP labor category.

Input formulas to link the rates in this column to the TAB Labor Category Mapping.

Author: Author:

Offeror's Proposed Escalation Rate Author: Author:

Offeror's CFY 1 allocation Author: Author:

Offeror's CFY 2 allocation

Author: Author:

Offeror's Proposed

Escalation Rate	Program Manager	$0.00	$0.00	$0.00	2557.50	$0	$0.00	5115.00	$0	$0.00	5280.00	$0	$0.00	5115.00	$0	$0.00	5115.00	$0	$0.00	2557.50	$0	$0.00	2557.50	$0	$0.00	2557.50	$0
	Program Manager II	$0.00	$0.00	$0.00	1534.50	$0	$0.00	3069.00	$0	$0.00	3168.00	$0	$0.00	3069.00	$0	$0.00	3069.00	$0	$0.00	1534.50	$0	$0.00	1534.50	$0	$0.00	1534.50	$0
	Program Manager III	$0.00	$0.00	$0.00	511.50	$0	$0.00	1023.00	$0	$0.00	1056.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	511.50	$0	$0.00	511.50	$0	$0.00	511.50	$0
	Program Manager IV	$0.00	$0.00	$0.00	306.90	$0	$0.00	613.80	$0	$0.00	633.60	$0	$0.00	613.80	$0	$0.00	613.80	$0	$0.00	306.90	$0	$0.00	306.90	$0	$0.00	306.90	$0
	Program Analyst I	$0.00	$0.00	$0.00	2046.00	$0	$0.00	4092.00	$0	$0.00	4224.00	$0	$0.00	4092.00	$0	$0.00	4092.00	$0	$0.00	2046.00	$0	$0.00	2046.00	$0	$0.00	2046.00	$0
	Program Analyst II	$0.00	$0.00	$0.00	1023.00	$0	$0.00	2046.00	$0	$0.00	2112.00	$0	$0.00	2046.00	$0	$0.00	2046.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0
	Program Analyst III	$0.00	$0.00	$0.00	511.50	$0	$0.00	1023.00	$0	$0.00	1056.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	511.50	$0	$0.00	511.50	$0	$0.00	511.50	$0
	Engineering Manager	$0.00	$0.00	$0.00	255.75	$0	$0.00	511.50	$0	$0.00	528.00	$0	$0.00	511.50	$0	$0.00	511.50	$0	$0.00	255.75	$0	$0.00	255.75	$0	$0.00	255.75	$0
	Mechanical Engineer I	$0.00	$0.00	$0.00	255.75	$0	$0.00	511.50	$0	$0.00	528.00	$0	$0.00	511.50	$0	$0.00	511.50	$0	$0.00	255.75	$0	$0.00	255.75	$0	$0.00	255.75	$0
	Mechanical Engineer II	$0.00	$0.00	$0.00	255.75	$0	$0.00	511.50	$0	$0.00	528.00	$0	$0.00	511.50	$0	$0.00	511.50	$0	$0.00	255.75	$0	$0.00	255.75	$0	$0.00	255.75	$0
	Mechanical Engineer III	$0.00	$0.00	$0.00	255.75	$0	$0.00	511.50	$0	$0.00	528.00	$0	$0.00	511.50	$0	$0.00	511.50	$0	$0.00	255.75	$0	$0.00	255.75	$0	$0.00	255.75	$0
	Stress Analyst	$0.00	$0.00	$0.00	255.75	$0	$0.00	511.50	$0	$0.00	528.00	$0	$0.00	511.50	$0	$0.00	511.50	$0	$0.00	255.75	$0	$0.00	255.75	$0	$0.00	255.75	$0
	Systems Analyst I	$0.00	$0.00	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0
	Systems Analyst II	$0.00	$0.00	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0
	Systems Engineer	$0.00	$0.00	$0.00	511.50	$0	$0.00	1023.00	$0	$0.00	1056.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	511.50	$0	$0.00	511.50	$0	$0.00	511.50	$0
	Technical Writer	$0.00	$0.00	$0.00	1534.50	$0	$0.00	3069.00	$0	$0.00	3168.00	$0	$0.00	3069.00	$0	$0.00	3069.00	$0	$0.00	1534.50	$0	$0.00	1534.50	$0	$0.00	1534.50	$0
	Configuration Mgmt Analyst	$0.00	$0.00	$0.00	1023.00	$0	$0.00	2046.00	$0	$0.00	2112.00	$0	$0.00	2046.00	$0	$0.00	2046.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0
	Configuration Data Manager	$0.00	$0.00	$0.00	511.50	$0	$0.00	1023.00	$0	$0.00	1056.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	511.50	$0	$0.00	511.50	$0	$0.00	511.50	$0
	Electrical Engineer I	$0.00	$0.00	$0.00	255.75	$0	$0.00	511.50	$0	$0.00	528.00	$0	$0.00	511.50	$0	$0.00	511.50	$0	$0.00	255.75	$0	$0.00	255.75	$0	$0.00	255.75	$0
	Electrical Engineer II	$0.00	$0.00	$0.00	255.75	$0	$0.00	511.50	$0	$0.00	528.00	$0	$0.00	511.50	$0	$0.00	511.50	$0	$0.00	255.75	$0	$0.00	255.75	$0	$0.00	255.75	$0
	Electrical Engineer Lead/III	$0.00	$0.00	$0.00	153.45	$0	$0.00	306.90	$0	$0.00	316.80	$0	$0.00	306.90	$0	$0.00	306.90	$0	$0.00	153.45	$0	$0.00	153.45	$0	$0.00	153.45	$0
	Engineering Aide	$0.00	$0.00	$0.00	511.50	$0	$0.00	1023.00	$0	$0.00	1056.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	511.50	$0	$0.00	511.50	$0	$0.00	511.50	$0
	Manufacturing Engineer	$0.00	$0.00	$0.00	255.75	$0	$0.00	511.50	$0	$0.00	528.00	$0	$0.00	511.50	$0	$0.00	511.50	$0	$0.00	255.75	$0	$0.00	255.75	$0	$0.00	255.75	$0
	ILS Manager	$0.00	$0.00	$0.00	767.25	$0	$0.00	1534.50	$0	$0.00	1584.00	$0	$0.00	1534.50	$0	$0.00	1534.50	$0	$0.00	767.25	$0	$0.00	767.25	$0	$0.00	767.25	$0
	Parts Clerk	$0.00	$0.00	$0.00	2046.00	$0	$0.00	4092.00	$0	$0.00	4224.00	$0	$0.00	4092.00	$0	$0.00	4092.00	$0	$0.00	2046.00	$0	$0.00	2046.00	$0	$0.00	2046.00	$0
	Material Handler	$0.00	$0.00	$0.00	4603.50	$0	$0.00	9207.00	$0	$0.00	9504.00	$0	$0.00	9207.00	$0	$0.00	9207.00	$0	$0.00	4603.50	$0	$0.00	4603.50	$0	$0.00	4603.50	$0
	Warehouse Specialist (Warehouse Worker)	$0.00	$0.00	$0.00	2557.50	$0	$0.00	5115.00	$0	$0.00	5280.00	$0	$0.00	5115.00	$0	$0.00	5115.00	$0	$0.00	2557.50	$0	$0.00	2557.50	$0	$0.00	2557.50	$0
	Shipping/Receiving/ Supply/Stock Clerk	$0.00	$0.00	$0.00	2557.50	$0	$0.00	5115.00	$0	$0.00	5280.00	$0	$0.00	5115.00	$0	$0.00	5115.00	$0	$0.00	2557.50	$0	$0.00	2557.50	$0	$0.00	2557.50	$0
	Warehouse Supervisor	$0.00	$0.00	$0.00	1023.00	$0	$0.00	2046.00	$0	$0.00	2112.00	$0	$0.00	2046.00	$0	$0.00	2046.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0
	Production Supervisor	$0.00	$0.00	$0.00	1023.00	$0	$0.00	2046.00	$0	$0.00	2112.00	$0	$0.00	2046.00	$0	$0.00	2046.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0
	Production Control Clerk (01270)	$0.00	$0.00	$0.00	1023.00	$0	$0.00	2046.00	$0	$0.00	2112.00	$0	$0.00	2046.00	$0	$0.00	2046.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0
	Structural Installer	$0.00	$0.00	$0.00	6138.00	$0	$0.00	12276.00	$0	$0.00	12672.00	$0	$0.00	12276.00	$0	$0.00	12276.00	$0	$0.00	6138.00	$0	$0.00	6138.00	$0	$0.00	6138.00	$0
	Structural Installer Lead	$0.00	$0.00	$0.00	1534.50	$0	$0.00	3069.00	$0	$0.00	3168.00	$0	$0.00	3069.00	$0	$0.00	3069.00	$0	$0.00	1534.50	$0	$0.00	1534.50	$0	$0.00	1534.50	$0
	Structural Fabricator	$0.00	$0.00	$0.00	1023.00	$0	$0.00	2046.00	$0	$0.00	2112.00	$0	$0.00	2046.00	$0	$0.00	2046.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0
	Structural Fabricator Lead	$0.00	$0.00	$0.00	409.20	$0	$0.00	818.40	$0	$0.00	844.80	$0	$0.00	818.40	$0	$0.00	818.40	$0	$0.00	409.20	$0	$0.00	409.20	$0	$0.00	409.20	$0
	Aerospace Structural Welder	$0.00	$0.00	$0.00	255.75	$0	$0.00	511.50	$0	$0.00	528.00	$0	$0.00	511.50	$0	$0.00	511.50	$0	$0.00	255.75	$0	$0.00	255.75	$0	$0.00	255.75	$0
	Laser Machine Operator	$0.00	$0.00	$0.00	255.75	$0	$0.00	511.50	$0	$0.00	528.00	$0	$0.00	511.50	$0	$0.00	511.50	$0	$0.00	255.75	$0	$0.00	255.75	$0	$0.00	255.75	$0
	Aircraft Mechanic	$0.00	$0.00	$0.00	7161.00	$0	$0.00	14322.00	$0	$0.00	14784.00	$0	$0.00	14322.00	$0	$0.00	14322.00	$0	$0.00	7161.00	$0	$0.00	7161.00	$0	$0.00	7161.00	$0
	Aircraft Mechanic II	$0.00	$0.00	$0.00	6649.50	$0	$0.00	13299.00	$0	$0.00	13728.00	$0	$0.00	13299.00	$0	$0.00	13299.00	$0	$0.00	6649.50	$0	$0.00	6649.50	$0	$0.00	6649.50	$0
	Aircraft Mechanic Lead	$0.00	$0.00	$0.00	3069.00	$0	$0.00	6138.00	$0	$0.00	6336.00	$0	$0.00	6138.00	$0	$0.00	6138.00	$0	$0.00	3069.00	$0	$0.00	3069.00	$0	$0.00	3069.00	$0
	Avionics Mechanic	$0.00	$0.00	$0.00	5115.00	$0	$0.00	10230.00	$0	$0.00	10560.00	$0	$0.00	10230.00	$0	$0.00	10230.00	$0	$0.00	5115.00	$0	$0.00	5115.00	$0	$0.00	5115.00	$0
	Avionics Mechanic Lead	$0.00	$0.00	$0.00	1534.50	$0	$0.00	3069.00	$0	$0.00	3168.00	$0	$0.00	3069.00	$0	$0.00	3069.00	$0	$0.00	1534.50	$0	$0.00	1534.50	$0	$0.00	1534.50	$0
	Ground Support Equipment Mechanic	$0.00	$0.00	$0.00	1023.00	$0	$0.00	2046.00	$0	$0.00	2112.00	$0	$0.00	2046.00	$0	$0.00	2046.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0
	Aircraft Painter	$0.00	$0.00	$0.00	1023.00	$0	$0.00	2046.00	$0	$0.00	2112.00	$0	$0.00	2046.00	$0	$0.00	2046.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0
	Electrical Fabricator	$0.00	$0.00	$0.00	4092.00	$0	$0.00	8184.00	$0	$0.00	8448.00	$0	$0.00	8184.00	$0	$0.00	8184.00	$0	$0.00	4092.00	$0	$0.00	4092.00	$0	$0.00	4092.00	$0
	Electrical Fabricator Lead	$0.00	$0.00	$0.00	1023.00	$0	$0.00	2046.00	$0	$0.00	2112.00	$0	$0.00	2046.00	$0	$0.00	2046.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0
	Wire Marker Machine Operator I	$0.00	$0.00	$0.00	511.50	$0	$0.00	1023.00	$0	$0.00	1056.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	511.50	$0	$0.00	511.50	$0	$0.00	511.50	$0
	Aircraft Quality Inspector	$0.00	$0.00	$0.00	4092.00	$0	$0.00	8184.00	$0	$0.00	8448.00	$0	$0.00	8184.00	$0	$0.00	8184.00	$0	$0.00	4092.00	$0	$0.00	4092.00	$0	$0.00	4092.00	$0
	Aircraft Quality Supervisor	$0.00	$0.00	$0.00	1534.50	$0	$0.00	3069.00	$0	$0.00	3168.00	$0	$0.00	3069.00	$0	$0.00	3069.00	$0	$0.00	1534.50	$0	$0.00	1534.50	$0	$0.00	1534.50	$0
	Quality Inspector	$0.00	$0.00	$0.00	3069.00	$0	$0.00	6138.00	$0	$0.00	6336.00	$0	$0.00	6138.00	$0	$0.00	6138.00	$0	$0.00	3069.00	$0	$0.00	3069.00	$0	$0.00	3069.00	$0
	Quality Supervisor	$0.00	$0.00	$0.00	1023.00	$0	$0.00	2046.00	$0	$0.00	2112.00	$0	$0.00	2046.00	$0	$0.00	2046.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0
	ECO/HAZMAT Inspector	$0.00	$0.00	$0.00	511.50	$0	$0.00	1023.00	$0	$0.00	1056.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	511.50	$0	$0.00	511.50	$0	$0.00	511.50	$0
	ALSE Technicians	$0.00	$0.00	$0.00	1023.00	$0	$0.00	2046.00	$0	$0.00	2112.00	$0	$0.00	2046.00	$0	$0.00	2046.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0
	Sr Provisioning Specialist	$0.00	$0.00	$0.00	1023.00	$0	$0.00	2046.00	$0	$0.00	2112.00	$0	$0.00	2046.00	$0	$0.00	2046.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0
	CNC Technician	$0.00	$0.00	$0.00	255.75	$0	$0.00	511.50	$0	$0.00	528.00	$0	$0.00	511.50	$0	$0.00	511.50	$0	$0.00	255.75	$0	$0.00	255.75	$0	$0.00	255.75	$0
	Maintenance Test Pilot (MTP)	$0.00	$0.00	$0.00	1023.00	$0	$0.00	2046.00	$0	$0.00	2112.00	$0	$0.00	2046.00	$0	$0.00	2046.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0
	Standardization/Maintenance Test Pilot	$0.00	$0.00	$0.00	511.50	$0	$0.00	1023.00	$0	$0.00	1056.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	511.50	$0	$0.00	511.50	$0	$0.00	511.50	$0
	Director of Safety/Instructor Pilot	$0.00	$0.00	$0.00	255.75	$0	$0.00	511.50	$0	$0.00	528.00	$0	$0.00	511.50	$0	$0.00	511.50	$0	$0.00	255.75	$0	$0.00	255.75	$0	$0.00	255.75	$0
	Flight Operations Technician	$0.00	$0.00	$0.00	511.50	$0	$0.00	1023.00	$0	$0.00	1056.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	511.50	$0	$0.00	511.50	$0	$0.00	511.50	$0
	Airplane / Helicopter Pilot	$0.00	$0.00	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0
	Flight Instructor/Flight Examiner	$0.00	$0.00	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0
	Flight Mechanic/Crew Chief	$0.00	$0.00	$0.00	2046.00	$0	$0.00	4092.00	$0	$0.00	4224.00	$0	$0.00	4092.00	$0	$0.00	4092.00	$0	$0.00	2046.00	$0	$0.00	2046.00	$0	$0.00	2046.00	$0
	Pilot/Non-MTP (Platform Specific )	$0.00	$0.00	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0	$0.00	1.00	$0
	Material/Production Planner	$0.00	$0.00	$0.00	2557.50	$0	$0.00	5115.00	$0	$0.00	5280.00	$0	$0.00	5115.00	$0	$0.00	5115.00	$0	$0.00	2557.50	$0	$0.00	2557.50	$0	$0.00	2557.50	$0
	Training Manager	$0.00	$0.00	$0.00	511.50	$0	$0.00	1023.00	$0	$0.00	1056.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	511.50	$0	$0.00	511.50	$0	$0.00	511.50	$0
	Training Project Manager	$0.00	$0.00	$0.00	511.50	$0	$0.00	1023.00	$0	$0.00	1056.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	511.50	$0	$0.00	511.50	$0	$0.00	511.50	$0
	Senior Instructor/SME I	$0.00	$0.00	$0.00	1023.00	$0	$0.00	2046.00	$0	$0.00	2112.00	$0	$0.00	2046.00	$0	$0.00	2046.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0
	Senior Instructor/SME II	$0.00	$0.00	$0.00	1023.00	$0	$0.00	2046.00	$0	$0.00	2112.00	$0	$0.00	2046.00	$0	$0.00	2046.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0
	Instructor/SME	$0.00	$0.00	$0.00	511.50	$0	$0.00	1023.00	$0	$0.00	1056.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	511.50	$0	$0.00	511.50	$0	$0.00	511.50	$0
	SME	$0.00	$0.00	$0.00	511.50	$0	$0.00	1023.00	$0	$0.00	1056.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	511.50	$0	$0.00	511.50	$0	$0.00	511.50	$0
	NDI Technician	$0.00	$0.00	$0.00	1023.00	$0	$0.00	2046.00	$0	$0.00	2112.00	$0	$0.00	2046.00	$0	$0.00	2046.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0
	NDI Technician Level II	$0.00	$0.00	$0.00	1023.00	$0	$0.00	2046.00	$0	$0.00	2112.00	$0	$0.00	2046.00	$0	$0.00	2046.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0
	NDI Technician Level III	$0.00	$0.00	$0.00	511.50	$0	$0.00	1023.00	$0	$0.00	1056.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	511.50	$0	$0.00	511.50	$0	$0.00	511.50	$0
	Integrated Master Scheduler I	$0.00	$0.00	$0.00	1023.00	$0	$0.00	2046.00	$0	$0.00	2112.00	$0	$0.00	2046.00	$0	$0.00	2046.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0
	Integrated Master Scheduler II	$0.00	$0.00	$0.00	1023.00	$0	$0.00	2046.00	$0	$0.00	2112.00	$0	$0.00	2046.00	$0	$0.00	2046.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0
	Integrated Master Scheduler III	$0.00	$0.00	$0.00	511.50	$0	$0.00	1023.00	$0	$0.00	1056.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	511.50	$0	$0.00	511.50	$0	$0.00	511.50	$0
	Aircraft Servicer (23060)	$0.00	$0.00	$0.00	1534.50	$0	$0.00	3069.00	$0	$0.00	3168.00	$0	$0.00	3069.00	$0	$0.00	3069.00	$0	$0.00	1534.50	$0	$0.00	1534.50	$0	$0.00	1534.50	$0
	Admin Clerk	$0.00	$0.00	$0.00	1534.50	$0	$0.00	3069.00	$0	$0.00	3168.00	$0	$0.00	3069.00	$0	$0.00	3069.00	$0	$0.00	1534.50	$0	$0.00	1534.50	$0	$0.00	1534.50	$0
	Computer Operator	$0.00	$0.00	$0.00	511.50	$0	$0.00	1023.00	$0	$0.00	1056.00	$0	$0.00	1023.00	$0	$0.00	1023.00	$0	$0.00	511.50	$0	$0.00	511.50	$0	$0.00	511.50	$0
					103430.30	$0		206855.60	$0		213528.20	$0		206855.60	$0		206855.60	$0		103430.30	$0		103430.30	$0		103430.30	$0

3. Prime FFP Labor Rate Table

Prime FFP Labor Rate Table

LSF-1

Prime Offeror Name:

Prime Offeror CAGE:

STEP 3: Prime FFP Labor Rate Table

The prime contractor's proposed direct labor base rates (unburdened labor rates) on FFP orders shall not exceed the base labor rates by contract year proposed as part of the basic IDIQ contract and as identified in the IDIQ Rate Table below.

The offeror is responsible for ensuring that all calculations within this worksheet are accurate and reflective of the offeror's proposed price.

Red text is shown as an example only. The offeror shall ensure that red text amounts are not included in the offeror's proposed price.
	EXAMPLE IDIQ RATE TABLE

	Labor Category	Base Labor Rate
($/Hr)	RFP Provided Labor Hours for USG Evaluation Purposes	FFP Prime Labor

Example Category- Analyst II	$54.00	11000.00	$ 594,000
Example Category- Engineer	$70.00	8000.00	$ 560,000

IDIQ RATE TABLE-

PRIME FFP LABOR RATE TABLE

		Calendar Year (CY) 2023	CY 2024	CY 2025	CY 2026	CY 2027	CY 2028	CY 2029	CY 2030
	IDIQ Labor Category	Base Labor Rate
($/Hr)	RFP Provided Labor Hours for USG Evaluation Purposes	FFP Prime Labor
($)	Base Labor Rate
($/Hr)	RFP Provided Labor Hours for USG Evaluation Purposes	FFP Prime Labor
($)	Base Labor Rate
($/Hr)	RFP Provided Labor Hours for USG Evaluation Purposes	FFP Prime Labor
($)	Base Labor Rate
($/Hr)	RFP Provided Labor Hours for USG Evaluation Purposes	FFP Prime Labor
($)	Base Labor Rate
($/Hr)	RFP Provided Labor Hours for USG Evaluation Purposes	FFP Prime Labor
($)	Base Labor Rate
($/Hr)	RFP Provided Labor Hours for USG Evaluation Purposes	FFP Prime Labor
($)	Base Labor Rate
($/Hr)	RFP Provided Labor Hours for USG Evaluation Purposes	FFP Prime Labor
($)	Base Labor Rate
($/Hr)	RFP Provided Labor Hours for USG Evaluation Purposes	FFP Prime Labor

Program Manager	2557.50	$0	5115.00	$0	5115.00	$0	5115.00	$0	5115.00	$0	2557.50	$0	2557.50	$0	2557.50	$0
Program Manager II	1534.50	$0	3069.00	$0	3069.00	$0	3069.00	$0	3069.00	$0	1534.50	$0	1534.50	$0	1534.50	$0
Program Manager III	511.50	$0	1023.00	$0	1023.00	$0	1023.00	$0	1023.00	$0	511.50	$0	511.50	$0	511.50	$0
Program Manager IV	306.90	$0	613.80	$0	613.80	$0	613.80	$0	613.80	$0	306.90	$0	306.90	$0	306.90	$0
Program Analyst I	2046.00	$0	4092.00	$0	4092.00	$0	4092.00	$0	4092.00	$0	2046.00	$0	2046.00	$0	2046.00	$0
Program Analyst II	1023.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	1023.00	$0	1023.00	$0	1023.00	$0
Program Analyst III	511.50	$0	1023.00	$0	1023.00	$0	1023.00	$0	1023.00	$0	511.50	$0	511.50	$0	511.50	$0
Engineering Manager	255.75	$0	511.50	$0	511.50	$0	511.50	$0	511.50	$0	255.75	$0	255.75	$0	255.75	$0
Mechanical Engineer I	255.75	$0	511.50	$0	511.50	$0	511.50	$0	511.50	$0	255.75	$0	255.75	$0	255.75	$0
Mechanical Engineer II	255.75	$0	511.50	$0	511.50	$0	511.50	$0	511.50	$0	255.75	$0	255.75	$0	255.75	$0
Mechanical Engineer III	255.75	$0	511.50	$0	511.50	$0	511.50	$0	511.50	$0	255.75	$0	255.75	$0	255.75	$0
Stress Analyst	255.75	$0	511.50	$0	511.50	$0	511.50	$0	511.50	$0	255.75	$0	255.75	$0	255.75	$0
Systems Analyst I	1.00	$0	1.00	$0	1.00	$0	1.00	$0	1.00	$0	1.00	$0	1.00	$0	1.00	$0
Systems Analyst II	1.00	$0	1.00	$0	1.00	$0	1.00	$0	1.00	$0	1.00	$0	1.00	$0	1.00	$0
Systems Engineer	511.50	$0	1023.00	$0	1023.00	$0	1023.00	$0	1023.00	$0	511.50	$0	511.50	$0	511.50	$0
Technical Writer	1534.50	$0	3069.00	$0	3069.00	$0	3069.00	$0	3069.00	$0	1534.50	$0	1534.50	$0	1534.50	$0
Configuration Mgmt Analyst	1023.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	1023.00	$0	1023.00	$0	1023.00	$0
Configuration Data Manager	511.50	$0	1023.00	$0	1023.00	$0	1023.00	$0	1023.00	$0	511.50	$0	511.50	$0	511.50	$0
Electrical Engineer I	255.75	$0	511.50	$0	511.50	$0	511.50	$0	511.50	$0	255.75	$0	255.75	$0	255.75	$0
Electrical Engineer II	255.75	$0	511.50	$0	511.50	$0	511.50	$0	511.50	$0	255.75	$0	255.75	$0	255.75	$0
Electrical Engineer Lead/III	153.45	$0	306.90	$0	306.90	$0	306.90	$0	306.90	$0	153.45	$0	153.45	$0	153.45	$0
Engineering Aide	511.50	$0	1023.00	$0	1023.00	$0	1023.00	$0	1023.00	$0	511.50	$0	511.50	$0	511.50	$0
Manufacturing Engineer	255.75	$0	511.50	$0	511.50	$0	511.50	$0	511.50	$0	255.75	$0	255.75	$0	255.75	$0
ILS Manager	767.25	$0	1534.50	$0	1534.50	$0	1534.50	$0	1534.50	$0	767.25	$0	767.25	$0	767.25	$0
Parts Clerk	2046.00	$0	4092.00	$0	4092.00	$0	4092.00	$0	4092.00	$0	2046.00	$0	2046.00	$0	2046.00	$0
Material Handler	4603.50	$0	9207.00	$0	9207.00	$0	9207.00	$0	9207.00	$0	4603.50	$0	4603.50	$0	4603.50	$0
Warehouse Specialist (Warehouse Worker)	2557.50	$0	5115.00	$0	5115.00	$0	5115.00	$0	5115.00	$0	2557.50	$0	2557.50	$0	2557.50	$0
Shipping/Receiving/ Supply/Stock Clerk	2557.50	$0	5115.00	$0	5115.00	$0	5115.00	$0	5115.00	$0	2557.50	$0	2557.50	$0	2557.50	$0
Warehouse Supervisor	1023.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	1023.00	$0	1023.00	$0	1023.00	$0
Production Supervisor	1023.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	1023.00	$0	1023.00	$0	1023.00	$0
Production Control Clerk (01270)	1023.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	1023.00	$0	1023.00	$0	1023.00	$0
Structural Installer	6138.00	$0	12276.00	$0	12276.00	$0	12276.00	$0	12276.00	$0	6138.00	$0	6138.00	$0	6138.00	$0
Structural Installer Lead	1534.50	$0	3069.00	$0	3069.00	$0	3069.00	$0	3069.00	$0	1534.50	$0	1534.50	$0	1534.50	$0
Structural Fabricator	1023.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	1023.00	$0	1023.00	$0	1023.00	$0
Structural Fabricator Lead	409.20	$0	818.40	$0	818.40	$0	818.40	$0	818.40	$0	409.20	$0	409.20	$0	409.20	$0
Aerospace Structural Welder	255.75	$0	511.50	$0	511.50	$0	511.50	$0	511.50	$0	255.75	$0	255.75	$0	255.75	$0
Laser Machine Operator	255.75	$0	511.50	$0	511.50	$0	511.50	$0	511.50	$0	255.75	$0	255.75	$0	255.75	$0
Aircraft Mechanic	7161.00	$0	14322.00	$0	14322.00	$0	14322.00	$0	14322.00	$0	7161.00	$0	7161.00	$0	7161.00	$0
Aircraft Mechanic II	6649.50	$0	13299.00	$0	13299.00	$0	13299.00	$0	13299.00	$0	6649.50	$0	6649.50	$0	6649.50	$0
Aircraft Mechanic Lead	3069.00	$0	6138.00	$0	6138.00	$0	6138.00	$0	6138.00	$0	3069.00	$0	3069.00	$0	3069.00	$0
Avionics Mechanic	5115.00	$0	10230.00	$0	10230.00	$0	10230.00	$0	10230.00	$0	5115.00	$0	5115.00	$0	5115.00	$0
Avionics Mechanic Lead	1534.50	$0	3069.00	$0	3069.00	$0	3069.00	$0	3069.00	$0	1534.50	$0	1534.50	$0	1534.50	$0
Ground Support Equipment Mechanic	1023.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	1023.00	$0	1023.00	$0	1023.00	$0
Aircraft Painter	1023.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	1023.00	$0	1023.00	$0	1023.00	$0
Electrical Fabricator	4092.00	$0	8184.00	$0	8184.00	$0	8184.00	$0	8184.00	$0	4092.00	$0	4092.00	$0	4092.00	$0
Electrical Fabricator Lead	1023.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	1023.00	$0	1023.00	$0	1023.00	$0
Wire Marker Machine Operator I	511.50	$0	1023.00	$0	1023.00	$0	1023.00	$0	1023.00	$0	511.50	$0	511.50	$0	511.50	$0
Aircraft Quality Inspector	4092.00	$0	8184.00	$0	8184.00	$0	8184.00	$0	8184.00	$0	4092.00	$0	4092.00	$0	4092.00	$0
Aircraft Quality Supervisor	1534.50	$0	3069.00	$0	3069.00	$0	3069.00	$0	3069.00	$0	1534.50	$0	1534.50	$0	1534.50	$0
Quality Inspector	3069.00	$0	6138.00	$0	6138.00	$0	6138.00	$0	6138.00	$0	3069.00	$0	3069.00	$0	3069.00	$0
Quality Supervisor	1023.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	1023.00	$0	1023.00	$0	1023.00	$0
ECO/HAZMAT Inspector	511.50	$0	1023.00	$0	1023.00	$0	1023.00	$0	1023.00	$0	511.50	$0	511.50	$0	511.50	$0
ALSE Technicians	1023.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	1023.00	$0	1023.00	$0	1023.00	$0
Sr Provisioning Specialist	1023.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	1023.00	$0	1023.00	$0	1023.00	$0
CNC Technician	255.75	$0	511.50	$0	511.50	$0	511.50	$0	511.50	$0	255.75	$0	255.75	$0	255.75	$0
Maintenance Test Pilot (MTP)	1023.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	1023.00	$0	1023.00	$0	1023.00	$0
Standardization/Maintenance Test Pilot	511.50	$0	1023.00	$0	1023.00	$0	1023.00	$0	1023.00	$0	511.50	$0	511.50	$0	511.50	$0
Director of Safety/Instructor Pilot	255.75	$0	511.50	$0	511.50	$0	511.50	$0	511.50	$0	255.75	$0	255.75	$0	255.75	$0
Flight Operations Technician	511.50	$0	1023.00	$0	1023.00	$0	1023.00	$0	1023.00	$0	511.50	$0	511.50	$0	511.50	$0
Airplane / Helicopter Pilot	1.00	$0	1.00	$0	1.00	$0	1.00	$0	1.00	$0	1.00	$0	1.00	$0	1.00	$0
Flight Instructor/Flight Examiner	1.00	$0	1.00	$0	1.00	$0	1.00	$0	1.00	$0	1.00	$0	1.00	$0	1.00	$0
Flight Mechanic/Crew Chief	2046.00	$0	4092.00	$0	4092.00	$0	4092.00	$0	4092.00	$0	2046.00	$0	2046.00	$0	2046.00	$0
Pilot/Non-MTP (Platform Specific )	1.00	$0	1.00	$0	1.00	$0	1.00	$0	1.00	$0	1.00	$0	1.00	$0	1.00	$0
Material/Production Planner	2557.50	$0	5115.00	$0	5115.00	$0	5115.00	$0	5115.00	$0	2557.50	$0	2557.50	$0	2557.50	$0
Training Manager	511.50	$0	1023.00	$0	1023.00	$0	1023.00	$0	1023.00	$0	511.50	$0	511.50	$0	511.50	$0
Training Project Manager	511.50	$0	1023.00	$0	1023.00	$0	1023.00	$0	1023.00	$0	511.50	$0	511.50	$0	511.50	$0
Senior Instructor/SME I	1023.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	1023.00	$0	1023.00	$0	1023.00	$0
Senior Instructor/SME II	1023.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	1023.00	$0	1023.00	$0	1023.00	$0
Instructor/SME	511.50	$0	1023.00	$0	1023.00	$0	1023.00	$0	1023.00	$0	511.50	$0	511.50	$0	511.50	$0
SME	511.50	$0	1023.00	$0	1023.00	$0	1023.00	$0	1023.00	$0	511.50	$0	511.50	$0	511.50	$0
NDI Technician	1023.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	1023.00	$0	1023.00	$0	1023.00	$0
NDI Technician Level II	1023.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	1023.00	$0	1023.00	$0	1023.00	$0
NDI Technician Level III	511.50	$0	1023.00	$0	1023.00	$0	1023.00	$0	1023.00	$0	511.50	$0	511.50	$0	511.50	$0
Integrated Master Scheduler I	1023.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	1023.00	$0	1023.00	$0	1023.00	$0
Integrated Master Scheduler II	1023.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	2046.00	$0	1023.00	$0	1023.00	$0	1023.00	$0
Integrated Master Scheduler III	511.50	$0	1023.00	$0	1023.00	$0	1023.00	$0	1023.00	$0	511.50	$0	511.50	$0	511.50	$0
Aircraft Servicer (23060)	1534.50	$0	3069.00	$0	3069.00	$0	3069.00	$0	3069.00	$0	1534.50	$0	1534.50	$0	1534.50	$0
Admin Clerk	1534.50	$0	3069.00	$0	3069.00	$0	3069.00	$0	3069.00	$0	1534.50	$0	1534.50	$0	1534.50	$0
Computer Operator	511.50	$0	1023.00	$0	1023.00	$0	1023.00	$0	1023.00	$0	511.50	$0	511.50	$0	511.50	$0
	103430.30	$0	206855.60	$0	206855.60	$0	206855.60	$0	206855.60	$0	103430.30	$0	103430.30	$0	103430.30	$0

4. Prime Wrap Rate Tables

Prime Wrap Rate Table

LSF-1

Offeror Name:

Offeror CAGE:

STEP 3: Prime Wrap Rate Tables

The prime contractor's proposed ODC/Material wrap rates on orders shall not exceed the wrap rates by contract year proposed as part of the basic IDIQ contract and as identified in the IDIQ Rate Table below.

The prime contractor's proposed FCCOM rates on orders shall not exceed the FCCOM rates by contract year proposed as part of the basic IDIQ contract and as identified in the IDIQ Rate Table below.

The offeror is responsible for ensuring that all calculations within this worksheet are accurate and reflective of the offeror's proposed price.

Red text is shown as an example only of how to convert Contractor Fiscal Year (CFY) rates to contract year rates. The offeror shall ensure that red text amounts are not included in the offeror's proposed price.

EXAMPLE CFY

From:

1 January

To:

31 December

EXAMPLE INDIRECT RATE TABLE

Contractor Fiscal Year (CFY)

Contract Year Rates

Indirect Burden

CFY 2023

CFY 2024

CFY X

Calendar Year (CY) 2023

Author: Input formulas to show the conversion of proposed rates by CFY to contract year rates. The contract year rates shall be used to populate the IDIQ Rate Tables below.

CY 2024

Author: Input formulas to show the conversion of proposed rates by CFY to contract year rates. The contract year rates shall be used to populate the IDIQ Rate Tables below.

CY 2025

Author: Input formulas to show the conversion of proposed rates by CFY to contract year rates. The contract year rates shall be used to populate the IDIQ Rate Tables below.

CY 2026

Author: Input formulas to show the conversion of proposed rates by CFY to contract year rates. The contract year rates shall be used to populate the IDIQ Rate Tables below.

	CY 2027
Author: Input formulas to show the conversion of proposed rates by CFY to contract year rates. The contract year rates shall be used to populate theI DIQ Rate Tables below.	CY 2028
Author: Input formulas to show the conversion of proposed rates by CFY to contract year rates. The contract year rates shall be used to populate the IDIQ Rate Tables below.	CY 2029
Author: Input formulas to show the conversion of proposed rates by CFY to contract year rates. The contract year rates shall be used to populate the IDIQ Rate Tables below.	CY 2030

Author: Input formulas to show the conversion of proposed rates by CFY to contract year rates. The contract year rates shall be used to populate the IDIQ Rate Tables below.

Example- Fringe Rate	10.00%	9.00%	9.67%
Example- Overhead Rate	8.50%	8.00%	8.33%
Example- Material/Sub Overhead	5.00%	4.50%	4.83%
Example- G&A Rate	3.00%	3.20%	3.07%
Example- FCCOM	0.1000%	0.1000%	0.10000%

		Contractor Fiscal Year (CFY)
		From:	Day Month
		To:	Day Month
INDIRECT RATE TABLE
	Contractor Fiscal Year (CFY) (%)			Contract Year Rates (%)
Indirect Rate/Burden (to include FCCOM)

Author: Identify the indirect rates/burdens and FCCOM (when applicable) used to develop the ceiling rate tables below.

	CFY X
Author: Input proposed rate by CFY used to calculate contract year rates.	CFY X
Author: Input proposed rate by CFY used to calculate contract year rates.	CFY X
Author: Input proposed rate by CFY used to calculate contract year rates.	CFY X
Author: Input proposed rate by CFY used to calculate contract year rates.	CFY X
Author: Input proposed rate by CFY used to calculate contract year rates.	CFY X
Author: Input proposed rate by CFY used to calculate contract year rates.	CFY X
Author: Input proposed rate by CFY used to calculate contract year rates.	CFY X
Author: Input proposed rate by CFY used to calculate contract year rates.	CFY X
Author: Input proposed rate by CFY used to calculate contract year rates.	CFY X
Author: Input proposed rate by CFY used to calculate contract year rates.	Calendar Year (CY) 2023
Author: Input formulas to show the conversion of proposed rates by CFY to contract year rates. The contract year rates shall be used to populate the IDIQ Rate Tables below.	CY 2024

Author: Input formulas to show the conversion of proposed rates by CFY to contract year rates. The contract year rates shall be used to populate the IDIQ Rate Tables below.

CY 2025

Author: Input formulas to show the conversion of proposed rates by CFY to contract year rates. The contract year rates shall be used to populate the IDIQ Rate Tables below.

CY 2026

Author: Input formulas to show the conversion of proposed rates by CFY to contract year rates. The contract year rates shall be used to populate the IDIQ Rate Tables below.

	CY 2027
Author: Input formulas to show the conversion of proposed rates by CFY to contract year rates. The contract year rates shall be used to populate theI DIQ Rate Tables below.	CY 2028
Author: Input formulas to show the conversion of proposed rates by CFY to contract year rates. The contract year rates shall be used to populate the IDIQ Rate Tables below.	CY 2029
Author: Input formulas to show the conversion of proposed rates by CFY to contract year rates. The contract year rates shall be used to populate the IDIQ Rate Tables below.	CY 2030

Author: Input formulas to show the conversion of proposed rates by CFY to contract year rates. The contract year rates shall be used to populate the IDIQ Rate Tables below.

Indirect Rate/Burden (Please Identify)

IDIQ RATE TABLE-

PRIME'S DIRECT LABOR WRAP RATES

Detail of Wrap Rate Author: Proposed Contract Year Rates in this table shall be taken from the INDIRECT RATE TABLE above.

	Description of Indirect Rate's Allocation Base	Calendar Year (CY) 2023
(%)	CY 2024
(%)	CY 2025
(%)	CY 2026
(%)	CY 2027
(%)	CY 2028
(%)	CY 2029
(%)	CY 2030

Indirect Rate/Burden (Please Identify)
Indirect Rate/Burden (Please Identify)
Indirect Rate/Burden (Please Identify)
Indirect Rate/Burden (Please Identify)
Indirect Rate/Burden (Please Identify)
DIRECT LABOR WRAP RATE (applied to prime's direct labor costs)	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%

IDIQ RATE TABLE-

PRIME'S ODC/MATERIAL WRAP RATES

Detail of Wrap Rate Author: Proposed Contract Year Rates in this table shall be taken from the INDIRECT RATE TABLE above.

	Description of Indirect Rate's Allocation Base	Calendar Year (CY) 2023
(%)	CY 2024
(%)	CY 2025
(%)	CY 2026
(%)	CY 2027
(%)	CY 2028
(%)	CY 2029
(%)	CY 2030

Indirect Rate/Burden (Please Identify)
Indirect Rate/Burden (Please Identify)
Indirect Rate/Burden (Please Identify)
Indirect Rate/Burden (Please Identify)
Indirect Rate/Burden (Please Identify)
ODC/MATERIAL WRAP RATE (applied to prime's non-labor costs)	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%

IDIQ RATE TABLE-

PRIME'S FCCOM RATES (IF APPLICABLE)

FCCOM Factor Author: Proposed Contract Year Rates in this table shall be taken from the INDIRECT RATE TABLE above.

Author: Input formulas to show the conversion of proposed rates by CFY to contract year rates. The contract year rates shall be used to populate the IDIQ Rate Tables below.

Author: Input formulas to show the conversion of proposed rates by CFY to contract year rates. The contract year rates shall be used to populate theI DIQ Rate Tables below.

Author: Input formulas to show the conversion of proposed rates by CFY to contract year rates. The contract year rates shall be used to populate the IDIQ Rate Tables below.

Author: Identify the indirect rates/burdens and FCCOM (when applicable) used to develop the ceiling rate tables below.

Author: Input proposed rate by CFY used to calculate contract year rates.

Author: Input formulas to show the conversion of proposed rates by CFY to contract year rates. The contract year rates shall be used to populate the IDIQ Rate Tables below.

Author: Proposed Contract Year Rates in this table shall be taken from the INDIRECT RATE TABLE above.

Author: Input formulas to show the conversion of proposed rates by CFY to contract year rates. The contract year rates shall be used to populate theI DIQ Rate Tables below.

Author: Input formulas to show the conversion of proposed rates by CFY to contract year rates. The contract year rates shall be used to populate the IDIQ Rate Tables below.

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 Jul 21, 2022.