Question: How hard is it to expand a set-covering model to accommodate new cities? Answer this by modifying the model in Figure 6.25. (See the file

How hard is it to expand a set-covering model to accommodate new cities? Answer this by modifying the model in Figure 6.25. (See the file Locating Hubs with Distances.xlsx.) Add several cities that must be served: Memphis, Dallas, Tucson, Philadelphia, Cleveland, and Buffalo. You can look up the distances from these cities to each other and to the other cities in a reference book (or on the Web), or you can make up approximate distances.

a. Modify the model appropriately, assuming that these new cities must be covered and are candidates for hub locations.

b. Modify the model appropriately, assuming that these new cities must be covered but are not candidates
for hub locations.


Figure 6.25

G H K M N 3 Mile limit (cell $B$4) values along side, output cell(s) along top 5. 800 1 900 7 1000 1 1100 1 1200 1 ol 1 OTTTCsed_as_hub_1 Used_as_hub_2 1. Used_as_hub_3 000oUsed_as_hub_4 Used_as_hub_5 Used_as_hub_6 oUsed_as_hub_7 o Used_as_hub_8 Used as_hub_9 -Used_as_hub_10 Used_as_hub_11 Used_as_hub_12 Total_hubs 3.

G H K M N 3 Mile limit (cell $B$4) values along side, output cell(s) along top 5. 800 1 900 7 1000 1 1100 1 1200 1 ol 1 OTTTCsed_as_hub_1 Used_as_hub_2 1. Used_as_hub_3 000oUsed_as_hub_4 Used_as_hub_5 Used_as_hub_6 oUsed_as_hub_7 o Used_as_hub_8 Used as_hub_9 -Used_as_hub_10 Used_as_hub_11 Used_as_hub_12 Total_hubs 3.

Step by Step Solution

3.25 Rating (169 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a To expand the set cover ing model to accommodate the new cities the decision variables in the mode... 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

1497_6042161eb747e_837414.xlsx

300 KBs Excel File

Students Have Also Explored These Related Practical Management Science Questions!