Hi ,
If we sort the data in your input data range by the ranking , then the top-ranked items which add up to 72 are almost the same as what you have manually entered in the output range.
The only items are 40141 and 40180 where you have considered 2 bins each for what have been mentioned as HALF items ; the first point you need to clarify is the basis for deciding whether a HALF item is to be taken as 1 or 2 ?
Narayan
First, the items have to remain in order of it's description which is the order the items are laid out in the Original Product List. A FULL item always requires 2 spaces or one FULL bin. A HALF bin typically requires a HALF bin meaning you need 2 HALF's to fill a bin. The problem is that when there is an odd number of HALF items in a group then the last HALF becomes requires 2 spaces because it can't share a bin with a FULL item.
Example FULL, HALF, HALF, HALF, FULL would require 4 bins or 8 spaces because the third HALF in that group would have to be by itself.
Example FULL, HALF, HALF, HALF, HALF, FULL would also require only four bins.
Example HALF, FULL, HALF, FULL is another that requires four bins.
Therefore the space requirements change based on the way the items would layout in the Finished List. Somehow I have to look at how many spaces are available, and how many of the top ranking items would fit based on their space requirements. In the example on the sheet there are 72 available spaces but only the top ranked 59 items actually fit.
Thanks,
