Solver Update Issue
 

Hello,

I am using Solver to do a sourcing problem. I have 5 plants and 5
locations to ship to. Production costs are different at each plant and
there is a shipping cost. Also, there is a min. capacity that each
location can run. That is the background.

Anyway, I am having trouble with solver updating. I can run it the
first time and I get an answer. I can then change one value, such as
increasing the min. capacity, and solver will recalculate fine. When
I try to go back to the original capacity solver's answer doesn't
change. From that point it doesn't seem to matter what I do, solver's
answer never changes. I am solving for a min. sum of values. I can
change all values to zero, thus a cost of zero, and I run solver and
get an answer of zero which totally ignores that constraint that I
have in it for a required min. capacity.

Bottom line: Solver doesn't seem to update with new information I put
in. I know all of my constraints are right (because it worked the
first time). Thanks in advance for any help.

David

Solver Update Issue
 

Not sure if I correctly understand but:
If I use Solver for any problem and then change a cell within the problem I
must rerun Solver to get a new Min or Max (or Value) solution. Solver is not
aware of any changes you made until it is run again.
best wsihes
--
Bernard Liengme
http://people.stfx.ca/bliengme

"DtTall" wrote in message
oups.com...
Hello,

I am using Solver to do a sourcing problem. I have 5 plants and 5
locations to ship to. Production costs are different at each plant and
there is a shipping cost. Also, there is a min. capacity that each
location can run. That is the background.

Anyway, I am having trouble with solver updating. I can run it the
first time and I get an answer. I can then change one value, such as
increasing the min. capacity, and solver will recalculate fine. When
I try to go back to the original capacity solver's answer doesn't
change. From that point it doesn't seem to matter what I do, solver's
answer never changes. I am solving for a min. sum of values. I can
change all values to zero, thus a cost of zero, and I run solver and
get an answer of zero which totally ignores that constraint that I
have in it for a required min. capacity.

Bottom line: Solver doesn't seem to update with new information I put
in. I know all of my constraints are right (because it worked the
first time). Thanks in advance for any help.

David