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:

Find the sum of weighted metropolitan model distances for each of the five locations; $A1,A2,A3,A4$ and A $5.$ Be sure the calculations are shown for each location's sum of distances. $(8$pts$)$

As evidenced by having the smallest weighted sum of distances, which location is best? $(2$pts$)$

$\backslash$table$[[$Demand Data$],[$Weight$,x,Y$

PPlleeaassee ssoollvvee uussiinngg eexxcceell wwiitthh ffoorrmmuullaass