SEMATS_2_FFP-LOE_Section_L_Attachment_6b_Version_1.1.xlsx

XLSX spreadsheet 55 KB Posted

Attached to
SEMATS 2
Solicitation number
FA2486-16-R-0065
Issued by

About this file

Section L Attachment 6b

View the file

Other files

Show all 20

On GovTribe

Work with this file

  • 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 31 May 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 June 2016 to 31 May 2021.
6. Assume an option period of performance of 1 July 2016 - 31 May 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 June 2016 to 31 May 2021.
6 Assume an option period of performance of 1 June 2017 - 31 May 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 June 2016 to 31 May 2021.
6 Assume an option period of performance of 1 June 2018 - 31 May 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 June 2016 to 31 May 2021.
6 Assume an option period of performance of 1 June 2019 - 31 May 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 June 2016 to 31 May 2021.
6 Assume an option period of performance of 1 June 2020 - 31 May 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 FY21Rate FY21Total
InstructionsB = C + FPortion of hours for FY21 entered.Enter FY21 RateMultiply F by G
EXAMPLE1,9801,98046.9592,961.00
Aeronautical/Aerospace Engineering 111-
Aeronautical/Aerospace Engineering 27,6807,680-
Aeronautical/Aerospace Engineering 311,52011,520-
Aeronautical/Aerospace Engineering 45,7605,760-
Computer Engineering 111-
Computer Engineering 211-
Computer Engineering 3960960-
Computer Engineering 4960960-
Electronic/Electrical Engineering 111-
Electronic/Electrical Engineering 2960960-
Electronic/Electrical Engineering 31,9201,920-
Electronic/Electrical Engineering 4960960-
Mechanical Engineering 111-
Mechanical Engineering 211-
Mechanical Engineering 3960960-
Mechanical Engineering 4960960-
Physics/Mathematics 111-
Physics/Mathematics 211-
Physics/Mathematics 3960960-
Physics/Mathematics 411-
Software Engineering/Computer Science 1960960-
Software Engineering/Computer Science 211,52011,520-
Software Engineering/Computer Science 314,40014,400-
Software Engineering/Computer Science 45,7605,760-
Administrative Specialist960960-
Computer-Aided Design Specialist 111-
Computer-Aided Design Specialist 2960960-
Computer-Aided Design Specialist 32,8802,880-
Computer-Aided Design Specialist 411-
Labor Category/Skill Level Yr 5Level of Effort (Hours)Hours FY21Rate FY21Sub Total
Configuration/Data Manager 111-
Configuration/Data Manager 2960960-
Configuration/Data Manager 3960960-
Configuration/Data Manager 411-
Contract Manager960960-
Information Technology Specialist 111-
Information Technology Specialist 24,8004,800-
Information Technology Specialist 34,8004,800-
Information Technology Specialist 41,9201,920-
Ordnance Specialist 111-
Ordnance Specialist 211-
Ordnance Specialist 31,9201,920-
Ordnance Specialist 411-
Project Manager 111-
Project Manager 211-
Project Manager 36,7206,720-
Project Manager 41,9201,920-
(YEAR 5) TOTAL96,01996,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 June 2016 to 31 May 2021.
6 Assume an option period of performance of 1 June 2021 - 30 November 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 .