Question: Set-covering models such as the original Western Airlines model in Figure 14.52 often have multiple optimal solutions. See how many alternative optimal solutions you can

Set-covering models such as the original Western Airlines model in Figure 14.52 often have multiple optimal solutions. See how many alternative optimal solutions you can find. Of course, each must use three hubs because we know this is optimal.
Figure 14.52 Set-Covering Model D E F G H K M 1

Figure 14.52 Set-Covering Model D E F G H K M 1 Western Airlines hub location model 2 3 Input data: which cities are covered by which potential hubs Range names used: Hubs covered by Total hubs Used as hub? Potential hub -ModelSB$25:5B$36 Model SB$39 =Model ISBS21:SMS21 4 5 City AT BO CH DE HO LA NO NY PI SL SF SE 6 JAT 7 IBO 1 1 1 1 1 1 8 CH 1 1 1 9 IDE 1 10 IHO 1 1 1 11 LA 1 1 12 NO 13 NY 14 PI 1. 1 1 1 1 15 SL 16 SF 1 1 1 17 SE 1 18 19 Decisions: which cities to use as hubs 20 AT BO CH DE LA NO NY PI SF SE 21 Used as hub? 22 23 Constraints that each city must be covered by at least one hub 24 City 25 AT 26 BO 27 CH 28 DE Hubs covered by Required 2 1 Note that there are multiple optimal solutions to this model, all of which require a total of 3 hubs. You might get a different solution from the one shown here. 1 1 1 1 29 HO 1 30 LA 31 NO 32 NY 33 PI 34 SL 35 SF 36 ISE 1 1 1 1 1 1 1 1 1 37 38 Objective to minimize 39 Total hubs

Step by Step Solution

3.39 Rating (177 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGeneral textaligngeneral verticalalignbottom whitespacenowrap msorotate0 msobackgroundsourceauto msopatt... View full answer

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

Document Format (1 attachment)

Excel file Icon

415-M-S-S-M (139).xlsx

300 KBs Excel File

Students Have Also Explored These Related Statistics Questions!