East Coast Airlines operates a hub at the Halifax International Airport. During the summer, the airline schedules
Question:
The flight crews live in Halifax or Toronto, and each day a new crew must fly one flight from Halifax to Toronto and one flight from Toronto to Halifax. A crew must return to its home city at the end of each day. For example, if a crew originates in Toronto and flies a flight to Halifax, it must then be scheduled for a return flight from Halifax back to Toronto. A crew must have at least one hour between flights at the city where it arrives. Some scheduling combinations are not possible; for example, a crew on flight 1 from Halifax cannot return on flights A, B, or C from Toronto. It is also possible for a flight to ferry one additional crew to a city in order to fly a return flight, if there are not enough crews in that city.
The airline wants to schedule its crews to minimize the total amount of crew ground time (i.e., the time the crew is on the ground between flights). Excessive ground time for a crew lengthens its work day, is bad for crew morale, and is expensive for the airline. Formulate a linear programming model to determine a flight schedule for the airline and solve using Excel. How many crews need to be based in each city? How much ground time will each crew experience?
Step by Step Answer:
Operations Management Creating Value Along the Supply Chain
ISBN: 978-1118301173
1st Canadian Edition
Authors: Roberta S. Russell, Bernard W. Taylor, Ignacio Castillo, Navneet Vidyarthi