SOLVE PROBLEM $18$ USING LINEAR PROGRAMMING IN EXCEL, PLEASE SHOW STEPS thank you.A company supplies goods to three customers, each of whom requires $30$ units. The company has two warehouses. Warehouse $1$ has $40$ units available and warehouse $2$ has $30$ units available. The costs of shipping $1$ unit from the warehouse to a customer are shown in worksheet $8\mathrm{.}17.$ There is a penalty for each unmet customer unit of demand. With customer $1,$ a penalty cost of $$90$ is incurred, with customer $2,$$$80,$ and with customer $3,$$$110.$ Formulate and solve a transportation problem to minimize the sum of shortage and shipping costs. $($Refer to worksheet $8\mathrm{.}17.)$

Referring to the above problem, suppose that extra units could be purchased and shipped to either warehouse for a total cost of $$100$ per unit and that all customer demand must be met. Formulate and solve this transportation problem to minimize the sum of purchasing and shipping costs.

$\backslash$table$[[$From$,$To Customer $1,$To Customer $2,$To Customer $3],[$Warehouse $1,$$$15,$$$35,$$$25$