Atch_16_-_SGEM_Calculations.xlsx

XLSX spreadsheet 41 KB Posted

Attached to
Sheppard Aircraft Maintenance Support Services Federal contract opportunity
Solicitation number
FA3002-14-R-0015
Issued by
Department of the Air Force Materiel Command Installation and Mission Support Center Installation Contracting Agency

About this file

Atch 16 - SGEM Calculations Tool

View the file

Other files for this federal contract opportunity

Other files attached to Sheppard Aircraft Maintenance Support Services, newest first.
File Type Posted
Atch_7_(Rev_1)_-_Sheppard_Manpower_Matrix.xlsx XLSX spreadsheet
Atch_16_(Rev_1)_-_SGEM_Calculations.xlsx XLSX spreadsheet
Atch_1_(Rev_1)_-_Performance_Work_Statement_(1_Dec_15).pdf PDF
Amend_0001_PWS_Change_Matrix_(1_Dec_15).pdf PDF
FA3002-14-R-0015-0001.doc DOC document
Sheppard_Acft_MX_Pre-Proposal_Conf_Brief.pdf PDF
Cover_Letter_for_Q A__1_and_Site_Visit_Brief_Release.pdf PDF
Consolidated_Q A__1_(FA3002-14-R-0015).pdf PDF
Sheppard_Acft_MX_Site_Visit_Q A_Form.doc DOC document
Sheppard_Acft_MX_Pre-Proposal_Conf_ _Site_Visit_Invitation.docx DOCX document
Atch_8_-_Sample_Vehicle_Matrix.xlsx XLSX spreadsheet
Atch_9_-_Subcontracting_Plan_Checklist.docx DOCX document
Atch_7_-_Sheppard_Manpower_Matrix.xlsx XLSX spreadsheet
Atch_1_-_Performance_Work_Statement_(1_Oct_15).pdf PDF
Atch_4a_-_CBA_(18_May_2015).pdf PDF
RFP_FA3002-14-R-0015 _Sheppard_Acft_MX_(2_Nov_15_Release).doc DOC document
Atch_3_-_SCLS_WD_05-2525_(Rev_18)_8_Jul_15.pdf PDF
Atch_2_-_DD_254.pdf PDF
Atch_12_-_Client_Authorization_Letter.docx DOCX document
Atch_4b_-_CBA_(TSquare_-_AGE)_(24_May_15).pdf PDF
Atch_5_-_PIR_Calculator_(Rev).xlsx XLSX spreadsheet
Atch_10_-_Past_Performance_Information_Sheet.docx DOCX document
Atch_4c_-_CBA_Memorandum_1_(Fringe_Benefit_Rate).pdf PDF
Atch_14_-_Workforce_Demographic_Information_as_of_Aug_15.xls XLS spreadsheet
Atch_6_-_Proposal_Incorporation_Memorandum.docx DOCX document
Atch_11-_Subktr_Letter_of_Consent.docx DOCX document
Atch_15_-_Past_Perf_Questionnaire.docx DOCX document
Atch_13_-_Solicitation_Question_and_Comment_Sheet.xlsx XLSX spreadsheet
Sheppard_Acft_MX_RFP_Cover _FA3002-14-R-0015.pdf PDF
Sheppard_RFP_Cover_Attachment_1_-_PWS_Change_Matrix_(1_Oct_15).pdf PDF
Show all 30

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

T-6A

Sortie Generation Estimation Model (SGEM) Calculations.
T-6A SGEM Example (Based on FY15 Data)
T-6AINPUTJOBJSTMINUTESCR SZTOT MINFREQTOT HRS% OF TOT
-------------------------------------------------------------
O&M DAYS IN MONTH20.0LAUNCH AIRCRAFT0.20012.01.012.01.0317.8
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Once per sortie flown7.0%
AVG POSS AIRCRAFT77.0RECOVER AIRCRAFT0.0835.01.05.01.0131.9
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Once per sortie flown2.9%
TOTAL HOURS FLOWN2165.3TOW AIRCRAFT2.000120.03.0360.01.0120.0
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Once per O&M day2.6%
TOTAL SORTIES FLOWN1589.0MOORING0.0835.01.05.06.038.3
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Avg possessed acft 6 times a month0.8%
SERVICE FUEL0.25015.01.015.01.0397.3
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Once per sortie flown8.8%
SERVICE OIL0.0835.01.05.010.018.0
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every 10 hours flown0.4%
SERVICE TIRES0.25015.01.015.04.099.3
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every 4 sorties flown2.2%
SERVICE AIR0.25015.01.015.04.099.3
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every 4 sorties flown2.2%
SERVICE HYD FLUID0.16710.01.010.010.036.2
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every 10 hours flown0.8%
MOVE AGE 1ST SRT0.33320.02.040.015.070.6
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every 15 sorties flown1.6%
MOVE AGE LAST SRT0.33320.02.040.015.070.6
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every 15 sorties flown1.6%
INSTALL/REMOVE COVERS & PLUGS0.16710.01.010.04.066.3
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every 4 sorties flown1.5%
FOD WALK0.25015.020.0300.01.0100.0
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Once per O&M day2.2%
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
MISC CLEANING0.50030.01.030.04.0198.6
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every 4 sorties flown4.4%
VACUUM AIRCRAFT0.25015.01.015.025.021.7
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every 25 hours flown0.5%
AIRCRAFT WIPE DOWN1.50090.01.090.015.0216.5
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every 15 hours flown4.8%
--------------------------------------------------------------------------------------------------------------------------------------------------------------
PREFLIGHT INSP0.66640.01.040.00.20211.7
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 20% of sorties flown4.7%
THRUFLIGHT INSP0.66740.01.040.00.75794.9
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 75% of sorties flown17.5%
COMBO BPO/PREFLIGHT INSP2.000120.01.0120.00.25794.5
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 25% of sorties flown17.5%
--------------------------------------------------------------------------------------------------------------------------------------------------------------
SOAP SAMPLES0.33320.01.020.025.028.8
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every 25 hours flown0.6%
DEFUEL/DEPUDDLE AIRCRAFT1.50090.01.090.08.012.0
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 8 times per month0.3%
--------------------------------------------------------------------------------------------------------------------------------------------------------------
UPDATE DAILY FORMS0.33320.01.020.04.0132.3
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every 4 sorties flown2.9%
AIRCRAFT DEBRIEF0.16710.01.010.01.0265.4
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Once per sortie flown5.8%
COMPUTER WORK0.16710.01.010.01.0257.2
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every possessed acft per O&M day5.7%
--------------------------------------------------------------------------------------------------------------------------------------------------------------
PARTS PROCESSING2.000120.01.0120.01.040.0
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every O&M day0.9%
----------------------------------
4539.0100.0%

&"Times New Roman,Bold"&12RFP Attachment 17, &"Times New Roman,Bold Italic"Sortie Generation Estimation Model (SGEM) Calculations &"Times New Roman,Regular"&12FA3002-14-R-0015 01 Oct 15

&"Times New Roman,Regular"&12Sheppard AFB Aircraft Maintenance

T-38C UPT

Sortie Generation Estimation Model (SGEM) Calculations.
T-38C UPT SGEM Example (Based on FY15 Data)
T-38C UPTINPUTJOBJSTMINUTESCR SZTOT MINFREQTOT HRS% OF TOT
------------------------------------------------------
O&M DAYS IN MONTH20.0LAUNCH AIRCRAFT0.33320.01.020.01.0585.4
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Once per sortie flown8.8%
AVG POSS AIRCRAFT89.1RECOVER AIRCRAFT0.16710.01.010.01.0293.6
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Once per sortie flown4.4%
TOTAL HOURS FLOWN1903.2TOW AIRCRAFT2.000120.03.0360.01.0120.0
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every O&M day1.8%
TOTAL SORTIES FLOWN1758.0MOORING0.16710.01.010.04.059.5
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Avg possessed acft times 40.9%
SERVICE FUEL0.33320.01.020.01.0585.4
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Once per sortie flown8.8%
SERVICE OIL0.0835.01.05.010.015.8
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every 10 hours flown0.2%
SERVICE O2 (LOX)0.50030.01.030.03.014.9
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 33% of avg possessed acft0.2%
SERVICE AIR0.33320.02.040.03.019.8
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 33% of avg possessed acft0.3%
SERVICE HYD FLUID0.50030.01.030.025.038.1
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every 25 hours flown0.6%
SERVICE TIRES0.25015.01.015.03.07.4
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 33% of avg possessed acft0.1%
FOD WALK0.33320.030.0599.41.0199.8
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every O&M day3.0%
--------------------------------------------------------------------------------------------------------------------------------------------------------
MISC CLEANING1.00060.01.060.04.0439.5
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every fourth sortie flown6.6%
VACUUM ACFT0.25015.01.015.025.019.0
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every 25 hours flown0.3%
ENG CLEAN & TREAT1.00060.04.0240.075.0101.5
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every 75 hours flown1.5%
--------------------------------------------------------------------------------------------------------------------------------------------------------
PREFLIGHT0.83350.01.050.00.25366.1
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 25% of sorties flown5.5%

THRUFLIGHT 0.833 50.0 1.0 50.0 0.67 981.2

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 67% of sorties flown MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Once per sortie flown 14.8%

BPO INSP 2.333 140.0 1.0 140.0 0.10 410.1

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 10% of sorties flown MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Once per sortie flown 6.2%

COMBO BPO/PREFLIGHT 2.050 123.0 1.0 123.0 0.40 665.3

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 40% of sorties flown minus hours for preflights and BPOs

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every O&M day10.0%
--------------------------------------------------------------------------------------------------------------------------------------------------------
SOAP SAMPLES0.75045.01.045.020.0142.7

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every 20 hours flown times 2 MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Avg possessed acft times 4 2.2%

DEFUEL/DEPUDDLE AIRCRAFT 1.500 90.0 1.0 90.0 6.0 9.0

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 6 times per month

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Once per sortie flown0.1%
--------------------------------------------------------------------------------------------------------------------------------------------------------
UPDATE DAILY FORMS0.16710.01.010.01.0293.6

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Once per sortie flown MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every 10 hours flown 4.4%

AIRCRAFT DEBRIEF 0.167 10.0 1.0 10.0 1.0 293.6

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Once per sortie flown MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 33% of avg possessed acft 4.4%

COMPUTER WORK 0.500 30.0 1.0 30.0 1.0 891.0

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Avg possessed acft every O&M day

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 33% of avg possessed acft13.4%
--------------------------------------------------------------------------------------------------------------------------------------------------------
PARTS PROCESSING2.000120.02.0240.01.080.0

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every O&M day MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every 25 hours flown MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 33% of avg possessed acft 1.2%

6632.3 100.0%

&"Times New Roman,Bold"&12RFP Attachment 17, &"Times New Roman,Bold Italic"Sortie Generation Estimation Model (SGEM) Calculations &"Times New Roman,Regular"&12FA3002-14-R-0015 01 Oct 15

&"Times New Roman,Regular"&12BD-2 &"Times New Roman,Regular"&12Sheppard AFB

T-38C IFF

Sortie Generation Estimation Model (SGEM) Calculations.
T-38C IFF SGEM Example (Based on FY15 Data)
T-38C IFFINPUTJOBJSTMINUTESCR SZTOT MINFREQTOT HRS% OF TOT
------------------------------------------------------
O&M DAYS IN MONTH20.0LAUNCH AIRCRAFT0.33320.01.020.01.0175.2
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Once per sortie flown7.5%
AVG POSS AIRCRAFT34.4RECOVER AIRCRAFT0.16710.01.010.01.087.8
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Once per sortie flown3.7%
TOTAL HOURS FLOWN488.1TOW AIRCRAFT2.000120.03.0360.01.0120.0
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every O&M day5.1%
TOTAL SORTIES FLOWN526.0MOORING0.16710.01.010.04.023.0
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Avg possessed acft times 41.0%
SERVICE FUEL0.33320.01.020.01.0175.2
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Once per sortie flown7.5%
SERVICE OIL0.0835.01.05.010.04.1
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every 10 hours flown0.2%
SERVICE O2 (LOX)0.50030.01.030.03.05.7
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 33% of avg possessed acft0.2%
SERVICE AIR0.33320.02.040.03.07.6
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 33% of avg possessed acft0.3%
SERVICE HYD FLUID0.50030.01.030.025.09.8
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every 25 hours flown0.4%
SERVICE TIRES0.25015.01.015.03.02.9
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 33% of avg possessed acft0.1%
FOD WALK0.33320.030.0599.41.0199.8
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every O&M day8.5%
--------------------------------------------------------------------------------------------------------------------------------------------------------
MISC CLEANING1.00060.01.060.04.0131.5
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every fourth sortie flown5.6%
VACUUM ACFT0.25015.01.015.025.04.9
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every 25 hours flown0.2%
ENG CLEAN & TREAT1.00060.04.0240.075.026.0
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every 75 hours flown1.1%
--------------------------------------------------------------------------------------------------------------------------------------------------------
PREFLIGHT0.83350.01.050.00.25109.5
MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 25% of sorties flown4.7%

THRUFLIGHT 0.833 50.0 1.0 50.0 0.67 293.6

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 67% of sorties flown MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Once per sortie flown 12.5%

BPO INSP 2.333 140.0 1.0 140.0 0.10 122.7

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 10% of sorties flown MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Once per sortie flown 5.2%

COMBO BPO/PREFLIGHT 2.050 123.0 1.0 123.0 0.40 199.1

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 40% of sorties flown minus hours for preflights and BPOs

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every O&M day8.5%
--------------------------------------------------------------------------------------------------------------------------------------------------------
SOAP SAMPLES0.75045.01.045.020.036.6

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every 20 hours flown times 2 MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Avg possessed acft times 4 1.6%

DEFUEL/DEPUDDLE AIRCRAFT 1.500 90.0 1.0 90.0 6.0 9.0

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 6 times per month

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Once per sortie flown0.4%
--------------------------------------------------------------------------------------------------------------------------------------------------------
UPDATE DAILY FORMS0.16710.01.010.01.087.8

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Once per sortie flown MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every 10 hours flown 3.7%

AIRCRAFT DEBRIEF 0.167 10.0 1.0 10.0 1.0 87.8

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Once per sortie flown MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 33% of avg possessed acft 3.7%

COMPUTER WORK 0.500 30.0 1.0 30.0 1.0 344.0

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Avg possessed acft every O&M day

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 33% of avg possessed acft14.7%
--------------------------------------------------------------------------------------------------------------------------------------------------------
PARTS PROCESSING2.000120.02.0240.01.080.0

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every O&M day MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: Every 25 hours flown MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 33% of avg possessed acft 3.4%

2343.6 100.0%

&"Times New Roman,Bold"&12RFP attachment 16, &"Times New Roman,Bold Italic"Sortie Generation Estimation Model (SGEM) Calculations &"Times New Roman,Regular"&12FA3002-14-R-0015 01 Oct 15

&"Times New Roman,Regular"&12BD-3 &"Times New Roman,Regular"&12Sheppard AFB

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