please help

solve

B D E Center of Gravity Name Hamilton Kingsport Chicago Pittsburgh New York Atlanta X-Coordinate y-Coordinate Volume 55 96 500 75 75 400 25 120 300 85 100 200 129 140 300 65 50 200 Formulas Center of Gravity #N/A Use the area to the right to draw a scatter diagram. 1 2 3 4 5 6 7 28 9 30 DN 00 32 33 34 35 OWN 37 38 4 Sheet1 + Calculation Mode: Automatic Workbook Statistics 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, =w/, C, - w./ w, 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 question telow. HIHI Open spreadsheet Questions 1. What are the x and y coordinates of the Center of Gravity? Round your answers to two decimal places. C: Cy! 2. Choose the correct graph representing the center of gravity 2. Choose the correct graph representing the center of gravity. The correct graph is y-Coordinate 140+ y-Coordinate 140+ 120 120 100 100 80 8 A. 60 B. 601 40 40. 20 20- 20 40 140 20 40 60 SO 100 120 140 60 SO 100 120 -Coordinate x-Coordinate y-Coordinate 140+ y-Coordinate 140+ 120 120 . 100 100 80 SO C. D. 60 60 40 40 20 20