My question: I want to use formula to decide optimal box to use for each product - minimizing extra air space in box and using smallest box possible to fit product.
I also want to establish, using a formula how efficient my box packing is. So maybe need a % of how much extra space will be in each dimension and then all dimensions.
1) I have boxes w dimensions (LxWxH in mm)
Box 1 - 336 162 116
Box 2 - 311 161 108
Box 3 - 520 380 107
Box 4 - 465 360 107
Box 5 - 343 187 120
Box 6 - 325 192 120
2) I have product dimensions (LxWxH in inches)
Product 1 - 10.444 9.375 1.125
Product 2 - 10.555 10.125 2.125
Product 3 - 11.777 9.875 3.125
Product 4 - 12.888 8.313 4.125
Product 5 - 11.000 5.500 5.250
is there a formula that will select the BEST (OPTIMAL) box to put product in taking all LxWxH criteria into account?
For example:
Product 4 cannot fit in box 2 because 12.888in product length is bigger than 311 mm (12.244 inches) box length.
The examples used are ones pulled out of my head, I hope suggested formula works across a variety of box and product combinations.
Thank you for the help, excel wizards
I also want to establish, using a formula how efficient my box packing is. So maybe need a % of how much extra space will be in each dimension and then all dimensions.
1) I have boxes w dimensions (LxWxH in mm)
Box 1 - 336 162 116
Box 2 - 311 161 108
Box 3 - 520 380 107
Box 4 - 465 360 107
Box 5 - 343 187 120
Box 6 - 325 192 120
2) I have product dimensions (LxWxH in inches)
Product 1 - 10.444 9.375 1.125
Product 2 - 10.555 10.125 2.125
Product 3 - 11.777 9.875 3.125
Product 4 - 12.888 8.313 4.125
Product 5 - 11.000 5.500 5.250
is there a formula that will select the BEST (OPTIMAL) box to put product in taking all LxWxH criteria into account?
For example:
Product 4 cannot fit in box 2 because 12.888in product length is bigger than 311 mm (12.244 inches) box length.
The examples used are ones pulled out of my head, I hope suggested formula works across a variety of box and product combinations.
Thank you for the help, excel wizards