3.11 Extension 10: Load Zoning

Download Workbook: pdp_extension_10.xlsx.

In the previous example, we used order and vehicle attributes to define vehicle delivery zones. Sometimes, we do not want to restrict where a vehicle operates but do want to ensure that all the deliveries in a load occur in a given area. This is called load zoning.

As with vehicle zoning, we label the orders with zone attributes but this time we use the Order-Order Compatibility sheet to require that only orders with compatible zones are loaded on the vehicle at the same time.

The Order-Order Compatibility sheet must be symmetric. The order in which attributes are listed in the first column must match the order in which they are listed in the first row.

Table 21 shows an excerpt from the Order-Order Compatibility sheet of the accompanying workbook. A cell containing TRUE means that the orders with the attributes in that column and row are compatible with each other. In this example, Zone_2 is compatible with Zone_3. This means that orders labelled with Zone_2 and Zone_3 are allowed to be loaded on the vehicle at the same time. Note that Zone_3 is also compatible with Zone_4, but because Zone_4 is not compatible with Zone_2, orders from Zone_2 and Zone_4 cannot be loaded on the vehicle at the same time.

Zone_1 Zone_2 Zone_3 Zone_4 Zone_5
Zone_1
TRUE TRUE
Zone_2
TRUE TRUE TRUE
Zone_3
TRUE TRUE TRUE
Zone_4
TRUE TRUE TRUE
Zone_5
TRUE TRUE
Table 21: Order-order compatibility.
Load Order Zone
1
Order9 Zone_5
Order12 Zone_6
Order10 Zone_5
Order11 Zone_6
2
Order1 Zone_1
Order4 Zone_2
Order2 Zone_1
Order3 Zone_2
3
Order8 Zone_4
Order6 Zone_3
Order5 Zone_3
Order7 Zone_4
4
Order16 Zone_8
Order15 Zone_8
Order14 Zone_7
Order13 Zone_7
5
Order20 Zone_10
Order18 Zone_9
Order17 Zone_9
Order19 Zone_10
Table 22: Load zones visited.

Table 22 is a summary of the orders in each load. You can see that each order is zone compatible with all the other orders in its load.