Fouke has three plants, one each in Orlando, Atlanta and Lexington each. Their capacities are 225,000 units, 175,000 units and 187,500 units respectively. Fouke needs to ship couches from these plants to 12 demand locations. The transportation cost between each source and destination is given to you in the Excel file below. How can you minimize the transportation cost?

1. As is, the optimal total cost is?

2. Which supply constraints are binding? (select all that apply)

A. Orlando

B. Atlanta

C. Lexington

3. Which of the market constraints are binding (demand constraints)? (Select all that apply)

Ral/Durham

Charleston

Miami

Columbus

Tampa

Birmingham

Greems/WS

Columbia

Savannah

Atlanta

Orlando

Knoxville

4. How many dimensions does the associated polygon exist in?

5. How many lines (or sides) does the corresponding polygon have including the non-negative constraints?

6. If you change the Knoxville demand to 100,000, what is the new total cost?

7. Now, return Knoxville's demand to 77,640. Resolve it and run the sensitivity report to get the shadow prices. What is the shadow price associated with the supply constraint on Atlanta's supply of 175,000? (Give answer to 2 decimal places.)

8. Looking at the sensitivity report, adding an extra demand to which city would be most detrimental to your total costs?

Tampa

Ral/Durham

Atlanta

Orlando

Charleston

Knoxville

Birmingham

Columbus

Columbia

Miami

Savannah

Greems