Function for calculation volume and packing

B

bob

Hello All,

I'm a Belgian, dutch speaking guy, and I am looking for quite some time for
a formula for the following problem :

We recieve goods in cartons of different sizes and would like to know in
advance (before we recieve them) howmany of these cartons (of which we have
the exact dimensions) we can put on 1 Pallet (120 cm x 80 cm) on 1
warehouselocation (height 1900 cm).
Can anyone of you wizzards send me a good formula for this or maybe even an
excel function?

Many thanks in advance, this would really be a great help.
Best regards,
Bob
 
R

rob

how high is a pallet load?
in general, mathematically:

# on a pallet = pallet volume / box h X w X l

Thats why I need the pallet height... pallet volume
cannot be comuted without the length, width, and height of
a standard pallet.

Also, you'd have to watch how many boxes you stack, each
package usually has a differrent specification for that...
 
B

bob

Dear Rob,

Thank you very much for the quick reply.
Unfortunatly I probably did not put the problem into the real perspectives.

I know the most common way is to calculate the total volume (in this case
120 x 80 x 190 cm) and divide that by the volume of 1 box (LxWxH).
Unfortunatly, that is not the problem.

I'll try to explain better by an example :
1 carton measures 55 x 35 x 45 cm
The pallet is 120 x 80 cm
The hight of this pallet warehouslocation is 190 cm

Before the goods arrive, we would like to know exactly howmuch cartons can
be fit on that pallet, in that specific warehouselocation , as ECONOMICAL as
possible, without having cartons exceeding the pallet itself, and being
able to put as much cartons on a pallet as possible in order not to loose
warehouse space.
We would like being able to instruct our suppliers to use a specific
cartonsize for that specific product in order to optimise the warehouse
capacity.
I know this is not simple at all, but if you could help by a formula, you
would have made my day.

Thanks in advance.
Best regards,
Bob


----- Original Message -----
From: "rob" <[email protected]>
Newsgroups: microsoft.public.excel.worksheet.functions
Sent: Thursday, August 21, 2003 9:31 PM
Subject: Function for calculation volume and packing
 
B

bob

Dear John,


Thank you very very much. Scamecania is exactly the software we need, this
is excellent, really great.
I will urge my boss to buy it immediatly.
Many many thanks for your help, you have no idea howmuch time and money this
will save us.

Bob
 
Top