=+answers should be. Your spreadsheet should recalculate results whenever any changes are made to the shaded cells. To test your logic, change the weight on demand point D to 250. Your new weighted X and Y coordinates should be 3.04 and 2.96, respectively.

1 Weighted Center of Gravity Model for Up to Five Demand Points 2

3 4

A B A

B C

D E

C D 5

6 7

8 9

11 10 Demand point Weighting X coordinate Y coordinate factor Weighted X coordinate: 3.08 Weighted Y coordinate: 2.92 1.00 2.00 3.00 4.00 5.00 5.00 4.00 3.00 2.00 1.00 300 200 100 300 300