Please solve ALL parts of the question, thank you. Please solve in excel.

After one iteration of the stepping-stone method, Johnson Consumer Inc. produced the following transportation table: After the initial iteration the results of the shipping pattern were as follows: a. Based on the tables above, what is the cost? b. Based on the optional solution (stepping stone method), what is the cost? a. Based on the tables above, what is the cost? b. Based on the optional solution (stepping stone method), what is the cost? c. If the requirement at Warehouse 3 increased by 25 units, what is the optimal solution? Are all of the warehouse requirements met? If soot, which warehouse is backloggedot, and by how much or not? d. Based on your solution in letter b., you now need to ship 40 units from Factory A to Warehouse B. What is the optimal solution