How would you do this calculation?

[cvegas]

I can ship 70 pounds with an airline going over the counter. They will
accept a box that is no more than 90 inches overall and weighs no more than
70 pounds. I have a box that is 36x22x22 which is 80 inches overall.

I would like to calculate how many smaller boxes I can put in the larger
"Master Box"

I think I would need to answer four questions before doing the calclulation

What is the average weight of the packages being shipped?
What is the average length of each package
What is the average width of each package
What is the average height of each package.

For this example lets say the average weight was 1 pound
Average length = 4 inches
Average width = 2 inches
Average height = 3 inches

How many of these packages could I get in the "Master Box" before getting to
the 70 pound limit?

Any help would be appreciated.

 

[Shane Devenshire]

Hi,

You should look into Solver, the add-in that comes with Excel. This is the
type of problem which it can be used to solve. Google Solver Solutions for
examples and techniques.

You attach Solver by choosing Tools, Add-ins and checking the appropriate box.

If this helps, please click the Yes button

cheers,
Shane Devenshire

 

[Gord Dibben]

36x22x22 is 17424 cubic inches.

4x3x2 is 24 cubic inches.

You could theoretically place 726 small boxes into the larger one.

That would give you 726 pounds.

You do the math from here.


Gord Dibben MS Excel MVP

 

[cvegas]

I will research how you determine cubic dimenisons and should be able to
figure it out from that point.

Great help

Thanks