PLEASE USE EXCEL FOR QUESTION: PROVIDE VALUES AND FORMULAS USED TO OBTAIN ANSWERS

THANK YOU

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. (Spts) 2. As evidenced by having the smallest weighted sum of distances, which location is best? (2pts) Demand Data Weight D 2 28 E 30 COW 28 4 5 1 3 35 30 32 28 33 27 32 NWN 26 27 28 1 27 27 30 6 ww 27 30 31 24 31 24 26 28 3 27 25 28 4 1 34 29 7 30 37 2 25 36 33 2 31 2 30 33 Location D E ARWRP 26 33 31 32 31 33 29 29 31 32