I only need an answer to question number 26.

The annual demand for products from customers X,Y, and Z is expected to be 40,000 , 25,000 , and 35,000 units, respectively. The annual production capacity and construction costs for each plant are: The company wants to determine which plants to build in order to satisfy customer demand at a minimum total cost. a. Formulate an ILP model for this problem. b. Create a spreadsheet model for this problem and solve it. 25. A manufacturer is considering alternatives for building new plants in order to be located closer to three of its primary customers with whom it intends to develop long-term relationships. The net cost of manufacturing and transporting each unit of the product to its customers will vary depending on where the plant is built and the production capacity of the plant. These costs are summarized in the following table: 26. Refer to the previous question. Suppose plants 1 and 2 represent different building alternatives for the same site (i.e., only one of these plants can be built). Similarly, suppose plants 4 and 5 represent different building alternatives for another site. a. What additional constraints are required to model these new conditions? b. Revise the spreadsheet to reflect these additional constraints and solve the resulting problem. c. What is the optimal solution