Question: Problem 2 A bus company would like to determine the optimal frequencies 1 of two bus routes for maximizing its profit. The cost on each

Problem 2 A bus company would like to determine
Problem 2 A bus company would like to determine the optimal frequencies 1 of two bus routes for maximizing its profit. The cost on each route is $120 per bus-hour, and the revenue received per bus on each route is given in the following table. The round-trip times (including all layovers) on each route are also given in the following table: The maximum total fleet size available among these two routes is 15 buses. Also, as a policy, each route must operate at least 2 buses per hour and at most 8 buses per hour. 'Frequency: Number of buses per hour a. Set up the Mathematical Model for this problem. b. Find the solution by graphical method. What is the optimal profit of the bus company? c. Solve the problem using the Excel Solver. (Provide screenshot for main steps and answers) d. Use the Sensitivity Report to answer the following questions. If the answer cannot be calculated simply from the Sensitivity Report, please explain why. 1 d.1.) If the Revenue per Bus for Route 1 is increased from $180 to $210, what are the optimal frequencies of the two bus routes? And what is the optimal profit? d.2.) If the Round Trip Time of Route 2 is decreased from 75 to 60 minutes, what are the optimal frequencies of the two bus routes? And what is the optimal profit? d.3.) If Route 2 can operate at most 9 buses per hour now, what are the optimal frequencies of the two bus routes? And what is the optimal profit

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!