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:

Ensure that Solver has been enabled on your PC. This may require you to turn Solver on in the "Add-Ins" area of Excel. For instructions on how to do this, you can go to the Office Support page and do a search for "Excel Solver Add-in."

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?

https://courserooma.capella.edu/bbcswebdav/institution/DB/DB8327/180700/Course_Files/cf_mip_9_city_example.xlsx