I would love some help with how to Complete the following problem and the steps to be taken, thanks. Looking for help within the hour

Edit View History Bookmarks People Tab Window Help a exam.fb.athabas Testing Session | Proctor 07 5 Mon 9:31 AM ' Athabasca t Analysis, ACCT 355 Instructions Question 17 (15 marks) Mark to review this question at the and of the exam Next TION 2 Candle Light Bus Lines Lid. 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 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.006. Question 16 of the company provides you with the following information: QuestionMy Costs per passenger per trip: Questic Driver Selling $4 $2 Ques Ques n addition, she informs you that Facility Overhead will be $100,000 and Selling and Admin Overhead will be $50,090, regardless of the nu per of trips made in the year. 2 of 2 Required: 9:31 AM a. Prepare a flexible budget for the company based on the above information for 20,000, 30,000, and 40,000 passengers. (6 marks) us this year and sales totalled $538,800. Fuel costs were $123,475, driver costs were $95,415 and selling and admin Hand In Exam variable costs were $41,500 and $17,250 respectiv marks) gers who used the busor $125,000 and Selling and Admin Overhead was $78,000. Prepare a fle b. Assume that there were actually 23430 respectively. Facility Costs were $12 flexible budget report for the ye c. Discuss the results of the year on should be taken in the future as a result. (3 marks) Consider creating a table to help organize and present your work. Font -Size 5 4 XX3FE A9 02 ns.nsf/studentExam.xsp# JUL DO 13 option