Something strange with the setup, modifying the formula for C production to "=((E3-MOD(E3,10))+(E4-MOD(E4,10)))*0.1 and setting target cell ">=4700" I got a much better profit. A thing one would expect as maximising production of A, minimizing production of D and balancing the C production according to the ratio is the optimal solution.
Don't know why the model did not see that at once? Something to do with the MOD function?
solv_mod2.jpg
Havin tested a bit more I replaced the C constraint with the "INT" function instead of using the "MOD" function so formula for C production is now
and this seems to work better as I got the target cell value to 4753 without specifying that this value should be ">=4700" and production was A =1127, B =0, C =112 and D =21.
Alf
Bookmarks