Iterate Pallets to Pick Best Option

In this example, we will explain how the Advanced Input Options in Quick Pallet Maker can be used for picking the best custom pallet type for a given box shipment.
The first step is to add the list of custom pallets. For this, we will first select the Window - Standard Cases and Pallets menu option.
Window - Standard Cases and Pallets

Window - Standard Cases and Pallets

The Standard Cases and Pallets window will appear, we click on the Pallets tab to show the list of standard (available) pallets.
Standard Pallets

Standard Pallets

The custom list of pallets that we will be using, can be pasted from a spreadsheet using the following format:
  • Use: type TRUE if this pallet will be enabled from the start
  • Code: The unique pallet identifier
  • Description: A longer description of the pallet
  • Length: the longest dimension of the pallet
  • Width: the shortest dimension of the pallet
  • Height: the height of the pallet itself
  • Weight: the weight of the empty pallet
  • Units: choose between mm/kg, cm/kg or in/lbs
Please note that this format does not include the load constraints (length, width and height), so this information will need to be edited later. An example Excel spreadsheet is available through this link.
Copy from Spreadsheet

Copy from Spreadsheet

We select the list of pallets and copy them from the spreadsheet. Then, we go to the pallet table in Quick Pallet Maker and right-click to paste them.
Paste on Pallet List

Paste on Pallet List

The new pallet list should appear, with the dimensions from the spreadsheet. We will need to increase the maximum load height from the original 70 inches to 90 inches. This is done by clicking on the cell and editing it. We repeat that procedure for all new custom pallets.
Pallet List

Updated Pallet List

The next step is to open the window in which we will calculate how many boxes can be palletized. We do this by selecting New Data Sheet - Box on Pallet.
New Data Sheet - Box on Pallet

New Data Sheet - Box on Pallet

Since we will be working with inches, we need to change the units for the document window if the selected units are different. For this, we use Tools - Units - in/lbs.
Tools - Units

Tools - Units

Then, we go to the spreadsheet with the list of boxes that we will be using. An example spreadsheet is available through the following link. We select the area in yellow with the box data and then choose Copy.
Copy Boxes

Copy Boxes

We go back to the QPM window we opened and then right-click the central table to select Paste.
Paste Boxes

Paste Boxes

The list of boxes should appear. We will leave just the upright position selected because in this case, we are not allowed to flip them on their sides.
Box List

Box List

The next step is to open the Iteration window. This is done by selecting Tools - Advanced Input Options.
Advanced Input Options

Advanced Input Options

A small window with two tabs will appear. We select the Inventory tab and check all of the new pallet types we pasted at the beginning of this example. Then we click on OK.
Pallet Inventory

Pallet Inventory

After that, Quick Pallet Maker will start calculating the different pallets and then choose the size that fit the most boxes and required the least amount of pallets to do so. It will display these pallets in a list.
Available Solutions

Available Solutions

To generate a report, we can select all of the pallets and then File - Print Report.
File - Print Report

File - Print Report

A new window will appear with the list of pallets and all their contents.
Pallet Shipment Report

Pallet Shipment Report