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.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education