03 05A COL Aircraft Maint Workload Appendix 3BA

FA3002-11-R-0007

23 Nov 2011

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 23470

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 45193

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 12587

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 3449

FY 14 3762

FY 15 3762

FY 16 3762

FY 17 3762

FY 18 3762

FY 19 3762

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 throughout 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 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).

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.

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

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

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

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

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

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

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 2.0 2.0 3.0 3.0 3.0 3.0 3.0

Attrition Reserve 8.2 5.7 4.0 1.5 1.5 1.5 1.5

Aircraft Assigned 47 47 47 47 47 47 47

Aircraft Availability (AA) 31 31 33 35 35 35 35

T-6A FY13 FY14 FY15 FY16 FY17 FY18 FY19

PAI Required 75.0 77.1 81.0 82 82 82 82

BAI 8.0 8.5 9.0 9.0 9.0 9.0 9.0

Attrition Reserve 16.4 14.9 10.0 9.0 9.0 9.0 9.0

Aircraft Assigned 100 100 100 100 100 100 100

Aircraft Availability (AA) 67 69 72 73 73 73 73

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 8.0 7.4 8.0 8.0 8.0 8.0 8.0

Attrition Reserve 0.9 0.0 0.7 1.1 1.2 1.2 1.2

Aircraft Assigned 58 58 58 58 58 58 58

Aircraft Availability (AA) 37 38 37 37 37 37 37

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

PAI Required 16 16 16 16 16 16 16

BAI 3 3 3 3 3 3 3

Attrition Reserve 10 10 10 10 10 10 10

Aircraft Assigned 29 29 29 29 29 29 29

Aircraft Availability (AA) 12 12 12 12 12 12 12

Columbus AFB

Aircraft Maintenance

3BA-10

3BA.4. - Aircraft Cap Spare Data.

Table 3BA.5.

T-1A SAMPLE (FY13 Hours)

Annual FH

23470 X-country 4.7%

22367

ASD

2.1 Annual Local Sorties Required

10651

Annual Attrition %

6.6% Annual Local Scheduled

11354

O&M days

220.5 Daily Local Required

51.49

Goes Per Day

2.0

Average Front lines

25.75

26.00

Average Spares Req 15.0% 3.86

4.00

29.61

Average Cap/Spares

30.00

30.00

Daily 10% (Cushion) Increase Maximum Front lines Required 10.0% 28.32

29.00

Spares Req 15.0% 4.25

5.00

32.57

Required Cap/Spares

33.00

34.00

Columbus AFB

Aircraft Maintenance

3BA-11

T-6A SAMPLE (FY13 Hours)

45193 X-country 4.1%

43340

1.35

32104

20.4%

38653

175.30

Average Goes Per Day

3.7

47.38

48.00

Average Spares Req 15.0% 7.11

8.00

54.48

55.00

56.00

Maximum Front lines Required 10.0% 52.12

53.00

Spares Req 15.0% 7.82

59.93

60.00

61.00

Columbus AFB

3BA-12

T-38C SUPT SAMPLE (FY13 Hours)

12587 X-country 5.2%

11932

1.089

10957

21.8%

13346

60.53

3.0

20.18

21.00

Average Spares Req 15.0% 3.03

23.20

24.00

25.00

Maximum Front lines Required 10.0% 22.19

23.00

Spares Req 15.0% 3.33

25.52

26.00

27.00

Columbus AFB

3BA-13

T-38C IFF SAMPLE (FY13 Hours)

X-country 1.9%

3383.5

0.95

3561.5

18.1%

4206.2

19.08

2.5

7.63

Average Spares Req 20.0% 1.53

2.00

9.16

10.00

10.00

Maximum Front lines Required 10.0% 8.39

9.00

Spares Req 20.0% 1.68

2.00

10.07

11.00

11.00