P&G Canada (Walmart Canada)
Automated Replenishment Reports Saved 120+ Hours Monthly
120+ hours saved monthly — replenishment from 3-day reviews to minutes.
Founder’s track record · built while at P&G Canada. The in-house operator experience Clarivant is built on.
The starting point
P&G’s eight Walmart Canada replenishment analysts each spent ~3 days a week pulling SKU-store fill-rate data from Retail Link and scanning for issues by hand. Problems surfaced Thursday or Friday — too late for the next cycle — and phantom inventory, stock sitting in the backroom rather than on the shelf, was invisible to everyone.
The method
I automated the whole extraction-to-insight pipeline: overnight Retail Link pulls, plus phantom-inventory logic that compared POS velocity against on-hand stock with thresholds tuned by category. Each analyst got a Monday-ready dashboard ranking their stores by revenue impact, and category leads got a weekly top-10 by estimated revenue across every territory.
The result
The team saved 120+ analyst-hours a month — roughly three full-time weeks redirected from wrangling to action. In-stock rose 1% across Walmart Canada (meaningful at P&G’s scale), on-time deliveries improved 5%, and analysts shifted from reactive problem-finders to proactive solvers — with the automated Monday report becoming the team’s standard rhythm.