Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

For most airlines, labor costs are their second largest operating expense - righ

ID: 454147 • Letter: F

Question

For most airlines, labor costs are their second largest operating expense - right below fuel costs. Labor costs are influenced by crew-pairing decisions, and better pairing decisions can provide substantial savings. A crew-pairing is an itinerary for a flight crew, consisting of a sequence of connectable flight legs, within the same fleet, that starts from and ends at the crew's home base. Typically, the pairing spans a single day, although in some cases may span as much as five days. Omega Airlines operates several flights per day between Atlanta and Los Angeles (see flight schedule below: Flight LI departs (LID) from Los Angeles at 05:00 AM and arrives (L1A) in Atlanta at 09:00)). Flight crews are based in each city, and each crew must return to their home base each evening (i.e., no RONs). Flight crews also require a minimum of one hour rest between flights. What is the minimum number of crews needed to operate these flights, and where should they be based? Please write out a mathematical model that solves this problem, then implement it in a spreadsheet, solve it, and summarize your findings in a brief report.

Explanation / Answer

1) 4 minimum number of crews for los angels and 4 minimum number of Atlanta.

Calculation for 7 crews

7 flights operating from los angels and 7 flights operating from Atlanta. and 7 times flights get departure and arrived in both places.

a crew from los angels to Atlanta = 4 hours + 1 hours rest

Atlanta to los angels=2 hours

Totally 4 +1+2 =7 hours per crew.

4+4=8 crews needed .

__________________________________________________________________________________

LID crew 1 to Atlanta and return by A3A

L2d crew 2 to Atlanta and return by A4A

L5D crew 5 to Atlanta and return by A6A

extra 1 crew is needed

A1D crew 1 to los angels and return by L3A

A2D crew 2 to los angels and return by L4A

A5D Crew 1 to low angels and return by 47A

extra 1 crew is needed

4 from los angels and 4 from Atlanta.

___________________________________________________________________________________

Min=crew members

5x1+6x2+9x3+12x4+2x5+5x6+7x7<7 (los angels departure time)

6x1+8x2+10x3+12x4+4x5+6x6+7x7<7(Atlanta departure time)

x1+x2x3+x4+x5+x6+x7<0