Candle Light Bus Lines Ltd. runs a series of bus routes between cities across Canada. A new route, between Kenora and Thunder Bay, has been planned for next year. The sales manager has come up with a series of possible passengers that would use the route in the upcoming year. She tells you that passengers could range between 20,000 and 40,000 per year and that each ticket would be S$25 per trip. Because of the availability of buses to service the route, the estimated passengers would be in increments of 10,000. The controller of the company provides you with the following information: Costs per passenger per trip: Fuel $5 Driver $4 Selling $2 Admin $1 In addition, she informs you that Facility Overhead will be $100,000 and Selling and Admin Overhead will be $50,000, regardless of the number of trips made in the year. Instructions a) Prepare a flexible budget for the company based on the above information for 20,000, 30,000, and 40,000 passengers. b) Assume that there were actually 22.450 passengers who used the bus this year and sales totalled $538,800. Fuel costs were $123,475, driver costs were $95,415 and selling and admin variable costs were $41,500 and $17,250 respectively. Facility Costs were $125,000 and Selling and Admin Overhead was $78,000. Prepare a flexible budget report for the c) Discuss the results of the year and what action should be taken in the future as a result. year.
Candle Light Bus Lines Ltd. runs a series of bus routes between cities across Canada. A new route, between Kenora and Thunder Bay, has been planned for next year. The sales manager has come up with a series of possible passengers that would use the route in the upcoming year. She tells you that passengers could range between 20,000 and 40,000 per year and that each ticket would be S$25 per trip. Because of the availability of buses to service the route, the estimated passengers would be in increments of 10,000. The controller of the company provides you with the following information: Costs per passenger per trip: Fuel $5 Driver $4 Selling $2 Admin $1 In addition, she informs you that Facility Overhead will be $100,000 and Selling and Admin Overhead will be $50,000, regardless of the number of trips made in the year. Instructions a) Prepare a flexible budget for the company based on the above information for 20,000, 30,000, and 40,000 passengers. b) Assume that there were actually 22.450 passengers who used the bus this year and sales totalled $538,800. Fuel costs were $123,475, driver costs were $95,415 and selling and admin variable costs were $41,500 and $17,250 respectively. Facility Costs were $125,000 and Selling and Admin Overhead was $78,000. Prepare a flexible budget report for the c) Discuss the results of the year and what action should be taken in the future as a result. year.
Chapter11: Cash Flow Estimation And Risk Analysis
Section: Chapter Questions
Problem 1bM
Related questions
Question
Transcribed Image Text:Candle Light Bus Lines Ltd. runs a series of bus routes between cities across Canada. A new
route, between Kenora and Thunder Bay, has been planned for next year. The sales manager has
come up with a series of possible passengers that would use the route in the upcoming year.
She tells you that passengers could range between 20,000 and 40,000 per year and that each
ticket would be $25 per trip. Because of the availability of buses to service the route, the
estimated passengers would be in increments of 10,000.
The controller of the company provides you with the following information:
Costs per passenger per trip:
Fuel
$5
Driver
$4
Selling
$2
Admin
$1
In addition, she informs you that Facility Overhead will be $100,000 and Selling and Admin
Overhead will be $50,000, regardless of the number of trips made in the year.
Instructions
a) Prepare a flexible budget for the company based on the above information for 20,000,
30,000, and 40,000 passengers.
b) Assume that there were actually 22,450 passengers who used the bus this year and sales
totalled $538,800. Fuel costs were $123,475, driver costs were $95,415 and selling and
admin variable costs were $41,500 and $17,250 respectively. Facility Costs were $125,000
and Selling and Admin Overhead was $78,000. Prepare a flexible budget report for the year.
c) Discuss the results of the year and what action should be taken in the future as a result.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 4 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning