Candle Light Bus Lines Ltd. runs a series of bus routes between cities across Canada. A...
Fantastic news! We've Found the answer you've been seeking!
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. 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 Answer:
Answer rating: 100% (QA)
a Statement showing a flexible budget for the company for 20000 30000 and 40000 passengers Flexible ... View the full answer
Related Book For
Posted Date:
Students also viewed these general management questions
-
The Ethan Company provides you with the following information on December 31, 2015 as it prepares to close its books for the year Accounts Receivable Balance (before write...
-
An avant-garde clothing manufacturer runs a series of high-profile, risqué ads on a billboard on Highway 101 and regularly collects protest calls from people who are offended by them....
-
Bravo Company provides you with the following information from its accounting records for the most recent year: Direct materials purchased...
-
Assuming @Weather is a valid repeatable annotation that takes a String, with its associated containing type annotation @Forecast, which of the following can be applied to a type declaration? (Choose...
-
AK Radio has hired a consultant to help in the assessment of a project to launch a satellite to deliver a 24/7 infomercial radio station to the world. The satellite costs $500 million and has a CCA...
-
Since Christmas is always on a Thursday, it follows that the day after Christmas is always a Friday. Determine whether the following arguments are inductive or deductive. If an argument is inductive,...
-
Water flows through the curved hose shown in Fig. P4.49 with an increasing speed of \(V=10 t \mathrm{ft} / \mathrm{s}\), where \(t\) is in seconds. For \(t=2 \mathrm{~s}\) determine (a) the component...
-
The Elegant Table sells china, glassware, and other gift items that are subject to an 8 percent sales tax. The shop uses a general journal and a sales journal similar to those illustrated in this...
-
We use demand elasticities to quantify how much quantity demanded for a product would change given changes to the factors that affect demand. Some common demand elasticities are: own-price...
-
To keep track of office furniture, computers, printers, and so on, the FOUNDIT Company uses the table structure shown in Table P6.5. a. Given that information, write the relational schema and draw...
-
Based on a simple random sample of 100 observations from a population, it is found that p = 0.68. Use this sample and answer each of the following questions. (1) Test Ho p = 0.6 against H p > 0.6....
-
Case Fosters Beer is an Australian-style beer brand owned by MillerCoors, a Delaware corporation headquartered in Chicago, Illinois. William and Ralph Foster brewed the first batch of Fosters Beer in...
-
On June 22, 2017, Representative Chris Collins was on the South Lawn of the White House for the Congressional Picnic. He received an email from the head of Innate Immunotherapeutics, an Australian...
-
WinCo is a privately owned regional grocery chain based in Idaho with additional stores in Washington, Nevada, California, and Nevada. In 2008, WinCos Portland Division maintenance manager, John...
-
Chris Mitchell bought an excellent PPO Plan with an A-rated carrier that qualified as an ACA plan from Simple Health. Simple Health told Mitchell that the plan covered doctor visits; diagnostic...
-
Ryan Bagley and William Sargent were long-time friends who served in the military together. Prior to July 2014, they had discussed the possibility of forming a partnership to purchase, rent, and...
-
Develop a process map using the strategic Planning Process as a guideline for Total Quality Management Make sure you include the following: All of the 6 steps of the Strategic Planning Process...
-
Describe a job you have had in the past or a job you are very familiar with. Indicate the negative aspects of the job and how it could be improved with current human resource management techniques.
-
Why do so many foreign companies build facilities in the U.S.?
-
The fixed and variable costs for three potential manufacturing plant sites for a rattan chair weaver are shown: (a) Over what range of production is each location optimal? (b) For a production of 200...
-
Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: (a) Develop a 3-year moving average to forecast registrations from year 4...
-
Modify the DrawStars example so that all the stars have Rotate transition animations that execute indefinitelythat is, set each animations cycle count to Animation.INDEFINITE. DrawStars example //...
-
Use inheritance to create an exception superclass (called ExceptionA) and exception subclasses ExceptionB and ExceptionC, where ExceptionB inherits from ExceptionA and ExceptionC inherits from...
-
Use a HashMap to create a reusable class for choosing one of the 13 predefined colors in class Color. The names of the colors should be used as keys, and the predefined Color objects should be used...
Study smarter with the SolutionInn App