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 locations sum of distances. (8pts)

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

Demand Data
Weight	D	E
2	28	33
4	30	34
5	28	28
1	35	32
3	30	28
2	32	33
3	26	27
2	27	28
1	27	27
6	30	31
3	27	24
5	30	31
3	28	24
3	27	26
4	25	28
1	34	29
7	30	37
2	25	36
2	31	33
2	30	33

Location	D	E
A1	26	32
A2	33	31
A3	31	33
A4	31	29
A5	32	29

******************All problems must be solved using Excel formulas*****************