Hey Everyone,
I'm very impressed by an initial thread in 2018 in this thread https://www.msofficeforums.com/post175661 . I haven't been able to find a source within our company to help with this...



I have a similar and more complex problem.

I would like to find the best fit box that would not go over 50% of the current box quantity, give a max head height of .5", give a volume utilization of 90% and return the best fit box to column "H".

My products are cylinders, if I can get more in a box by staggering them in a honey comb pattern then I would prefer to do that, while other items may fit better lined up. The products do sit on the flat side, so the diameter measurement in column "A" can be used as length and width.

-I don't know if this would be possible, but I would be open to creating new box dimensions based off of similarities and utilization needs if that can be worked into a separate sheet so I can compare the pros and cons of making the change.

We have over 40,000 items internally, so it would be a great help if I can apply an array to help with this.

Attached Files

Box_Problem_Multiple_Qty_Per_Box.xlsx (17.2 KB, 6 views)