Fleet Routing Service Level Estimator

The Fleet Routing Service Level Estimator measures the share of routed shipments that meet a defined delivery or routing service target. You provide the number that met the target and the total routed shipment count; the calculator returns the service rate and exceptions.

It can be used for route-scorecard reporting, carrier reviews, and operational comparisons across depots or periods when each comparison uses the same success definition. The calculation does not decide what an acceptable target should be. Organizations may define success using on-time delivery, route completion, appointment compliance, or another documented service rule.

Inputs

shipments
shipments
Result
Fleet routing service level
Meeting target
Total routed shipments
Exceptions
Exception rate

1. Specify the routing target
Use a clear criterion such as on-time delivery or completion within the scheduled service window.

2. Count target hits
Enter routed shipments that satisfied the criterion in the selected period.

3. Enter total routed shipments
Use the full comparable routed-shipment population for that period.

4. Review service and exceptions
Use both the service percentage and exception count when evaluating route performance.

Fleet routing service level (%) = Shipments meeting route target ÷ Total routed shipments × 100

Where:

  • Shipments meeting route target — entered in shipments.
  • Total routed shipments — entered in shipments.

Assumptions: all inputs refer to the same planning period or operating scenario, and the model uses the averages entered rather than forecasting external disruption.

What the result means

The result is the percentage of routed shipments that met the service definition used in your data.

Use the same target definition, cutoff rules, and treatment of exclusions across comparison periods to avoid misleading changes in the rate.

Given:
1,176 shipments met the routing target out of 1,225 routed shipments.

Calculation:
1,176 ÷ 1,225 × 100 = 96.00%.

Result:
96.00% service level and 49 exceptions.

Interpretation:
Four percent of the measured routed shipments missed the selected service target.

Can the target be different by customer?

Yes operationally, but aggregate reporting should classify each shipment against its applicable target before totals are entered.

Should failed delivery attempts count as misses?

Use your documented service rule. Whatever treatment you choose should remain consistent across reporting periods.

Why show the exception rate too?

The exception rate is the complement of service level and can make missed-service trends easier to discuss.

Can I compare depots with different shipment counts?

You can compare percentages, but also review exception counts and service definitions because volume and operating mix can differ.

Does this show routing efficiency?

No. Service level describes target attainment, while efficiency or utilization measures use of time, distance, vehicles, or capacity.