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, . . . ,