Hey Everyone,
I'm very impressed by this initial thread in 2018. 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.

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, 23 views)