Hello! Right now i'm in the middle of a research related to inventory modelling and there is one paper that i use as main reference. In this paper, the optimal solution was obtained by using excel solver. In order for me to understans how to use excel solver, i try to find the optimal solution from this paper by using excel solver and if the result i obtained is the same as the result in the paper than the way i use excel solver is already correct. I'm pretty sure there is something wrong with the way i use excel solver but i dont know what i did wrong.
I attached my excel file below.
So basically i write all the numerical example and the mathematical modelling from the paper. I wrote the mathematical formula for each cost first and then the total cost. Cost 1 is for formula 1 like the picture i attach below.
and the paper also attached below.
Can you help me to explain what i'm supposed to do to obtained the optimal solution? And by the way, i'm really sorry if my question and explanation is not clear or confusing since i'm not that good in english.
Bookmarks