For mathWHIZ only

profileSalal
studenttemplate-agritransshipnetworkv2.xls

Template

Case Project - Agricultural Transshipment Distribution Network
Transportation Cost Per Rail Car: Transportation Cost Per Rail Car:
To Proc Center To Customer
From Farm Louisville Cincinatti From Proc Center Macon Greenwood Concord Chatham
Muncie 8000 6000 Louisville 44000 34000 34000 32000
Brazil 3000 8000 Cincinnati 57000 35000 28000 24000
Xenia 9000 3000
Decision Variables:
Xij Muncie Brazil Xenia Louisville Cincinatti Macon Greenwood Concord Chatham
Muncie 0 0
Brazil 0 0
Xenia 0 0
Louisville 0 0 0 0
Cincinatti 0 0 0 0
Obj Function: Total Cost = $ 0
Constraints: Munice Farm Capacity <= 3 Outbound
Brazil Farm Capacity <= 6 Outbound
Xenia Farm Capacity <= 5 Outbound
Louisville Proc Ctr Balance Constraint = 0 Hub
Cincinatti Proc Ctr Balance Constraint = 0 Hub
Macon Customer Demand = 3 Inbound
Greenwood Customer Demand = 4 Inbound
Concord Customer Demand = 3 Inbound
Chatham Customer Demand = 6 Inbound
Hint: check total supply capacity and total customer demand before you proceed
yellow indicates infeasible shipping route