Jason Blair Calculating CFI Pay Increases Compared to Training Costs
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
ABCDEFG
1
2
Calculating theTotal Training Cost Increase Effect to a Customer of Increasing Instructor Compensation Levels
3
Instruction: Enter expected/desired values in each yellow box to cause resultant calculation levels throughout the spreadsheet.
4
5
Current and Desired Instructor Wage Considerations
6
Expected Flight Hours billed per year by instructor:1000Aircraft rental rate (assuming only single engine instruction):$160.00
7
Expected Ground hours billed per year by instructor:200Number aircraft hours:100
8
Current Instructor Wage rate:$20.00Cost of aircraft time:$16,000.00
9
Yearly wage:$24,000.00Number gorund hours:20
10
11
Current Customer billed rate:
$160.00Cost of instructor time at current wage rate:$16,020.00
12
13
Desired instructor wage:$35,000.00Cost of training footprint yearly per customer:$32,020.00
14
Hourly wage required:$29.17
15
Difference Required to Customer Hourly Rate:$9.17Cost of instructor time at increase wage rate:$17,120.00
16
Required Instructor to Customer Rate:$169.90
17
Cost of training footprint yearly per cusotmer at increased wage rate:$33,120.00
18
Number of students per hours billed (yearly):10
19
Billed Ground/Flight Hours per student (yearly) - ground and flight combined):120
20
21
Difference in expense to student (yearly over
22
50 hours of flight/50 hours of ground instruction):$1,100.00% Increase in cost to customer:3.44%
23
24
25
Total Training Footprint Cost
Number of
26
At Current Instructor Rate
Hours Customer
Aircraft Rate
Aircraft Rate
27
PrivateIncurs
Single Engine
MultiengineCost to Student
28
Aircraft Hours80$160.00$12,800.00
29
Instructor Flight Hours70$11,200.00
30
Instructor Ground Hours20$3,200.00
31
32
Instrument
33
Aircraft Hours50$160.00$8,000.00
34
Instructor Flight Hours50$8,000.00
35
Instructor Ground Hours20$3,200.00
36
37
Commercial Multi
38
Aircraft Hours0$0.00$0.00
39
Instructor Flight Hours0$0.00
40
Instructor Ground Hours0$0.00
41
42
Total Instructor Hours/Cost160$25,600.00
43
Total Aircraft Cost$20,800.00
44
Total Current Rate Training Footprint Cost
$46,400.00
45
46
Number of
47
At Increased Instructor Rate
Hours Customer
Aircraft Rate
Aircraft Rate
48
PrivateIncurs
Single Engine
MultiengineCost to Student
49
Aircraft Hours80$160.00$12,800.00
50
Instructor Flight Hours70$11,893.00
51
Ground Hours20$3,398.00
52
53
Instrument
54
Aircraft Hours50$160.00$8,000.00
55
Instructor Flight Hours50$8,495.00
56
Ground Hours20$3,398.00
57
58
Commercial Multi
59
Aircraft Hours0$0.00$0.00
60
Instructor Flight Hours0$0.00
61
Ground Hours0$0.00
62
63
Total Instructor Hours/Cost160$27,184.00
64
Total Aircraft Cost$20,800.00
65
Total Increased Instructor Rate Training Footprint Cost
$47,984.00
66
67
Increase in Cost to Customer for Training:
$1,584.00
68
69
% Increase Cost to Customer over ALL Training with Instructor:
3.41%
70
71
Increase in Pay Percentage to Instructor:
46%
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Sheet1
 
 
Main menu