Question and example format attached.

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: Actual Results Lessons Revenue $ Expenses: Instructor wages Aircraft depreciation Fuel Maintenance Ground facility expenses Administration Variances $ 580 U 14,000 13,440 560 U 5,700 4,270 4,800 4,010 900 U 260 U 2,500 2,590 90 F 4,365 4,430 65 F 46,535 $ 15,120 44,390 2,145 U 4,105 $ 6,010 $ 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: Revenue Instructor wages Aircraft depreciation Fuel Maintenance Ground facility expenses Administration 240 F 15,700 Total expense Net operating income TipTop Flight School Variance Report For the Month Ended July 31 Planning Budget 250 240 50,640 $ 50,400 Cost Formulas $210q $63q $56q $20q $ 650 + $14q $1,630 + $4q $4,190 + $1q 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).) -1,905 U Solution:- Computation of the Flexible Budget Performance Report AirQual Test Corporation Flexible Budget Performance Report For the Month Ended February 28 Particulars Jobs (q) Revenue ($276.00q) Expenses: Technician wages ($8,300) Mobile lab operating expenses ($4,800 + $27.00q) Office expenses ($2,500 + $3.00q) Advertising expenses ($1580) Insurance ($2,890) Miscellaneous expenses ($940 + $2.00q) Total expense Net operating income Planning Budget Activity Variances F/U Flexible Budget 110 $30,360 $8,300 $7,770 $2,830 $1,580 $2,890 $1,160 $24,530 $5,830 $(1,104) F $$$(12) $$$(8) $(20) $(1,084) U U U U F 110 $29,256 $8,300 $7,770 $2,818 $1,580 $2,890 $1,152 $24,510 $4,746 Revenue and Spending Variances F/U Actual Results $(1,646) F 106 $27,610 $(150) $160 $(138) $70 $$687 $(745) $(901) $8,150 $7,930 $2,680 $1,650 $2,890 $465 $23,765 $3,845 U F U U F U F Comprehensive Variance Analysis [LO2, LO3, LO4] Miller Toy Company manufactures a plastic swimming pool at its Westwood Plant. The plant has been experiencing problems as shown by its June contribution format income statement below: Budgeted Actual Sales (15,000 pools) . . . . . . . . . . . . . . . . . . . . $450,000 $450,000 Variable expenses: Variable cost of goods sold* . . . . . . . . . . . . 180,000 196,290 Variable selling expenses . . . . . . . . . . . . . . 20,000 20,000 Total variable expenses . . . . . . . . . . . . . . . . . . 200,000 216,290 Contribution margin . . . . . . . . . . . . . . . . . . . . . 250,000 233,710 Fixed expenses: Manufacturing overhead . . . . . . . . . . . . . . . 130,000 130,000 Selling and administrative . . . . . . . . . . . . . . 84,000 84,000 Total fixed expenses . . . . . . . . . . . . . . . . . . . . 214,000 214,000 Net operating income . . . . . . . . . . . . . . . . . . . $ 36,000 $ 19,710 Janet Dunn, who has just been appointed general manager of the Westwood Plant, has been given instructions to \"get things under control.\" Upon reviewing the plant's income statement, Ms. Dunn has concluded that the major problem lies in the variable cost of goods sold. She has been provided with the following standard cost per swimming pool: Standard Quantity Standard Standard Price Standard or Hours or Rate Cost Direct materials . . . . . . . . . . . . . . . . . 3.0 pounds $2.00 per pound $ 6.00 Direct labor . . . . . . . . . . . . . . . . . . . . 0.8 hours $6.00 per hour 4.80 Variable manufacturing overhead . . . 0.4 hours* $ 3.00 per hour 1.20 Total standard cost . . . . . . . . . . . . . . $12.00 *Based on machine-hours. During June the plant produced 15,000 pools and incurred the following costs: a. Purchased 60,000 pounds of materials at a cost of $1.95 per pound. b. Used 49,200 pounds of materials in production. (Finished goods and work in process inventories are insignificant and can be ignored.) c. Worked 11,800 direct labor-hours at a cost of $7.00 per hour. d. Incurred variable manufacturing overhead cost totaling $18,290 for the month. A total of 5,900 machine-hours were recorded. It is the company's policy to close all variances to cost of goods sold on a monthly basis. Required: 1. Compute the following variances for June: a. Direct materials price and quantity variances. b. Direct labor rate and efficiency variances. c. Variable overhead rate and efficiency variances. 2. Summarize the variances that you computed in (1) above by showing the net overall favorable or unfavorable variance for the month. What impact did this figure have on the company's income statement? Show computations. 3. Pick out the two most significant variances that you computed in (1) above. Explain to Ms. Dunn possible causes of these variances. This assignment has 2 parts to it. Solution please check word document