Show Formulas Used in Excel

Submit an excel file which shows the calculation as well as the answers to the following two questions. Consider the warehouse location decision facing CupAMoe's (example 1 in the lecture ) 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 (8 points) 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. (8 points) 3) Which weighting system would be preferred? Justify your conclusion. (4 points) Submit an excel file which shows the calculation as well as the answers to the following two questions. Consider the warehouse location decision facing CupAMoe's (example 1 in the lecture ) 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 (8 points) 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. (8 points) 3) Which weighting system would be preferred? Justify your conclusion. (4 points)