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,
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
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
 
Upvote 0
if pallets are different widths and lengths they may leave a lot of redundant space - unless they are cunningly sized...
 
Upvote 0
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........
 
Upvote 0
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>
 
Upvote 0
9c104363564853
10c112772564853

<tbody>
</tbody>

Sorry, it should read 53 - the same as part 10 as it is the same pallet.
 
Upvote 0
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....
 
Upvote 0
Unfortunately our product shipping is different lengths/widths, thus calling for different pallet sizes!
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,251
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top