Question

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

		Destination
Source	Business	Education	Parsons Hall	Holmstedt Hall	Supply
Baker Hall	10	9	5	2	35
Tirey Hall	12	11	1	6	10
Arena	15	14	7	6	20
Demand	12	20	10	10

           Draw the transportation network for this problem. Formulate the LP model for AV center if they wish to minimize the total transportation distance.

           Implement a spreadsheet model and use Excel Solver to obtain a solution to the problem. (Submit the complete Solver File including both answer and sensitivity reports)

Answer 1

1) Transportation matrix

2) Formulas used

3) Solver inputs

4) Final solution matrix

We can see that the minimum distance comes out to be 358 units after the optimum allocations.

5) Answer report