Atch (L-7) CLIN Pricing Sheet_NEW_11APR23.xlsx

XLSX spreadsheet 25 KB Posted

Attached to
ATAEP DRAFT RFP
Solicitation number
ATAEP-0004
Issued by

View the file

Other files

File Type Posted
DRAFT ATAEP RFP.docx DOCX document
Atch (L-8) Past Performance Contract Reference Worksheet.docx DOCX document
Attachment 1 - ATAEP IDIQ SOW.docx DOCX document
Atch (L-2) CE Contract Data.xlsx XLSX spreadsheet
Exhibit A - Analysis and Eval Base IDIQ CDRLs B001-B005.docx DOCX document
Atch (L-5) Contractor Performance Assessment Questionaire (CPAQ).docx DOCX document
Atch (L-1) Q and A Form.xlsx XLSX spreadsheet
Atch (L-3) COTS User Manual.pdf PDF
Atch (L-9) SAMPLE DOL BLS Pricing Sheet.xlsx XLSX spreadsheet
Attachment 2 - Data-Item-Transmittal-2018.pdf PDF
Atch (L-4) Training Task Selection.xlsx XLSX spreadsheet
Atch (L-6) Relevancy Information of the PP Contract_July2021.docx DOCX document
Show all 12

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 ProductsDOL BLS Hourly Burdened RatesJustification
Training Analysis & Training EvaluationDOL Standard Occupational CategoryDOL Funtional FactorOnly if lower than the SOC rate
SOW RefGovernment Labor CategoryContractor Equivalent Labor CategoryTypeQtyUnitOP1OP2OP3OP4OP5(SOC)OP1OP2OP3OP4OP5StepInstructions
3.5.4.1Sr. Instructional Analyst<Insert equivalent labor category from contractor's organization that correlates to a Sr. Instructional Analyst>FFP1HourTo be provided by USN<provide justification only if the proposed rate is lower than the DOL rate>1In 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.1Journeyman Instructional Analyst<Insert equivalent labor category from contractor's organization that correlates to a Journeyman Instuctional Analyst>FFP1HourTo be provided by USN<provide justification only if the proposed rate is lower than the DOL rate>2For 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.1Jr. Instructional Analyst<Insert equivalent labor category from contractor's organization that correlates to a Jr. Instuctional Analyst>FFP1HourTo be provided by USN<provide justification only if the proposed rate is lower than the DOL rate>3For 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.2Sr. Engineering Analyst<Insert equivalent labor category from contractor's organization that correlates to a Sr. Engineering Analyst>FFP1HourTo be provided by USN<provide justification only if the proposed rate is lower than the DOL rate>4Provide justifications, only if the proposed rate is lower than the SOC rate
3.5.4.2Journeyman Engineering Analyst<Insert equivalent labor category from contractor's organization that correlates to a Journeyman Engineering Analyst>FFP1HourTo be provided by USN<provide justification only if the proposed rate is lower than the DOL rate>5Provide the location of performance.
3.5.4.2Jr. Engineering Analyst<Insert equivalent labor category from contractor's organization that correlates to a Jr. Engineering Analyst>FFP1HourTo be provided by USN<provide justification only if the proposed rate is lower than the DOL rate>Notes: Labor burdened rates include all factors (i.e. overheads (OH), General & Administrative (G&A)…), but do not include Profit.
3.5.4.3Pilot SME in Naval Aviation<Insert equivalent labor category from contractor's organization that correlates to a SME in Naval Aviation>FFP1HourTo be provided by USN<provide justification only if the proposed rate is lower than the DOL rate>
3.5.4.3Aircrew SME in Naval Aviation<Insert equivalent labor category from contractor's organization that correlates to a SME in Naval Aviation>FFP1HourTo be provided by USN<provide justification only if the proposed rate is lower than the DOL rate>
3.5.4.3Avionics Technician SME in Naval Aviation<Insert equivalent labor category from contractor's organization that correlates to a SME in Naval Aviation>FFP1HourTo be provided by USN<provide justification only if the proposed rate is lower than the DOL rate>
3.5.4.3Aircraft Mechanic SME in Naval Aviation<Insert equivalent labor category from contractor's organization that correlates to a SME in Naval Aviation>FFP1HourTo be provided by USN<provide justification only if the proposed rate is lower than the DOL rate>
3.5.4.3Technical SME in Naval Aviation<Insert equivalent labor category from contractor's organization that correlates to a SME in Naval Aviation>FFP1HourTo be provided by USN<provide justification only if the proposed rate is lower than the DOL rate>
3.5.4.4Project Manager<Insert equivalent labor category from contractor's organization that correlates to a SME in Naval Aviation>FFP1HourTo be provided by USN<provide justification only if the proposed rate is lower than the DOL rate>
<Insert your hourly labor burdened rates><Insert DOL BLS rates here>
Foot Note
AHourly wages found CareerOneStop (www.careerinfonet.org), are the same as they appear on thev DOL's Bureau of Labor Statistics (BLS) websiteLOCATION:
BThe government applied these factors to the different labor categories using Orlando Florida as an example in attempt to account for different aspects or functions of a proposed labor category and its location.
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%.
CThe 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)

Attachment L-7

Training Analysis

Aviation Training Analysis and Evaluation ProductsDOL BLS Hourly Burdened RatesJustification
Table A - Training Analysis (CLINS 1001, 2001, 3001, 4001, 5001)DOL Standard Occupational CategoryDOL Funtional FactorOnly if lower than the SOC rate
SOW RefGovernment Labor CategoryContractor Equivalent Labor CategoryTypeQtyUnitOP1OP2OP3OP4OP5(SOC)OP1OP2OP3OP4OP5
3.5.4.1Sr. Instructional AnalystFFP1920Hour19-3032 Industrial-Organizational Psychologists75%
3.5.4.1Journeyman Instructional AnalystFFP3840Hour19-3032 Industrial-Organizational PsychologistsMedian
3.5.4.1Jr. Instructional AnalystFFP3840Hour19-3032 Industrial-Organizational Psychologists10%
3.5.4.2Sr. Engineering AnalystFFP96Hour17-2141 Mechanical Engineer75%
3.5.4.2Journeyman Engineering AnalystFFP192Hour17-2141 Mechanical EngineerMedian
3.5.4.2Jr. Engineering AnalystFFP384Hour17-2141 Mechanical Engineer10%
3.5.4.3Pilot SME in Naval AviationFFP480Hour53-2011 Test PilotMedian
3.5.4.3Aircrew SME in Naval AviationFFP480Hour17-3021 Aerospace Engineering and Operations Technologists and TechniciansMedian
3.5.4.3Avionics Technician SME in Naval AviationFFP480Hour49-2091 Avionics TechnicianMedian
3.5.4.3Aircraft Mechanic SME in Naval AviationFFP480Hour49-3011 Aircraft MechanicMedian
3.5.4.3Technical SME in Naval AviationFFP480Hour17-3023 Electrical and Electronic Engineering Technologists and TechniciansMedian
3.5.4.4Project ManagerFFP1920Hour13-1082 Project Management SpecialistsMedian
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
SOW RefGovernment Labor CategoryContractor Equivalent Labor Category (optional)TypeQtyUnitOP1OP2OP3OP4OP5
3.5.4.1Sr. Instructional Analyst0FFP960Hour$ - 0$ - 0$ - 0$ - 0$ - 0Location:
3.5.4.1Journeyman Instructional Analyst0FFP1920Hour$ - 0$ - 0$ - 0$ - 0$ - 0
3.5.4.1Jr. Instructional Analyst0FFP960Hour$ - 0$ - 0$ - 0$ - 0$ - 0
3.5.4.2Sr. Engineering Analyst0FFP192Hour$ - 0$ - 0$ - 0$ - 0$ - 0
3.5.4.2Journeyman Engineering Analyst0FFP435Hour$ - 0$ - 0$ - 0$ - 0$ - 0
3.5.4.2Jr. Engineering Analyst0FFP435Hour$ - 0$ - 0$ - 0$ - 0$ - 0
3.5.4.3Pilot SME in Naval Aviation0FFP480Hour$ - 0$ - 0$ - 0$ - 0$ - 0
3.5.4.3Aircrew SME in Naval Aviation0FFP480Hour$ - 0$ - 0$ - 0$ - 0$ - 0
3.5.4.3Avionics Technician SME in Naval Aviation0FFP480Hour$ - 0$ - 0$ - 0$ - 0$ - 0
3.5.4.3Aircraft Mechanic SME in Naval Aviation0FFP480Hour$ - 0$ - 0$ - 0$ - 0$ - 0
3.5.4.3Technical SME in Naval Aviation0FFP480Hour$ - 0$ - 0$ - 0$ - 0$ - 0
3.5.4.4Project Manager0FFP1920Hour$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Training Evaluation

Aviation Training Analysis and Evaluation ProductsDOL BLS Hourly Burdened RatesJustification
Table A - Training Evaluation (CLINS 1002, 2002, 3002, 4002, 5002)DOL Standard Occupational CategoryDOL Funtional FactorOnly if lower than the SOC rate
SOW RefGovernment Labor CategoryContractor Equivalent Labor Category (optional)TypeQtyUnitOP1OP2OP3OP4OP5(SOC)OP1OP2OP3OP4OP5
3.5.4.1Sr. Instructional AnalystFFP1Hour19-3032 Industrial-Organizational Psychologists75%
3.5.4.1Journeyman Instructional AnalystFFP1Hour19-3032 Industrial-Organizational PsychologistsMedian
3.5.4.1Jr. Instructional AnalystFFP1Hour19-3032 Industrial-Organizational Psychologists10%
3.5.4.2Sr. Engineering AnalystFFP1Hour17-2141 Mechanical Engineer75%
3.5.4.2Journeyman Engineering AnalystFFP1Hour17-2141 Mechanical EngineerMedian
3.5.4.2Jr. Engineering AnalystFFP1Hour17-2141 Mechanical Engineer10%
3.5.4.3Pilot SME in Naval AviationFFP1Hour53-2011 Test PilotMedian
3.5.4.3Aircrew SME in Naval AviationFFP1Hour17-3021 Aerospace Engineering and Operations Technologists and TechniciansMedian
3.5.4.3Avionics Technician SME in Naval AviationFFP1Hour49-2091 Avionics TechnicianMedian
3.5.4.3Aircraft Mechanic SME in Naval AviationFFP1Hour49-3011 Aircraft MechanicMedian
3.5.4.3Technical SME in Naval AviationFFP1Hour17-3023 Electrical and Electronic Engineering Technologists and TechniciansMedian
3.5.4.4Project ManagerFFP1Hour13-1082 Project Management SpecialistsMedian
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
SOW RefGovernment Labor CategoryContractor Equivalent Labor Category (optional)TypeQtyUnitOP1OP2OP3OP4OP5
3.5.4.1Sr. Instructional Analyst0FFP960Hour$ - 0$ - 0$ - 0$ - 0$ - 0Location:
3.5.4.1Journeyman Instructional Analyst0FFP1920Hour$ - 0$ - 0$ - 0$ - 0$ - 0
3.5.4.1Jr. Instructional Analyst0FFP960Hour$ - 0$ - 0$ - 0$ - 0$ - 0
3.5.4.2Sr. Engineering Analyst0FFP192Hour$ - 0$ - 0$ - 0$ - 0$ - 0
3.5.4.2Journeyman Engineering Analyst0FFP435Hour$ - 0$ - 0$ - 0$ - 0$ - 0
3.5.4.2Jr. Engineering Analyst0FFP435Hour$ - 0$ - 0$ - 0$ - 0$ - 0
3.5.4.3Pilot SME in Naval Aviation0FFP480Hour$ - 0$ - 0$ - 0$ - 0$ - 0
3.5.4.3Aircrew SME in Naval Aviation0FFP480Hour$ - 0$ - 0$ - 0$ - 0$ - 0
3.5.4.3Avionics Technician SME in Naval Aviation0FFP480Hour$ - 0$ - 0$ - 0$ - 0$ - 0
3.5.4.3Aircraft Mechanic SME in Naval Aviation0FFP480Hour$ - 0$ - 0$ - 0$ - 0$ - 0
3.5.4.3Technical SME in Naval Aviation0FFP480Hour$ - 0$ - 0$ - 0$ - 0$ - 0
3.5.4.4Project Manager0FFP1920Hour$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

File details come from the government source that posted it. Updated .