Case study · 2024
Replacing 40 spreadsheets with one transport management system
A freight forwarder handling 400 consignments a week ran its operation on spreadsheets, WhatsApp and phone calls. We built a transport management system, a customer tracking portal and an offline-capable driver app.
- Client
- Meridian Freight Services (freight forwarder, Kochi)
- Sector
- Logistics & Supply Chain
- Duration
- 7 months
Logistics & Supply Chain
Meridian Freight Services (freight forwarder, Kochi)
68%
fewer status enquiry calls
2.1 hrs
daily planning time saved per coordinator
4 days
faster invoicing after delivery
94%
driver app adoption within six weeks
The challenge
Where things stood
Operations staff spent most of the day answering "where is my shipment". Consignment data lived in forty spreadsheets, drivers reported by phone, proof of delivery arrived as photographs in a WhatsApp group, and invoices were raised days late because nobody could confirm what had been delivered. Detention charges were routinely discovered after the fact.
Our approach
What we did about it
We spent four days in their operations room before designing anything. The main finding was that the spreadsheets were not the problem — they were a symptom of drivers having no practical way to report status from a port or a highway.
So the driver app came first, built offline-first with large touch targets, minimal typing and automatic photo capture for proof of delivery. Once drivers were reporting reliably, the office system had real data to work with.
The customer portal followed, exposing the same data to shippers directly. Status enquiries fell sharply within a month of launch, which freed the operations team to work on exceptions instead of answering the phone.
What we delivered
The system, in parts
Built with
The team came and sat in our office for four days before they wrote anything. That is why the drivers actually use the app — it was designed for a man standing at a port gate, not for the office.
Services used
How this project was delivered
More of our work
All case studiesBackwater Collection (resort group, Kerala & UAE)
Cutting OTA commission by shifting 38% of bookings direct
Ayur Health Network (multi-specialty clinics, Kerala)
A telemedicine platform 18,000 patients use without support
Confidential (NBFC, South India)
From a 9-day loan decision to under 4 hours
Got a problem shaped like this one?
Tell us where it hurts. You will get a rough cost, a rough timeline and an honest opinion — before anyone mentions a contract.