Excel Online Activity: Center of Gravity 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-/ where C = x coordinate of the center of gravity C = y coordinate of the center of gravity X = x coordinate of location/ Y = y coordinate of location / W = volume of goods or services moved to or from location / Open the spreadsheet and perform the required analysis to answer the questions below. X Open spreadsheet Questions 1. What are the x and y coordinates of the Center of Gravity? Round your answers to two decimal places. Cx: Cy: 2. Choose the correct graph representing the center of gravity. The correct graph is y-Coordinate 140+ 120 100- 80 60 A. B. y-Coordinate 140- 120- 100- 80- 60- Excel Online Activity: Center of Gravity 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-/ where C = x coordinate of the center of gravity C = y coordinate of the center of gravity X = x coordinate of location/ Y = y coordinate of location / W = volume of goods or services moved to or from location / Open the spreadsheet and perform the required analysis to answer the questions below. X Open spreadsheet Questions 1. What are the x and y coordinates of the Center of Gravity? Round your answers to two decimal places. Cx: Cy: 2. Choose the correct graph representing the center of gravity. The correct graph is y-Coordinate 140+ 120 100- 80 60 A. B. y-Coordinate 140- 120- 100- 80- 60
