Using Solver to set contraint divisibility

[trigger467]

I am working on a problem that I must use solver for and I need to have one of the "changed cells" divisible by 6. Is there a way to set a constraint in Solver to do this?

For example, I am deciding on how many of product A, B, and C to produce. But, Product A MUST be produced in quantities of 6.

Any help is appreciated.

Wil

 

[PaddyD]

without thinking of the solver setup, the contraint is of the form:

mod(your_cal,6)=0

 

[tusharm]

If you know about the advantage of keeping an optimization problem "linear," you may want to add a new variable, say X=A/6 and ensure X is an integer. I *believe* that will keep the problem linear but it's been a long time since I had to worry about things like this.

I am working on a problem that I must use solver for and I need to have one of the "changed cells" divisible by 6. Is there a way to set a constraint in Solver to do this?

For example, I am deciding on how many of product A, B, and C to produce. But, Product A MUST be produced in quantities of 6.

Any help is appreciated.

Wil