# Calculation of Loads Based on Normalized Number of Pallets

By Pavel Novikov, Senior Functional Consultant, Industry Consulting Service (ICS)

Let’s formulate the problematic of the task. It is required to calculate loads in pallets or other cargo places (hereinafter we will use pallets) for planned orders where the lines of one order are not to be divided into different loads. A vehicle’s load capacity should be determined by the number of pallets of the required type and the permissible weight capacity of the vehicle. The vehicle’s capacity is not controlled by volume, it is assumed that the vehicle loading height will not be exceeded by limiting the height of loaded pallets. If a vehicle is loaded with different types of pallets, which mostly match each other well in the vehicle, the capacity of the vehicle with different types of pallets can be determined by recalculating the different types of pallets into one target pallet type. Let’s assume that items are shipped in boxes. The number of boxes that can be placed on a pallet is specified for items. Boxes of different items can be placed well together on a pallet allowing different items to be consolidated on the same pallet. We assume that if different items are placed on one pallet, you can calculate the filling of a pallet by adding up the calculated quantity of items on the pallets. Optionally, items of different customers can be placed on the same pallet. Such a mathematical model can calculate the vehicle's occupancy in pallets.

To implement this load building strategy in D365SCM, you need to enter cargo place units in the Container types table, e.g. EPAL (Euro pallet).

For items, you need to specify the cargo place unit and the unit conversion from boxes to cargo place units. The cargo place unit is defined in the Unit sequence groups as the largest unit. In our example, this would be the PL unit and the EPAL pallet type.

The capacity of the vehicle will be specified in cargo place units, so for load templates a new table should be included to specify the capacity in container types, e.g. 20 EPAL. The maximum weight capacity must also be specified.

Let’s now look at a load calculation scenario with the approach discussed above. Suppose we have three items for which unit conversion from boxes to pallets is specified:

TMS40

TMS41

TMS42

Physical dimensions of items:

TMS40

TMS41

TMS42

We need to calculate loads for these load template parameters: 10,000 kg weight capacity and 20 EPAL cargo place capacity.

There are 10 sales orders created with the following items and quantities in the Sales unit and Pallets unit:

The total number of pallets is then calculated for orders and the orders are sorted in descending order by the number of pallets and their weight:

The algorithm gives the following order allocation by loads: