Question

USING EXCEL

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 on the following page:

1. Find the sum of weighted metropolitan model distances for each of the five locations. 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)

Demand Data
Weight	X	Y
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	X	Y
A	26	32
B	31	29
C	31	33
D	32	29
E	31	31

Answer 1

location planing using load distance method

• Distance between any two points (here location and demand source) =
• Weighted distance= weight for demand source * distance between location and demand source
• SUM=   summation (weight * distance)

choosing a location -

we choose the location with least (sum of weighted distance). Here we choose location E

as