q set 3. please use excel formulas and show the formas for understanding. if if its not in excel formulas unfortunatly i would have ti give negative rating

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 AS. 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) \begin{tabular}{|c|c|c|} \hline Location & X & Y \\ \hline A1 & 27 & 34 \\ \hline A2 & 26 & 28 \\ \hline A3 & 32 & 30 \\ \hline A4 & 27 & 32 \\ \hline A5 & 33 & 29 \\ \hline \end{tabular} 3