Load Planning

[NWoodard]

Hello,

I am looking for a spread sheet which will allow me to "cube" a trailer based, either by weight or space. Trailer and pallet restrictions/dimensions will vary depending on the ship to destination. I am targeting an excel based program due to in house restrictions (I have found other software to perform the tasks but prefer excel).

Does anyone have a sheet already designed or created that may meet these requirements?

Thanks,

 

[oldbrewer]

what does cube a trailer mean please ?

 

[NWoodard]

Cubing a trailer means filling it up. Essentially, we would have several different pallets (different sizes, weights etc.) and I would like t have an excel spreadsheet that shows the trailer filling up to its max (either weight or space, whatever comes first).

Below is a link to an online tool which completes this, but I do not want to use this tool for our 200+ trucks a day.

http://www.pier2pier.com/loadcalc/equipment

 

[oldbrewer]

if pallets are different widths and lengths they may leave a lot of redundant space - unless they are cunningly sized...

 

[oldbrewer]

if you said each trailer carries a maximum of 10 pallets and pallets are either 6 ft by 6 ft OR 6 ft by 3 ft then we can make a start........

 

[NWoodard]

Below is an example of some of the data I work with. We have 15 different part numbers, but only use 5 different containers (for this customer). The length, width and height of the package will be set (same with the trailer). I can quickly identify how many pallets are allowed to go beside one another, and how many can stack on top of one another if that helps. Essentially, the customer tells us how many pieces of a part they want, we determine how many pallets that is, and then have to determine how many trucks that is. We have a very manual, none visual way of completing this today, and we are looking to modernize it and provide visual templates to our drivers loading the material.

[TABLE="width: 558"]
<colgroup><col><col><col><col><col span="3"></colgroup><tbody>[TR]
[TD]PART #[/TD]
[TD]Rack Code[/TD]
[TD]Weight[/TD]
[TD]Pack Density[/TD]
[TD]L[/TD]
[TD]W[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]a[/TD]
[TD]1088[/TD]
[TD]280[/TD]
[TD]48[/TD]
[TD]36[/TD]
[TD]26[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]a[/TD]
[TD]1087[/TD]
[TD]280[/TD]
[TD]48[/TD]
[TD]36[/TD]
[TD]26[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]a[/TD]
[TD]1089[/TD]
[TD]280[/TD]
[TD]48[/TD]
[TD]36[/TD]
[TD]26[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]a[/TD]
[TD]1081[/TD]
[TD]280[/TD]
[TD]48[/TD]
[TD]36[/TD]
[TD]26[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]a[/TD]
[TD]868[/TD]
[TD]420[/TD]
[TD]48[/TD]
[TD]36[/TD]
[TD]26[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]a[/TD]
[TD]860[/TD]
[TD]420[/TD]
[TD]48[/TD]
[TD]36[/TD]
[TD]26[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]b[/TD]
[TD]1266[/TD]
[TD]33[/TD]
[TD]70[/TD]
[TD]48[/TD]
[TD]53[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]b[/TD]
[TD]1269[/TD]
[TD]33[/TD]
[TD]70[/TD]
[TD]48[/TD]
[TD]53[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]c[/TD]
[TD]1043[/TD]
[TD]63[/TD]
[TD]56[/TD]
[TD]48[/TD]
[TD]36[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]c[/TD]
[TD]1127[/TD]
[TD]72[/TD]
[TD]56[/TD]
[TD]48[/TD]
[TD]53[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]c[/TD]
[TD]968[/TD]
[TD]54[/TD]
[TD]56[/TD]
[TD]48[/TD]
[TD]53[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]d[/TD]
[TD]1078[/TD]
[TD]24[/TD]
[TD]78[/TD]
[TD]48[/TD]
[TD]76[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]d[/TD]
[TD]1076[/TD]
[TD]24[/TD]
[TD]78[/TD]
[TD]48[/TD]
[TD]76[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]e[/TD]
[TD]1049[/TD]
[TD]42[/TD]
[TD]48[/TD]
[TD]48[/TD]
[TD]53[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]e[/TD]
[TD]1056[/TD]
[TD]42[/TD]
[TD]48[/TD]
[TD]48[/TD]
[TD]53[/TD]
[/TR]
</tbody>[/TABLE]

 

[oldbrewer]

[TABLE="class: cms_table, width: 558"]
<tbody>[TR]
[TD] is part 9 H= 36 ?[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[NWoodard]

[TABLE="class: cms_table, width: 558"]
<tbody>[TR]
[TD]9[/TD]
[TD]c[/TD]
[TD]1043[/TD]
[TD]63[/TD]
[TD]56[/TD]
[TD]48[/TD]
[TD]53[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]c[/TD]
[TD]1127[/TD]
[TD]72[/TD]
[TD]56[/TD]
[TD]48[/TD]
[TD]53[/TD]
[/TR]
</tbody>[/TABLE]

Sorry, it should read 53 - the same as part 10 as it is the same pallet.

 

[oldbrewer]

if a lorry can carry say 20 of the 48 long, 15 of the 70 long, 18 of the 56 long and 10 of the 78 long and you check the weight of the 48, 70, 56 and 78 to ensure lorry not overloaded I do not see the issue - yet - lol. Why not go to a standard pallet size so say lorries carry 40 pallets unless weight reduces this....

 

[NWoodard]

Unfortunately our product shipping is different lengths/widths, thus calling for different pallet sizes!