Just problem 2 please

Problem 1. (14 points) 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. Due to an anticipated increase in demand, Martin-Beck plans to increase capacity by constructing one or more new plants in the following cities: Detroit, Toledo, Denver, or Kansas City. The estimated annual fixed cost and annual capacity for the four potential plants are as follows: Potential Plant Detroit Toledo Denver Kansas city Annual fixed costs $175,000 $300,000 $375,000 $400,000 Annual capacity 10,000 20,000 30,000 30,000 The company's long-term planning group developed the following forecasts of the anticipated annual demand at the distribution centers as follows: Distribution center Boston Atlanta Houston Annual demand 30,000 10,000 25,000 The shipping cost per unit from each plant to each distribution center is shown in the table below. Management at the company requires all demands be met. Boston Atlanta Houston Detroit $5 $2 $3 Toledo $4 $3 $4 Denver $9 $7 $5 Kansas city $10 $4 $2 St. Louis $8 $4 $3 Use Location Data.xlsx to build your Excel model. Formulate and solve a model to determine the optimal plan that minimizes the total annual cost (fixed and distribution). Submit your Excel file. Clearly specify decision variables, objective function, and constraints. Problem 2. (6 points) In Problem 1, label the plant in Detroit, Toledo, Denver, and Kansas city as Plant 1, 2, 3, and 4, respectively. Define Pi (i = 1,2,3,4) as follows: P, = {2 (1 if plant i opens 10 if plant i does not open Write a linear constraint that reflects each of the following requirements. 1. (2 points) Due to their proximity, at most one plant can be open between Detroit and Toledo. 2. (2 points) The company must open at least two plants. 3. (2 points) The company must open a plant either in Denver or in Detroit but not both