View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
DtTall DtTall is offline
external usenet poster
 
Posts: 17
Default 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