Matrix

[Guest]

I am putting together a freight matrix to calculate the loadfactor on
truckloads. I have run into a problem with some of the product because it
cubes out the truck verses weighing out the truck. On the product that
weighs out, I am able to use the IF function to make sure I am shipping the
maximum weight allowed per truckload without being to heavy. On the product
that cubes out, I need a way to recognize that product in a formula by
converting the cube size to a number that will let me know that it is a cube
product issue and that is why the maximum truckload weight is not attained.

Please Help!

 

[Guest]

Excel geeks probably don't know much about Cube vs Weight for trucking.
Perhaps you can give us more info? What is an example of a Cube value? Is
it a measure of the area inside of the truck? Perhaps give us sample data
for one with a weight and then one that is cubed?

 

[Guest]

Yes,

It is a measure of the area inside of the truck? For example:

Product A - Is on a 48X48 pallet and weighs 1544#. Maximum weight on a
truckload is 41,000#. You could fit a maximum 28 pallets on the truck but
the weight won't allow you to load 28 pallets so you load 26 pallets to make
a truckload.

Product B - Is on a 48X60 pallets and weighs 1197#. In this case, the
product weighs less but the pallets are bigger; so they will cube out to make
a truckload before they reach the weight maximum.

The formula being used for product A is:
=+IF(G61>35300,"OverWeight",35300-G61; it allows me to plug in a number of
pallets and then it will let me know how close I am to a full truckload. But
I can't figure out how to do this with product B because it cubes out the
truck.

 

[Guest]

Well it looks like you will be comparing volumes (or areas) rather than
comparing weights. In your first case you say that you can fit 28 48x48
pallets on the truck but are limited to 26 due to the weight.

I would think that you need to calculate how many of the 48x60 pallets will
fit into the truck. 48 by 60 is 48 inches by 60 inches I take it? Are all
pallets the same height?

 

[Alan Beban]

This could be more complicated than the data provided so far can
accommodate. What is the volume of a truck? And what are its 3
dimensions? For a ridiculous example, but to make the point, if a truck
is 36 inches wide, 240 inches long and 96 inches high, then although it
has a volume of 450 cubic feet you can't put even 1 48x60 pallet in it
because it isn't wide enough.

Alan Beban