Show your work with formulas in Excel Solver. Please do not copy other answers because they are wrong.

Drylce, Inc., is a manufacturer of air conditioners that has seen its demand grow significantly. The data below shows all suppliers, potential plant locations, variable production and transportation costs. Management must come up with a plan to decide which facilities are going to be open and how to manage the whole supply chain. Formulate this problem as a Linear Programming Problem 1. What is the objective function? 2. What are the constraints? 3. Which manufacturing facilities are open? List any unused capacities at the plants. 4. What is the total cost of this supply chain