Question

AV Center: Introduction The next four questions refer to the following information: After some special presentations, the employees of the AV Center have to move projectors back to classrooms. The table below indicates the buildings where the projectors are now (the sources), where they need to go (the destinations), and a measure of the distance between sites. Education Parsons Hall Holmstedt Hall Supply Destination Business 10 12 Source Baker Hall Tirey Hall Arena Demand 35 11 10 20

Answer 1

In case of any doubt please comment, I am happy to assist you.

Solution:

Part1:

Nehoore iagramm Source Destin ation IC 12 -35 O 12 20 -lo 10 10

Part2: Liner Program

Decision variables:

Xij = Number of projectors to move from source i to destination j, where i=1,2,3 and j=4,5,6,7

Objective:

Minimize Z = ∑∑Dij*Xij

Dij is the distance between source i and destination j

s.t.

∑X1j <= 35

∑X2j <= 10

∑X3j <= 20

∑Xi4 =12

∑Xi5 = 20

∑Xi6 = 10

∑Xi7 = 10

Xij >= 0

Spreadsheet screenshot:
Formula:D19 =SUMPRODUCT(B4:E6,B13:E15)

A E F G H J K L N O P R 2 Destination BusinessEducatio Parsons HolmstedSupply 3 Source Hall t Hall n Baker 4. 10 5 2 35 Hall 5 Tirey Hall 12 11 1 6 10 6 Arena 15 14 7 6 20 7 Demand 12 20 10 10 8 9 10 Optimal movement plan 11 Destination BusinessEducatio Parsons Holmsted Supply 12 Source t Hall Hall Baker 13 Hall 12 20 0 3 35 14 Tirey Hall 0 0 10 0 10 15 Arena 0 0 0 7 20 16 Demand 12 20 10 10 17 18 19 Minimize total distance 358 20

Thank you, Have a great day:-)