| PLANT.XLS | Plant Location Model | |||||||
| Fixed | Variable | Production | Plant | Fixed cost | ||||
| Plants | Cost | Cost | Capacity | Open | Variable cost | |||
| Brazil | 500 | 10 | 30 | Shipping cost | ||||
| Philippines | 400 | 12 | 25 | Total cost | ||||
| Mexico | 600 | 16 | 35 | |||||
| (All costs in $100) | ||||||||
| Unit Shipping Costs: | Customers | |||||||
| Central Am. | U.S. | Europe | S.Amer. | |||||
| Brazil | 9 | 9 | 7 | 5 | ||||
| Philippines | 7 | 7 | 4 | 6 | ||||
| Mexico | 3 | 4 | 7 | 9 | ||||
| Shipping Plan: | Customers | Available | Avail - | Constraint | ||||
| Central Am. | U.S. | Europe | S.Amer. | Total | Capacity | Total | >=0 ? | |
| Brazil | ||||||||
| Philippines | ||||||||
| Mexico | ||||||||
| Total | ||||||||
| Constraint | ||||||||
| Demand | 18 | 15 | 20 | 12 | ||||