Trace replenishment gaps from purchase commitment to accepted receipt
An illustrative retail and e-commerce concept connecting purchase order lines, supplier confirmations, delivery appointments, and accepted goods receipts for retail supplier fill rate.
Supplier quantity fill rate (%)
On time in full receipt rate (%)
Rejected receipt quantity (%)
Average purchase order delay (days)
THE CHALLENGE
Supplier performance is obscured by partial receipts and revised commitments
Stock not visible
Closing stock is reported irregularly or not at all.
Static norms
Stock norms do not change with seasonal sales velocity.
Fast-mover gaps
High-velocity SKUs run out while slow SKUs pile up.
Ordering by habit
Primary orders follow last month's quantity rather than need.
THE SOLUTION
Retail Supplier Fill Rate Review Framework
Commitment history
Collect daily or weekly closing stock from every distributor.
Velocity-based norms
Set norms from recent secondary sales velocity and lead time.
Gap identification
Compare stock with norm for every SKU and distributor.
Order suggestion
Show suggested primary quantities for sales team review.
THE APPROACH
Purchase Commitment Versioning
Standardise closing stock submissions and track missing reports.
Sales Velocity Calculation
Calculate rolling daily secondary sales by SKU and distributor.
Norm Recalculation
Recalculate days-of-cover norms with lead time and seasonality.
Below Norm Alerts
Exclude quarantined and rejected quantities from usable supply while retaining documented inspection outcomes.
Supplier Service Comparison
Calculate fill and on-time-in-full measures by material, supplier, receiving location, and commitment period.
Short Supply Follow-Up
Assign overdue or incomplete lines for commercial review with receipt evidence and unresolved quantity balances.
THE IMPACT
Commitment clarity
Supplier reviews could distinguish original and revised promises.
Usable stock visibility
Accepted quantities could drive fill-rate reporting.
Exception focus
Short and delayed deliveries could be assigned for follow-up.
Consistent measurement
Converted units could prevent misleading quantity comparisons.
Controlled review
Authorized teams could follow up overdue purchase lines, receipt shortages, and recurring rejection reasons, with source evidence retained beside the review case.
Measurable evaluation
A pilot could establish baseline values for supplier quantity fill rate (%) and assess changes after approved actions. A shortage would need to be evaluated against purchase changes and receiving evidence before attributing supplier fault.
Explore Distributor Inventory And Stock Norms
Work with RUSA Analytics to connect distributor closing stock, stock norms, secondary sales velocity, and pending primary orders and create a governed workflow to review distributors below stock norm on fast movers or holding excess slow stock. Start with a scoped concept or pilot and agreed success measures.
MORE WORK
Explore other case studies