Essentials of Business Analytics 1st Edition by Jeffrey Camm,James Cochran,Michael Fry,Jeffrey Ohlmann ,David Anderson

Exercise 2

The Martin-Beck Company operates a plant in St. Louis with an annual capacity of 30,000 units. Product is shipped to regional distribution centers located in Boston, Atlanta, and Houston. Because of an anticipated increase in demand, Martin-Beck plans to increase capacity
by constructing a new plant in one or more of the following cities:
Detroit, Toledo, Denver, or Kansas City. The estimated annual fixed cost and the annual capacity for the four proposed plants are as follows:

The company's long-range planning group developed forecasts of the anticipated annual demand at the distribution centers as follows:

The shipping cost per unit from each plant to each distribution center is as follows:

a. Formulate a mixed-integer programming model that could be used to help Martin-Beck determine which new plant or plants to open in order to satisfy anticipated demand.
b. Solve the model you formulated in part a. What is the optimal cost What is the optimal set of plants to open
c. Using equation (9.1), find a second-best solution. What is the increase in cost versus the best solution from part b