Constraint Modeling for Solver

[IrishHawk01]

I think my logic is a little off...

I have three products (Small, Medium, Large)-produced across 3 plants/locations:

Product
S=Small
M=Medium
L= Large

Plant 1=1
Plant 2=2
Plant 3=3

Constraint: Production of Small cannot be greater than 5x the production of Medium

5(Xs1+Xs2+Xs3)<= (Xm1+Xm2+Xm3)
5(Xs1+Xs2+Xc3) - 1(Xm1+Xm2+Xm3) <= 0
5(Xs1+Xs2+Xs3) - 1(Xm1+Xm2+Xm3) + 0(XL1+XL2+XL3) <= 0

Production of Large cannot be greater than 5x the production of medium

5(XL1+XL2+XL3)<= (Xm1+Xm2+Xm3)
5(XL1+XL2+XL3) - 1(Xm1+Xm2+Xm3) <= 0
5(XL1+XL2+XL3) - 1(Xm1+Xm2+Xm3) + 0(Xs1+Xs2+Xs3) <= 0

Cell Ranges that I've created:

[TABLE="width: 1306"]
<tbody>[TR]
[TD][/TD]
[TD="colspan: 5"]Small[/TD]
[TD][/TD]
[TD="colspan: 5"]Medium[/TD]
[TD][/TD]
[TD="colspan: 5"]Large[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Xs₁[/TD]
[TD][/TD]
[TD]Xs₂[/TD]
[TD][/TD]
[TD]Xs₃[/TD]
[TD][/TD]
[TD]X_m1[/TD]
[TD][/TD]
[TD]X_m2[/TD]
[TD][/TD]
[TD]X_m3[/TD]
[TD][/TD]
[TD]XL₁[/TD]
[TD][/TD]
[TD]XL₂[/TD]
[TD] XL₃ [/TD]
[TD][TABLE="width: 197"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] -[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Production of Small cannot be greater than 5x production of Medium[/TD]
[TD]5[/TD]
[TD]+[/TD]
[TD]5[/TD]
[TD]+[/TD]
[TD]5[/TD]
[TD]+[/TD]
[TD]-1[/TD]
[TD]+[/TD]
[TD]-1[/TD]
[TD]+[/TD]
[TD]-1[/TD]
[TD]+[/TD]
[TD]0[/TD]
[TD]+[/TD]
[TD]0[/TD]
[TD]+[/TD]
[TD]0 (0) <= 0[/TD]
[/TR]
[TR]
[TD]Production of Large cannot be greater than 5x production of Medium[/TD]
[TD]0[/TD]
[TD]+[/TD]
[TD]0[/TD]
[TD]+[/TD]
[TD]0[/TD]
[TD]+[/TD]
[TD]-1[/TD]
[TD]+[/TD]
[TD]-1[/TD]
[TD]+[/TD]
[TD]-1[/TD]
[TD]+[/TD]
[TD]5[/TD]
[TD]+[/TD]
[TD]5[/TD]
[TD]+[/TD]
[TD]5 (0) <= 0[/TD]
[/TR]
</tbody>[/TABLE]


Something appears to be off in my results.....just want to double check my logic on this one.

 

[IrishHawk01]

Problem Solved:

No need to reply.