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

Do not find an initial solution. Instead, program this into Solver and use Solver to find a solution. Make sure to choose the Simplex LP Method.

Locate Problem C.1 on p. 745 of the 13th edition of Heizer, Render, and Munson. (Note it's not Solved Problem C.1 on p. 744, but instead a regular problem on p. 745. The problem text reads, "Find an initial solution to the following transportation problem.") Do not find an initial solution. Instead, program this into Solver and use Solver to find a solution. Make sure to choose the Simplex LP Method. At optimality, how many units are shipped from Ottawa to Panama? C.1 Find an initial solution to the following transporta- tion problem. TO LOS ANGELES PANAMA CITY FROM CALGARY SUPPLY $ 8 100 Mexico City Detroit $ 6 $17 $20 $18. $13 $10 60 $19 $24 40 Ottawa Demand 50 80 70 a) Use the northwest-corner method. What is its total cost? b) Use the intuitive lowest-cost approach. What is its total cost? c) Using the stepping-stone method, find the optimal solution. Compute the total cost. PX