Three new facilities are to be located relative to six existing facilities. The weighting factors are vjk flow intensity between new machines j and k, and wji flow intensity between new machine j and existing machine i:

The coordinate locations of the existing facilities are P1 (0, 10), P2 (15, 0), P3
(10, 25), P4 (5, 15), P5 (20, 20), and P6 (25, 5).

a. Use the Excel® SOLVER tool to solve the linear programming formulation of the minisum location problem assuming rectilinear distance.

b. Use the Excel® SOLVER tool to solve the minisum multifacility rectilinear location problem.

c. Use the Excel® SOLVER tool to solve the location problem assuming Euclidean distance.

d. Solve the multifacility gravity problem.

Transcribed Image Text:

13 = 3, 123 2, = W = = 4, 0, W14 = 4, W15= 0, W16 0, = W23 = 4, W24 0, = W25 = 0, W12 = 2, = W21 2. W26 7, = W32=0, W33 = 4, W34 = 2, W35 = 2225 5, 12 1, W13 = = 0, W22 W31=> = 0, W360,