3.6 Extension 5: Order-Vehicle Compatibility

Download Workbook: pdp_extension_5.xlsx.

Opturion Freight has a new requirement: heavy orders must only be loaded on a truck that has a tailgate loader. This requirement is an order-vehicle compatibility rule. It restricts what assignments of orders to vehicles are allowed.

You can describe the properties of vehicles and orders using labels called attributes. Attribute names, like identifiers, must not contain semicolons and are not case or white space sensitive. A vehicle or order may be labelled with any number of attributes. A vehicle or order identifier is automatically treated as one of its attributes.

Vehicle and order attributes are set in the Attributes column of the Fleet and Orders sheets respectively. Multiple attributes must be separated using semicolons. Order-vehicle compatibility rules are set up in the Order-Vehicle Compatibility sheet.

Note: the Order-Vehicle Compatibility sheet only allows you to define positive relationships between order and vehicle attributes. For further details, refer to Opturion Dynamic Transport Optimiser – Data Formats

In the accompanying workbook, we have added attributes and set up an order-vehicle compatibility rule that meets Opturion Freight’s new requirement. Heavy orders are labelled with the attribute HEAVY and vehicles that have at tailgate loader have been labelled with the attribute TAILGATE. Table 9 shows the Order-Vehicle Compatibility sheet from the accompanying workbook. The order attributes are listed in the first column, and the vehicle attributes are listed in the first row. The presence of TRUE in a cell corresponding to the HEAVY and TAILGATE attributes means the optimiser is only allowed to assign an order labelled with the HEAVY attribute to a vehicle labelled with the TAILGATE attribute.

We can also use order-vehicle compatibility rules to restrict the locations the vehicles are allowed to make pickups or deliveries at. While we cannot label locations directly with attributes, we can label the orders being picked up from, or delivered to, those locations with location specific properties.

For example, consider the situation where a location lacks a loading dock and vehicles must park on the street. Longer vehicles are not allowed to make pickups or deliveries at this location due to space restrictions. We have included this example in the accompanying workbook: orders that are picked up from, or delivered to, locations without a loading dock are labelled with the attribute NO DOCK. Vehicles that may be parked on the street are labelled with the attribute SHORT. Finally, in the Order-Vehicle Compatibility sheet we have set up a compatibility rule that requires orders with the NO DOCK attribute to only be assigned to vehicles with the SHORT attribute. This effectively imposes the restriction that longer vehicles cannot visit the location without a loading dock.

Vehicle Attributes
TAILGATE SHORT
Order Attributes
HEAVY TRUE
NO DOCK TRUE
Table 9: Order-vehicle compatibility.