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 you use. THIS IS THE QUESTION I WANT YOU TO ANSWER: ---> How much does it cost to ship 116 unit(s) from Source 2 to Destination E?

QUESTION 4 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 Supply 4 181 9 14 2 32/32 8 How much does it cost to ship 116 unit(s) from Source 2 to Destination E? 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