# On Time Delivery Metrics

Archie Wood

## Why are On-Time Delivery metrics so important?

When customers' orders are not delivered on time, they may miss their delivery, or it may arrive too late to be useful.

Ensuring a high on-time delivery rate protects customer satisfaction, so it's important to measure if customers are receiving their items on time.

A flawless handover

## Definition

On-Time Delivery (OTD), sometimes called On-Time Performance, or On-Time Percentage (OTP) measures the percentage of orders that are delivered on time:

$On\text{-} Time \ Delivery \ \% = {Number \ of \ On\text{-} Time \ Deliveries \over Total \ Deliveries} \times 100$

## Calculating On-Time Delivery

In order to calculate the OTD %, we need to know when the deliveries were meant to be delivered, and when they were actually delivered.

Assuming we are starting with the below data from 100,000 deliveries, which is stored in a database. For each order delivery_slot_start and delivery_slot_end mark the time period when the delivery was expected, and delivery_time is when the delivery was actually made.

all_deliveries
100,000 records with 4 properties

We first compare the delivery time to the start and end of the delivery slot to determine if the order was delivered on time, early, or late.

deliveries_classification
100,000 records with 5 properties

From here, we can calculate the OTD % for each month in the dataset.

otd_per_month
36 records with 5 properties
Delivery Mon Total Deliveries On Time Early Late
1
2019-01
2.24k 62.0% 32.0% 7.0%
2
2019-02
1.76k 64.0% 29.0% 7.0%
3
2019-03
2.28k 64.0% 30.0% 6.0%
4
2019-04
1.84k 62.0% 31.0% 7.0%
5
2019-05
2.4k 61.0% 32.0% 7.0%

## Presenting On-Time Delivery Metrics

On-time delivery metrics are typically presented as a time series, allowing the viewer to see the OTD % for each month.

We can use Evidence to plot a line chart to see how the OTD % changes over time: