| | Plant | Capacity | Revenue from closing | Cost to open | | | | | Plant |
| | Seattle | 300 | $ 3,250.00 | | | | | Market | Seattle | Atlanta | Chicago | Pittsburgh | Phoenix | Total Received | >= | Demand |
| | Atlanta | 350 | $ 4,000.00 | | | | | Atlanta | 0 | 130 | 70 | 0 | 0 | 200 | >= | 200 |
| | Chicago | 650 | $ 2,000.00 | | | | | Columbia | 100 | 0 | 0 | 0 | 0 | 100 | >= | 100 |
| | Pittsburgh | 200 | | $ 4,400.00 | | | | Dayton | 0 | 0 | 50 | 0 | 0 | 50 | >= | 50 |
| | Phoenix | 200 | | $ 3,900.00 | | | | Fremont | 50 | 0 | 0 | 0 | 0 | 50 | >= | 50 |
| | Total | 1700 | | | | | | Hanover | 0 | 0 | 25 | 0 | 0 | 25 | >= | 25 |
| | | | | | | | | Indianapolis | 0 | 0 | 200 | 0 | 0 | 200 | >= | 200 |
| | Market | Demand | | | | | | Kensington | 100 | 0 | 0 | 0 | 0 | 100 | >= | 100 |
| | Atlanta | 200 | | | | | | Manchester | 30 | 0 | 0 | 0 | 0 | 30 | >= | 30 |
| | Columbia | 100 | | | | | | New York | 0 | 0 | 300 | 0 | 0 | 300 | >= | 300 |
| | Dayton | 50 | | | | | | Raleigh | 0 | 220 | 0 | 0 | 0 | 220 | >= | 220 |
| | Fremont | 50 | | | | | | Total Shipped | 280 | 350 | 645 | 0 | 0 |
| | Hanover | 25 | | | | | | <= | <= | <= | <= | <= | <= |
| | Indianapolis | 200 | | | | | | Supply | 300 | 350 | 650 | 0 | 0 |
| | Kensington | 100 | | | | | | Plant Open? (1=open, 0=close) | 1 | 1 | 1 | 0 | 0 |
| | Manchester | 30 | | | | | | Revenue from closing | $ - 0 | $ - 0 | $ - 0 |
| | New York | 300 | | | | | | Cost of opening | | | | $ - 0 | $ - 0 |
| | Raleigh | 220 |
| | Total | 1,275 | | | | | | Transportation Cost | $ 912.50 | $ 1,269.00 | $ 4,531.00 | $ - 0 | $ - 0 |
| | | | | | | | | Total Transportation Cost | $ 6,712.50 |
| | Transportation Cost / Unit | | | | | | | Revenue from closing plants | $ - 0 |
| | | Plant | | | | | | Cost of opening plants | $ - 0 |
| | Market | Seattle | Atlanta | Chicago | Pittsburgh | Phoenix | | TOTAL COST | $ 6,712.50 |
| | Atlanta | $ 5.21 | $ 0.20 | $ 2.30 | $ 1.00 | $ 2.00 |
| | Columbia | $ 2.30 | $ 5.20 | $ 2.60 | $ 3.25 | $ 1.96 |
| | Dayton | $ 2.65 | $ 2.30 | $ 1.20 | $ 2.50 | $ 2.50 |
| | Fremont | $ 2.50 | $ 2.50 | $ 10.58 | $ 5.00 | $ 3.25 |
| | Hanover | $ 8.14 | $ 5.00 | $ 7.00 | $ 6.25 | $ 5.10 |
| | Indianapolis | $ 8.58 | $ 6.52 | $ 3.20 | $ 2.52 | $ 3.41 |
| | Kensington | $ 2.50 | $ 8.01 | $ 15.24 | $ 10.00 | $ 2.00 |
| | Manchester | $ 10.25 | $ 12.25 | $ 12.45 | $ 7.14 | $ 8.50 |
| | New York | $ 15.21 | $ 10.25 | $ 11.65 | $ 5.12 | $ 8.00 |
| | Raleigh | $ 14.36 | $ 5.65 | $ 9.87 | $ 4.50 | $ 6.00 |
jiayou
Handout16-Problem2-COMPLETED.xlsx
