Load Planning

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
10,990
..then I have no idea how to "fit" different size pallets onto a lorry footprint. ...maybe make your biggest pallet the only one you use ... or... have some blueprint layouts for different combinations of pallets in the form of posters on warehouse walls....
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
10,990
if your lorry has a length L and a width W then pallet lengths should be L/8 L/6 L/4 L/3
and widths W/8 W/6 W/4 W/3 W/2

= 20 pallet sizes
 

AhoyNC

Well-known Member
Joined
Oct 10, 2011
Messages
4,410
Office Version
365
Platform
Windows
You may want to look at the following link. Under the video is a link to download the program and a PDF.
https://www.youtube.com/watch?v=-0MCkd-CjD0

I think you are going to find it rather difficult to do this in Excel and would be better off using one of the commercial programs available.
 

Watch MrExcel Video

Forum statistics

Threads
1,089,930
Messages
5,411,322
Members
403,359
Latest member
Automationlover899

This Week's Hot Topics

Top