ABC Bus Lines runs a series of bus routes. A new route is being planned for next year. The Sales Manager says the range of passengers would be: 20,000 (Conservative Estimate) and 40,000 (Optimistic Estimate). The ticket price is $26.00. The controller provides the following information: $6.00 for fuel, $56.00 for the driver, $2.00 for selling, $1.00 for admin, $15.00 for facility overhead (regardless of number of trips), and $50,000 for selling & administration (regardless of number of trips).
Instructions:
Assume the first-year results were: 22,450 passengers, $538,800 in revenue, $95,415 for the driver, $41,500 for selling variable, $123,475 for fuel, $17,250 for administration variable, $125,000 for facility costs, and $80,000 for overhead.
A. Prepare flexible budgets based on 20,000, 30,000, and 40,000 passengers.
B. Determine the break-even point for each budget.
C. Prepare a flexible budget report including variances based on the actual results of 22,450 passengers.
D. Discuss the results of the year and decide what action should be taken in the future as a result.