Using Solver - integer solution

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the solver feature to determine the minimum # of suppliers we need
to fill our demands. When I use my solver solution, it optimizes the number
of suppliers to be .6 of a supplier. Is there a way to force the numbers to
be integers?
 
DIL

Set target cell, Equal to: click Value Radio Button and type 1 in InputBox

Regards
Peter
 
Hi. In general, you add the constraint that your particular changing
cells are "Int" for Integer. In the Constraint window, "Int" is the
fourth item in the pull-down menu.

HTH
Dana DeLouis
 
Also read about Tolerance. Use Tools | Solver | Options | Help and you will
find
Tolerance:The percentage by which the target cell of a solution satisfying
the integer constraints can differ from the true optimal value and still be
considered acceptable. This option applies only to problems with integer
constraints. A higher tolerance tends to speed up the solution process

best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007: Help creating a macro that will run Solver? 3
Solver with If then else? 3
precision in solver 4
Solver 3
Solver not found 1
Solver or not Solver 4
Excel solver via access/vba 1
what does error message "too many adjustable cells" mean in solver 1

Back
Top