D
DtTall
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
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