Atch_16_(Rev_1)_-_SGEM_Calculations.xlsx

XLSX spreadsheet 39 KB Posted Dec 8, 2015

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

From the source

Atch 16 (Rev 1) - SGEM Calculations

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	Dec 8, 2015
Amend_0001_PWS_Change_Matrix_(1_Dec_15).pdf	PDF	Dec 8, 2015
FA3002-14-R-0015-0001.doc	DOC document	Dec 8, 2015
Atch_1_(Rev_1)_-_Performance_Work_Statement_(1_Dec_15).pdf	PDF	Dec 8, 2015
Cover_Letter_for_Q A__1_and_Site_Visit_Brief_Release.pdf	PDF	Dec 3, 2015
Consolidated_Q A__1_(FA3002-14-R-0015).pdf	PDF	Dec 3, 2015
Sheppard_Acft_MX_Pre-Proposal_Conf_Brief.pdf	PDF	Dec 3, 2015
Sheppard_Acft_MX_Site_Visit_Q A_Form.doc	DOC document	Nov 2, 2015
Sheppard_Acft_MX_Pre-Proposal_Conf_ _Site_Visit_Invitation.docx	DOCX document	Nov 2, 2015
Atch_1_-_Performance_Work_Statement_(1_Oct_15).pdf	PDF	Nov 2, 2015
Atch_4a_-_CBA_(18_May_2015).pdf	PDF	Nov 2, 2015
RFP_FA3002-14-R-0015 _Sheppard_Acft_MX_(2_Nov_15_Release).doc	DOC document	Nov 2, 2015
Atch_3_-_SCLS_WD_05-2525_(Rev_18)_8_Jul_15.pdf	PDF	Nov 2, 2015
Atch_2_-_DD_254.pdf	PDF	Nov 2, 2015
Atch_12_-_Client_Authorization_Letter.docx	DOCX document	Nov 2, 2015
Atch_4b_-_CBA_(TSquare_-_AGE)_(24_May_15).pdf	PDF	Nov 2, 2015
Atch_6_-_Proposal_Incorporation_Memorandum.docx	DOCX document	Nov 2, 2015
Atch_11-_Subktr_Letter_of_Consent.docx	DOCX document	Nov 2, 2015
Atch_15_-_Past_Perf_Questionnaire.docx	DOCX document	Nov 2, 2015
Atch_16_-_SGEM_Calculations.xlsx	XLSX spreadsheet	Nov 2, 2015
Atch_13_-_Solicitation_Question_and_Comment_Sheet.xlsx	XLSX spreadsheet	Nov 2, 2015
Atch_5_-_PIR_Calculator_(Rev).xlsx	XLSX spreadsheet	Nov 2, 2015
Atch_10_-_Past_Performance_Information_Sheet.docx	DOCX document	Nov 2, 2015
Atch_4c_-_CBA_Memorandum_1_(Fringe_Benefit_Rate).pdf	PDF	Nov 2, 2015
Atch_14_-_Workforce_Demographic_Information_as_of_Aug_15.xls	XLS spreadsheet	Nov 2, 2015
Atch_8_-_Sample_Vehicle_Matrix.xlsx	XLSX spreadsheet	Nov 2, 2015
Atch_9_-_Subcontracting_Plan_Checklist.docx	DOCX document	Nov 2, 2015
Atch_7_-_Sheppard_Manpower_Matrix.xlsx	XLSX spreadsheet	Nov 2, 2015
Sheppard_Acft_MX_RFP_Cover _FA3002-14-R-0015.pdf	PDF	Nov 2, 2015
Sheppard_RFP_Cover_Attachment_1_-_PWS_Change_Matrix_(1_Oct_15).pdf	PDF	Nov 2, 2015

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

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

000000

T-6A

Sortie Generation Estimation Model (SGEM) Calculations.
T-6A SGEM Example (Based on FY15 Data)
T-6	INPUT	JOB	JST	MINUTES	CR SZ	TOT MIN	FREQ	TOT HRS	% OF TOT
----	-----	----------	---	-------	-----	--------	----	-------	--------
O&M DAYS IN MONTH	20.0	LAUNCH AIRCRAFT	0.200	12.0	1.0	12.0	1.0	317.8

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Once per sortie flown 7.0%

AVG POSS AIRCRAFT 77.0 RECOVER AIRCRAFT 0.083 5.0 1.0 5.0 1.0 131.9

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Once per sortie flown 2.9%

TOTAL HOURS FLOWN 2165.3 TOW AIRCRAFT 2.000 120.0 3.0 360.0 1.0 120.0

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Once per O&M day 2.6%

TOTAL SORTIES FLOWN 1589.0 MOORING 0.083 5.0 1.0 5.0 6.0 38.3

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Avg possessed acft 6 times a month 0.8%

SERVICE FUEL 0.250 15.0 1.0 15.0 1.0 397.3

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Once per sortie flown 8.8%

SERVICE OIL 0.083 5.0 1.0 5.0 10.0 18.0

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every 10 hours flown 0.4%

SERVICE TIRES 0.250 15.0 1.0 15.0 4.0 99.3

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every 4 sorties flown 2.2%

SERVICE AIR 0.250 15.0 1.0 15.0 4.0 99.3

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every 4 sorties flown 2.2%

SERVICE HYD FLUID 0.167 10.0 1.0 10.0 10.0 36.2

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every 10 hours flown 0.8%

MOVE AGE 1ST SRT 0.333 20.0 2.0 40.0 15.0 70.6

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every 15 sorties flown 1.6%

MOVE AGE LAST SRT 0.333 20.0 2.0 40.0 15.0 70.6

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every 15 sorties flown 1.6%

INSTALL/REMOVE COVERS & PLUGS 0.167 10.0 1.0 10.0 4.0 66.3

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every 4 sorties flown 1.5%

FOD WALK 0.250 15.0 20.0 300.0 1.0 100.0

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Once per O&M day	2.2%
		------------------------------------------	-----------------	-----------------	-----------------	-----------------	-----------------	-----------------	-----------------
		MISC CLEANING	0.500	30.0	1.0	30.0	4.0	198.6

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every 4 sorties flown 4.4%

VACUUM AIRCRAFT 0.250 15.0 1.0 15.0 25.0 21.7

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every 25 hours flown 0.5%

AIRCRAFT WIPE DOWN 1.500 90.0 1.0 90.0 15.0 216.5

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every 15 hours flown	4.8%
		---------------------------------------	-----------------	-----------------	-----------------	-----------------	-----------------	-----------------	-----------------
		PREFLIGHT INSP	0.666	40.0	1.0	40.0	0.20	211.7

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

20% of sorties flown 4.7%

THRUFLIGHT INSP 0.667 40.0 1.0 40.0 0.75 794.9

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

75% of sorties flown 17.5%

COMBO BPO/PREFLIGHT INSP 2.000 120.0 1.0 120.0 0.25 794.5

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

25% of sorties flown	17.5%
		---------------------------------------	-----------------	-----------------	-----------------	-----------------	-----------------	-----------------	-----------------
		SOAP SAMPLES	0.333	20.0	1.0	20.0	25.0	28.8

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every 25 hours flown 0.6%

DEFUEL/DEPUDDLE AIRCRAFT 1.500 90.0 1.0 90.0 8.0 12.0

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

8 times per month	0.3%
		---------------------------------------	-----------------	-----------------	-----------------	-----------------	-----------------	-----------------	-----------------
		UPDATE DAILY FORMS	0.333	20.0	1.0	20.0	4.0	132.3

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every 4 sorties flown 2.9%

AIRCRAFT DEBRIEF 0.167 10.0 1.0 10.0 1.0 265.4

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Once per sortie flown 5.8%

COMPUTER WORK 0.167 10.0 1.0 10.0 1.0 257.2

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every possessed acft per O&M day	5.7%
		---------------------------------------	-----------------	-----------------	-----------------	-----------------	-----------------	-----------------	-----------------
		PARTS PROCESSING	2.000	120.0	1.0	120.0	1.0	40.0

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every O&M day	0.9%
		-----------------	-----------------
		4539.0	100.0%

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

&"Times New Roman,Regular"&12 1 &"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	INPUT	JOB	JST	MINUTES	CR SZ	TOT MIN	FREQ	TOT HRS	% OF TOT
----	-----	----------	---	-------	-----	--------	----	-------	-
O&M DAYS IN MONTH	20.0	LAUNCH AIRCRAFT	0.333	20.0	1.0	20.0	1.0	585.4

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Once per sortie flown 8.8%

AVG POSS AIRCRAFT 89.1 RECOVER AIRCRAFT 0.167 10.0 1.0 10.0 1.0 293.6

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Once per sortie flown 4.4%

TOTAL HOURS FLOWN 1903.2 TOW AIRCRAFT 2.000 120.0 3.0 360.0 1.0 120.0

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every O&M day 1.8%

TOTAL SORTIES FLOWN 1758.0 MOORING 0.167 10.0 1.0 10.0 4.0 59.5

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Avg possessed acft times 4 0.9%

SERVICE FUEL 0.333 20.0 1.0 20.0 1.0 585.4

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Once per sortie flown 8.8%

SERVICE OIL 0.083 5.0 1.0 5.0 10.0 31.6

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every 10 hours flown times 2 engines 0.5%

SERVICE O2 (LOX) 0.500 30.0 1.0 30.0 3.0 14.9

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

33% of avg possessed acft 0.2%

SERVICE AIR 0.333 20.0 2.0 40.0 3.0 19.8

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

33% of avg possessed acft 0.3%

SERVICE HYD FLUID 0.500 30.0 1.0 30.0 25.0 38.1

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every 25 hours flown 0.6%

SERVICE TIRES 0.250 15.0 1.0 15.0 3.0 7.4

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

33% of avg possessed acft 0.1%

FOD WALK 0.333 20.0 30.0 599.4 1.0 199.8

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every O&M day	3.0%
		--------------------------------------	----------------	----------------	----------------	----------------	----------------	----------------	------------------
		MISC CLEANING	1.000	60.0	1.0	60.0	4.0	439.5

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every fourth sortie flown 6.6%

VACUUM ACFT 0.250 15.0 1.0 15.0 25.0 19.0

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every 25 hours flown 0.3%

ENG CLEAN & TREAT 1.000 60.0 4.0 240.0 75.0 101.5

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every 75 hours flown	1.5%
		--------------------------------------	----------------	----------------	----------------	----------------	----------------	----------------	------------------
		PREFLIGHT	0.833	50.0	1.0	50.0	0.25	366.1

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

25% of sorties flown 5.5%

THRUFLIGHT 0.833 50.0 1.0 50.0 0.67 981.2

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

67% of sorties flown MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 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: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

10% of sorties flown MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 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: 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: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every O&M day	10.0%
		--------------------------------------	----------------	----------------	----------------	----------------	----------------	----------------	------------------
		SOAP SAMPLES	0.750	45.0	1.0	45.0	20.0	142.7

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every 20 hours flown times 2 MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Avg possessed acft times 4 2.1%

DEFUEL/DEPUDDLE AIRCRAFT 1.500 90.0 1.0 90.0 6.0 9.0

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

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

Once per sortie flown	0.1%
		--------------------------------------	----------------	----------------	----------------	----------------	----------------	----------------	------------------
		UPDATE DAILY FORMS	0.167	10.0	1.0	10.0	1.0	293.6

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Once per sortie flown MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every 10 hours flown times 2 engines 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: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Once per sortie flown MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 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: 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: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

33% of avg possessed acft	13.4%
		--------------------------------------	----------------	----------------	----------------	----------------	----------------	----------------	------------------
		PARTS PROCESSING	2.000	120.0	2.0	240.0	1.0	80.0

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every O&M day MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every 25 hours flown MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

33% of avg possessed acft 1.2%

6648.1 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-0001 01 Dec 15

&"Times New Roman,Regular"&12 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	INPUT	JOB	JST	MINUTES	CR SZ	TOT MIN	FREQ	TOT HRS	% OF TOT
----	-----	----------	---	-------	-----	--------	----	-------	-
O&M DAYS IN MONTH	20.0	LAUNCH AIRCRAFT	0.333	20.0	1.0	20.0	1.0	175.2

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Once per sortie flown 7.5%

AVG POSS AIRCRAFT 34.4 RECOVER AIRCRAFT 0.167 10.0 1.0 10.0 1.0 87.8

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Once per sortie flown 3.7%

TOTAL HOURS FLOWN 488.1 TOW AIRCRAFT 2.000 120.0 3.0 360.0 1.0 120.0

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every O&M day 5.1%

TOTAL SORTIES FLOWN 526.0 MOORING 0.167 10.0 1.0 10.0 4.0 23.0

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Avg possessed acft times 4 1.0%

SERVICE FUEL 0.333 20.0 1.0 20.0 1.0 175.2

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Once per sortie flown 7.5%

SERVICE OIL 0.083 5.0 1.0 5.0 10.0 8.1

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every 10 hours flown times 2 engines 0.3%

SERVICE O2 (LOX) 0.500 30.0 1.0 30.0 3.0 5.7

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

33% of avg possessed acft 0.2%

SERVICE AIR 0.333 20.0 2.0 40.0 3.0 7.6

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

33% of avg possessed acft 0.3%

SERVICE HYD FLUID 0.500 30.0 1.0 30.0 25.0 9.8

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every 25 hours flown 0.4%

SERVICE TIRES 0.250 15.0 1.0 15.0 3.0 2.9

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

33% of avg possessed acft 0.1%

FOD WALK 0.333 20.0 30.0 599.4 1.0 199.8

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every O&M day	8.5%
		--------------------------------------	----------------	----------------	----------------	----------------	----------------	----------------	------------------
		MISC CLEANING	1.000	60.0	1.0	60.0	4.0	131.5

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every fourth sortie flown 5.6%

VACUUM ACFT 0.250 15.0 1.0 15.0 25.0 4.9

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every 25 hours flown 0.2%

ENG CLEAN & TREAT 1.000 60.0 4.0 240.0 75.0 26.0

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every 75 hours flown	1.1%
		--------------------------------------	----------------	----------------	----------------	----------------	----------------	----------------	------------------
		PREFLIGHT	0.833	50.0	1.0	50.0	0.25	109.5

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

25% of sorties flown 4.7%

THRUFLIGHT 0.833 50.0 1.0 50.0 0.67 293.6

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

67% of sorties flown MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 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: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

10% of sorties flown MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 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: 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: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every O&M day	8.5%
		--------------------------------------	----------------	----------------	----------------	----------------	----------------	----------------	------------------
		SOAP SAMPLES	0.750	45.0	1.0	45.0	20.0	36.6

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every 20 hours flown times 2 MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 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: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

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

Once per sortie flown	0.4%
		--------------------------------------	----------------	----------------	----------------	----------------	----------------	----------------	------------------
		UPDATE DAILY FORMS	0.167	10.0	1.0	10.0	1.0	87.8

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Once per sortie flown MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every 10 hours flown times 2 engines 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: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Once per sortie flown MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: 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: 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: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

33% of avg possessed acft	14.7%
		--------------------------------------	----------------	----------------	----------------	----------------	----------------	----------------	------------------
		PARTS PROCESSING	2.000	120.0	2.0	240.0	1.0	80.0

MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every O&M day MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

Every 25 hours flown MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA: MORGAN, JAMES C GS-12 USAF AETC AETC/A4MMA:

33% of avg possessed acft 3.4%

2347.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-0001 01 Dec 15

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

File details come from the government source that posted it. Updated Nov 14, 2017.