el Activity #3: Center of Gravity 11:59 PM CDT Excel Online Activity: Center of

ID: 2614875 • Letter: E

Question

el Activity #3: Center of Gravity 11:59 PM CDT Excel Online Activity: Center of Gravity Taylor Paper Products is a producer of paper stock used in newspapers and magazines. Taylor's demand is 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 where C x coordinate of the center of gravity Cyy coordinate of the center of gravity X, x coordinate of location Y,-Y coordinate of location , volume of goods or services moved to or from location Open the spreadsheet and perform the required analysis to answer the questiont below 1. What are the x and y coordinates of the Center of Gravity? Round your answers to two decimal places. Cx: Cy: Back

Explanation / Answer

Name

x- Coordinate

y-Coordinate

Volume(W)

Hamilton

500

Kingsport

400

Chicago

130

200

Pittsburg

120

200

New York

129

120

300

Atlanta

200

1. Cx = ?XiWi/?Wi = (54*500)+(75*400)+(30*200)+(90*200)+(129*300)+(70*200)/(500+400+200+200+300+200)

=74.28

Cy = ?XiWi/?Wi=

(98*500)+(65*400)+(130*200)+9120*200)+(120*300)+(50*200)/( 500+400+200+200+300+200)

=95

1. X any y coordinates of center of gravity are 74.28 and 95 (Cx=74.28 and Cy=95)

2. To answer the second question , just look at the center of gravity posiiton in the different charts. It should be 74.8 on the x axis and 95 on the y axis. Option B matches with 74.28 and 95. Hence the answer is option B.