I want to minimize shipping costs (Cell B39) by filling in (Cell B21:F24) subject to certain constraints. The solver's solution are currently in Cell B21:F24 which give B39 answer of 79875.
However, by trial and error I found a test case (answer in Cell I21:M24) that gives Cell B39 answer of 70500, which is less than 79875. It is not possible to try all possible cases by hand, so I am not sure whether 70500 is the best.
How do I make solver give me the correct answer?
I don't know whether to use Simplex LP, GRG Nonlinear or Evolutionary but whatever I use, the best answer it gave was 79875 (Using Evolutionary).
The file is uploaded.
Bookmarks