Todd’s Video, a major video rental and TV sales chain headquartered in New Orlea
ID: 2747212 • Letter: T
Question
Todd’s Video, a major video rental and TV sales chain headquartered in New Orleans, is about to open its first outlet in Mobile, Alabama, and wants to select a site that will place the new outlet in the center of Mobile’s population base. Todd examines the seven census tracts in Mobile, plots the coordinates of the center of each from a map, and looks up the population base on each to user as a weighting. The information gathered appears in the following table:
Census Tract
Population in Census Tract
x, y Coordinates
101
2000
(25, 45)
102
5000
(25, 25)
103
10000
(55, 45)
104
7000
(50, 20)
105
10000
(80, 50)
106
20000
(70, 20)
107
14000
(90, 25)
using SOLVER, the optimal coordinates of the new outlet are?
x=
y=
2 decimal places
Census Tract
Population in Census Tract
x, y Coordinates
101
2000
(25, 45)
102
5000
(25, 25)
103
10000
(55, 45)
104
7000
(50, 20)
105
10000
(80, 50)
106
20000
(70, 20)
107
14000
(90, 25)
Explanation / Answer
Solution :
For X = 395 / 7
= 56.43
For Y = 230 / 7
= 32.86
optimal coordinates of the new outlet are?
X= 56.43
Y= 32.86
Sr.No Census Tract Population in Census Tract X Coordinate Y Coordinate 1 101 2000 25 45 2 102 5000 25 25 3 103 10000 55 45 4 104 7000 50 20 5 105 10000 80 50 6 106 20000 70 20 7 107 14000 90 25 68000 395 230