Load Planning

NWoodard

New Member
Joined
Aug 16, 2018
Messages
5
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,
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

NWoodard

New Member
Joined
Aug 16, 2018
Messages
5
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

Board Regular
Joined
Apr 11, 2010
Messages
10,990
if pallets are different widths and lengths they may leave a lot of redundant space - unless they are cunningly sized...
 

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
10,990
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

New Member
Joined
Aug 16, 2018
Messages
5
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.

PART #Rack CodeWeightPack DensityLWH
1a1088280483626
2a1087280483626
3a1089280483626
4a1081280483626
5a868420483626
6a860420483626
7b126633704853
8b126933704853
9c104363564836
10c112772564853
11c96854564853
12d107824784876
13d107624784876
14e104942484853
15e105642484853

<colgroup><col><col><col><col><col span="3"></colgroup><tbody>
</tbody>
 

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
10,990
is part 9 H= 36 ?

<tbody>
</tbody>
 

NWoodard

New Member
Joined
Aug 16, 2018
Messages
5
9c104363564853
10c112772564853

<tbody>
</tbody>

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

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
10,990
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

New Member
Joined
Aug 16, 2018
Messages
5
Unfortunately our product shipping is different lengths/widths, thus calling for different pallet sizes!
 

Forum statistics

Threads
1,089,264
Messages
5,407,252
Members
403,131
Latest member
Lewas2019

This Week's Hot Topics

Top