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. --- Say you wanted to ship 9 units from Detroit to Los Angeles, and 7 units from Mexico City to Calgary. What would your total cost be?

Look at problem C.1 on p. 745 of the 13th edition of Heizer, Render, and Munson. (Note this not Solved Problem C.1 on p. 744, but rather regular old Problem C.1 on p. 745.) A screenshot of this problem's implementation in Excel is below. A B D E F 4 5 Data 6 Costs 7 Mexico City 8 Detroit 9 Ottawa 10 Demand 11 Los Angeles Calgary Panama Supply 6 18 8 100 17 13 19 60 20 10 24 40 50 80 70 200 / 200 Say you wanted to ship 9 units from Detroit to Los Angeles, and 7 units from Mexico City to Calgary. What would your total cost be? Do not enter a currency symbol. For example, if you calculate $123.45 as your answer, just type in 123.45. 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