SEMATS_2_FFP-LOE_Section_L_Attachment_6b.xlsx

XLSX spreadsheet 57 KB Posted

Attached to
SEMATS 2 Federal contract opportunity
Solicitation number
FA2486-16-R-0065
Issued by
Department of the Air Force Materiel Command Test Center

About this file

FA2486-16-R-0065 Section L Attachment 6b

View the file

Other files for this federal contract opportunity

Other files attached to SEMATS 2, newest first.
File Type Posted
SEMATS_2_FFP-LOE_Section_L_Attachment_6b_Version_1.1.xlsx XLSX spreadsheet
SEMATS_2_Task_Order_2_(19_Oct_15).docx DOCX document
SEMATS_2_Task_Order_1_(19_Oct_15).docx DOCX document
SEMATS_2_TEP_Summary_Section_L_Attachment_6a_Version_1.0.xlsx XLSX spreadsheet
FA2486-16-R-0065_0003.pdf PDF
SEMATS_2_Section_L_Version_1.0.docx DOCX document
Questions_and_Answers.docx DOCX document
FA2486-16-R-0065_0002.pdf PDF
SEMATS_2_FFP-LOE_Section_L_Attachment_6b_Version_1.0.xlsx XLSX spreadsheet
SEMATS_2_Section_M_Version_1.0.docx DOCX document
FA2486-16-R-0065_Amendment_0001.pdf PDF
GFAX_2015-12-09_09_41_08_263.pdf PDF
ppi_tool.accdb —
RFP_Cover_Letter_FINAL.pdf PDF
SEMATS_2_Section_M_19_Oct_2015.pdf PDF
SEMATS_2_TEP_Summary_Section_L_Attachment_6a.xlsx XLSX spreadsheet
FA2486-16-R-0065_SEMATS_II_30_Nov.pdf PDF
SEMATS_2_Rate_Table_Section_J_Attachment_3.xlsx XLSX spreadsheet
SEMATS_2_Section_L_19_Oct_2015.pdf PDF
SSP_SEMATS_2_-_For_Release_with_RFP.pdf PDF
Show all 20

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

Text version

TEP

Section L, Attachment 6b
Total Evaluated Price
Year 1Year 2Year 3Year 4Year 552.217-8*Total
Total Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
StartEnd
Government Fiscal Year1 October30 September
Notes:Instructions:
1. Contractor Man-year Equivalent = 1,920 Hours* These are the only fill-in blocks on this spreadsheet.
2. Insert Firm-Fixed Price Labor Hour Rates.
3. The SEMATS 2 PWS gives contract requirements for all Labor Categories. Utilize the Government provided labor categories, number of hours, and skill level to meet contract requirements.Those labor catagories with one hour and the 52.217-8 pricing are part of the TEP, but will be excluded from TO 0001 and TO 0002 pricing.
4. No cross-utilization and reach back are unauthorized.
5. Submit only one copy of this spreadsheet. Submit only one firm-fixed price. Do not separately price subcontracts, teaming arrangements, or joint ventures.
6. Assume a contract performance period of 1 June 2016 to 30 April 2021.

&KFF0000Insert Company Name, Insert Business Unit Name, and any proprietary information.

FA2486-15-R-0030, Volume III, Section 2, Offeror Summary Page &P of &N

&KFF0000Insert Company Name and any proprietary information.

Year 1

Year 1
Labor Category/Skill LevelLevel of Effort (Hours)Hours FY16Rate FY16Sub TotalHours FY17Rate FY17Sub TotalHour CheckTotal
InstructionsB = C + FEnter portion of hours for FY16Enter FY16 RateMultiply C by DEnter portion of hours for FY17Enter FY17 RateMultiply F by GAdd C and F; This total shall match BAdd E and H
EXAMPLE1,98099045.9545,490.5099046.9546,480.501,98091,971.00
Aeronautical/Aerospace Engineering 11----
Aeronautical/Aerospace Engineering 214,080----
Aeronautical/Aerospace Engineering 321,120----
Aeronautical/Aerospace Engineering 410,560----
Computer Engineering 11----
Computer Engineering 21----
Computer Engineering 31,760----
Computer Engineering 41,760----
Electronic/Electrical Engineering 11----
Electronic/Electrical Engineering 21,760----
Electronic/Electrical Engineering 33,520----
Electronic/Electrical Engineering 41,760----
Mechanical Engineering 11----
Mechanical Engineering 21----
Mechanical Engineering 31,760----
Mechanical Engineering 41,760----
Physics/Mathematics 11----
Physics/Mathematics 21----
Physics/Mathematics 31,760----
Physics/Mathematics 41----
Software Engineering/Computer Science 11,760----
Software Engineering/Computer Science 221,120----
Software Engineering/Computer Science 326,400----
Software Engineering/Computer Science 410,560----
Administrative Specialist1,760----
Computer-Aided Design Specialist 11----
Computer-Aided Design Specialist 21,760----
Computer-Aided Design Specialist 35,280----
Computer-Aided Design Specialist 41----
Labor Category/Skill Level Yr 1Level of Effort (Hours)Hours FY16Rate FY16Sub TotalHours FY17Rate FY17Sub TotalHour CheckTotal
Configuration/Data Manager 11----
Configuration/Data Manager 21,760----
Configuration/Data Manager 31,760----
Configuration/Data Manager 41----
Contract Manager1,760----
Information Technology Specialist 11----
Information Technology Specialist 28,800----
Information Technology Specialist 38,800----
Information Technology Specialist 43,520----
Ordnance Specialist 11----
Ordnance Specialist 21----
Ordnance Specialist 33,520----
Ordnance Specialist 41----
Project Manager 11----
Project Manager 21----
Project Manager 310,560----
Project Manager 43,520----
(YEAR 1) TOTAL174,259------
Notes:
* These are the only fill-in blocks on this spreadsheet.
1. Contractor Man-year Equivalent = 1,920 Hours
2. Insert Firm-Fixed Price Labor Hour Rates.
3. The SEMATS 2 PWS gives contract requirements for all Labor Categories. Utilize the Government provided labor categories, number of hours, and skill level to meet contract requirements.
4. No cross-utilization and reach back are unauthorized.
5. Assume a contract performance period of 1 May 2016 to 30 April 2021.
6. Assume an option period of performance of 1 June 2016 - 30 April 2017.

&KFF0000Insert Company Name, and any proprietary information. FA2486-15-R-0030, Volume III, Section 2, Year 1 Page &P of &N and any proprietary information.

Year 2

Year 2
Labor Category/Skill LevelLevel of Effort (Hours)Hours FY17Rate FY17Sub TotalHours FY18Rate FY18Sub TotalHour CheckTotal
InstructionsB = C + FEnter portion of hours for FY17Enter FY17 RateMultiply C by DEnter portion of hours for FY18Enter FY18 RateMultiply F by GAdd C and F; This total shall match BAdd E and H
EXAMPLE1,98099045.9545,490.5099046.9546,480.501,98091,971.00
Aeronautical/Aerospace Engineering 11----
Aeronautical/Aerospace Engineering 215,360----
Aeronautical/Aerospace Engineering 323,040----
Aeronautical/Aerospace Engineering 411,520----
Computer Engineering 11----
Computer Engineering 21----
Computer Engineering 31,920----
Computer Engineering 41,920----
Electronic/Electrical Engineering 11----
Electronic/Electrical Engineering 21,920----
Electronic/Electrical Engineering 33,840----
Electronic/Electrical Engineering 41,920----
Mechanical Engineering 11----
Mechanical Engineering 21----
Mechanical Engineering 31,920----
Mechanical Engineering 41,920----
Physics/Mathematics 11----
Physics/Mathematics 21----
Physics/Mathematics 31,920----
Physics/Mathematics 41----
Software Engineering/Computer Science 11,920----
Software Engineering/Computer Science 223,040----
Software Engineering/Computer Science 328,800----
Software Engineering/Computer Science 411,520----
Administrative Specialist1,920----
Computer-Aided Design Specialist 11----
Computer-Aided Design Specialist 21,920----
Computer-Aided Design Specialist 35,760----
Computer-Aided Design Specialist 41----
Labor Category/Skill Level Yr 2Level of Effort (Hours)Hours FY17Rate FY17Sub TotalHours FY18Rate FY18Sub TotalHour CheckTotal
Configuration/Data Manager 11----
Configuration/Data Manager 21,920----
Configuration/Data Manager 31,920----
Configuration/Data Manager 41----
Contract Manager1,920----
Information Technology Specialist 11----
Information Technology Specialist 29,600----
Information Technology Specialist 39,600----
Information Technology Specialist 43,840----
Ordnance Specialist 11----
Ordnance Specialist 21----
Ordnance Specialist 33,840----
Ordnance Specialist 41----
Project Manager 11----
Project Manager 21----
Project Manager 313,440----
Project Manager 43,840----
(YEAR 2) TOTAL192,019------
Notes:
* These are the only fill-in blocks on this spreadsheet.
1. Contractor Man-year Equivalent = 1,920 Hours
2. Insert Firm-Fixed Price Labor Hour Rates.
3. The SEMATS 2 PWS gives contract requirements for all Labor Categories. Utilize the Government provided labor categories, number of hours, and skill level to meet contract requirements.
4. No cross-utilization and reach back are unauthorized.
5. Assume a contract performance period of 1 May 2016 to 30 April 2021.
6 Assume an option period of performance of 1 May 2017 - 30 April 2018.

&KFF0000Insert Company Name, and any proprietary information. FA2486-15-R-0030, Volume III, Year 2 and any proprietary information.

Year 3

Year 3
Labor Category/Skill LevelLevel of Effort (Hours)Hours FY18Rate FY18Sub TotalHours FY19Rate FY19Sub TotalHour CheckTotal
InstructionsB = C + FEnter portion of hours for FY18Enter FY18 RateMultiply C by DEnter portion of hours for FY19Enter FY19 RateMultiply F by GAdd C and F; This total shall match BAdd E and H
EXAMPLE1,98099045.9545,490.5099046.9546,480.501,98091,971.00
Aeronautical/Aerospace Engineering 11----
Aeronautical/Aerospace Engineering 215,360----
Aeronautical/Aerospace Engineering 323,040----
Aeronautical/Aerospace Engineering 411,520----
Computer Engineering 11----
Computer Engineering 21----
Computer Engineering 31,920----
Computer Engineering 41,920----
Electronic/Electrical Engineering 11----
Electronic/Electrical Engineering 21,920----
Electronic/Electrical Engineering 33,840----
Electronic/Electrical Engineering 41,920----
Mechanical Engineering 11----
Mechanical Engineering 21----
Mechanical Engineering 31,920----
Mechanical Engineering 41,920----
Physics/Mathematics 11----
Physics/Mathematics 21----
Physics/Mathematics 31,920----
Physics/Mathematics 41----
Software Engineering/Computer Science 11,920----
Software Engineering/Computer Science 223,040----
Software Engineering/Computer Science 328,800----
Software Engineering/Computer Science 411,520----
Administrative Specialist1,920----
Computer-Aided Design Specialist 11----
Computer-Aided Design Specialist 21,920----
Computer-Aided Design Specialist 35,760----
Computer-Aided Design Specialist 41----
Labor Category/Skill Level Yr 3Level of Effort (Hours)Hours FY18Rate FY18Sub TotalHours FY19Rate FY19Sub TotalHour CheckTotal
Configuration/Data Manager 11----
Configuration/Data Manager 21,920----
Configuration/Data Manager 31,920----
Configuration/Data Manager 41----
Contract Manager1,920----
Information Technology Specialist 11----
Information Technology Specialist 29,600----
Information Technology Specialist 39,600----
Information Technology Specialist 43,840----
Ordnance Specialist 11----
Ordnance Specialist 21----
Ordnance Specialist 33,840----
Ordnance Specialist 41----
Project Manager 11----
Project Manager 21----
Project Manager 313,440----
Project Manager 43,840----
(YEAR 3) TOTAL192,019------
Notes:
* These are the only fill-in blocks on this spreadsheet.
1. Contractor Man-year Equivalent = 1,920 Hours
2. Insert Firm-Fixed Price Labor Hour Rates.
3. The SEMATS 2 PWS gives contract requirements for all Labor Categories. Utilize the Government provided labor categories, number of hours, and skill level to meet contract requirements.
4. No cross-utilization and reach back are unauthorized.
5. Assume a contract performance period of 1 May 2016 to 30 April 2021.
6 Assume an option period of performance of 1 May 2018 - 30 April 2019.

&KFF0000Insert Company Name, and any proprietary information. FA2486-15-R-0030, Volume III, Year 3 and any proprietary information.

Year 4

Year 4
Labor Category/Skill LevelLevel of Effort (Hours)Hours FY19Rate FY19Sub TotalHours FY20Rate FY20Sub TotalHour CheckTotal
InstructionsB = C + FEnter portion of hours for FY19Enter FY19 RateMultiply C by DEnter portion of hours for FY20Enter FY20 RateMultiply F by GAdd C and F; This total shall match BAdd E and H
EXAMPLE1,98099045.9545,490.5099046.9546,480.501,98091,971.00
Aeronautical/Aerospace Engineering 11----
Aeronautical/Aerospace Engineering 215,360----
Aeronautical/Aerospace Engineering 323,040----
Aeronautical/Aerospace Engineering 411,520----
Computer Engineering 11----
Computer Engineering 21----
Computer Engineering 31,920----
Computer Engineering 41,920----
Electronic/Electrical Engineering 11----
Electronic/Electrical Engineering 21,920----
Electronic/Electrical Engineering 33,840----
Electronic/Electrical Engineering 41,920----
Mechanical Engineering 11----
Mechanical Engineering 21----
Mechanical Engineering 31,920----
Mechanical Engineering 41,920----
Physics/Mathematics 11----
Physics/Mathematics 21----
Physics/Mathematics 31,920----
Physics/Mathematics 41----
Software Engineering/Computer Science 11,920----
Software Engineering/Computer Science 223,040----
Software Engineering/Computer Science 328,800----
Software Engineering/Computer Science 411,520----
Administrative Specialist1,920----
Computer-Aided Design Specialist 11----
Computer-Aided Design Specialist 21,920----
Computer-Aided Design Specialist 35,760----
Computer-Aided Design Specialist 41----
Labor Category/Skill Level Yr 4Level of Effort (Hours)Hours FY19Rate FY19Sub TotalHours FY20Rate FY20Sub TotalHour CheckTotal
Configuration/Data Manager 11----
Configuration/Data Manager 21,920----
Configuration/Data Manager 31,920----
Configuration/Data Manager 41----
Contract Manager1,920----
Information Technology Specialist 11----
Information Technology Specialist 29,600----
Information Technology Specialist 39,600----
Information Technology Specialist 43,840----
Ordnance Specialist 11----
Ordnance Specialist 21----
Ordnance Specialist 33,840----
Ordnance Specialist 41----
Project Manager 11----
Project Manager 21----
Project Manager 313,440----
Project Manager 43,840----
(YEAR 4) TOTAL192,019------
Notes:
* These are the only fill-in blocks on this spreadsheet.
1. Contractor Man-year Equivalent = 1,920 Hours
2. Insert Firm-Fixed Price Labor Hour Rates.
3. The SEMATS 2 PWS gives contract requirements for all Labor Categories. Utilize the Government provided labor categories, number of hours, and skill level to meet contract requirements.
4. No cross-utilization and reach back are unauthorized.
5. Assume a contract performance period of 1 May 2016 to 30 April 2021.
6 Assume an option period of performance of 1 May 2019 - 30 April 2020.

&KFF0000Insert Company Name, and any proprietary information. FA2486-15-R-0030, Volume III, Year 4 and any proprietary information.

Year 5

Year 5
Labor Category/Skill LevelLevel of Effort (Hours)Hours FY20Rate FY20Sub TotalHours FY21Rate FY21Sub TotalHour CheckTotal
InstructionsB = C + FEnter portion of hours for FY20Enter FY20 RateMultiply C by DEnter portion of hours for FY21Enter FY21 RateMultiply F by GAdd C and F; This total shall match BAdd E and H
EXAMPLE1,98099045.9545,490.5099046.9546,480.501,98091,971.00
Aeronautical/Aerospace Engineering 11----
Aeronautical/Aerospace Engineering 215,360----
Aeronautical/Aerospace Engineering 323,040----
Aeronautical/Aerospace Engineering 411,520----
Computer Engineering 11----
Computer Engineering 21----
Computer Engineering 31,920----
Computer Engineering 41,920----
Electronic/Electrical Engineering 11----
Electronic/Electrical Engineering 21,920----
Electronic/Electrical Engineering 33,840----
Electronic/Electrical Engineering 41,920----
Mechanical Engineering 11----
Mechanical Engineering 21----
Mechanical Engineering 31,920----
Mechanical Engineering 41,920----
Physics/Mathematics 11----
Physics/Mathematics 21----
Physics/Mathematics 31,920----
Physics/Mathematics 41----
Software Engineering/Computer Science 11,920----
Software Engineering/Computer Science 223,040----
Software Engineering/Computer Science 328,800----
Software Engineering/Computer Science 411,520----
Administrative Specialist1,920----
Computer-Aided Design Specialist 11----
Computer-Aided Design Specialist 21,920----
Computer-Aided Design Specialist 35,760----
Computer-Aided Design Specialist 41----
Labor Category/Skill Level Yr 5Level of Effort (Hours)Hours FY20Rate FY20Sub TotalHours FY21Rate FY21Sub TotalHour CheckTotal
Configuration/Data Manager 11----
Configuration/Data Manager 21,920----
Configuration/Data Manager 31,920----
Configuration/Data Manager 41----
Contract Manager1,920----
Information Technology Specialist 11----
Information Technology Specialist 29,600----
Information Technology Specialist 39,600----
Information Technology Specialist 43,840----
Ordnance Specialist 11----
Ordnance Specialist 21----
Ordnance Specialist 33,840----
Ordnance Specialist 41----
Project Manager 11----
Project Manager 21----
Project Manager 313,440----
Project Manager 43,840----
(YEAR 5) TOTAL192,019------
Notes:
* These are the only fill-in blocks on this spreadsheet.
1. Contractor Man-year Equivalent = 1,920 Hours
2. Insert Firm-Fixed Price Labor Hour Rates.
3. The SEMATS 2 PWS gives contract requirements for all Labor Categories. Utilize the Government provided labor categories, number of hours, and skill level to meet contract requirements.
4. No cross-utilization and reach back are unauthorized.
5. Assume a contract performance period of 1 May 2016 to 30 April 2021.
6 Assume an option period of performance of 1 May 2020 - 30 April 2021.

&KFF0000Insert Company Name, and any proprietary information. FA2486-15-R-0030, Volume III, Year 5 and any proprietary information.

52.217-8

Year 5
Labor Category/Skill LevelLevel of Effort (Hours)Hours FY20Rate FY20Sub TotalHours FY21Rate FY21Sub TotalHour CheckTotal
InstructionsB = C + FEnter portion of hours for FY20Enter FY20 RateMultiply C by DEnter portion of hours for FY21Enter FY21 RateMultiply F by GAdd C and F; This total shall match BAdd E and H
EXAMPLE1,98099045.9545,490.5099046.9546,480.501,98091,971.00
Aeronautical/Aerospace Engineering 11----
Aeronautical/Aerospace Engineering 27,680----
Aeronautical/Aerospace Engineering 311,520----
Aeronautical/Aerospace Engineering 45,760----
Computer Engineering 11----
Computer Engineering 21----
Computer Engineering 3960----
Computer Engineering 4960----
Electronic/Electrical Engineering 11----
Electronic/Electrical Engineering 2960----
Electronic/Electrical Engineering 31,920----
Electronic/Electrical Engineering 4960----
Mechanical Engineering 11----
Mechanical Engineering 21----
Mechanical Engineering 3960----
Mechanical Engineering 4960----
Physics/Mathematics 11----
Physics/Mathematics 21----
Physics/Mathematics 3960----
Physics/Mathematics 41----
Software Engineering/Computer Science 1960----
Software Engineering/Computer Science 211,520----
Software Engineering/Computer Science 314,400----
Software Engineering/Computer Science 45,760----
Administrative Specialist960----
Computer-Aided Design Specialist 11----
Computer-Aided Design Specialist 2960----
Computer-Aided Design Specialist 32,880----
Computer-Aided Design Specialist 41----
Labor Category/Skill Level Yr 5Level of Effort (Hours)Hours FY20Rate FY20Sub TotalHours FY21Rate FY21Sub TotalHour CheckTotal
Configuration/Data Manager 11----
Configuration/Data Manager 2960----
Configuration/Data Manager 3960----
Configuration/Data Manager 41----
Contract Manager960----
Information Technology Specialist 11----
Information Technology Specialist 24,800----
Information Technology Specialist 34,800----
Information Technology Specialist 41,920----
Ordnance Specialist 11----
Ordnance Specialist 21----
Ordnance Specialist 31,920----
Ordnance Specialist 41----
Project Manager 11----
Project Manager 21----
Project Manager 36,720----
Project Manager 41,920----
(YEAR 5) TOTAL96,019------
Notes:
* These are the only fill-in blocks on this spreadsheet.
1. Contractor Man-year Equivalent = 1,920 Hours
2. Insert Firm-Fixed Price Labor Hour Rates.
3. The SEMATS 2 PWS gives contract requirements for all Labor Categories. Utilize the Government provided labor categories, number of hours, and skill level to meet contract requirements.
4. No cross-utilization and reach back are unauthorized.
5. Assume a contract performance period of 1 May 2016 to 30 April 2021.
6 Assume an option period of performance of 30 April 2021 - 29 October 2021, only when the option at 52.217-8 is exercised.This is not part of TO 0002

&KFF0000Insert Company Name, and any proprietary information. FA2486-15-R-0030, Volume III, Year 5 and any proprietary information.

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