Explore BrainMass

Explore BrainMass

    Wings flight:Critique a Report; Prepare a Performance Report

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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

    © BrainMass Inc. brainmass.com June 4, 2020, 2:13 am ad1c9bdddf
    https://brainmass.com/business/accounting/wings-flight-critique-a-report-prepare-a-performance-report-447076

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

    $2.19

    ADVERTISEMENT