Fouke has three plants, one each in Orlando, Atlanta and Lexington each. Their capacities are 225,000 units,
Question:
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 transportation cost?
1. As is, the optimal total cost?
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
Greens/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 the 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
Greens