Omega Airlines has several nonstop flights between Atlanta and Los Angeles every day. The schedules of these
Question:
Omega Airlines has several nonstop flights between Atlanta and Los Angeles every day. The schedules of these flights are shown in the following table.
Omega wants to determine the optimal way of assigning flight crews to these different flights. The company wants to ensure that the crews always return to the city from which they left each day. FAA regulations require at least one hour of rest for flight crews between flights. However, flight crews become irritated if they are forced to wait for extremely long periods of time between flights, so Omega wants to find an assignment of flight schedules that minimizes these waiting periods.
a. Draw a network flow model for this problem.
b. Implement the problem in a spreadsheet and solve it.
c. What is the optimal solution? What is the longest period of time that a flight crew has to wait between flights, according to your solution?
d. Are there alternate optimal solutions to this problem? If so, do any alternate optimal solutions result in a smaller maximum waiting period betweenflights?
Step by Step Answer:
Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science
ISBN: 978-0324656633
5th edition
Authors: Cliff T. Ragsdale