SHOW ME EXCEL STEPS BY STEPS PLEASE

3. Devos Inc. wants to figure out the most cost efficient shipping routes from 3 plants to 3 different warehouses. Transportation costs are as follows:

Warehouse

Plant 1 2 3 Capacities (supply)

A 3.21 1.45 2.13 4,000

B 3.35 5.43 1.60 6,000

C 4.25 3.27 3.11 3,000

Requirement 8,000 2,000 3,000 (demand)

1. What routes get taken and how much gets shipped over each route?
2. In a separate tab than part a) (label as Q3b), Use the same information in part A, except that plant B now can supply only 5,000 units. Re-solve. Which warehouse (or warehouses) will not have their demand met, and how many units will they be short?
3. In a separate tab than part a) an d b) (label as Q3c), use the same information in part A (note, not part b use original data in part a), except that now warehouse 2 can ship to warehouse 1 for $0.34. What routes are taken and how much gets shipped over each route?