The challenge
Dispatch ran on eleven linked spreadsheets and a WhatsApp group. Vehicle availability was frequently wrong, two teams occasionally assigned the same truck, and monthly reporting took a full day to assemble by hand.
What we did
- Ran a two-week discovery with dispatchers, drivers and accounts
- Built a single live view of vehicles, drivers, trips and maintenance status
- Added conflict detection so a vehicle cannot be double-assigned
- Gave drivers a mobile view for trip sheets and proof-of-delivery photos
- Automated the monthly reports that previously took a day
The result
Replaced 11 spreadsheets; the dispatch team saves around two hours every day. The figures below are measured against the three months before launch, using the client's own analytics rather than ours.
~2h
Saved per day
11
Spreadsheets retired
-91%
Reporting time
340
Vehicles managed
”
The logistics dashboard they built replaced eleven spreadsheets. Our dispatch team saves about two hours a day. It shipped on the date they promised in the proposal.
AV
Amit VermaCOO, FleetOps Logistics
