Hello,

I need help on my accounting homework regarding variance cost (attached). Please provide answer in solution tab of the provided excel sheet with step by step calculation showing in excel sheet. Thank you.

CASE 9-27 Critiquing a Report; Preparing Spending Variances (Course Objective F) Boyne University offers an extensive continuing education program in many cities throughout the state. For the convenience of its faculty and administrative staff and to save costs, the university operates a motor pool. The motor pool's monthly planning budget is based on operating 20 vehicles; however, for the month of March the university purchased one additional vehicle. The motor pool furnishes gasoline, oil, and other supplies for its automobiles. A mechanic does routine maintenance and minor repairs. Major repairs are performed at a nearby commercial garage. The following cost control report shows actual operating costs for March of the current year compared to the planning budget for March. The planning budget was based on the following assumptions: a. $0.15 per mile for gasoline. b. $0.04 per mile for oil, minor repairs, and parts. c. $75 per automobile per month for outside repairs. d. $100 per automobile per month for insurance. e. $7,540 per month for salaries and benefits. f. $250 per automobile per month for depreciation. The supervisor of the motor pool is unhappy with the report, claiming it paints an unfair picture of the motor pool's performance. Required: 1 Prepare a new performance report for March based on a flexible budget that shows spending variances. 2 What are the deficiencies in the original cost control report? How does the report that you prepared in part (1) above overcome these deficiencies? Planning Budget Assumptions Miles Autos Gasoline Oil, minor repairs, parts Outside repairs Insurance Salaries and benefits Vehicle depreciation Total $ 0.15 per mile $ 0.04 per mile $ 75.00 per auto $ 100.00 per auto $ 7,540.00 $ 250.00 per auto Actual Results $ $ $ $ 63000 21 9,350.00 2,360.00 1,420.00 2,120.00 Flexible Budget Spending Favorable / Variance Unfavorable 63000 21 $ 5,250.00 $ 20,500.00 Required: 1 Prepare a new performance report for March based on a flexible budget that shows spending variances. 2 What are the deficiencies in the original cost control report? How does the report that you prepared in part (1) above overcome these deficiencies? get that shows spending es the report that you