The distribution system for DeWayne Company consists of three plants, two warehouses, and one customer. Plant capacities and shipping costs per unit (in $) from each plant to each warehouse are shown below along with customer demand and shipping costs per unit (in $) from each warehouse to the customer.

Formulate the linear programming model to minimize the cost of shipping for this transshipment problem

can you use Solver in Excel to solve the problem and obtain an answer report and a sensitivity report - attach the file when submitting your work

can you type out how much is shipped on each combination and the cost of shipping

and explain what the shadow price on Plant 1 shipments means.

	Warehouse 1	Warehouse 2	Plant Capacity
Plant 1	4	3	60
Plant 2	4	5	30
Plant 3	2	2	20
	Customer
Warehouse 1	6
Warehouse 2	5
Demand	100