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. ---

1) Look at problem C.5 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 were shipped from C to 2? 2) Look at problem C.5 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. What is the total cost at optimality?

QUESTION 7 Look at problem C.5 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 were shipped from C to 2? QUESTION 8 Look at problem C.5 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. What is the total cost at optimality? Enter your answer without any currency signs. For example, if you want to enter $123.45 as your answer, just type in 123.45. The following table is the result of one or more C.5 iterations. To From 1 2 3 Capacity 30 30 5 A 40 10 50 10 10 10 B 30 30 20 10 25 30 45 75 Demand 40 60 55 155 a) Complete the next iteration using the stepping-stone method. b) Calculate the total cost incurred if your results were to be accepted as the final solution. Px