$13$:$09$

LTE

$,$

$3.$S$4.$ Producing and Distributing AEDs at Heart Start Heart Start produces automated external defibrillators in each of two different plants $($A and B$).$ The unit production costs and monthly production capacity of the two plants are indicated in the table below. The automated external defibrillators are sold through three wholesalers. 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. The management of Heart Start now has asked their top management scientist $($you$)$ to address the following two questions. How many automated external defibrillators 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.

$\backslash$table$[[,$Unit Shipping Cost,$\backslash$table$[[$Unit$],[$Produc$-],[$tion$],[$Cost$]],\backslash$table$[[$Monthly$],[$Produc$-],[$tion$],[$Capacity$]]],[,\backslash$table$[[$Ware$-],[$house$],[1]],\backslash$table$[[$Ware$-],[$house$],[2]],\backslash$table$[[$Ware$-],[$house$],[3]]],[$Plant A$,$$$22,$$$14,$$$30,$$$600,100],[$Plant B$,$$$16,$$$20,$$$24,$$$625,120],[\backslash$table$[[$M onthly$],[$Demand$]],80,60,70,,]]$

Please show step by step in excel