Making sure variable is an integer?

**shg** · 02-03-2008, 03:07 PM

If I did it right, I get 215 tables and 136 chairs:

       --A--- -B-- -C-- -D-- ---E--- -F- -------------G-------------- --H-- ----I-----
  13   Profit wood prod time Fitting box           Formula            Value Constraint
  14   tables 215   70   20    72     1              =20*x + 12.5 * y  6000 <= 6000   
  15   chairs 136   30  12.5   18     1                        =x + y   351 <= 400    
  16          > 0  > 0                               =72 * x + 18 * y 17928 <= 18000  
  17                                     =SUMPRODUCT(B14:B15,D14:D15)  6000 maximize

**Mooshey** · 02-03-2008, 04:39 PM

I got 216 and 133.
It doesn't let me upload the xls file..

**Mooshey** · 02-03-2008, 04:43 PM

You mentioned that there is an integer constraint for cells. Where is it in Solver?

**shg** · 02-03-2008, 05:23 PM

I got 216 and 133.

That results in 5982.5 for SUMPRODUCT(B14:B15, D14:D15); 215 and 136 returns 6000.

You mentioned that there is an integer constraint for cells. Where is it in Solver?

It's one of the selections in the operator dropdown in the Add Constraint dialog.

**Mooshey** · 02-03-2008, 05:45 PM

Hi,

I found how to add integer constraints.
For some reason I get 217 and 132....

I appreciate your help,
Tlalit

**shg** · 02-03-2008, 06:32 PM

See attached. Set x and y initially to 1.

**Mooshey** · 02-03-2008, 08:21 PM

Thank you.
I have added the ing constraint to Solver.
Is there a way to make sure that solver rounds the variables down?
I am thinking that if we are talking about a factory that makes tables for example, the rounding should always be round-down type, because rounding up might mean that we are using materials or time that the factory doesn't have.
Does it make sence?