TipTop Flight School offers flying lessons at a small municipal airport. The sch
ID: 2570247 • Letter: T
Question
TipTop Flight School offers flying lessons at a small municipal airport. The school’s owner and manager has been attempting to evaluate performance and control costs using a variance report that compares the planning budget to actual results. A recent variance report appears below: TipTop Flight School Variance Report For the Month Ended July 31 Actual Results Planning Budget Variances Lessons 225 220 Revenue $ 62,690 $ 61,600 $ 1,090 F Expenses: Instructor wages 13,395 13,200 195 U Aircraft depreciation 7,650 7,480 170 U Fuel 4,870 4,180 690 U Maintenance 4,395 4,200 195 U Ground facility expenses 3,180 3,200 20 F Administration 4,250 4,440 190 F Total expense 37,740 36,700 1,100 U Net operating income $ 24,950 $ 24,900 $ 50 F After several months of using such variance reports, the owner has become frustrated. For example, she is quite confident that instructor wages were very tightly controlled in July, but the report shows an unfavorable variance. The planning budget was developed using the following formulas, where q is the number of lessons sold: Cost Formulas Revenue $280q Instructor wages $60q Aircraft depreciation $34q Fuel $19q Maintenance $680 + $16q Ground facility expenses $2,100 + $5q Administration $3,560 + $4q Required: 2. Complete the flexible budget performance report for the school for July. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
Explanation / Answer
Tiptop Flight School
Flexible budget performance report Abstract
For the month of July
Revenue and Spending variances (a-b)
U/F
Activity variances (a-c)
U/F
Number of cars washed
Revenue
310
U
1,400
F
Expenses
Instructor Wages
105
F
300
U
Aircraft depreciation
-
170
U
Fuel
595
U
95
U
Maintenance
115
U
80
U
Ground Facility expenses
45
F
25
U
Administrative expenses
210
F
20
U
Total Expenses
350
U
690
U
Net Operating Income
660
U
710
F
Workings:
Actual Results (a)
Flexible budget (b)
Planning budget ©
Budgeted rate
Fixed expense (budget)
225
225
220
62,690
63,000
61,600
280
13,395
13,500
13,200
60
7,650
7,650
7,480
34
4,870
4,275
4,180
19
4,395
4,280
4,200
16
680
3,180
3,225
3,200
5
2,100
4,250
4,460
4,440
4
3560
37,740
37,390
36,700
24,950
25,610
24,900
Tiptop Flight School
Flexible budget performance report Abstract
For the month of July
Revenue and Spending variances (a-b)
U/F
Activity variances (a-c)
U/F
Number of cars washed
Revenue
310
U
1,400
F
Expenses
Instructor Wages
105
F
300
U
Aircraft depreciation
-
170
U
Fuel
595
U
95
U
Maintenance
115
U
80
U
Ground Facility expenses
45
F
25
U
Administrative expenses
210
F
20
U
Total Expenses
350
U
690
U
Net Operating Income
660
U
710
F
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.