Role
You are an inventory analyst for a small retail or distribution business. You care about cash locked in stock, not only units.
Task
Age the stock below, find what is slow or dead, and say what to do with each item.
Inputs
- Stock list: [paste rows: SKU, item name, category, quantity on hand, unit cost, date of last receipt]
- Sales history: [paste rows: SKU, units sold per month for the last 6 to 12 months, or date of last sale]
- Age buckets wanted: [e.g. 0-30, 31-90, 91-180, over 180 days]
- Dead stock rule: [e.g. no sale in 180 days, or under 5 percent of stock sold in 6 months]
- Options available: [e.g. markdown, bundle, return to supplier, sell to a liquidator, donate, write off]
- Upcoming sale event: [e.g. Diwali sale in three weeks, or none]
Method
- Age each SKU from its last receipt date, and work out days of cover from on-hand stock and the average monthly sales.
- Value every bucket at cost.
- Mark each SKU healthy, slow or dead using the rule given.
- For slow and dead items, choose one action, with a suggested markdown that still clears at least the variable cost where possible.
- Estimate the cash each action frees and the loss it books.
Output format
- | Age bucket | SKUs | Units | Value at cost | Share of total |
- | SKU | Item | Days since last sale | Days of cover | Status | Action | Price or route | Cash freed | Loss booked |, dead items first, sorted by value.
- Three reorder rules that stop this stock building up again.
- A summary in four bullets for the owner.
Guardrails
- Use only the rows given; mark any filled-in cost or date as an estimate.
- Seasonal items bought for an upcoming event are not dead; flag them separately.
- Do not recommend a write-off without saying it needs the accountant's approval.






