3.3 Extension 2: Service and Site Times

Download Workbook: pdp_extension_2.xlsx.

In the solution of the previous example, you can see that the vehicles are loading and unloading instantaneously. In reality, it takes approximately thirty minutes to load a truck at the depot. Each order also requires a check after it has been loaded. This check takes one minute per order. Every delivery takes five minutes to complete.

DTO supports several different timings that can be used to model loading and unloading times. In this example, we introduce service time and site time.

  • Service time is the amount of time needed to service an order at a pickup or delivery stop. Orders can have separate pickup and delivery service times. Different orders can have different service times.
  • Site time is the amount of time needed when a vehicle visits a location. It is independent of the number of consecutive pickups and deliveries occurring at the location. It is also independent of any service time for the pickups and deliveries. Site time has many uses: it can be used to model loading times at depots, docking and engagement procedures, vehicle inspections etc. Note that if a vehicle leaves a location and later returns to that same location to do further pickups or deliveries then it will incur the site time again.

Returning to Opturion Freight, to model the thirty-minute loading time at the depot, we add the Site Time column to the Locations sheet. We set a value of 00:30 against the depot in that column and 00:00 against the other locations. (We could alternatively leave the cells for locations with no site time blank.)

To model the one-minute check of each order, we use a pickup service time. We add a Pickup Service Time column to the Orders sheet and set a value of 00:01 for every order.

Finally, to model the five-minute delivery time for each order, we use a delivery service time. We add a Delivery Service Time column to the Orders sheet and set a value of 00:05 for every order.

The accompanying workbook contains these modifications.

KPI Value
Total Cost 330
Total Distance 202.89
Work Time 08:24
Transit Time 04:24
Assigned Orders 20 / 20
Fleet Usage 1 / 5
Table 5: Solution KPIs.

After optimising the modified scenario, we can see the additional time taken for loading and unloading in the Work Time KPI shown in Table 5. It has increased from that of the previous examples. In the Runsheet, you can see that the site and service times are now included in the differences between the stop arrival time (ETA) and stop departure time (ETD) columns.