Hey guys I really feeling kind of lost. I have to hand in an assignment which includes one small linear programming problem.
Mex Hex Data Sheet
Plant Production Cost__________Capacity________Running
(in $ per unit)___________(in million)_________(in million $)
Canada ______0,34 ____________3,0_________0,6
South Africa ___0,21 ____________2,5_________1,2
Region_____Demand (in million)
South America 1,5
North America 1,2
Transportation costs (in $ per unit)
______South America___North America___Europe ___Asia____ Africa
South Afri ______0,29_________0,23_________0,17_____0,24_____0,13
Differences in local labor costs and other regional factors created significant differences in the cost to produce MexHex in the various locations. The data tables give details on the costs to produce each unit and the capacity of each plant. Additionally, the running costs for each plant are given (only needed for problem 3).
MexHex is needed on all continents and the demand for each continent is also given in the data tables. Moreover, you are given the costs to ship one vaccination from each plant to each region.
1. Compute the total production and transportation costs if each plant only serves its region (Japan and India both ship to Asia).
2. Compute the minimal production and transportation costs and the corresponding plan. Compute the savings w.r.t. to the solution of 1.
3. Now also take running costs into account. The running costs for each plant are added for each operating plant. First compute the total costs for the case that each plant only serves its region. Then compute the minimal production, transportation and running costs and the corresponding plan. This means if a plant is not producing anything, its running costs do not need to be added. [Note: your solution must be an integer linear program, i.e. it must run when the ’linear model’ option is checked. You cannot use ’IF’ in an formula.]