Atch (L-7) CLIN Pricing Sheet-Rev1_15Jun23.xlsx

XLSX spreadsheet 42 KB Posted Jul 10, 2023

Attached to: ATAEP RFP Industry Questions and Government Responses
Solicitation number: ATAEP-0008
Issued by: Department of the Navy Naval Air Systems Command

About this file

Written by GovTribe AI · Dec 21, 2023

This document contains a pricing sheet template for a federal contract opportunity to provide aviation training analysis and evaluation products and services. The pricing sheet template includes instructions for contractors to provide hourly labor rates using Department of Labor Standard Occupational Categories and burdened labor rates for five ordering periods covering a potential five-year indefinite-delivery, indefinite-quantity contract. Rate categories include senior and junior instructional and engineering analysts, aircrew and aircraft mechanic subject matter experts, and a project manager. The related federal contract opportunity notice provides additional context, with the solicitation being for aviation training analysis and evaluation requirements issued by the Naval Air Systems Command on behalf of the Department of the Navy.

View the file

Other files

File	Type	Posted
Industry Question and Answer Form_10July2023.xlsx	XLSX spreadsheet	Jul 10, 2023

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Instructions

Aviation Training Analysis and Evaluation Products

DOL BLS Hourly Burdened Rates

Justification

Training Analysis & Training Evaluation

DOL Standard Occupational Category

DOL Funtional Factor

Only if lower than the SOC rate

SOW Ref

Government Labor Category

Contractor Equivalent Labor Category

Type

Qty

Unit

OP1

OP2

OP3

OP4

OP5

(SOC)

OP1

OP2

OP3

OP4

OP5

Step

Instructions

3.5.4.1

Sr. Instructional Analyst

FFP

Hour

To be provided by USN

In Column B of sheet titles "CLIN 1001" and "CLIN 1002" the Offeror shall insert the equivalent labor category that correlates to the Government's labor category identified in the SOW.

3.5.4.1

Journeyman Instructional Analyst

FFP

Hour

To be provided by USN

For each category the Offeror shall provide the PROPOSED hourly labor burdened rate for each Ordering Period (OP) covering the duration of the 5-year IDIQ.

3.5.4.1

Jr. Instructional Analyst

FFP

Hour

To be provided by USN

For each category the Offeror shall provide the DOL BLS hourly labor burdened rate for each Ordering Period (OP) covering the duration of the 5-year IDIQ. These rates can be found at the SOC to DOL operated website at https://www.careeronestop.org/Toolkit/ACINet.aspx, by inserting under Explore Careers, the SOC from column C and the Location, then select the Median figure of the city.

3.5.4.2

Sr. Engineering Analyst

FFP

Hour

To be provided by USN

Provide justifications, only if the proposed rate is lower than the SOC rate

3.5.4.2

Journeyman Engineering Analyst

FFP

Hour

To be provided by USN

Provide the location of performance.

3.5.4.2

Jr. Engineering Analyst

FFP

Hour

To be provided by USN

Notes: Labor burdened rates include all factors (i.e. overheads (OH), General & Administrative (G&A)…), but do not include Profit.

3.5.4.3

Pilot SME in Naval Aviation

FFP

Hour

To be provided by USN

3.5.4.3

Aircrew SME in Naval Aviation

FFP

Hour

To be provided by USN

3.5.4.3

Avionics Technician SME in Naval Aviation

FFP

Hour

To be provided by USN

3.5.4.3

Aircraft Mechanic SME in Naval Aviation

FFP

Hour

To be provided by USN

3.5.4.3

Technical SME in Naval Aviation

FFP

Hour

To be provided by USN

3.5.4.4

Project Manager

FFP

Hour

To be provided by USN

Foot Note

Hourly wages found CareerOneStop (www.careerinfonet.org or www.careeronestop.org/Toolkit/ACINet.aspx), are the same as they appear on thev DOL's Bureau of Labor Statistics (BLS) website

LOCATION:

B	The factors are based upon considerations such as education, experience, program workload assignment, and number of personnel at a location. Based upon those considerations, the government then used one of five factor choices,
	10%, 25%, Median, 75%, and 90%.

C	The government obtained the hour wages set forth in column H using the following procedures and analysis:
	1. Go to the homepage of DOL's CarrerOneStop website at https://www.careerinfonet.org. Click the Occupation Profile then type in either the O*Net Index or SOC. Then click Search.
	2. Click View Hourly Wage, then when the screen appears, click Learn More about This Occupation.
	3. Click Compare Wages by Occupation and Local Areas then select up to five occupations. Click Continue.
	4. Select the associated Metropolitan area (i.e. Jacksonville, FL; Oklahoma City, OK; or Arlington, VA). Click Continue.
	5. Comparison of national, selected state, and selected city hourly wages will be displayed in five survey groups mentioned in note (4) -- 10%, 25%, Median, 75%, and 90%.

D Table B automatically calculates based upon inputs in Table A for each respective tab (i.e., Training Analysis, Training Evaluation)

E	To simplify the proposal evaluation on PAC, ODC and Travel, the government provided the fixed amounts for these CLINs and set them as Firm Fixed Price (FFP). These are the amounts that will be considered in the price proposal
	evaluation for the purpose of establishing the total evaluated price. However, the government anticipates and reserves the right to convert the Travel CLINs (1003, 2003, 3003, 4003 and 5003), wholly or partially, to Cost No Fee CLINs,
	in the awarded contract.

Attachment L-7

Total Price

Aviation Training Analysis and Evaluation Products
CLIN Description	Tab Total
Training Analysis Labor	$ - 0
Training Evaluation Labor	$ - 0
Post Award Conference	$10,000
ODC	$250,000
Travel	$50,000
Total	$ 310,000.00

Training Analysis Labor

Aviation Training Analysis and Evaluation Products														DOL BLS Hourly Burdened Rates					Justification
Table A - Training Analysis Labor (CLINS 1001, 2001, 3001, 4001, 5001)												DOL Standard Occupational Category	DOL Funtional Factor						Only if lower than the SOC rate
				Annual	CLIN	1002	2002	3002	4002	5002
SOW Ref	Government Labor Category	Contractor Equivalent Labor Category	Type	Hours	Unit	OP1	OP2	OP3	OP4	OP5	Total	(SOC)		OP1	OP2	OP3	OP4	OP5
3.5.4.1	Sr. Instructional Analyst		FFP	1920	Hour						$ - 0	19-3032 Industrial-Organizational Psychologists	75%
3.5.4.1	Journeyman Instructional Analyst		FFP	3840	Hour						$ - 0	19-3032 Industrial-Organizational Psychologists	Median
3.5.4.1	Jr. Instructional Analyst		FFP	3840	Hour						$ - 0	19-3032 Industrial-Organizational Psychologists	10%
3.5.4.2	Sr. Engineering Analyst		FFP	96	Hour						$ - 0	17-2141 Mechanical Engineer	75%
3.5.4.2	Journeyman Engineering Analyst		FFP	192	Hour						$ - 0	17-2141 Mechanical Engineer	Median
3.5.4.2	Jr. Engineering Analyst		FFP	384	Hour						$ - 0	17-2141 Mechanical Engineer	10%
3.5.4.3	Pilot SME in Naval Aviation		FFP	480	Hour						$ - 0	53-2011 Test Pilot	Median
3.5.4.3	Aircrew SME in Naval Aviation		FFP	480	Hour						$ - 0	17-3021 Aerospace Engineering and Operations Technologists and Technicians	Median
3.5.4.3	Avionics Technician SME in Naval Aviation		FFP	480	Hour						$ - 0	49-2091 Avionics Technician	Median
3.5.4.3	Aircraft Mechanic SME in Naval Aviation		FFP	480	Hour						$ - 0	49-3011 Aircraft Mechanic	Median
3.5.4.3	Technical SME in Naval Aviation		FFP	480	Hour						$ - 0	17-3023 Electrical and Electronic Engineering Technologists and Technicians	Median
3.5.4.4	Project Manager		FFP	1920	Hour						$ - 0	13-1082 Project Management Specialists	Median
						Insert your hourly labor burdened rates in these above columns.								Insert DOL hourly labor burdened rates in these above columns.
Table B - This table auto-calculates based upon inputs in Table A above
				Annual	CLIN	1002	2002	3002	4002	5002
SOW Ref	Government Labor Category	Contractor Equivalent Labor Category (optional)	Type	Hours	Unit	OP1	OP2	OP3	OP4	OP5	Total
3.5.4.1	Sr. Instructional Analyst	0	FFP	1920	Hour	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0							Location:
3.5.4.1	Journeyman Instructional Analyst	0	FFP	3840	Hour	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3.5.4.1	Jr. Instructional Analyst	0	FFP	3840	Hour	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3.5.4.2	Sr. Engineering Analyst	0	FFP	96	Hour	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3.5.4.2	Journeyman Engineering Analyst	0	FFP	192	Hour	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3.5.4.2	Jr. Engineering Analyst	0	FFP	384	Hour	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3.5.4.3	Pilot SME in Naval Aviation	0	FFP	480	Hour	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3.5.4.3	Aircrew SME in Naval Aviation	0	FFP	480	Hour	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3.5.4.3	Avionics Technician SME in Naval Aviation	0	FFP	480	Hour	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3.5.4.3	Aircraft Mechanic SME in Naval Aviation	0	FFP	480	Hour	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3.5.4.3	Technical SME in Naval Aviation	0	FFP	480	Hour	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3.5.4.4	Project Manager	0	FFP	1920	Hour	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Profit Rate (%)										$ - 0
	Profit Dollars					$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Total Price					$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Total Estimated Annual Labor Hours			14592
						Insert your profit rate in the above row identified for the profit rate columns.

Training Evaluation Labor

Aviation Training Analysis and Evaluation Products														DOL BLS Hourly Burdened Rates					Justification
Table A - Training Evaluation Labor (CLINS 1002, 2002, 3002, 4002, 5002)												DOL Standard Occupational Category	DOL Funtional Factor						Only if lower than the SOC rate
				Annual	CLIN	1002	2002	3002	4002	5002
SOW Ref	Government Labor Category	Contractor Equivalent Labor Category (optional)	Type	Hours	Unit	OP1	OP2	OP3	OP4	OP5	Total	(SOC)		OP1	OP2	OP3	OP4	OP5
3.5.4.1	Sr. Instructional Analyst		FFP	960	Hour						$ - 0	19-3032 Industrial-Organizational Psychologists	75%
3.5.4.1	Journeyman Instructional Analyst		FFP	1920	Hour						$ - 0	19-3032 Industrial-Organizational Psychologists	Median
3.5.4.1	Jr. Instructional Analyst		FFP	960	Hour						$ - 0	19-3032 Industrial-Organizational Psychologists	10%
3.5.4.2	Sr. Engineering Analyst		FFP	192	Hour						$ - 0	17-2141 Mechanical Engineer	75%
3.5.4.2	Journeyman Engineering Analyst		FFP	435	Hour						$ - 0	17-2141 Mechanical Engineer	Median
3.5.4.2	Jr. Engineering Analyst		FFP	435	Hour						$ - 0	17-2141 Mechanical Engineer	10%
3.5.4.3	Pilot SME in Naval Aviation		FFP	480	Hour						$ - 0	53-2011 Test Pilot	Median
3.5.4.3	Aircrew SME in Naval Aviation		FFP	480	Hour						$ - 0	17-3021 Aerospace Engineering and Operations Technologists and Technicians	Median
3.5.4.3	Avionics Technician SME in Naval Aviation		FFP	480	Hour						$ - 0	49-2091 Avionics Technician	Median
3.5.4.3	Aircraft Mechanic SME in Naval Aviation		FFP	480	Hour						$ - 0	49-3011 Aircraft Mechanic	Median
3.5.4.3	Technical SME in Naval Aviation		FFP	480	Hour						$ - 0	17-3023 Electrical and Electronic Engineering Technologists and Technicians	Median
3.5.4.4	Project Manager		FFP	1920	Hour						$ - 0	13-1082 Project Management Specialists	Median
						Insert your hourly labor burdened rates in these above columns.								Insert DOL hourly labor burdened rates in these above columns.
Table B - This table auto-calculates based upon inputs in Table A above
				Annual	CLIN	1002	2002	3002	4002	5002
SOW Ref	Government Labor Category	Contractor Equivalent Labor Category (optional)	Type	Hours	Unit	OP1	OP2	OP3	OP4	OP5	Total
3.5.4.1	Sr. Instructional Analyst	0	FFP	960	Hour	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0							Location:
3.5.4.1	Journeyman Instructional Analyst	0	FFP	1920	Hour	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3.5.4.1	Jr. Instructional Analyst	0	FFP	960	Hour	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3.5.4.2	Sr. Engineering Analyst	0	FFP	192	Hour	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3.5.4.2	Journeyman Engineering Analyst	0	FFP	435	Hour	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3.5.4.2	Jr. Engineering Analyst	0	FFP	435	Hour	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3.5.4.3	Pilot SME in Naval Aviation	0	FFP	480	Hour	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3.5.4.3	Aircrew SME in Naval Aviation	0	FFP	480	Hour	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3.5.4.3	Avionics Technician SME in Naval Aviation	0	FFP	480	Hour	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3.5.4.3	Aircraft Mechanic SME in Naval Aviation	0	FFP	480	Hour	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3.5.4.3	Technical SME in Naval Aviation	0	FFP	480	Hour	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3.5.4.4	Project Manager	0	FFP	1920	Hour	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Profit Rate (%)										$ - 0	$ - 0
	Profit Dollars					$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Total Price					$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Total Estimated Annual Labor Hours			9222
						Insert your profit rate in the above row identified for the profit rate columns.

Non-Labor CLINs (ODC & Travel)

Aviation Training Analysis and Evaluation Products
Table C - Post Award Conference, Travel & ODC (CLINS 0001, 1003, 1004, 2003, 2004, 3003, 3004, 4003, 4004, 5003, 5004)
CLIN Description	Type	CLIN	OP1	OP2	OP3	OP4	OP5	Total
Post Award Conference	FFP	CLIN	0001
		PAC Amount	$10,000					$10,000
Travel	FFP	CLIN	1003	2003	3003	4003	5003
		Travel Amount	$50,000	$50,000	$50,000	$50,000	$50,000	$250,000
ODC	FFP	CLIN	1004	2004	3004	4004	5004
		ODC Amount	$10,000	$10,000	$10,000	$10,000	$10,000	$50,000

File details come from the government source that posted it. Updated Jul 10, 2023.