use solver

Appendix B. Model B: Production-Distribution Optimization (PDO) Heart Start produces automated external defibrillators (AEDs) in each of three different plants (Plant A, Plant B, and Plant C). The unit production costs and monthly production capacity of the two plants are indicated in the table below. The AEDs are sold through four wholesalers (warehouses). The shipping cost from each plant to the warehouse of each wholesaler along with the monthly demand from each wholesaler are also indicated in the table. How many AEDs should be produced in each plant, and how should they be distributed to each of the three wholesaler warehouses so as to minimize the combined cost of production and shipping? Formulate and solve a linear programming model in a spreadsheet. Hints: This is a transportation problem as described in Section 3.5 of the textbook (provided in the file "Textbook Chapter 3 Pages for the Project.pdf"). The data for this problem are the unit shipping cost, the unit production cost and monthly production capacity at each plant, and the monthly demand at each warehouse. The decisions to be made in this problem are how many units to ship from each plant to each warehouse. The goal is to minimize the total cost, including production costs and shipping costs. The functional constraints in this problem are that each plant can't ship out more than its monthly capacity, and each warehouse needs to receive its monthly demand. The units shipped out of each plant are calculated by summing each row of changing cells, while the units shipped to each warehouse are calculated by summing each column of changing cells. Please consider using the template given below as a starting point (you will need to modify it)