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?