Case study deck · 9 slides
Agri & dairy
A D2C dairy brand scaling across 3 Indian cities
The challenge
Procurement ran on eight spreadsheets, one per collection center, stitched together by hand every month-end, two to three days of rework and still not clean. A single mistyped BMC code could route 400 litres to the wrong vendor. With 20,000+ farmers across three cities, the variance that fell through the cracks showed up as missing farmer payments, not a line in a report.
The approach
We mapped how milk actually moved before touching a dashboard, and found three centers used a different litre-rounding convention than the rest. We built a connector pulling BMC and vendor data into one table, added variance flags that fire the moment a mismatch appears, then built the view procurement checks daily instead of the one they dread monthly.
What we built
We redesigned the workflow around the model, then built the pieces that make it run every day.
ERP/IoT connector unifying BMC intake logs and vendor invoices
Variance flags on any center-vendor mismatch, in near real time
Farmer-level tracking across all 20,000+ farmers, every VLCC
Power BI dashboard replacing the eight-file manual reconciliation
Inside the build
One live view of milk moving from center to vendor to farmer payment, with the points where litres used to go missing flagged instead of buried.
Tools & systems
Collection centers
Vendors
Farmers
Results
End-to-end data refresh, down from 2–3 days, with zero rework cycles
Reconciliation variance, with faster and cleaner farmer payments
Farmers tracked on a single dashboard across all collection centers
Replaced the cross-center Excel that failed every month-end
How it stuck
The two-day, phone-off month-end ritual disappeared after one cycle, not by mandate but because the dashboard was simply faster. What kept people in it was the flagging: a mismatch now surfaces the same week instead of the same quarter, so procurement stopped reconciling and started investigating.
“We used to close the books not knowing if the number was right. Now if a center's off by two hundred litres, I know which one, and I know it Tuesday.”
Procurement operations lead, dairy engagement
Book a free 30-minute AI opportunity assessment. You will leave with at least one concrete idea.