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:600Aircraft rental rate (assuming only single engine instruction):$160.00
7
Expected Ground hours billed per year by instructor:100Number aircraft hours:50
8
Current Instructor Wage rate:$24.00Cost of aircraft time:$8,000.00
9
Yearly wage:$16,800.00Number gorund hours:8
10
11
Current Customer billed rate:
$65.00Cost of instructor time at current wage rate:$8,008.33
12
13
Desired instructor wage:$50,000.00Cost of training footprint yearly per customer:$16,008.33
14
Hourly wage required:$71.43
15
Difference Required to Customer Hourly Rate:$47.43Cost of instructor time at increase wage rate:$10,775.00
16
Required Instructor to Customer Rate:$116.22
17
Cost of training footprint yearly per cusotmer at increased wage rate:$18,775.00
18
Number of students per hours billed (yearly):12
19
Billed Ground/Flight Hours per student (yearly) - ground and flight combined):58
20
21
Difference in expense to student (yearly over
22
50 hours of flight/50 hours of ground instruction):$2,766.67% Increase in cost to customer:17.28%
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 Hours60$160.00$9,600.00
29
Instructor Flight Hours40$2,600.00
30
Instructor Ground Hours40$2,600.00
31
32
Instrument
33
Aircraft Hours50$160.00$8,000.00
34
Instructor Flight Hours50$3,250.00
35
Instructor Ground Hours20$1,300.00
36
37
Commercial Multi
38
Aircraft Hours20$240.00$4,800.00
39
Instructor Flight Hours20$1,300.00
40
Instructor Ground Hours20$1,300.00
41
42
Total Instructor Hours/Cost190$12,350.00
43
Total Aircraft Cost$22,400.00
44
Total Current Rate Training Footprint Cost
$34,750.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 Hours60$160.00$9,600.00
50
Instructor Flight Hours40$4,648.91
51
Ground Hours40$4,648.91
52
53
Instrument
54
Aircraft Hours50$160.00$8,000.00
55
Instructor Flight Hours50$5,811.14
56
Ground Hours20$2,324.46
57
58
Commercial Multi
59
Aircraft Hours20$240.00$4,800.00
60
Instructor Flight Hours20$2,324.46
61
Ground Hours20$2,324.46
62
63
Total Instructor Hours/Cost190$22,082.34
64
Total Aircraft Cost$22,400.00
65
Total Increased Instructor Rate Training Footprint Cost
$44,482.34
66
67
Increase in Cost to Customer for Training:
$9,732.34
68
69
% Increase Cost to Customer over ALL Training with Instructor:
28.01%
70
71
Increase in Pay Percentage to Instructor:
198%
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...
Main menu