please answer on excel using simplex LP

3. David 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 3 Capacities (supply) 3.21 1.45 2.13 4,000 5.43 1.60 6,000 4.25 3.27 3.11 3,000 Requirement 8,000 2,000 3,000 (demand) 3.35 a) What routes get taken and how much gets shipped over each route? b) 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? c) 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