UC-431
SKU-Store Shelf-Life & Markdown Timing
Works out remaining shelf life per batch in each store, predicts what will not sell in time, and sets the markdown moment per line.
TBDBuild Duration
XXXXIndicative ROI
XXXXBuild Cost
XXXXValue
The Challenge
Short-life lines are marked down too late to sell, or too early and give away margin that was never at risk. It persists because production dates, store sell-through and chill records are never read together.
How It Works
- Reads batch production and use-by dates, store sell-through, stock positions and chill records.
- Forecasts sell-through against remaining shelf life per SKU, batch and store, and ranks risk.
- Pushes a markdown or transfer instruction to the store team while the stock can still sell.
What It Removes
- Store-by-store manual date checks on the shelf
- Fixed-rule markdowns applied regardless of stock
- Weekly waste reports written after the loss
Input Data RequirementsBatch production and use-by dates, store-level sales and stock, delivery and chill-chain records, markdown rules, waste write-off records
Output FormatDaily markdown and transfer list per store, a predicted waste value per SKU, and a weekly view of where short-life lines are being over-ordered
“We mark down at four o'clock every day whether the stock needed it or not because that is the rule”