IrishHawk01
New Member
- Joined
- Mar 20, 2014
- Messages
- 4
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:
<tbody>
</tbody>
Something appears to be off in my results.....just want to double check my logic on this one.
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:
Small | Medium | Large | |||||||||||||||||||||
Xs1 | Xs2 | Xs3 | Xm1 | Xm2 | Xm3 | XL1 | XL2 | XL3 |
<tbody> </tbody> | ||||||||||||||
Production of Small cannot be greater than 5x production of Medium | 5 | + | 5 | + | 5 | + | -1 | + | -1 | + | -1 | + | 0 | + | 0 | + | 0 (0) <= 0 | ||||||
Production of Large cannot be greater than 5x production of Medium | 0 | + | 0 | + | 0 | + | -1 | + | -1 | + | -1 | + | 5 | + | 5 | + | 5 (0) <= 0 |
<tbody>
</tbody>
Something appears to be off in my results.....just want to double check my logic on this one.