10. (***) (Microsoft Excel problem). The following figure shows an Excel spreadsheet that calculates weighted X and Y coordinates, based on values for up to five demand points. Re-create this spreadsheet in Excel.

While your formatting does not have to be exactly the same, your 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 300. Your new weighted X and Y coordinates should be 3.08 and 2.92, respectively.

Transcribed Image Text:

A B 1 Weighted Center of Gravity Model for up to Five Demand Points 2 Demand 3 point X coordinate Y coordinate Weighting factor 4 A 1.00 5.00 300 5678 B 2.00 4.00 200 C 3.00 3.00 100 D 4.00 2.00 300 E 5.00 1.00 300 9 10 Weighted X coordinate: 11 3.08 Weighted Y coordinate: 2.92 E F