ILP_Excel_2 - Western Airlines hub locaTon model Input data...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Western Airlines hub location model Input data: which cities are covered by which potential hubs Potential hub City AT BO CH DE HO LA NO NY PI SL SF SE AT 1 0 1 0 1 0 1 1 1 0 0 0 BO 0 1 0 0 0 0 0 1 1 0 0 0 CH 1 0 1 0 0 0 1 1 1 0 0 0 DE 0 0 0 1 0 0 0 0 0 1 0 0 HO 1 0 0 0 1 0 1 0 0 0 0 0 LA 0 0 0 0 0 1 0 0 0 1 1 0 NO 1 0 1 0 1 0 1 0 0 0 0 0 NY 1 1 1 0 0 0 0 1 1 0 0 0 PI 1 1 1 0 0 0 0 1 1 0 0 0 SL 0 0 0 1 0 1 0 0 0 1 1 1 SF 0 0 0 0 0 1 0 0 0 1 1 1 SE 0 0 0 0 0 0 0 0 0 1 1 1 Decisions: which cities to use as hubs AT BO CH DE HO LA NO NY PI SL SF SE Used as hub? Constraints that each city must be covered by at least one hub City Covered by Required AT BO CH DE HO LA NO NY PI SL SF SE Objective to minimize Total hubs A B C D E F G H I J K L M 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Western Airlines hub location model with distances Input data Mile limit 1000 Distance from each city to each other city AT BO CH DE HO LA NO NY PI SL SF SE AT 0 1037 674 1398 789 2182 479 841 687 1878 2496 2618 BO 1037 0 1005 1949 1804 2979 1507 222 574 2343 3095 2976 CH 674 1005 0 1008 1067 2054 912 802 452 1390 2142 2013 DE 1398 1949 1008 0 1019 1059 1273 1771 1411 504 1235 1307 HO 789 1804 1067 1019 0 1538 356 1608 1313 1438 1912 2274 LA 2182 2979 2054 1059 1538 0 1883 2786 2426 715 379 1131 NO 479 1507 912 1273 356 1883 0 1311 1070 1738 2249 2574 NY 841 222 802 1771 1608 2786 1311 0 368 2182 2934 2815 PI 687 574 452 1411 1313 2426 1070 368 0 1826 2578 2465 SL 1878 2343 1390 504 1438 715 1738 2182 1826 0 752 836 SF 2496 3095 2142 1235 1912 379 2249 2934 2578 752 0 808 SE 2618 2976 2013 1307 2274 1131 2574 2815 2465 836 808 0 Which cities are covered by which potential hubs with this mile limit Potential hub City AT BO CH DE HO LA NO NY PI SL SF SE AT BO CH DE HO LA NO NY PI SL SF SE
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern