PLEASE USE EXCEL TO SOLVE PROBLEM & PLEASE DISPLAY FORMULA USED. NOTICE THIS PROBLEM SAYS TO USE THE WEIGHTED METROPOLITAN METHOD. (USE ABS NO SQRT)

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. 2. As evidenced by having the smallest weighted sum of distances, which location is best? Demand Data Weight D 2 28 E 33 4 30 34 5 1 28 35 30 28 32 28 32 33 | | | 27 26 27 27 1 28 27 31 6 30 3 24 27 30 5 3 28 31 24 26 28 3 27 4 25 1 34 29 7 30 37 2 25 36 31 NIN 33 33 30 Location E D 26 32 A1 A2 A3 33 31 31 33 29 29 A4 A5 31 32