Boxes per pallet help

Do you need this for any possible box size, or do you have a specific selection of box sizes to choose from? Do you need to mix box sizes on the same pallet? Do you have the flattened sizes of the boxes, or does the solution need to take the box size and add the flap dimensions?

You will also need to know the flat thickness of each box size to determine the limit of the stack size.

Is the 4" overhang on all 4 sides of the pallet, or do you have to have one side flush for forklift access?

I am not sure this can be done with formulas. It depends on the answers to the above. It may require VBA to iterate through different combinations to optimize loading.

Originally Posted by 6StringJazzer

Do you need this for any possible box size, or do you have a specific selection of box sizes to choose from? Do you need to mix box sizes on the same pallet? Do you have the flattened sizes of the boxes, or does the solution need to take the box size and add the flap dimensions?

You will also need to know the flat thickness of each box size to determine the limit of the stack size.

Is the 4" overhang on all 4 sides of the pallet, or do you have to have one side flush for forklift access?

I am not sure this can be done with formulas. It depends on the answers to the above. It may require VBA to iterate through different combinations to optimize loading.

This can get quite complicated. The 4" overlap is only useful if the stacked boxes are stable with the overhang. This is particularly troublesome at the corners. I imagine the OP is expecting the flattened boxes to be rectangular. However this does not have to be the case! Mind you if everything is rectangular and a pallet only has boxes of one size it doesn't get too complicated unless you are trying to achieve and mathematically prove "best fit".