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 |
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 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 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 | ||
In this example, we used zoning to restrict where vehicles can deliver. We can apply zoning to pickups in a similar manner.

