03 05A COL Aircraft Maint Workload Appendix 3BA

FA3002-11-R-0007

23 Nov 2011

A0001

Columbus AFB

Aircraft Maintenance

3BA-1

Appendix 3BA

3BA. Workload Data, Flying Program Workload Estimates (Informational only)

3BA.1. Annual Flying Hour Projections.

Table 3BA.1.

Fiscal

Year

Contract

Award

Operational

Period

Baseline

Current HQ

AETC/PA

Hours

Adjusted

FH CLIN

Band

Mod#

T-1A Aircraft Flying Hours:

FY 13 25604

FY 14 26323

FY 15 26256

FY 16 26197

FY 17 26180

FY 18 26180

FY 19 26180

T-6A Aircraft Flying Hours:

FY 13 49301

FY 14 50176

FY 15 50129

FY 16 49757

FY 17 50223

FY 18 50223

FY 19 50223

T-38C (SUPT) Aircraft Flying Hours:

FY 13 13731

FY 14 14202

FY 15 14178

FY 16 14073

FY 17 14039

FY 18 14039

FY 19 14039

T-38C (IFF) Aircraft Flying Hours:

FY 13 3762

FY 14 3762

FY 15 3762

FY 16 3762

FY 17 3762

FY 18 3762

FY 19 3762

A0001

Columbus AFB

Aircraft Maintenance

3BA-2

3BA.2. Flying Program Utilization. The following information shall be used to accurately calculate the daily aircraft requirement. Due to seasonal changes in daylight flying windows through out the year, actual operational flying periods require adjustment in order to accommodate training requirements and timelines. In addition, fluctuations in requirements such as daily Average Sortie Duration (ASD) can be anticipated however, the overall yearly program execution goal is to achieve the advertised rate and it is reflected as the annual average. Close coordination and pro active long range planning between the maintenance organizations and flying squadrons are required. Because of the many factors affecting daily operations, aircraft maintenance manning levels shall be able to accommodate a daily Ten percent (cushion) increase in required Cap and Spare for all MDS.

Table 3BA.2.

T-1A T-6A

T-38C

SUPT

T-38C

IFF

Average Sortie Duration (ASD) 2.1 1.35 1.089 0.95

Annual Utilization Rate (UTE) 25.0 38.2 22.0 22.0

Initial Solo Sortie (Note 6) 0 320 0 0

Night flights 4.2% 2% 5.5% 0%

Off Station Weekend cross country flights 4.7% 4.1% 5.2% 1.9%

Day/night out and back flights

- off station 37.1% 1.0% 4.6% .1%

Day/night out and back flights

- on station 34% 1.0% 5.6% .0%

Annual Attrition % 6.6% 20.4% 21.8% 18.1%

O & M Days (Average) 242.5 242.5 242.5 242.5

Goes Per Day

(Note 1 & Note 2)

3.7

Average

3.0

Average

2.5

Average

Spares 15% 15% 15% 20%

Note 1: An increased Cap will be required in the winter months due to shortened daylight flying windows. Additionally, there is a potential of increased flying periods during night time operations. These flying periods are subject to change based on attrition, increased student load, and/or IP availability as well as daylight windows. Ultimately, the number of “Goes Per

Day” are a function of daylight window, Operations and Maintenance negotiation.

Note 2: For general planning purposes, the length of the operational summer flying period is approximately fourteen and one half hours, starting 15 minutes prior to official sunrise

(normally May through September). For general planning purposes, the length of the operational winter flying period is approximately ten hours (normally October through April).

A0001

Columbus AFB

Aircraft Maintenance

3BA-3

Note 3: Approximately 50 administrative flights may take place per year using any type aircraft. Cost will be included in the contract price.

Note 4: Approximately 500 ROTC flights may take place each year using T-6 aircraft. These flights may take place on or off station. Cost will be included in the contract price.

Note 5: T-1A, T-6A & T-38C Flyovers: Approximately 20 events per year, minimum of 4 aircraft per event. Cost will be included in the contract price.

Note 6: Initial Solo Sortie: This sortie consists of an instructor and student pilot flying the first half of sortie length together, upon completion the aircraft returns to parking spot and instructor pilot departs aircraft and student pilot completes the last half scheduled sortie line.

No maintenance actions are requires except for marshaling aircraft in and out of parking spot.

A0001

Columbus AFB

Aircraft Maintenance

3BA-4

3BA.3. Example Daily Flying Schedules.

NOTE: Times reflected in T-1A, T-6A, T-38C SUPT & T-38C IFF Plt Prflt, Taxi, TOT and

Chock columns are offered as examples only. The times will vary and the number of sorties

(lines) will vary according to available flying windows throughout the year and weather delays/cancellations.

Table 3BA.3.1. T-1A Example Schedule.

1 2

Line

PLT PRFLT TAXI TOT CHOCK PLT PRFLT TAXI TOT CHOCK

1 7:20 7:50 8:00 11:30 12:50 13:20 13:30 17:00

2 7:25 7:55 8:05 11:35 12:55 13:25 13:35 17:05

3 7:30 8:00 8:10 11:40 13:00 13:30 13:40 17:10

4 7:35 8:05 8:15 11:45 13:05 13:35 13:45 17:15

5 7:40 8:10 8:20 11:50 13:10 13:40 13:50 17:20

6 7:45 8:15 8:25 11:55 13:15 13:45 13:55 17:25

7 7:50 8:20 8:30 12:00 13:20 13:50 14:00 17:30

8 7:55 8:25 8:35 12:05 13:25 13:55 14:05 17:35

9 8:00 8:30 8:40 12:10 13:30 14:00 14:10 17:40

10 8:05 8:35 8:45 12:15 13:35 14:05 14:15 17:45

11 8:10 8:40 8:50 O & B 15:05

12 8:15 8:45 8:55 O & B 15:10

13 8:20 8:50 9:00 O & B 15:15

14 8:25 8:55 9:05 O & B 15:20

15 8:30 9:00 9:10 O & B 15:25

16 8:35 9:05 9:15 O & B 15:30

17 8:40 9:10 9:20 O & B 15:35

18 8:45 9:15 9:25 O & B 15:40

19 8:50 9:20 9:30 O & B 15:45

20 8:55 9:25 9:35 O & B 15:50

21 9:00 9:30 9:40 O & B 15:55

22 9:05 9:35 9:45 O & B 16:00

23 9:10 9:40 9:50 O & B 16:05

24 9:15 9:45 9:55 O & B 16:10

25 9:20 9:50 10:00 O & B 16:15

26 9:25 9:55 10:05 O & B 16:20

27 9:30 10:00 10:10 O & B 16:25

28 9:35 10:05 10:15 O & B 16:30

29 9:40 10:10 10:20 O & B 16:35

A0001

Columbus AFB

Aircraft Maintenance

3BA-5

Table 3BA.3.2. T-6A Example Schedule.

LINE

PLT PREFLT TAXI TOT CHOC

K

PLT PREFLT TAXI TOT CHOCK

1 6:00 6:20 6:30 7:45 9:00 9:20 9:30 10:45

2 6:03 6:23 6:33 7:48 9:03 9:23 9:33 10:48

3 6:06 6:26 6:36 7:51 9:06 9:26 9:36 10:51

4 6:09 6:29 6:39 7:54 9:09 9:29 9:39 10:54

5 6:12 6:32 6:42 7:57 9:12 9:32 9:42 10:57

6 6:15 6:35 6:45 8:00 9:15 9:35 9:45 11:00

7 6:18 6:38 6:48 8:03 9:18 9:38 9:48 11:03

8 6:21 6:41 6:51 8:06 9:21 9:41 9:51 11:06

9 6:24 6:44 6:54 8:09 9:24 9:44 9:54 11:09

10 6:27 6:47 6:57 8:12 9:27 9:47 9:57 11:12

11 6:30 6:50 7:00 8:15 9:30 9:50 10:00 11:15

12 6:33 6:53 7:03 8:18 9:33 9:53 10:03 11:18

13 6:36 6:56 7:06 8:21 9:36 9:56 10:06 11:21

14 6:39 6:59 7:09 8:24 9:39 9:59 10:09 11:24

15 6:42 7:02 7:12 8:27 9:42 10:02 10:12 11:27

16 6:45 7:05 7:15 8:30 9:45 10:05 10:15 11:30

17 6:48 7:08 7:18 8:33 9:48 10:08 10:18 11:33

18 6:51 7:11 7:21 8:36 9:51 10:11 10:21 11:36

19 6:54 7:14 7:24 8:39 9:54 10:14 10:24 11:39

20 6:57 7:17 7:27 8:42 9:57 10:17 10:27 11:42

21 7:00 7:20 7:30 8:45 10:00 10:20 10:30 11:45

22 7:03 7:23 7:33 8:48 10:03 10:23 10:33 11:48

23 7:06 7:26 7:36 8:51 10:06 10:26 10:36 11:51

24 7:09 7:29 7:39 8:54 10:09 10:29 10:39 11:54

25 7:12 7:32 7:42 8:57 10:12 10:32 10:42 11:57

26 7:15 7:35 7:45 9:00 10:15 10:35 10:45 12:00

27 7:18 7:38 7:48 9:03 10:18 10:38 10:48 12:03

28 7:21 7:41 7:51 9:06 10:21 10:41 10:51 12:06

29 7:24 7:44 7:54 9:09 10:24 10:44 10:54 12:09

30 7:27 7:47 7:57 9:12 10:27 10:47 10:57 12:12

31 7:30 7:50 8:00 9:15 10:30 10:50 11:00 12:15

32 7:33 7:53 8:03 9:18 10:33 10:53 11:03 12:18

33 7:36 7:56 8:06 9:21 10:36 10:56 11:06 12:21

34 7:39 7:59 8:09 9:24 10:39 10:59 11:09 12:24

35 7:42 8:02 8:12 9:27 10:42 11:02 11:12 12:27

36 7:45 8:05 8:15 9:30 10:45 11:05 11:15 12:30

37 7:48 8:08 8:18 9:33 10:48 11:08 11:18 12:33

38 7:51 8:11 8:21 9:36 10:51 11:11 11:21 12:36

39 7:54 8:14 8:24 9:39 10:54 11:14 11:24 12:39

40 7:57 8:17 8:27 9:42 10:57 11:17 11:27 12:42

41 8:00 8:20 8:30 9:45 11:00 11:20 11:30 12:45

42 8:03 8:23 8:33 9:48 11:03 11:23 11:33 12:48

43 8:06 8:26 8:36 9:51 11:06 11:26 11:36 12:51

44 8:09 8:29 8:39 9:54 11:09 11:29 11:39 12:54

45 8:12 8:32 8:42 9:57 11:12 11:32 11:42 12:57

46 8:15 8:35 8:45 10:00 11:15 11:35 11:45 13:00

47 8:18 8:38 8:48 10:03 11:18 11:38 11:48 13:03

48 8:21 8:41 8:51 10:06 11:21 11:41 11:51 13:06

49 8:24 8:44 8:54 10:09 11:24 11:44 11:54 13:09

50 8:27 8:47 8:57 10:12 11:27 11:47 11:57 13:12

51 8:30 8:50 9:00 10:15 11:30 11:50 12:00 13:15

52 8:33 8:53 9:03 10:18 11:33 11:53 12:03 13:18

A0001

Columbus AFB

Aircraft Maintenance

3BA-6

53 8:36 8:56 9:06 10:21 11:36 11:56 12:06 13:21

54 8:39 8:59 9:09 10:24 11:39 11:59 12:09 13:24

55 8:42 9:02 9:12 10:27 11:42 12:02 12:12 13:27

3 4

1 12:00 12:20 12:30 13:45 15:00 15:20 15:30 16:45

2 12:03 12:23 12:33 13:48 15:03 15:23 15:33 16:48

3 12:06 12:26 12:36 13:51 15:06 15:26 15:36 16:51

4 12:09 12:29 12:39 13:54 15:09 15:29 15:39 16:54

5 12:12 12:32 12:42 13:57 15:12 15:32 15:42 16:57

6 12:15 12:35 12:45 14:00 15:15 15:35 15:45 17:00

7 12:18 12:38 12:48 14:03 15:18 15:38 15:48 17:03

8 12:21 12:41 12:51 14:06 15:21 15:41 15:51 17:06

9 12:24 12:44 12:54 14:09 15:24 15:44 15:54 17:09

10 12:27 12:47 12:57 14:12 15:27 15:47 15:57 17:12

11 12:30 12:50 13:00 14:15 15:30 15:50 16:00 17:15

12 12:33 12:53 13:03 14:18 15:33 15:53 16:03 17:18

13 12:36 12:56 13:06 14:21 15:36 15:56 16:06 17:21

14 12:39 12:59 13:09 14:24 15:39 15:59 16:09 17:24

15 12:42 13:02 13:12 14:27 15:42 16:02 16:12 17:27

16 12:45 13:05 13:15 14:30 15:45 16:05 16:15 17:30

17 12:48 13:08 13:18 14:33 15:48 16:08 16:18 17:33

18 12:51 13:11 13:21 14:36 15:51 16:11 16:21 17:36

19 12:54 13:14 13:24 14:39 15:54 16:14 16:24 17:39

20 12:57 13:17 13:27 14:42 15:57 16:17 16:27 17:42

21 13:00 13:20 13:30 14:45 16:00 16:20 16:30 17:45

22 13:03 13:23 13:33 14:48 16:03 16:23 16:33 17:48

23 13:06 13:26 13:36 14:51 16:06 16:26 16:36 17:51

24 13:09 13:29 13:39 14:54 16:09 16:29 16:39 17:54

25 13:12 13:32 13:42 14:57 16:12 16:32 16:42 17:57

26 13:15 13:35 13:45 15:00 16:15 16:35 16:45 18:00

27 13:18 13:38 13:48 15:03 16:18 16:38 16:48 18:03

28 13:21 13:41 13:51 15:06 16:21 16:41 16:51 18:06

29 13:24 13:44 13:54 15:09 16:24 16:44 16:54 18:09

30 13:27 13:47 13:57 15:12 16:27 16:47 16:57 18:12

31 13:30 13:50 14:00 15:15 16:30 16:50 17:00 18:15

32 13:33 13:53 14:03 15:18 16:33 16:53 17:03 18:18

33 13:36 13:56 14:06 15:21 16:36 16:56 17:06 18:21

34 13:39 13:59 14:09 15:24 16:39 16:59 17:09 18:24

35 13:42 14:02 14:12 15:27 16:42 17:02 17:12 18:27

36 13:45 14:05 14:15 15:30 16:45 17:05 17:15 18:30

37 13:48 14:08 14:18 15:33 16:48 17:08 17:18 18:33

38 13:51 14:11 14:21 15:36 16:51 17:11 17:21 18:36

39 13:54 14:14 14:24 15:39 16:54 17:14 17:24 18:39

40 13:57 14:17 14:27 15:42 16:57 17:17 17:27 18:42

41 14:00 14:20 14:30 15:45 17:00 17:20 17:30 18:45

42 14:03 14:23 14:33 15:48 17:03 17:23 17:33 18:48

43 14:06 14:26 14:36 15:51 17:06 17:26 17:36 18:51

44 14:09 14:29 14:39 15:54 17:09 17:29 17:39 18:54

45 14:12 14:32 14:42 15:57 17:12 17:32 17:42 18:57

46 14:15 14:35 14:45 16:00 17:15 17:35 17:45 19:00

47 14:18 14:38 14:48 16:03 17:18 17:38 17:48 19:03

48 14:21 14:41 14:51 16:06 17:21 17:41 17:51 19:06

49 14:24 14:44 14:54 16:09 17:24 17:44 17:54 19:09

50 14:27 14:47 14:57 16:12 17:27 17:47 17:57 19:12

51 14:30 14:50 15:00 16:15 17:30 17:50 18:00 19:15

52 14:33 14:53 15:03 16:18 17:33 17:53 18:03 19:18

A0001

Columbus AFB

Aircraft Maintenance

3BA-7

53 14:36 14:56 15:06 16:21 17:36 17:56 18:06 19:21

54 14:39 14:59 15:09 16:24 17:39 17:59 18:09 19:24

55 14:42 15:02 15:12 16:27 17:42 18:02 18:12 19:27

Table 3BA.3.3. T-38C SUPT Example Schedule.

Line

PLT

PRFLT

TAXI TOT CHOCK PLT PRFLT TAXI TOT CHOCK

1 6:00 6:20 6:35 7:45 9:30 9:50 10:05 11:15

2 6:00 6:20 6:35 7:45 9:30 9:50 10:05 11:15

3 6:05 6:25 6:40 7:50 9:35 9:55 10:10 11:20

4 6:05 6:25 6:40 7:50 9:35 9:55 10:10 11:20

5 6:20 6:40 6:55 8:05 9:50 10:10 10:25 11:35

6 6:20 6:40 6:55 8:05 9:50 10:10 10:25 11:35

7 6:25 6:45 7:00 8:10 9:55 10:15 10:30 11:40

8 6:25 6:45 7:00 8:10 9:55 10:15 10:30 11:40

9 6:40 7:00 7:15 8:25 10:10 10:30 10:45 11:55

10 6:40 7:00 7:15 8:25 10:10 10:30 10:45 11:55

11 6:45 7:05 7:20 8:30 10:15 10:35 10:50 12:00

12 6:45 7:05 7:20 8:30 10:15 10:35 10:50 12:00

13 7:00 7:20 7:35 8:45 10:30 10:50 11:05 12:15

14 7:00 7:20 7:35 8:45 10:30 10:50 11:05 12:15

15 7:05 7:25 7:40 8:50 10:35 10:55 11:10 12:20

16 7:05 7:25 7:40 8:50 10:35 10:55 11:10 12:20

17 7:20 7:40 7:55 9:05 10:50 11:10 11:25 12:35

18 7:20 7:40 7:55 9:05 10:50 11:10 11:25 12:35

19 7:25 7:45 8:00 9:10 10:55 11:15 11:30 12:40

20 7:25 7:45 8:00 9:10 10:55 11:15 11:30 12:40

21 7:40 8:00 8:15 9:25 11:10 11:30 11:45 12:55

22 7:40 8:00 8:15 9:25 11:10 11:30 11:45 12:55

23 7:45 8:05 8:20 9:30 11:15 11:35 11:50 13:00

24 7:45 8:05 8:20 9:30 11:15 11:35 11:50 13:00

25 8:00 8:20 8:35 9:45 11:30 11:50 12:05 13:15

26 8:00 8:20 8:35 9:45 11:30 11:50 12:05 13:15

27 8:05 8:25 8:40 9:50 11:35 11:55 12:10 13:20

28 8:05 8:25 8:40 9:50 11:35 11:55 12:10 13:20

29 11:50 12:10 12:25 13:35

30 11:50 12:10 12:25 13:35

31 11:55 12:15 12:30 13:40

32 11:55 12:15 12:30 13:40

1 13:00 13:20 13:35 14:45

2 13:00 13:20 13:35 14:45

3 13:05 13:25 13:40 14:50

4 13:05 13:25 13:40 14:50

5 13:20 13:40 13:55 15:05

6 13:20 13:40 13:55 15:05

A0001

Columbus AFB

Aircraft Maintenance

3BA-8

7 13:25 13:45 14:00 15:10

8 13:25 13:45 14:00 15:10

9 13:40 14:00 14:15 15:25

10 13:40 14:00 14:15 15:25

11 13:45 14:05 14:20 15:30

12 13:45 14:05 14:20 15:30

13 14:00 14:20 14:35 15:45

14 14:00 14:20 14:35 15:45

15 14:05 14:25 14:40 15:50

16 14:05 14:25 14:40 15:50

17 14:20 14:40 14:55 16:05

18 14:20 14:40 14:55 16:05

19 14:25 14:45 15:00 16:10

20 14:25 14:45 15:00 16:10

21 14:40 15:00 15:15 16:25

22 14:40 15:00 15:15 16:25

23 14:45 15:05 15:20 16:30

24 14:45 15:05 15:20 16:30

25 15:00 15:20 15:35 16:45

26 15:00 15:20 15:35 16:45

27 15:05 15:25 15:40 16:50

28 15:05 15:25 15:40 16:50

Table 3BA.3.3. T-38C IFF Example Schedule

Note: During required surge the schedule will be extended to 3 goes 12X10X10 with a maximum of 2 hours and 45 minutes between goes for no more than 25% of total annual operations 1 2

Line

PLT

PRFLT

TAXI TOT CHOCK Line

PLT

PRFLT

TAXI TOT CHOCK

1 9:20 9:40 9:55 11:05 7 13:35 13:55 14:10 15:20

2 9:20 9:40 9:55 11:05 8 13:35 13:55 14:10 15:20

3 9:20 9:40 9:55 11:05 9 13:45 14:05 14:20 15:30

4 9:20 9:40 9:55 11:05 10 13:45 14:05 14:20 15:30

5 9:30 9:50 10:05 11:15 11 13:55 14:15 14:30 15:40

6 9:30 9:50 10:05 11:15 12 13:55 14:15 14:30 15:40

7 9:50 10:10 10:25 11:35 13 14:15 14:35 14:50 16:00

8 9:50 10:10 10:25: 11:35 14 14:15 14:35 14:50 16:00

9 10:00 10:20 10:35 11:45

10 10:00 10:20 10:35 11:45

A0001

Columbus AFB

Aircraft Maintenance

3BA-9

3BA.4. - Aircraft Assignment Data.

Table 3BA.4.

T-1A FY13 FY14 FY15 FY16 FY17 FY18 FY19

PAI Required 37.8 38.3 40.0. 42.5 42.5 42.5 42.5

BAI (5%) 2.0 2.0 3.0 3.0 3.0 3.0 3.0

Attrition Reserve (.9 X

100K FH)

8.2 5.7 4.0 1.5 1.5 1.5 1.5

Aircraft Assigned 47 47 47 47 47 47 47

T-6A FY13 FY14 FY15 FY16 FY17 FY18 FY19

PAI Required 75.0 77.1 81.0 82 82 82 82

BAI (10%) 8.0 8.5 9.0 9.0 9.0 9.0 9.0

Attrition Reserve (1.5

X100K FH)

16.4 14.9 10.0 9.0 9.0 9.0 9.0

Aircraft Assigned 100 100 100 100 100 100 100

T-38C SUPT FY13 FY14 FY15 FY16 FY17 FY18 FY19

PAI Required 49.1 50.6 49.3 48.9 48.8 48.8 48.8

BAI (15%) 8.0 7.4 8.0 8.0 8.0 8.0 8.0

Attrition Reserve (1.2 X

100K FH

0.9 0.0 0.7 1.1 1.2 1.2 1.2

Aircraft Assigned 58 58 58 58 58 58 58

T-38C IFF FY13 FY14 FY15 FY16 FY17 FY18 FY19

PAI Required 16 16 16 16 16 16 16

BAI (15%) 3 3 3 3 3 3 3

Attrition Reserve (1.2 X

100K FH)

10 10 10 10 10 10 10

Aircraft Assigned 29 29 29 29 29 29 29

A

A0001

Columbus AFB

Aircraft Maintenance

3BA-10

3BA.4. - Aircraft Cap Spare Data.

Table 3BA.5.

T-1A SAMPLE (FY13 Hours)

Annual FH

25604 X-country 4.7%

24401

ASD

2.1 Annual Local Sorties Required

11619

Annual Attrition %

6.6% Annual Local Scheduled

12386

O&M days

242.5 Daily Local Required

51.08

Goes Per Day

2.0

Average Front lines

25.54

26.00

Average Spares Req 15.0% 3.83

4.00

Maximum Front lines Required 10.0% 28.09

29.00

Spares Req 15.0% 4.21

5.00

32.31

Required Cap/Spares

33.00

34.00

A0001

Columbus AFB

Aircraft Maintenance

3BA-11

T-6A SAMPLE (FY13 Hours)

49301 X-country 4.1%

47280

1.35

35022

20.4%

42166

173.88

Average Goes Per Day

3.7

47.00 Average Spares Req 15.0% 7.05

Maximum Front lines Required 15.0% 54.04

55.00

Spares Req 15.0% 8.11

9.00

62.15

63.00

64.00

A0001

Columbus AFB

Aircraft Maintenance

3BA-12

T-38C SUPT SAMPLE (FY13 Hours)

13731 X-country 5.2%

13017

1.089

11953

21.8%

14559

60.04

3.0

20.01 Average Spares Req 15.0% 3.00

Maximum Front lines Required 35.0% 27.02

28.00

Spares Req 15.0% 4.05

5.00

31.07

32.00

33.00

A0001

Columbus AFB

Aircraft Maintenance

3BA-13

T-38C IFF SAMPLE (FY13 Hours)

X-country 1.9%

3690.5

0.95

3884.8

18.1%

4587.9

18.92

2.5

7.57 Average Spares Req 20.0% 1.51

Maximum Front lines Required 20.0% 9.08

10.00

Spares Req 20.0% 1.82

2.00

10.90

11.00

12.00