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