Problem 17-48 Flexible Budget (LO 17-5)

Oak Hill Township operates a motor pool with 20 vehicles. Themotor pool furnishes gasoline, oil, and other supplies for the carsand hires one mechanic who does routine maintenance and minorrepairs. Major repairs are done at a nearby commercial garage. Asupervisor manages the operations.

Each year, the supervisor prepares a master budget for the motorpool. Depreciation on the automobiles is recorded in the budget todetermine the costs per mile.

The following schedule presents the master budget for the yearand for the month of July.

OAK HILL TOWNSHIP
Motor Pool
Budget Report for July
	Annual Master				One-Month										Over- or
	Budget				Master Budget						July Actual				(Under-) Budget
Gasoline	$	81,000				$	6,750				$	8,515				$	1,765
Oil, minor repairs, parts, andsupplies		7,200					600					761					161
Outside repairs		5,400					450					90					(360	)
Insurance		12,000					1,000					1,050					50
Salaries and benefits		63,600					5,300					5,300					0
Depreciation		52,800					4,400					4,620					220
Total cost	$	222,000				$	18,500				$	20,336				$	1,836
Total miles		900,000					75,000					94,500
Cost per mile	$	0.2467				$	0.2467				$	0.2152
Number of automobiles		20					20					21

The annual budget was based on the following assumptions:

Automobiles in the pool: 20.

Miles per year per automobile: 45,000.

Miles per gallon per automobile: 20.

Gas per gallon: $1.80.

Oil, minor repairs, parts, and supplies per mile: $0.008.

Outside repairs per automobile per year: $270.

  

The supervisor is unhappy with the monthly report, claiming thatit unfairly presents his performance for July. His previousemployer used flexible budgeting to compare actual costs tobudgeted amounts.

Required:

a. What is the gasoline monthly flexible budgetand the resulting amount over- or underbudget? (Use miles as theactivity base.) (Do not round intermediate calculations. Ifthe amounts are equal to budget, select "No change".)

	Flexiblebudget

b. What is the monthly flexible budget for theoil, minor repairs, parts, and supplies and the amount over- orunderbudget? (Use miles as the activity base.) (Do notround intermediate calculations. If the amounts are equal tobudget, select "No change".)

	Flexiblebudget

c. What is the monthly flexible budget forsalaries and benefits and the resulting amount over- orunderbudget? (Do not round intermediate calculations. Ifthe amounts are equal to budget, select "No change".)

	Flexiblebudget