Question

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 250. Your new weighted X and Y coordinates should be 3.04 and 2.96, respectively.




$1.99
Sales3
Views55
Comments0
  • CreatedApril 10, 2015
  • Files Included
Post your question
5000