Please complete the following Excel sheet along with the formulas used.

H J K L M N o B E F G 1 Plant Costs and Capacity 2 Wipes Ointment Variable Variable 3 Plant Fixed Cost Cost/Unit Capacity Fixed Cost Cost/Unit Capacity 4 Chicago 5,000 10 5,000 1,500 20 5 Princeton, NJ 2,200 10 2,000 1,500 20 6 Atlanta 2,200 10 2,000 1,500 20 7 LA 2,200 10 2,000 1,500 20 8 9 Regional Demand by Product Upper Lower 10 Zone Northwest Southwest Midwest Midwest Northeast Southeast 11 Wipes 500 700 900 800 1,000 12 Ointment 50 90 120 65 120 13 14 Transportation Costs 1,000 1,000 1,000 1,000 Question 1 Set Cells H23 and H31 to be 1. Copy B11 to G11 to B23 to G23. Copy B12 to G12 to B31 to G31. Total cost is obtained in Cell B37. Question 2 Use Data Analysis | Solver to solve for the optimal configuration. To change transportation costs, change the multiplier in Cell 116. Question 3 Delete the constraints in Solver setting Cells H23 and H31 to 1 and resolve. Total 600 4,500 70 515 Transpor t Cost Multiplie 1 5.96 4.08 3.64 6.60 Fixed 600 Upper Lower 15 Northwest Southwest Midwest Midwest Northeast Southeast 16 Chicago 6.32 6.32 3.68 4.04 5.76 17 Princeton, NJ 6.60 6.60 5.76 5.92 3.68 18 Atlanta 6.72 6.48 5.92 4.08 4.04 19 LA 4.36 3.68 6.32 6.32 6.72 20 21 Wipes Variables Upper Lower 22 Northwest Southwest Midwest Midwest Northeast Southeast 23 Chicago 500 700 900 800 1,000 24 Princeton, NJ 25 Atlanta 26 LA 27 Demand 28 29 Ointment Variables Upper Lower 30 Northwest Southwest Midwest Midwest Northeast Southeast 31 Chicago 50 90 120 65 120 32 Princeton, NJ 33 Atlanta 34 LA 35 Demand 36 37 Total Cost 32,661.40 38 Capacity 1 500 0 0 0 Fixed 70 | Capacity 1 485 0 0 0