3.10 Extension 9: Vehicle Zoning

Download Workbook: pdp_extension_9.xlsx.

Opturion Freight wants to restrict each vehicle to make deliveries only in its own specific area or areas. This is called vehicle zoning. To do this, we label each order with an attribute identifying the zone in which its delivery location is located. We then label each vehicle with attributes identifying the zones it is allowed to deliver in. Finally, we set up order-vehicle compatibility rules between the zone attributes on the orders and vehicles. Attributes and order-vehicle compatibility are described in Section 3.6.

Table 17 shows the delivery zones that Opturion Freight wants to use. Listed next to each zone are the vehicles that are allowed to make deliveries in that zone. Here, Vehicle1 is only allowed to make deliveries in Zone_1 or Zone_2. Deliveries in Zone_2 may be made by either Vehicle1 or Vehicle2.

Zone
Locations
Allowed Vehicles
Zone_1 CHELTENHAM MENTONE Vehicle1
Zone_2 SANDRINGHAM HAMPTON Vehicle1, Vehicle2
Zone_3 MOORABBIN HIGHETT Vehicle2
Zone_4 ORMOND BENTLEIGH Vehicle2
Zone_5 BALACLAVA RIPPONLEA Vehicle3
Zone_6 WINDSOR PRAHRAN Vehicle3
Zone_7 SOUTH YARRA RICHMOND Vehicle4
Zone_8 HAWTHORN AUBURN Vehicle4
Zone_9 IVANHOE HEIDELBERG Vehicle5
Zone_10 TOORAK ARMADALE Vehicle5
Table 17: Zone locations and vehicles.

In the accompanying workbook, we set up the above zoning by first adding the zone attributes to the Attributes column of the Orders sheet.

Id Delivery Location Attributes
Order1 CHELTENHAM Zone_1
Order2 MENTONE Zone_1
Order3 SANDRINGHAM Zone_2
Order4 HAMPTON Zone_2
Order5 MOORABBIN Zone_3
Table 18: Order attributes for zones.

Table 18 shows the first five orders in the Orders sheet. The attribute identifies what zone an order’s delivery location is in.

We then label the vehicles in the Fleet sheet with attributes identifying what zones the vehicle is allowed to deliver to.

Id Attributes
Vehicle1 Zone_1;Zone_2
Vehicle2 Zone_2;Zone_3;Zone_4
Vehicle3 Zone_5;Zone_6
Vehicle4 Zone_7;Zone_8
Vehicle5 Zone_9;Zone_10
Table 19: Vehicle attributes for zones.

Table 19 shows an excerpt from the Fleet sheet in the accompanying workbook. The Attributes column lists which zones each vehicle can deliver to. Vehicles that can deliver to multiple zones have each zone attribute separated by a semicolon.

Compatibility between the order and vehicle attributes is defined in the Order-Vehicle Compatibility sheet. The order attributes are in the left column and the vehicle attributes are in the first row.

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

Table 20 is a summary of the delivery locations visited by each vehicle. Each location visited by a vehicle is in one of the zones the vehicle is allowed to deliver to.

Vehicle
Delivery Locations
Vehicle1 CHELTENHAM MENTONE
Vehicle2 BENTLEIGH HAMPTON HIGHETT MOORABBIN
ORMOND
SANDRINGHAM
Vehicle3 BALACLAVA PRAHRAN RIPPONLEA WINDSOR
Vehicle4 AUBURN HAWTHORN RICHMOND SOUTH YARRA
Vehicle5 ARMADALE HEIDELBERG IVANHOE TOORAK
Table 20: Delivery locations visited.

In this example, we used zoning to restrict where vehicles can deliver. We can apply zoning to pickups in a similar manner.