Real-data logistics simulation

Does fleet size or SLA design drive on-time delivery?

A discrete-event simulation of Delhivery's real dispatch operations at India's busiest hub in this dataset, built to separate a congestion problem from a promise-design problem.

Data: real Delhivery operational scans
Sep–Oct 2018 · 144,867 records
View source on GitHub →
01

How the study was built

STEP 1

Clean real scans

144,867 checkpoint scans collapsed to 26,003 real actual-vs-planned transit legs.

STEP 2

Model the hub

SimPy queue model of outbound dispatch, vehicle pool as a shared resource.

STEP 3

Rule out congestion

Swept fleet size 2–24 vehicles — on-time rate plateaus early.

STEP 4

Find the real lever

Swept the SLA buffer itself — found the route-type gap.

02

What the raw data shows

Across all 1,487 source hubs nationally, real delivery time runs well past the routing engine's naive plan — and FTL (long-haul) legs are, on average, slightly more predictable than Carting (local) legs.

Actual / planned transit time ratio
All hubs · n = 26,003 legs · ratio of 1.0 = exactly on the routing engine's plan
Top source hubs by outbound leg volume
Gurgaon_Bilaspur_HB is the busiest — the hub this study models
03

Test 1 — is it a fleet-size problem?

Gurgaon hub, Medium-distance tier (77–299km, where both route types are genuinely used). SLA promise fixed at 2× the planned time. Fleet size swept from 2 to 24 outbound vehicles.

≠

Finding: no — on-time rate plateaus while vehicles are still idle

By ~8 vehicles, average dispatch wait time is already near zero — yet on-time rate caps at just 42–50% even at 24 vehicles. The real constraint is transit-time variance, not fleet capacity. Adding trucks would not fix this.

04

Test 2 — what SLA can each route type actually deliver?

Fleet size fixed at 12 vehicles (congestion-free, per Test 1). SLA buffer swept instead, to find the promise window each policy can hit 90% of the time.

✓

Recommendation

For Medium-tier corridors out of Gurgaon, an all-FTL policy reaches a 90% on-time rate at a 3.0×-of-plan SLA buffer — tighter than Carting or the historical 55/45 mix, both of which need 3.5×. Quoting FTL for this tier lets the hub promise a shorter delivery window at the same reliability target.