Purchase Solution

Wings flight:Critique a Report; Prepare a Performance Report

Not what you're looking for?

Ask Custom Question

Wings flight school offers lessons at a small municipal airport. The school's owner and manager has been attempting to evaluate performance and control costs using variance report that compares the planning budget to actual results. A recent variance appears below:
Wings flight school
Variance report
For the month ended august 31

Planning Actual Variances
Budget Results

Lessons.....................................200 210
Revenue....................................$45,000 $47,300 $2300 F
expenses:
instructor wages..........................12,400 12,910 510 U
aircraft depreciation...................11,400 11,970 570 U
Fuel.............................................4,200 5,150 950 U
maintenance................................3,270 3,470 200 U
ground facility expenses..............2,440 2,350 90 F
administration...............................4,410 4,340 70 F
Total expenses..............................38,120 40,190 2,070 U
Net operating income.....................$6,880 $7,110 $230 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 august, but the report shows an unfavorable variance.

The planning budget was developed using the following formulas, where q is the
number of lessons sold:

Revenue............................$225q
Instructor wages.................$62q
Aircraft depreciation..........$57q
Fuel.....................................$21q
Maintenance........................$670+$13q
Ground facility expenses......$1640+$4q
Administration.......................$4210+$1q

Required:
1.Should the owner feel frustrated with the variance reports?Explain
2.Prepare a flexible budget performance report for the school for August
3.Evaluate the school's performance for August

Purchase this Solution

Solution Summary

Your tutorial includes a flexible budget report and an evaluation of the flight school results for August (in word). The flexible budget is in Excel so you have a template for other similar problems.

Solution Preview

1.Should the owner feel frustrated with the variance reports? Explain

Yes, the owner should be frustrated. The reason is that the actual activity varies from the planning budget and a significant portion of the total expenses vary with activity. Therefore, when activity is up, the expenses are up and appear over budget when, in fact, they are up appropriately because of increased activity and not because of unfavorable events. A better way to evaluate is to adjust the ...

Solution provided by:
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution


Free BrainMass Quizzes
Motivation

This tests some key elements of major motivation theories.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.