Problem 17-48 Flexible Budget (LO 17-5) Oak Hill Township operates a motor pool with 20 vehicles. The motor pool furnishes gasoline, oil, and other supplies for the cars and hires one mechanic who does routine maintenance and minor repairs. Major repairs are done at a nearby commercial garage. A supervisor manages the operations. Each year, the supervisor prepares a master budget for the motor pool. Depreciation on the automobiles is recorded in the budget to determine the costs per mile The following schedule presents the master budget for the year and for the month of July OAK HILL TOWNSHIP Motor Pool Budget Report for July Annual Master One-Month Master Budget Over- or (Under-) Budget Budget $ 81,000 7,200 5.400 13,200 60,000 55,200 $222,000 900,000 $0.2467 20 July Actual S 8,468 758 90 1.155 5,000 4.830 $20,301 94,000 S0.2160 21 Gasoline Oil, minor repairs, parts, and supplies Outside repairs S1,718 158 S 6,750 600 450 1,100 5,000 4,600 $18,500 75,000 $0.2467 20 (360) Salaries and benefits 230 S1,801 Total cost Total miles Cost per mile Number of automobiles The annual budget was based on the following assumptions: 1. Automobiles in the pool: 20 2. Miles per year per automobile: 45,000. 3. Miles per gallon per automobile: 20. 4. Gas per gallon: $1.80 5. Oil, minor repairs, parts, and supplies per mile: $0.008. 6. Outside repairs per automobile per year: $270. The supervisor is unhappy with the monthly report, claiming that it unfairly presents his performance for July. His previous employer used flexible budgeting to compare actual costs to budgeted amounts Required a. What is the gasoline monthly flexible budget and the resulting amount over- or underbudget? (Use miles as the activity base.) (Do not