Software Development
Custom operations portal for a distribution business
Replaced a sprawl of spreadsheets with a single web portal covering orders, stock and driver allocation.
The challenge
Eleven linked spreadsheets ran the business. Only two people understood them, and a single corrupted file could stop dispatch for a morning.
Our approach
- Mapped the real workflow with the operations team before designing anything
- Built a role-based web portal with audit history on every record
- Migrated three years of historical data with reconciliation reports
- Ran both systems in parallel for four weeks before switch-off
Results
11
Spreadsheets retired
6 hrs
Admin time saved per day
100%
Order history auditable