Design a spreadsheet to compute the total rectilinear distance from a set of up to10 existing locations to any other location. Assume that existing locations areplaced in Columns A and B and the new location in cells D1 and E1. Initializecolumn A with the value of cell D1 and column B with the value of cell E1, so thatthe total distance will be computed correctly when there are fewer than10 locations.a. Suppose that existing facilities are located at (0, 0), (5, 15), (110, 120), (35, 25),(80, 10), (75, 20), (8, 38), (50, 65), (22, 95), and (44, 70), and the new facility is tobe located at (50, 50). Determine the total rectilinear distance of the new facilityto the existing facilities.b. Suppose the new facility in part (a) can be located only at x =0, 5, 10, . . . , 100and y = 0, 10, 20, . . . , 100. By systematically varying the x and y coordinates,find the optimal location of the new facility
Design a spreadsheet to compute the total rectilinear distance from a set of up to
10 existing locations to any other location. Assume that existing locations are
placed in Columns A and B and the new location in cells D1 and E1. Initialize
column A with the value of cell D1 and column B with the value of cell E1, so that
the total distance will be computed correctly when there are fewer than
10 locations.
a. Suppose that existing facilities are located at (0, 0), (5, 15), (110, 120), (35, 25),
(80, 10), (75, 20), (8, 38), (50, 65), (22, 95), and (44, 70), and the new facility is to
be located at (50, 50). Determine the total rectilinear distance of the new facility
to the existing facilities.
b. Suppose the new facility in part (a) can be located only at x =0, 5, 10, . . . , 100
and y = 0, 10, 20, . . . , 100. By systematically varying the x and y coordinates,
find the optimal location of the new facility
Step by step
Solved in 3 steps with 3 images
