Please solve using excel, and provide formulas

Question Set 3. This question set uses the metropolitan model for facility location decisions. Each demand source has a weight indicating the volume of sales it is expected to generate. Using the demand data and five potential locations below: 1. Find the sum of weighted metropolitan model distances for each of the five locations; A1, A2, A3, A4 and A5. Be sure the calculations are shown for each location's sum of distances. (8pts) 2. As evidenced by having the smallest weighted sum of distances, which location is best? (2pts)