Optimization Tool issue

[feethsn]

Hi, I am trying to use the optimization tool for allocation. The issue i am having is that when i do not have enough capacity i do not want the tool to optimisize to that variable. I have tried to manage this by setting the upper and lower bounds for said variable to the same number but this creates an error " no feasible solutions" 

i.e in the example below i would expect it to allocate the 9 to 'Pants' and if there were 10 to allocation to jackets? - Just wondering if there is a different way to set the tool to solve this?

[AkimasaKajitani]

Hi @feethsn 

In this occasionally, the "no feasible solutions" is correct. Because your setting is that the number of Jackets is fixed at 10 and rhs is less than 9. This is contradictory.

If you want to make an obvious distinction between 10 and less than 9, I recommend to bypass before Optimization tool.

[apathetichell]

Exactly as @AkimasaKajitani said  with a 10 an LB in jackets you have an inequality of 10 (lb +lb) <= 9 <= 19 (ub +ub)... obviously - this can't happen.

Perhaps you can spend a bit more time explaining the results you'd want to see in different scenarios?

[feethsn]

Hi, All thank you 

The scenario is around order fill - I would like to be able to tell the optimisation tool to only allocate material to a certain variable if it can make the full order. i.e i have 1 order for 10 but i cannot sell short so i would like it to not try to allocate to that variable if it knows there is not enough to make the full order?

[apathetichell · Accepted solution]

I think your optimization is a binary optimization with 0 and 1 being your two options. You have 10 and 9 as the material requirements but 0 and 1 are your upper/lower bounds. This way if there is less than 10 in material instead of producing an error - you'd get a zero, i.e. a non-allocation.

[feethsn]

That makes sense - Brilliant thank you so much