1. See MS Excel Spreadsheet.

2. Model was solved as follows:

a. Plants were labeled 1 through 6, waste facilities labeled A through C.

b. Objective function: Minimize Z 1A(12) 1B(15) 1C(17) 2A(14) 2B(9) 2C(10) 3A(13) 3B(20) 3C(11) 4A(17) 4B(16) 4C(19) 5A(7) 5B(14) 5C(12) 6A(22) 6B(16) 6C(18);

c. Subject to:

1A 1B 1C 35

2A 2B 2C 26

3A 3B 3C 42

4A 4B 4C 53

5A 5B 5C 29

6A 6B 6C 38

1A 2A 3A 4A 5A 6A 65

1B 2B 3B 4B 5B 6B 80

1C 2C 3C 4C 5C 6C 105

All Combinations 0

d. Solver add-on solution in MS Excel yielded the following results:

35 bbl shipped from Kinsport to Whitewater,

26 bbl shipped from Danville to Duras,

42 bbl shipped from Macon to Duras,

1 bbl shipped from Selma...