Track near-expiry stock and market returns before they become write-offs
An illustrative consumer goods and distribution concept connecting batch-level stock, expiry dates, market return claims, and secondary sales by batch for near-expiry stock and market returns.
Stock within 90 days of expiry (%)
Market return rate (%)
Return claims with batch evidence (%)
Expired stock write-off value
THE CHALLENGE
Expiry losses are discovered when returns arrive
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
Expiry And Returns Review Framework
Batch visibility
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
Batch Stock Collection
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
Group returns by reason, SKU, and region.
Liquidation Option Review
List at-risk batches for transfer, scheme, or approved disposal.
Monthly Exposure Reporting
Report value at risk of expiry by distributor and brand.
THE IMPACT
Early warning
At-risk batches could be seen months ahead.
Claim evidence
Returns could be validated against supplied batches.
Root causes
Return reasons could be grouped for supply and sales review.
Lower exposure
Near-expiry stock could be routed before it expires.
Controlled review
Authorized teams could review batches nearing expiry, rising return rates, and unsupported return claims, with source evidence retained beside each review case.
Measurable evaluation
A pilot could establish baseline values for stock within 90 days of expiry (%) and assess changes after approved actions. Descriptive results alone would not establish causality.
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