toolbox
Home / Shipping & Supply Chain / Last Mile Delivery Service Level Estimator

Last Mile Delivery Service Level Estimator

The Last Mile Delivery Service Level Estimator calculates the share of measured transportation events that met an on-time service definition. It turns counts of compliant and total events into a service-level percentage suitable for route, carrier, terminal, or period-level tracking. Use it when reviewing delivery reliability, investigating deterioration in schedule performance, or comparing operations that share the same measurement rule. The result can support exception analysis and improvement work, especially when late events are separately categorized by cause. The metric depends heavily on its definition. Before comparing results, keep the promised time, grace window, exclusions, and event population consistent; otherwise two percentages may describe different standards even if they look directly comparable.

Last-mile service inputs

deliveries
deliveries
Result
—
Last-mile service level
On-time deliveries—
Late deliveries—
Late share—

1. Set the operating scope
Define the lane, movement, and time period the calculation represents so every input refers to the same operation.

2. Enter the primary inputs
Provide On-time deliveries, Total completed deliveries. Use the units shown next to each field and base values on the route or booking you want to evaluate.

3. Review the live result
The result updates automatically after an input changes. Read the breakdown beside the main result to see which components drive the estimate.

4. Test a scenario
Change one assumption at a time to understand sensitivity, then use Reset to restore the page defaults.

Service level = On-time deliveries ÷ Total completed deliveries × 100

On-time deliveries meet the service promise you define. Total completed deliveries use the same period and population.

Assumptions: The model uses the entered values directly and does not infer unentered constraints or external operating rules.

What the result means

The percentage represents the share of completed deliveries that met the chosen on-time standard.

Define “on time” consistently—for example, by promised date or delivery window—before comparing periods, routes, or carriers.

Given:

  • On-time deliveries: 936
  • Total completed deliveries: 1,000

Calculation:
936 ÷ 1,000 × 100 = 93.60%.

Result: 93.60% service level

This example shows how the entered assumptions roll into the displayed estimate. Change the inputs to match your own route, load, booking, or reporting period.

What counts as on time?

Use the promise or schedule rule your operation actually manages, such as arrival by the planned timestamp or within an agreed delivery window. Keep the same rule when comparing periods.

Should canceled events be included?

That depends on your KPI definition. The important point is to decide whether cancellations belong in the measured population and apply that rule consistently rather than changing it between reports.

Can I compare carriers with this percentage?

Yes, if they are measured against comparable lanes, time windows, event definitions, and exclusions. Different operating profiles can otherwise make the comparison misleading.

What if on-time events are greater than total events?

The calculator rejects that combination because the numerator cannot logically exceed the measured population. Recheck filters, duplicates, and date ranges in the source data.

What does a change of one percentage point mean operationally?

Translate the percentage back into event counts for the period. On a large volume, a one-point change can represent many additional late or on-time events and may warrant cause-level analysis.