Please use excel to solve, thank you!

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: Plant A Warehouse 1 2 3 Capacities (supply). 3.21 1.45 2.13 4,000 3.35 5.43 1.60 6,000 4.25 3.27 3.11 3,000 8,000 2,000 3,000 (demand) Requirement a) What routes get taken and how much gets shipped over each route? b) In a separate tab than part a) (label as 93b), 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? In a separate tab than part a) and 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