EMXG Manpower Contractor Pricing Worksheet Proposal - Rev1.xlsx

36 KB Posted

Attached to
EMXG Production Support IDIQ
Solicitation number
F3QCCL4183A008
Issued by

About this file

Written by GovTribe AI ·

This is a pricing worksheet template for a follow-on IDIQ contract supporting the 402d Electronic Maintenance Group (EMXG) at Robins Air Force Base, with a period of performance from June 5, 2025 through June 4, 2030. The worksheet is structured for both direct and indirect labor categories across five ordering periods.

The template includes staffing requirements for direct labor positions including Avionics Technicians (33 FTEs), Engineering Technicians (8 FTEs), Engineers (2 FTEs), Senior Engineering Technicians (10 FTEs), Senior Industrial Engineering Technicians (2 FTEs), and Senior Engineers (3 FTEs). Indirect labor positions include Technical Writers (2 FTEs), Working Capital Fund Analysts (1 FTE), Equipment Custodians (2 FTEs), Management Analysts (1 FTE), Process Analysts (1 FTE), Lean Facilitators (1 FTE), Security Services (35 FTEs), Security Assistants (2 FTEs), and Contractor Supervisors (3 FTEs). The worksheet calculates 1,872 productive hours per year per FTE, accounting for federal holidays, vacation, and sick leave, with provisions for overtime hours in certain labor categories.

View the file

Other files

File Type Posted
Statement of Equivalent Rates for Federal Hires.pdf PDF
Contractor Questions - Set 2.xlsx XLSX spreadsheet
EMXG Manpower Contractor Pricing Worksheet Proposal - Rev2.xlsx XLSX spreadsheet
EMXG Informational Sheet.pdf PDF
Contractor Questions - Set 1.xlsx XLSX spreadsheet
PWS - DIRECT and INDIRECT EMXG Support - 19 Dec 24.pdf PDF
Solicitation - FA857125R0001.pdf PDF
CDRL ABCDE001 Monthly Status Report.pdf PDF
CDRL ABCDE007 Accident Incident Report.pdf PDF
CDRL ABCDE002 Monthly Funds and Manhour.pdf PDF
DD Form 254 EMXG Prod Control.pdf PDF
EMXG Manpower Contractor Pricing Worksheet Proposal.xlsx XLSX spreadsheet
CDRL ABCDE008 Monthly Status Report.pdf PDF
CDRL ABCDE004 Monthly Status Report EMS Training.pdf PDF
CDRL A003 Quality Program Plan.pdf PDF
PWS - DIRECT and INDIRECT EMXG Support.pdf PDF
WD - 2015-4495.pdf PDF
CDRL A006 Contractors Safety Plan.pdf PDF
Appendix C for Direct Indirect Production Support.pdf PDF
Solicitation - FA857125R0001.pdf PDF
CDRL A005 Status Report ISO 50001 EnMS Training.pdf PDF
Show all 21

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.

Sheet1

DIRECT DOCAT FOLLOW-ON (POP: 05 June 2025 thru 04 June 2030)
Basic YearPOPCLIN NomenclatureWG/GS Equivalent GradeSeries NumberFTEsHours*Total HoursFully Burden Hourly RateTotalOrdering PeriodPOPCLIN NomenclatureWG/GS Equivalent GradeFTEsHoursTotal HoursHourly RateTotalOrdering PeriodPOPCLIN NomenclatureWG/GS Equivalent GradeFTEsHoursTotal HoursHourly RateTotalOrdering PeriodPOPCLIN NomenclatureWG Equivalent GradeFTEsHoursTotal HoursHourly RateTotalOrdering PeriodPOPCLIN NomenclatureWG/GS Equivalent GradeFTEsHoursTotal HoursHourly RateTotalGrand Total
Basic Yr-Ordering Period I05 Jun 2025 thru 04 June 2026Avionics Technician (AT2)WG 102604121,87222,464$0.00Ordering Period II05 Jun 2026 thru 04 June 2027Avionics Technician (AT2)WG 10121,87222,464$0.00Ordering Period III05 Jun 2027 thru 04 June 2028Avionics Technician (AT2)WG 10121,87222,464$0.00Ordering Period IV05 Jun 2028 thru 04 June 2029Avionics Technician (AT2)WG 10121,87222,464$0.00Ordering Period V05 Jun 2029 thru 04 June 2030Avionics Technician (AT2)WG 10121,87222,464$0.00$0.00
Basic Yr-Ordering Period I05 Jun 2025 thru 04 June 2026Avionics Technician (AT3)WG 122610211,87239,312$0.00Ordering Period II05 Jun 2026 thru 04 June 2027Avionics Technician (AT3)WG 12211,87239,312$0.00Ordering Period III05 Jun 2027 thru 04 June 2028Avionics Technician (AT3)WG 12211,87239,312$0.00Ordering Period IV05 Jun 2028 thru 04 June 2029Avionics Technician (AT3)WG 12211,87239,312$0.00Opt 4 Period 505 Jun 2029 thru 04 June 2030Avionics Technician (AT3)WG 12211,87239,312$0.00$0.00
Basic Yr-Ordering Period I05 Jun 2025 thru 04 June 2026Engineering Tech (ET2)GS-0985661,87211,232$0.00Ordering Period II05 Jun 2026 thru 04 June 2027Engineering Tech (ET2)GS-0961,87211,232$0.00Ordering Period III05 Jun 2027 thru 04 June 2028Engineering Tech (ET2)GS-0961,87211,232$0.00Ordering Period IV05 Jun 2028 thru 04 June 2029Engineering Tech (ET2)GS-0961,87211,232$0.00Opt 4 Period 505 Jun 2029 thru 04 June 2030Engineering Tech (ET2)GS-0961,87211,232$0.00$0.00
Basic Yr-Ordering Period I05 Jun 2025 thru 04 June 2026Engineer (E2)GS-1185521,8723,744$0.00Ordering Period II05 Jun 2026 thru 04 June 2027Engineer (E2)GS-1121,8723,744$0.00Ordering Period III05 Jun 2027 thru 04 June 2028Engineer (E2)GS-1121,8723,744$0.00Ordering Period IV05 Jun 2028 thru 04 June 2029Engineer (E2)GS-1121,8723,744$0.00Opt 4 Period 505 Jun 2029 thru 04 June 2030Engineer (E2)GS-1121,8723,744$0.00$0.00
Basic Yr-Ordering Period I05 Jun 2025 thru 04 June 2026SR Engineering Tech (ET3)GS 11856101,87218,720$0.00Ordering Period II05 Jun 2026 thru 04 June 2027SR Engineering Tech (ET3)GS 11101,87218,720$0.00Ordering Period III05 Jun 2027 thru 04 June 2028SR Engineering Tech (ET3)GS 11101,87218,720$0.00Ordering Period IV05 Jun 2028 thru 04 June 2029SR Engineering Tech (ET3)GS 11101,87218,720$0.00Opt 4 Period 505 Jun 2029 thru 04 June 2030SR Engineering Tech (ET3)GS 11101,87218,720$0.00$0.00
Basic Yr-Ordering Period I05 Jun 2025 thru 04 June 2026Sr Industrial Engineering Tech (IT3)GS 1189521,8723,744$0.00Ordering Period II05 Jun 2026 thru 04 June 2027Sr Industrial Engineering Tech (IT3)GS 1121,8723,744$0.00Ordering Period III05 Jun 2027 thru 04 June 2028Sr Industrial Engineering Tech (IT3)GS 1121,8723,744$0.00Ordering Period IV05 Jun 2028 thru 04 June 2029Sr Industrial Engineering Tech (IT3)GS 1121,8723,744$0.00Opt 4 Period 505 Jun 2029 thru 04 June 2030Sr Industrial Engineering Tech (IT3)GS 1121,8723,744$0.00$0.00
Basic Yr-Ordering Period I05 Jun 2025 thru 04 June 2026Sr Engineer (E3)GS-1285531,8725,616$0.00Ordering Period II05 Jun 2026 thru 04 June 2027Sr Engineer (E3)GS-1231,8725,616$0.00Ordering Period III05 Jun 2027 thru 04 June 2028Sr Engineer (E3)GS-1231,8725,616$0.00Ordering Period IV05 Jun 2028 thru 04 June 2029Sr Engineer (E3)GS-1231,8725,616$0.00Opt 4 Period 505 Jun 2029 thru 04 June 2030Sr Engineer (E3)GS-1231,8725,616$0.00$0.00
Basic Yr-Ordering Period I05 Jun 2025 thru 04 June 2026Avionics Technician Overtime (AT2OT)WG-10260401414$0.00Ordering Period II05 Jun 2026 thru 04 June 2027Avionics Technician Overtime (AT2OT)WG-1001414$0.00Ordering Period III05 Jun 2027 thru 04 June 2028Avionics Technician Overtime (AT2OT)WG-1001414$0.00Ordering Period IV05 Jun 2028 thru 04 June 2029Avionics Technician Overtime (AT2OT)WG-1001414$0.00Opt 4 Period 505 Jun 2029 thru 04 June 2030Avionics Technician Overtime (AT2OT)WG-1001414$0.00$0.00
Basic Yr-Ordering Period I05 Jun 2025 thru 04 June 2026Sr Avionics Technician Overtime(AT3OT)WG-12261007070$0.00Ordering Period II05 Jun 2026 thru 04 June 2027Sr Avionics Technician Overtime(AT3OT)WG-1207070$0.00Ordering Period III05 Jun 2027 thru 04 June 2028Sr Avionics Technician Overtime(AT3OT)WG-1207070$0.00Ordering Period IV05 Jun 2028 thru 04 June 2029Sr Avionics Technician Overtime(AT3OT)WG-1207070$0.00Opt 4 Period 505 Jun 2029 thru 04 June 2030Sr Avionics Technician Overtime(AT3OT)WG-1207070$0.00$0.00
Basic Yr-Ordering Period I05 Jun 2025 thru 04 June 2026Sr Engineering tech Overtime (ET3OT)GS-118560150150$0.00Ordering Period II05 Jun 2026 thru 04 June 2027Sr Engineering tech Overtime (ET3OT)GS-110150150$0.00Ordering Period III05 Jun 2027 thru 04 June 2028Sr Engineering tech Overtime (ET3OT)GS-110150150$0.00Ordering Period IV05 Jun 2028 thru 04 June 2029Sr Engineering tech Overtime (ET3OT)GS-110150150$0.00Opt 4 Period 505 Jun 2029 thru 04 June 2030Sr Engineering tech Overtime (ET3OT)GS-110150150$0.00$0.00
Grand Total (Direct)Total Ordering Period I (Direct)$0.00Total Ordering Period II (Direct)$0.00Total Ordering Period III (Direct)$0.00Total Ordering Period IV (Direct)$0.00Total Ordering Period V (Direct)$0.00$0.00Grand Total (Direct)
INDIRECT FOLLOW-ON (POP: 05 June 2025 thru 04 June 2030)
Basic YearPOPCLIN NomenclatureWG/GS Equivalent GradeSeriesFTEsHoursTotal HoursHourly RateTotalOrdering PeriodPOPCLIN NomenclatureWG/GS Equivalent GradeFTEsHoursTotal HoursHourly RateTotalOrdering PeriodPOPCLIN NomenclatureWG/GS Equivalent GradeFTEsHoursTotal HoursHourly RateTotalOrdering PeriodPOPCLIN NomenclatureWG/GS Equivalent GradeFTEsHoursTotal HoursHourly RateTotalOrdering PeriodPOPCLIN NomenclatureWG/GS Equivalent GradeFTEsHoursTotal HoursHourly RateTotalGrand Total
Basic Yr-Ordering Period I05 Jun 2025 thru 04 June 2026Technicial Writer/EditorGS-12108321,8723,744$0.00Ordering Period II05 Jun 2026 thru 04 June 2027Technicial Writer/EditorGS-1221,8723,744$0.00Ordering Period III05 Jun 2027 thru 04 June 2028Technicial Writer/EditorGS-1221,8723,744$0.00Ordering Period IV05 Jun 2028 thru 04 June 2029Technicial Writer/EditorGS-1221,8723,744$0.00Option Year IV05 Jun 2029 thru 04 June 2030Technicial Writer/EditorGS-1221,8723,744$0.00$0.00
Basic Yr-Ordering Period I05 Jun 2025 thru 04 June 2026Working Capital Fund Production AnalystGS-1234311,8721,872$0.00Ordering Period II05 Jun 2026 thru 04 June 2027Working Capital Fund Production AnalystGS-1211,8721,872$0.00Ordering Period III05 Jun 2027 thru 04 June 2028Working Capital Fund Production AnalystGS-1211,8721,872$0.00Ordering Period IV05 Jun 2028 thru 04 June 2029Working Capital Fund Production AnalystGS-1211,8721,872$0.00Option Year IV05 Jun 2029 thru 04 June 2030Working Capital Fund Production AnalystGS-1211,8721,872$0.00$0.00
Basic Yr-Ordering Period I05 Jun 2025 thru 04 June 2026Engineering Tech (ET2)GS-0985621,8723,744$0.00Ordering Period II05 Jun 2026 thru 04 June 2027Engineering Tech (ET2)GS-0921,8723,744$0.00Ordering Period III05 Jun 2027 thru 04 June 2028Engineering Tech (ET2)GS-0921,8723,744$0.00Ordering Period IV05 Jun 2028 thru 04 June 2029Engineering Tech (ET2)GS-0921,8723,744$0.00Option Year IV05 Jun 2029 thru 04 June 2030Engineering Tech (ET2)GS-0921,8723,744$0.00$0.00
Basic Yr-Ordering Period I05 Jun 2025 thru 04 June 2026Equipment CustodianGS-07115221,8723,744$0.00Ordering Period II05 Jun 2026 thru 04 June 2027Equipment CustodianGS-0721,8723,744$0.00Ordering Period III05 Jun 2027 thru 04 June 2028Equipment CustodianGS-0721,8723,744$0.00Ordering Period IV05 Jun 2028 thru 04 June 2029Equipment CustodianGS-0721,8723,744$0.00Option Year IV05 Jun 2029 thru 04 June 2030Equipment CustodianGS-0721,8723,744$0.00$0.00
Basic Yr-Ordering Period I05 Jun 2025 thru 04 June 2026SR Engineering Tech (ET3)GS-1185691,87216,848$0.00Ordering Period II05 Jun 2026 thru 04 June 2027SR Engineering Tech (ET3)GS-1191,87216,848$0.00Ordering Period III05 Jun 2027 thru 04 June 2028SR Engineering Tech (ET3)GS-1191,87216,848$0.00Ordering Period IV05 Jun 2028 thru 04 June 2029SR Engineering Tech (ET3)GS-1191,87216,848$0.00Option Year IV05 Jun 2029 thru 04 June 2030SR Engineering Tech (ET3)GS-1191,87216,848$0.00$0.00
Basic Yr-Ordering Period I05 Jun 2025 thru 04 June 2026Engineer (E2)GS-1185521,8723,744$0.00Ordering Period II05 Jun 2026 thru 04 June 2027Engineer (E2)GS-1121,8723,744$0.00Ordering Period III05 Jun 2027 thru 04 June 2028Engineer (E2)GS-1121,8723,744$0.00Ordering Period IV05 Jun 2028 thru 04 June 2029Engineer (E2)GS-1121,8723,744$0.00Option Year IV05 Jun 2029 thru 04 June 2030Engineer (E2)GS-1121,8723,744$0.00$0.00
Basic Yr-Ordering Period I05 Jun 2025 thru 04 June 2026Sr Engineer (E3)GS-1280112

tc={23293704-075B-478D-A077-5C6C572B2694}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

24 Oct 23:Per Aaron Lachman, needed to increase by 7 due to shortage of Senior Level Engineers. 1,872 22,464 $0.00 Ordering Period II 05 Jun 2026 thru 04 June 2027 Sr Engineer (E3) GS-12 12 tc={4A3FA136-2221-40E7-8386-B82553209429}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

24 Oct 23:Per Aaron Lachman, needed to increase by 7 due to shortage of Senior Level Engineers. 1,872 22,464 $0.00 Ordering Period III 05 Jun 2027 thru 04 June 2028 Sr Engineer (E3) GS-12 12 tc={FBCFF507-EA7B-4597-AE8C-3A5C960A6DA7}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

24 Oct 23:Per Aaron Lachman, needed to increase by 7 due to shortage of Senior Level Engineers. 1,872 22,464 $0.00 Ordering Period IV 05 Jun 2028 thru 04 June 2029 Sr Engineer (E3) GS-12 12 tc={290F98E1-1B9E-4CB2-9C9C-73127A501DE0}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

24 Oct 23:Per Aaron Lachman, needed to increase by 7 due to shortage of Senior Level Engineers. 1,872 22,464 $0.00 Option Year IV 05 Jun 2029 thru 04 June 2030 Sr Engineer (E3) GS-12 12 tc={7CFA470E-E8C0-4C75-AA61-A82622699D65}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

24 Oct 23:Per Aaron Lachman, needed to increase by 7 due to shortage of Senior Level Engineers.

tc={4A3FA136-2221-40E7-8386-B82553209429}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

24 Oct 23:Per Aaron Lachman, needed to increase by 7 due to shortage of Senior Level Engineers.

tc={290F98E1-1B9E-4CB2-9C9C-73127A501DE0}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

24 Oct 23:Per Aaron Lachman, needed to increase by 7 due to shortage of Senior Level Engineers.

tc={23293704-075B-478D-A077-5C6C572B2694}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

24 Oct 23:Per Aaron Lachman, needed to increase by 7 due to shortage of Senior Level Engineers.1,87222,464$0.00$0.00
Basic Yr-Ordering Period I05 Jun 2025 thru 04 June 2026Management Analyst (MA)GS-1234311,8721,872$0.00Ordering Period II05 Jun 2026 thru 04 June 2027Management Analyst (MA)GS-1211,8721,872$0.00Ordering Period III05 Jun 2027 thru 04 June 2028Management Analyst (MA)GS-1211,8721,872$0.00Ordering Period IV05 Jun 2028 thru 04 June 2029Management Analyst (MA)GS-1211,8721,872$0.00Option Year IV05 Jun 2029 thru 04 June 2030Management Analyst (MA)GS-1211,8721,872$0.00$0.00
Basic Yr-Ordering Period I05 Jun 2025 thru 04 June 2026Process Analyst (PA)GS-1134311,8721,872$0.00Ordering Period II05 Jun 2026 thru 04 June 2027Process Analyst (PA)GS-1111,8721,872$0.00Ordering Period III05 Jun 2027 thru 04 June 2028Process Analyst (PA)GS-1111,8721,872$0.00Ordering Period IV05 Jun 2028 thru 04 June 2029Process Analyst (PA)GS-1111,8721,872$0.00Option Year IV05 Jun 2029 thru 04 June 2030Process Analyst (PA)GS-1111,8721,872$0.00$0.00
Basic Yr-Ordering Period I05 Jun 2025 thru 04 June 2026Lean Facilitator (LF)GS-1234311,8721,872$0.00Ordering Period II05 Jun 2026 thru 04 June 2027Lean Facilitator (LF)GS-1211,8721,872$0.00Ordering Period III05 Jun 2027 thru 04 June 2028Lean Facilitator (LF)GS-1211,8721,872$0.00Ordering Period IV05 Jun 2028 thru 04 June 2029Lean Facilitator (LF)GS-1211,8721,872$0.00Option Year IV05 Jun 2029 thru 04 June 2030Lean Facilitator (LF)GS-1211,8721,872$0.00$0.00
Basic Yr-Ordering Period I05 Jun 2025 thru 04 June 2026Security Services (SECA)GS-0486351,87265,520$0.00Ordering Period II05 Jun 2026 thru 04 June 2027Security Services (SECA)GS-04351,87265,520$0.00Ordering Period III05 Jun 2027 thru 04 June 2028Security Services (SECA)GS-04351,87265,520$0.00Ordering Period IV05 Jun 2028 thru 04 June 2029Security Services (SECA)GS-04351,87265,520$0.00Option Year IV05 Jun 2029 thru 04 June 2030Security Services (SECA)GS-04351,87265,520$0.00$0.00
Basic Yr-Ordering Period I05 Jun 2025 thru 04 June 2026Security Assistant (SEASST)GS-048621,8723,744$0.00Ordering Period II05 Jun 2026 thru 04 June 2027Security Assistant (SEASST)GS-0421,8723,744$0.00Ordering Period III05 Jun 2027 thru 04 June 2028Security Assistant (SEASST)GS-0421,8723,744$0.00Ordering Period IV05 Jun 2028 thru 04 June 2029Security Assistant (SEASST)GS-0421,8723,744$0.00Option Year IV05 Jun 2029 thru 04 June 2030Security Assistant (SEASST)GS-0421,8723,744$0.00$0.00
Basic Yr-Ordering Period I05 Jun 2025 thru 04 June 2026Contractor SupervisorGS-0930131,8725,616$0.00Ordering Period II05 Jun 2026 thru 04 June 2027Contractor SupervisorGS-0931,8725,616$0.00Ordering Period III05 Jun 2027 thru 04 June 2028Contractor SupervisorGS-0931,8725,616$0.00Ordering Period IV05 Jun 2028 thru 04 June 2029Contractor SupervisorGS-0931,8725,616$0.00Option Year IV05 Jun 2029 thru 04 June 2030Contractor SupervisorGS-0931,8725,616$0.00$0.00
Basic Yr-Ordering Period I05 Jun 2025 thru 04 June 2026Security Services/ Security Assistant (SEASST OT)GS-048601,4151,415$0.00Ordering Period II05 Jun 2026 thru 04 June 2027Security Services/ Security Assistant (SEASST OT)GS-0401,4151,415$0.00Ordering Period III05 Jun 2027 thru 04 June 2028Security Services/ Security Assistant (SEASST OT)GS-0401,4151,415$0.00Ordering Period IV05 Jun 2028 thru 04 June 2029Security Services/ Security Assistant (SEASST OT)GS-0401,4151,415$0.00Option Year IV05 Jun 2029 thru 04 June 2030Security Services/ Security Assistant (SEASST OT)GS-04014151,415$0.00$0.00
Grand Total (InDirect)Total Ordering Period I (InDirect)$0.00Total Ordering Period II (InDirect)$0.00Total Ordering Period III (InDirect)$0.00Total Ordering Period IV (InDirect)$0.00Total Ordering Period V (InDirect)$0.00$0.00Grand Total Indirect
$0.00Overall Proposed Total
· Available work hours per year (40 hrs. per week x 52 weeks) = 2080 hrs.
· Holidays = 88 hrs. (We now have 11 federal holidays instead of 10)
· Vacation = 80 hrs.
· Sick Leave = 40 hrs.
· Productive hours available per year per person = 1,872*
* Taken from DoD Independent Government Cost Estimate, Handbook for Services Acquisition, Feb 2018

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