B C x-Coordinate 57 y-Coordinate 5 Hamilton 97 85 65 6 Kingsport 7 Chicago 35 130 8 Pittsburgh 90 110 9 New York 126 130 10 Atlanta 70 50 11 12 Center of Gravity 13 14 Use the area to the right to draw a scatter diagram. 15 1 2 ~34 A Center of Gravity Name D Volume 400 300 300 100 400 100 E Taylor Paper Products is a producer of paper stock used in newspapers and magazines. Taylor's demand is relatively constant, and thus can be forecast rather accurately. The company's two factories are located in Hamilton, Ohio, and Kingsport, Tennessee. The company distributes paper stock to four major markets: Chicago, Pittsburgh, New York, and Atlanta. The board of directors has authorized the construction of an intermediate warehouse to service those markets. Coordinates for the factories and markets as well as the amounts produced and demanded have been collected in the Microsoft Excel Online file below. Use the following equations to compute the coordinates of the center of gravity: C₂ = ΣXW₁/W G-ΣΥN/ΣΜ where C₂ = x coordinate of the center of gravity Cy = y coordinate of the center of gravity X₁ x coordinate location / Y = y coordinate of location / W₁ = volume of goods or services moved to or from location i Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Questions 1. What are the x and y coordinates of the Center of Gravity? Round your answers to two decimal places. C₂: 74.29 Cy: 96.47 X
