Question: here is the excel spreadsheet: 5. If you have a problem with 1,000 customers and want to consider 1,000 poten- tial warehouse locations, how many

here is the excel spreadsheet: 5. If you have a

here is the excel spreadsheet:

here is the excel spreadsheet: 5. If you have a

5. If you have a problem with 1,000 customers and want to consider 1,000 poten- tial warehouse locations, how many different combinations of choices will you have if you want to pick the best 10 warehouse locations, or the best 25 ware- house locations? 6. Complete the following questions using the MIP for 9-City Example.xls spreadsheet found on the book Web site and reviewed previously in this chapter: a. What are the best two locations with the given demand? b. What are the best three locations with the given demand? How much did the average distance decrease? c. What are the best three locations if you consider the demand for each of the cities to equal 100,000? How does this solution compare to part (b)? d. What are the best three locations if the demand for every city is equal to 100,000 except New York and Chicago, which are 200,000 each? C D E F G . J L M. N O Q R S T U B Objective N Wisconsin Vermont Michigan Toronto Milwaukee New Hampre New York Devolt Massachusetts Chiago Cleveland conecticut-Rho

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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

Students Have Also Explored These Related General Management Questions!