Solver Resetting itself

Hello,

I've recently made a macro that utilizes solver to minimize a variable. There are a number of constraints that I had to use to get the results that I wanted.
When I use solver initially (setting the macro) it works exactly how I want .
But after running the macro after setting it loses most of the constraints that I have applied and the answer is not what I am after .
When setting the macro I make sure to hit the reset all button on solver before entering the constraints just to be safe.

Any idea why this is happening and how do I solve this?

I've made a simple spreadsheet to show what is happening and what I am trying to achieve;
In this case I am trying to choose the best shop to go to by maximizing items
Initially my macro included a constraint for fruit and chocolate but after running it through the button it deletes the constraint for chocolate and just goes for the maximum

Thanks

I did have som problem with your file as solver in an Scandinavian environment didn't did not work with your costs expressed as $4.00

I also modified your setup a bit as I setup the problem a simplex one.

Maximum chocolate is the driving force. You could change the total cost = 20 instead of my =< 20 it will not give you more chocolate but perhaps your mom will by happy as you saved her a dollar.

The only thing I'm not sure about are two fruits. Could they be the same or must it be different fruits?

If so you could sum the fruit range F5:H5 and set the sum to be "<=1" and do the same for range F6:H6 and range F7:H7 .

If you do change the setup you then need to add this line to the macro before the line "SolverSolve" line in order to add this constraint in the building of the solver macro.

Please Login or Register  to view this content.

Alf