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