please help!!
TipTop Flight School offers flying lessons at a small municipal alrport. The schools owner and manage has been evaluate performance and control costs using a variance report that compares the planning budget to actual espace report appears below TipTop Flight School Variance Report For the Month Ended Jaly 31 Actual Flaming Results Badget Vari Lessons 155 150 $36,920 $ 36,000 $9207 Revenue Expenses : Instructor wages Aircraft depreciation Fuel Maintenance Ground facility expenses Administration Total expense 9,870 9,750 1200 4,960 4,800 1600 2,470 1,950 520 2,280 2,160 120 1.680 1,700 25 3.440 3.520 24,700 23,280 $200 $ 12,220 $ 12,120 $ 100 F Net operating income After several months of using these reports, the owner has become frustrated. For example, the as quite considera wages were very tightly controlled in July, but the report shows an unfavorable variance The planning budget was developed using the following formulas where is the number of lessons solid Revenue Instructor wages Aircraft depreciation Fuel Maintenance Ground facility expenses Administration Cost Formulas $2407 $650 $329 $139 $510 + $119 $1,250 + $30 $3,220 - $20 16 Required: 2. Complete the flexible budget performance report for the school for luy indicate the effect of criance by favorable, "U" for unfavorable, and "None" for no effect f.e, zero variance). Input all amounts as pouverture Pey tv 204 NEVE Instructor wages Aircraft depreciation Puel Maintenance Ground facility expenses Administration 3654 $329 $139 $510 - 5119 $1,250 + $34 $3,220 . $29 Required: 2. Complete the flexible budget performance report for the school for July (Indicate the effect of each varierer by favorable, "U" for unfavorable, and "None" for no effect fie. zero variance). Input al amounts as per the watu TipTop Flight School Flexible Budget Performance Report For the Month Ended July 31 Actual Revenue and Spending Results Variances 155 Pleasin Budowt Activity ances 150 Lessons $ 38,920 Revenue 100 Us Expenses: Instructor wages Aircraft depreciation Fuel 9.870 4,960 2.470 2 Maintenance Ground facility exponses Administration Total expense 2.280 1,680 3,440 24,700 $ 12.220 Net operating income fo 20 4