1st exercise explanation-fernando martín-miguel pintor
Post on 23-Feb-2018
220 Views
Preview:
TRANSCRIPT
-
7/24/2019 1st Exercise Explanation-Fernando Martn-Miguel Pintor
1/2canned by CamScanner
-
7/24/2019 1st Exercise Explanation-Fernando Martn-Miguel Pintor
2/2
Excel explanation
Columns (C6:K17) show the equations of the different costs we have. They depend on
the variables which are shown in columns (N5:T17), showing also the month 0 in the
production and inventory columns.
Columns (G21:K32) show the equations we need to make the restrictions in the solver.
Finally in D19 is shown final result equation, which is the minimum cost.
Using solver I have selected as objective, the minimum cost equation. Then I have
selected the variables and introduced the equations for the three restrictions,
achieving a final result of 1795590.
top related