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 123 units from Source 1 to C, and 30 units from Source 2 to A. What would your total cost be?

Look at problem C.2 on the bottom of p. 745 of the 13th edition of Heizer, Render, and Munson. (Note this not Solved Problem C.2 on the top of p. 745, but rather regular old Problem C.2 on the bottom of p. 745.) A screenshot of this problem's implementation in Excel is below. G H B. D E F 1 Problem C.2, p. 741 in Heizer, Render, and Munson (12th edition) 2 3 Data 4 Costs A B D E 5 1 12 8 5 10 6 2 6 11 3 7 7 Demand 6 8 12 4 8 Supply 4 18 9 14 32/32 2 Say you wanted to ship 123 units from Source 1 to C, and 30 units from Source 2 to A. What would your total cost be? Enter your answer without the currency sign. For example, if you calculate $123.45 as your answer, just type in the 123.45. C.2 Consider the transportation table at right. Unit costs for each shipping route are in dollars. What is the total cost of the basic feasible solution that the intuitive lowest-cost method would find for this problem? PX Destination Source A B D E Supply 12 8 5 10 4 1 18 6 11 3 7 9 2 14 Demand 6 8 12 4 2