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

40,000

Optimistic Estimate

$26.00

Ticket Price

The controller provides the following information:

$6.00

Fuel

$6.00

Driver

$2.00

Selling

$1.00

Admin

$15.00

$100,000

Facility Overhead (Regardless of Number of Trips)

$50,000

Selling & Administration (Regardless of Number of Trips)

Instructions Assume the first-year results were:

22,450Passengers

$538,800Revenue

$123,475Fuel

$95,415Driver

$41,500Selling Variable

$17,250Administration Variable

$125,000Facility Costs

$80,000Overhead

Prepare flexible budgets based on 20,000, 30,000, and 40,000 passengers.

Determine the break-even point for each budget.

Prepare a flexible budget report including variances based on the actual results of 22,450 passengers.

Discuss the results of the year and decide what action should be taken in the future as a result. PS pls I need all the correct answer in a table format