Telecommut
- the receipts
- the receipts
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 120+ analyst-hours saved per month
Book a 30-min strategy call Read the case ↓
Founder’s track record
- built while at P&G Canada. The in-house operator experience Clarivant is built on.
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.
← All case studies Next case: Ecommerce Data Foundation for Digital-Native Brand →
SIGNATURE PAGE
- countersign this file
The call is direct with the founder. We take the engagements we can lead end to end — yours might be one we say yes to.
Book the call — and we'll defend these numbers on the record.
120+ analyst-hours saved per month
Book a 30-min strategy call signed.
Direct with the founder. No pitch. Bring your messiest data question.
Not ready to book? Write to us: [email protected] A straight answer within one business day. Or read the questions buyers ask us →
