Submit an excel file that shows the calculation as well as the answers to the following two questions. $($An excel file that shows the formulas$/$answer$)$

$1)$ Suppose Robbie has learned that Capital City$$s population is expected to grow by just $3$ percent over the next five years, while Springfield$$s population is expected to increase by $55,000$ over the same time period. Recalculate the X and Y coordinates using this new information

$2)$ Now suppose Robbie has also learned that Capital City generates $$900,000$ in sales per year, while Springfield and Shelbyville both generate only $$200,000$ in sales each. Using sales dollars as the weights, recalculate the X and Y coordinates.

$3)$ Which weighting system would be preferred? Justify your conclusion.

Please show all formulas in excel!!