Steel Appliances (SA), a manufacturer of high-quality refrigerators and cooking ranges, has two plants located in St. Louis and Buffalo. SA has decided to build a distribution center that will serve two markets in Atlanta and Boston. The coordinate location, the demand in each market, the required supply from each plant, and the shipping cost from each supply source and for each market are given. (4 points) Apply two iterations of the center of gravity method. Use (XY (0,0) as an initial location to start with a. Y coordinate Shipping cost, $/unit 0.5 Volume, units X coordinate St. Louis 200 200 200 Buffalo 1 100 100 500 Atlanta 1.5 300 250 600 Boston 0.5 250 500 300 b. Use Solver to find an optimal couple of coordinates. Steel Appliances (SA), a manufacturer of high-quality refrigerators and cooking ranges, has two plants located in St. Louis and Buffalo. SA has decided to build a distribution center that will serve two markets in Atlanta and Boston. The coordinate location, the demand in each market, the required supply from each plant, and the shipping cost from each supply source and for each market are given. (4 points) Apply two iterations of the center of gravity method. Use (XY (0,0) as an initial location to start with a. Y coordinate Shipping cost, $/unit 0.5 Volume, units X coordinate St. Louis 200 200 200 Buffalo 1 100 100 500 Atlanta 1.5 300 250 600 Boston 0.5 250 500 300 b. Use Solver to find an optimal couple of coordinates