Determining Box size from Product Dimensions (LxWxH)

[czhang96]

Hello all,

First time poster here. I am creating a comprehensive product analyzer for my company and I am stuck on one part of it. To preface this problem, I will give a little bit of background about the business to hopefully shed some light on the issue. We are an e-commerce company that sells vitamins/supplements in bulk to Amazon where it sits in a fulfillment center until customers order it, in which case it is sent directly from the fulfillment center to the customer. Since most of our products are relatively small and don't weight much, we are usually putting 60+ products in the same box before we ship it to Amazon. Sometimes, depending on the material, we can just throw the products into a box, but other times the product will require additional packaging such as a Bubble Envelope or a Box. The box is where I am having trouble.


[TABLE="width: 500"]
<tbody>[TR]
[TD]Volume
[/TD]
[TD]Length
[/TD]
[TD]Width
[/TD]
[TD]Height
[/TD]
[TD]Box Type
[/TD]
[/TR]
[TR]
[TD]1152
[/TD]
[TD]12
[/TD]
[TD]12
[/TD]
[TD]8
[/TD]
[TD]Box 12x12x8
[/TD]
[/TR]
[TR]
[TD]504
[/TD]
[TD]14
[/TD]
[TD]6
[/TD]
[TD]6
[/TD]
[TD]Box 14x6x6
[/TD]
[/TR]
[TR]
[TD]480
[/TD]
[TD]10
[/TD]
[TD]8
[/TD]
[TD]6
[/TD]
[TD]Box 10x8x6
[/TD]
[/TR]
[TR]
[TD]432
[/TD]
[TD]12
[/TD]
[TD]6
[/TD]
[TD]6
[/TD]
[TD]Box 12x6x6
[/TD]
[/TR]
[TR]
[TD]324
[/TD]
[TD]9
[/TD]
[TD]6
[/TD]
[TD]6
[/TD]
[TD]Box 9x6x6
[/TD]
[/TR]
[TR]
[TD]216
[/TD]
[TD]9
[/TD]
[TD]6
[/TD]
[TD]4
[/TD]
[TD]Box 9x6x4
[/TD]
[/TR]
[TR]
[TD]192
[/TD]
[TD]8
[/TD]
[TD]6
[/TD]
[TD]4
[/TD]
[TD]Box 8x6x4
[/TD]
[/TR]
[TR]
[TD]180
[/TD]
[TD]9
[/TD]
[TD]5
[/TD]
[TD]4
[/TD]
[TD]Box 9x5x5
[/TD]
[/TR]
[TR]
[TD]175
[/TD]
[TD]7
[/TD]
[TD]5
[/TD]
[TD]5
[/TD]
[TD]Box 7x5x5
[/TD]
[/TR]
[TR]
[TD]144
[/TD]
[TD]9
[/TD]
[TD]4
[/TD]
[TD]4
[/TD]
[TD]Box 9x4x4
[/TD]
[/TR]
[TR]
[TD]128
[/TD]
[TD]4
[/TD]
[TD]4
[/TD]
[TD]8
[/TD]
[TD]Box 4x4x8
[/TD]
[/TR]
[TR]
[TD]96
[/TD]
[TD]6
[/TD]
[TD]4
[/TD]
[TD]4
[/TD]
[TD]Box 6x4x4
[/TD]
[/TR]
</tbody>[/TABLE]

These are all the boxes that we currently have that products might be placed into before going into the final box. On one sheet of the program, I have a section for the user to input the Length, Width, and Height of the product and whether or not it will need to go into a box. So, in summary, my question is: based on the LxWxH of the product, how would I get this program to spit out the box type needed while ensuring the product will fit in the additional box. If anybody needs some clarification, please let me know.

Thank you in advance

 

[Eric W]

We answered a similar problem recently. Check out this topic:

https://www.mrexcel.com/forum/excel...roduct-xs-dimensions.html?highlight=dimension

Let us know if that works for you, or if you have additional questions.

 

[czhang96]

Thank you very much this was very helpful. Sorry for posting a similar problem!

 

[Eric W]

No problem! Sometimes finding an answer that already exists is as hard as recreating it. I'm glad I could point you in the right direction.