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.