Could you please answer and explain the questions BELOW and please explain in great detail to how you got each answer by explaining it to me step by step, please. Thanks! --- Please use Excel and show the formulas used. ---

Run Solver on this problem and see if you can improve on their solution. At optimality, how many units are shipped from Houston to Denver?

QUESTION 6 Look at problem C.4 on p. 746 of the 13th edition of Heizer, Render, and Munson. Run Solver on this problem and see if you can improve on their solution. At optimality, how many units are shipped from Houston to Denver? C.4 Consider the transportation table below. The solu- tion displayed was obtained by performing some iterations of the transportation method on this problem. What is the total cost of the shipping plan that would be obtained by performing one more iteration of the stepping-stone method on this problem? Destination Source Denver Yuma Miami Supply $2 $8 $1 Houston 10 10 $4 $5 $6 St. Louis 10 10. 20 $6 $3 $2 Chicago 10 20 30 Demand 20 20 20