Understanding Service Durations

Service durations in Routing and Scheduling can be based on user defined rates and measures. All rates must be in the form of units/minutes. The rates and measures can be defined at the following database levels: Order, Order Line, and Product Type.

A service rate can be applied for each of the units that are to be picked up and/or delivered. This rate will allow third party systems to calculate the total service time that will be required to service/deliver or pickup the totality of the order/task.

Service duration rates can also be affected at the location level by a factor that will determine whether a unit can be serviced faster or slower depending on its value.

Simple Orders Service Duration Calculations

For simple orders, the service durations (pre-service duration and service duration) can be calculated as described below.

Double-ended or Multi-task Orders Service Duration Calculations

Service Durations Specified at the Order level

If the service durations are only specified at the Order level and not at the Order line level, then the pre-service duration and service duration is the same for each activity and order line for the entire order.

Example:

For the route above:

The pre-service duration and service duration for each stop activity would be:

Service Durations specified at the Order and Order Line level

If the service durations are only specified at the Order level and the Order line level, then the pre-service duration and service duration is calculated as follows:

·        For Pickups - Pre-Service Duration = Order Pre-Service Duration + Order PU Pre-Service Duration + Location Service Factor * (Orderline Pre-Service Duration + Orderline PU Pre-Service Duration)

·        For Pickups - Service Duration = Order Service Duration + Order PU Service Duration + Location Service Factor * (Orderline Service Duration + Orderline PU Service Duration)

·        For Drop-offs - Pre-Service Duration = Order Pre-Service Duration + Order Delivery Pre-Service Duration + Location Service Factor * {(Orderline1 Pre-Service Duration + Orderline1 Delivery Pre-Service Duration) + (Orderlinex Pre-Service Duration +Orderlinex Delivery Pre-Service Duration)}

In this equation, x represents all additional order lines. If the route contained three order lines, then three order lines would be represented in the equation above. See the example below.

·        For Drop-offs &endash; Service Duration = Order Service Duration + Order Delivery Service Duration + Location Service Factor * {(Orderline1 Service Duration + Orderline1 Delivery Service Duration) + (Orderlinex Service Duration + Orderlinex Delivery Service Duration)}

In this equation, x represents all additional order lines. If the route contained three order lines, then three order lines would be represented in the equation above. See the example below.

Example:

Using the same route as in the example above, durations are applied to the Order and the Order Lines.

A location service factor is also applied to each location.

The pre-service duration and service duration for each stop activity would be:

For FWActivit(A):

·        Pre Service Duration calculation is: 1 + 1 + 0.9 * (2 +1) = 4.7 mins

·        Service Duration calculation is: 5 + 5 +0.9 * (45 + 5) = 55 mins

For FWActivity(B):

·        Pre Service Duration calculation is: 1 + 2 + 1.1 * {(2 + 2) + (2 + 2) (3 + 1)} = 16.2 mins

·        Service Duration calculation is: 5 + 6 +1.1 * {(45 + 6) + (35 + 6) + (35 + 6)} = 157.3 mins

Service Durations for the Order line level when specified at the Product Type level

If service durations are specified for a product type, then the order line level for that product type would be calculated as follows:

·        Order line Pre-Service Duration = Product Type Pre-Service Duration * Product Type Quantity

·        Order line Service Duration = Product Type Service Duration * Product Type Quantity

·        Order line PU Pre-Service Duration = Product Type PU Pre-Service Duration * Product Type Quantity

·        Order line PU Service Duration = Product Type PU Service Duration * Product Type Quantity

·        Order line Delivery Pre-Service Duration = Product Type Delivery Pre-Service Duration * Product Type Quantity

·        Order line Delivery Service Duration = Product Type Delivery Service Duration * Product Type Quantity

Example:

Using the same route as in first example above, durations are applied to the Order level and the Product Type level.

The Order line level is computed internally and the results are:

Service Durations using Measures at the Order line Level

If service durations are applied by measures with a service rate to the Order lines then they are calculated as follows:

Ü  Note - In order for the measures and the service rate to take precedence over the service duration, a service duration at the Order line level has to be null. If a value is in place, then it overrides the measure and service rate.

·        For Pickups - Pre-Service Duration = Order Pre-Service Duration + Order PU Pre-Service Duration + Location Service Factor * (Orderline Pre-Service Duration + Orderline PU Pre-Service Duration)

·        For Pickups that has a null service duration at the Order line level - Service Duration = Order Service Duration + Order PU Service Duration + Location Service Factor * (MeasureX * Qty/Service Rate)

·        For Drop-offs - Pre-Service Duration = Order Pre-Service Duration + Order Delivery Pre-Service Duration + Location Service Factor * {(Orderline1 Pre-Service Duration + Orderline1 Delivery Pre-Service Duration) + (Orderlinex Pre-Service Duration +Orderlinex Delivery Pre-Service Duration)}

In this equation, x represents all additional order lines. If the route contained three order lines, then three order lines would be represented in the equation above. See the example below.

·        For Drop-offs that has a null service duration at the Order line level &endash; Service Duration = Order Service Duration + Order Delivery Service Duration + Location Service Factor * {(Orderline1 Service Duration + Orderline1 Delivery Service Duration) + (Orderlinex Service Duration + Orderlinex Delivery Service Duration) + (MeasureX * Qty/Service Rate)}

In this equation, x represents all additional order lines. If the route contained three order lines, then three order lines would be represented in the equation above. See the example below.

Example:

Using the same route as in first example above, some service durations are applied to the Order level and some are applied by measure and service rate.

Ü  Note - Where service durations are null, the quantity, measure, apply to measure, and service rates apply in the calculation.

A location service factor is also applied to each location.

The pre-service duration and service duration for each stop activity would be:

For FWActivit(A):

·        Pre Service Duration calculation is: 1 + 1 + 0.9 * (2 +1) = 4.7 mins

·        Service Duration calculation is: 5 + 5 +0.9 * (1500 * 2/100) = 37 mins

For FWActivity(B):

·        Pre Service Duration calculation is: 1 + 2 + 1.1 * {(2 + 2) + (2 + 2) (3 + 1)} = 16.2 mins

·        Service Duration calculation is: 5 + 6 +1.1 * {(6) + (6) + (600 * 1/100)} = 30.8 mins

Service Durations using Measures at the Product Type Level

If service durations are applied by measures with a service rate to the Product Types then they are calculated as follows:

Ü  Note - In order for the measures and the service rate to take precedence over the service duration, service durations at the Order line level have to be null and the Measure has to be null at the Order line level. A service duration at the Product Type level also has to be null. If a value is in place, then it overrides the measure and service rate.

·        For Pickups - Pre-Service Duration = Order Pre-Service Duration + Order PU Pre-Service Duration + Location Service Factor * (ProductType Pre-Service Duration + ProductType PU Pre-Service Duration)

·        For Pickups that has a null service duration at the Product Type level - Service Duration = Order Service Duration + Order PU Service Duration + Location Service Factor * (ProductType MeasureX * Orderline Qty/ProductType Service Rate)

·        For Drop-offs - Pre-Service Duration = Order Pre-Service Duration + Order Delivery Pre-Service Duration + Location Service Factor * {(ProductType1 Pre-Service Duration + ProductType1 Delivery Pre-Service Duration) + (ProductTypex Pre-Service Duration +ProductTypex Delivery Pre-Service Duration)}

In this equation, x represents all additional order lines. If the route contained three order lines, then three order lines would be represented in the equation above. See the example below.

·        For Drop-offs that has a null service duration at the Order line level &endash; Service Duration = Order Service Duration + Order Delivery Service Duration + Location Service Factor * {(ProductType1 Service Duration + ProductType1 Delivery Service Duration) + (ProductTypex Service Duration + ProductTypex Delivery Service Duration) + (ProductType MeasureX * Orderline Qty/ProductType Service Rate)}

In this equation, x represents all additional order lines. If the route contained three order lines, then three order lines would be represented in the equation above. See the example below.

Example:

Using the same route as in first example above, durations are applied to the Order level and the Product Type level.

Ü  Note - Where service durations are null; the quantity, measure, apply to measure, and service rates apply in the calculation.

A location service factor is also applied to each location.

The pre-service duration and service duration for each stop activity would be:

For FWActivit(A):

·        Pre Service Duration calculation is: 1 + 1 + 0.9 * (2 +1) = 4.7 mins

·        Service Duration calculation is: 5 + 5 +0.9 * (1500 * 2/100) = 37 mins

For FWActivity(B):

·        Pre Service Duration calculation is: 1 + 2 + 1.1 * {(2 + 2) + (2 + 2) (3 + 1)} = 16.2 mins

·        Service Duration calculation is: 5 + 6 +1.1 * {(6) + (6) + (600 * 1/100)} = 30.8 mins