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...
-
Penn Corporation purchased 80 percent ownership of ENC Company on January 1, 20X2, at underlying book value. At that date, the fair value of the noncontrolling interest was equal to 20 percent of the...
-
Obtain Microsofts June 30, 2009, 10-K through the Investor Relations portion of their website (do a search for Microsoft investor relations) or go to www.sec.gov and click Search for Company Filings...
-
Use the abbreviated comparative financial statements for Pacific Digital Corporation in the Working Papers. The comparative balance sheet for Pacific Digital Corporation lists an intangible asset,...
-
Baker, Inc., supplies wheels for a large bicycle manufacturing company. The bicycle company has recently requested that Baker decrease its delivery time. Baker made a commitment to reduce the lead...
-
X Unit 1 Lab Assignment - AC1 x wNWP Assessment Builder UI X w Question 9 of 10- ssment-player/index.html?launchld=52da9f77-b354-4506-b456-9659835b850e#/question/8 Question 9 of 10 View Policies Show...
-
Use Solver to create Answer and Sensitivity Reports for question 15 at the end of Chapter 2 and answer the following questions: a. How much excess wiring and testing capacity exists in the optimal...
-
Hunter's, Inc. reported a balance of $1,410 in its cash account at the end of the month There were $1,240 of deposits in transit and $1,170 of checks outstanding. The bank statement showed a balance...
-
Describe a few differences between children's temperaments in different cultures and why those temperaments might benefit them in their environments. What factors influence?
-
Assume when completing step 10 you entered -1000 because the bank account is being reduced by a payment. Note the error message at the bottom of the screen after selecting enter. What kind of...
-
You operate a financial planning business out of your primary dwelling. You frequently conduct business out from your "home" office based in your primary dwelling and invite clients to meet there...
-
The interest rate is 10% but the government offers you a subsidized perpetual loan for $1M at 5%. In other words, you get the $1M today and, in return, you pay the government $50,000 a year forever...
-
How your MUTED GROUP THEORY is demonstrated by the movie Legally Blonde . Make a thesis statement based on that premise.
-
Please answer the following questions after reading the below case study: 1) What Solution-Focused strategies would you use with Mr. Alvarez? 2) What might be some possible exceptions to Mr. Alvarez...
-
Beginning with a country that has a trade deficit, demonstrate graphically what will happen to a countrys potential output with globalization if that countrys costs of production fall. Explain your...
-
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...
-
From the following data, determine the total actual costs incurred for direct material, direct labor, and variable overhead. Direct material Price variance.. Quantity variance Direct labor.... Rate...
-
Marshfield Tax Company considers 8,000 direct labor hours or 400 tax returns its normal monthly capacity. Its standard variable overhead rate is \($4\) per direct labor hour. During the current...
-
Harrison Company manufactures product Q in its factory. Production of find Q requires 3 pounds of material T, costing \($7\) per pound and 2 hours of direct labor, costing \($10\) per hour. The...
Study smarter with the SolutionInn App