DE D E F G H 1 J P L M N o Using Solver to Optimize Location for Steel Appliances 1. Using Data Analysis | Solver, solve the model to obtain location of facility represented by pink dot in chart below. 2. Change tonnage from St. Lous in Cell D7 to 1,700. How do you expect location of facility to change? Try using Solver. 515 dn = (x x. )' +(y-yn) v? S/Ton Mile Tons F D. 0.90 500 0.95 300 0.85 700 1.50 225 1.50 150 1.50 250 1.50 175 1.50 300 Coordinates .x, d d 700 1200 319 250 600 225 825 460 600 500 391 1050 1200 487 800 300 594 925 975 261 1000 1080 375 681.3 882 3. Change tonnage from St. Lous in Cell D7 to 2,700. How do you expect location of facility to change? Try using Solver A B 1 Steel Appliances 2 3 Sources: 4 Markets 5 Buffalo 6 Sources Memphis 7 St. Louis 8 Atlanta 9 Boston 10 Markets Jacksonville 11 Philadelphia 12 New York 13 14 Facility Location 15 16 x = 681.3 17 ya 882.0 18 19 Cost = S 4,265,235 20 21 2 23 >4 >5 26 27 1400 1200 A Buffalo Boston Now York Philadelphia 1000 800 St. Louis 600 A Memphis k Atlanta TC = d.D.F. 400 = . Jacksonville n=1 200 0 0 200 400 600 800 1000 1200 X Question 1 Change the quantity to be shipped from St. Louis to the new facility to 1700 tones. What are the coordinates of the new facility? O 375.7, 814.2 875.7, 314.2 O 814.7, 457.8 O 575.4, 414.8