Directions: First, Complete problem 10a and bon page 128-129 (Edition W10 - Edition #9, pp. 544). Note: if you are not given a transportation rate, use "1"!! Next, you must identify the cost of applying this solution. Use Excel to make a spreadsheet of the total cost. Look at the example bellow that uses the Grid Problem from the slides. Name: Bubba Assignment Grid R#000000000 #10a Calculated By Hand Solution Y Rate Sites M1 M2 S1 22 10 4 10 Ton 200 100 100 150 Cost $8,168 $2.863 $5,052 $0.266 2 10 8 New $22,350 5.194.55 Calculated By Solver Solution Sites M1 M2 Ton 200 Y 2 4 10 6 Rate 10 10 8 6 100 Cost $4,895 $4,060 $5,481 $7.578 SA S1 2 12 208 100 150 New 244 $22.014 The formula for cell G8 is "=((+$C$13-C8Y 2+(+$D$13-D8Y 2Y 0.5*8*F8" The second part is to identify a less costly location than the grid solution. To do this you should use the "Solver" function under tools. You are trying to minimize the total cost in cell G23 by varying the values in 23 D23. Good luck!! When you are done, you should tam in the following: Page 1 - your hand written solution of=10a Page 2 - your print out of the Excel answer of =10a Page 3 - your hand written solution of =10b. Page 4 - your print out of the Excel answer of=10b. NOTE: If you tum it in online - one PDF file not a PDF and Excel. I don't need to see your constraints and Solver set up. I just want the solutions please! Directions: First, Complete problem 10a and bon page 128-129 (Edition W10 - Edition #9, pp. 544). Note: if you are not given a transportation rate, use "1"!! Next, you must identify the cost of applying this solution. Use Excel to make a spreadsheet of the total cost. Look at the example bellow that uses the Grid Problem from the slides. Name: Bubba Assignment Grid R#000000000 #10a Calculated By Hand Solution Y Rate Sites M1 M2 S1 22 10 4 10 Ton 200 100 100 150 Cost $8,168 $2.863 $5,052 $0.266 2 10 8 New $22,350 5.194.55 Calculated By Solver Solution Sites M1 M2 Ton 200 Y 2 4 10 6 Rate 10 10 8 6 100 Cost $4,895 $4,060 $5,481 $7.578 SA S1 2 12 208 100 150 New 244 $22.014 The formula for cell G8 is "=((+$C$13-C8Y 2+(+$D$13-D8Y 2Y 0.5*8*F8" The second part is to identify a less costly location than the grid solution. To do this you should use the "Solver" function under tools. You are trying to minimize the total cost in cell G23 by varying the values in 23 D23. Good luck!! When you are done, you should tam in the following: Page 1 - your hand written solution of=10a Page 2 - your print out of the Excel answer of =10a Page 3 - your hand written solution of =10b. Page 4 - your print out of the Excel answer of=10b. NOTE: If you tum it in online - one PDF file not a PDF and Excel. I don't need to see your constraints and Solver set up. I just want the solutions please