Question

2. Using the following locations of customers:

1. Death Dogs: 400 E 400 S
2. Intestinal Fortitude: 2500 W 500 N
3. Road Kill: 100 W 1100 N
4. Bismo’s Pepto: 900 E 850 N
5. Salt’s Flat: 3500 W 250 S
6. Yeehaw’s: 2000 E 100 N

and the following average yearly demand figures for each customer, below, find a weighted average location based on the dollar volume of the customers and their locations. Again, do not worry about locating on actual streets, just find the coordinates using a weighted average. Someone else can worry about which street is best for these coordinates. Solve your answer in excel

1. $6.5 million
2. $2.5 million
3. $1.1 million
4. $2.2 million
5. $10.6 million
6. $3.4 million

Answer 1

Answer: X coordinate should be= -1219.77 or 1219.77 W

Y coordinate should be= -22.05 or 22.05 S

Explanation:

Customer Location	Dollar volume in Millions	Given coordinate	Given coordinate	X-Coordinate	Y-Coordinate	weighted X= Dollar volume * X coordinate	weighted Y=Dollar volume * Y coordinate
A. Death dogs	6.5	400E	400S	400	-400	2600	-2600
B. Intestinal Fortitude	2.5	2500W	500N	-2500	500	-6250	1250
C. Road kill	1.1	100W	1100N	-100	1100	-110	1210
D. Bismo's pepto	2.2	900E	850N	900	850	1980	1870
E. Salt's flat	10.6	3500W	250S	-3500	-250	-37100	-2650
F. Yeehaw's	3.4	2000E	100N	2000	100	6800	340
Total dollar volume	26.3	Average= sum of weighted X or Y/total Dollar volume				-1219.77	-22.05