If your warehouse is full of items nobody buys while your best sellers keep running out, your capital is stuck in the wrong stock. This article shows a trading business how to fix both problems at once using three tools: ABC analysis, reorder points, and safety stock. You will leave with a method you can apply to your SKUs this week.
Why dead stock and stockouts happen together
They share one root cause: buying decisions based on gut feeling instead of demand data. When every SKU is treated the same, slow movers get over-ordered and fast movers get under-ordered. The result is cash frozen in shelves and lost sales on the items customers actually want.
Dead stock is expensive in ways the invoice never shows. It occupies space, ages, blocks cash you could reinvest, and eventually gets discounted below cost. Stockouts cost the sale, and sometimes the customer, who simply buys from a competitor next time.
Step 1: Sort SKUs with ABC analysis
ABC analysis ranks items by their share of annual sales value (quantity sold times unit price). It is a practical use of the Pareto principle: a small share of SKUs usually drives most of the revenue.
- A items — roughly the top 20% of SKUs that generate about 70-80% of value. Watch these closely.
- B items — the middle group, reviewed periodically.
- C items — the long tail of low-value SKUs. Many dead-stock candidates hide here.
The point is not the exact percentages. It is to stop spending equal attention on every SKU and concentrate control where the money is.
Step 2: Set a reorder point for each key SKU
A reorder point is the stock level that triggers a new purchase order. The formula is simple:
| Reorder point | = (average daily sales x lead time in days) + safety stock |
Lead time is the full gap between placing an order and having goods sellable on the shelf, including supplier processing and transport. Measure it from your own records, not the supplier’s promise.
Step 3: Size safety stock to real variability
Safety stock is the buffer that covers demand spikes and late deliveries. Do not set one flat number for everything. Higher variability in sales or lead time needs a bigger buffer. A stable A item with a reliable supplier needs less buffer than a seasonal item from a supplier who often ships late. Keep buffers lean on C items; they rarely justify the tied-up cash.
A real scenario
A building-materials distributor sold a fast-moving sealant averaging 40 units a day, with a 7-day supplier lead time. They ordered by eye and hit stockouts twice a month. Applying the formula: 40 x 7 = 280 units, plus a 120-unit safety buffer for demand swings, gave a reorder point of 400 units. At the same time, an ABC review flagged 60 slow C items that had not moved in six months. They ran a clearance on the dead stock, freed shelf space and cash, and redirected that cash into deeper A-item coverage. Stockouts on the sealant stopped, and working capital improved without any new borrowing.
Tim hieu them qua keonhacai.
Common mistakes and how to fix them
- Averaging demand over too long a period. A yearly average hides seasonality. Fix: use a rolling recent window and adjust for known peaks.
- Trusting quoted lead times. Suppliers report best cases. Fix: track actual receipt dates and use your measured average.
- One safety-stock rule for all SKUs. Fix: scale the buffer to each item’s variability and value tier.
- Never retiring dead stock. Holding it for a hopeful future sale keeps costing you. Fix: set a rule, for example clear anything with zero sales in a defined period.
- Ignoring the data after setup. Demand shifts. Fix: recalculate reorder points at least quarterly for A items.
Action checklist
- Export sales by SKU for a recent representative period.
- Rank SKUs by sales value and tag them A, B, or C.
- Measure real average lead time from your receiving records.
- Calculate reorder points for all A items first.
- Set safety stock scaled to each item’s variability.
- Identify C items with no recent sales and plan a clearance.
- Schedule a quarterly review of A-item numbers.
Conclusion and next step
You do not need software to start. Take your top 20 SKUs by value, calculate a reorder point for each, and act on your slowest dead stock this month. Once the method proves itself on A items, extend it down to B items. The next step is simple: pull your sales report today and rank it.
Frequently asked questions
How often should I recalculate reorder points?
Quarterly for A items is a sensible default, and sooner if demand shifts sharply or a supplier’s lead time changes. B and C items can be reviewed less often.
What if I do not have clean sales data?
Start with the SKUs you know are fast movers and reconstruct their sales from invoices. Even a rough recent average beats ordering by feel. Clean data can follow.
Is safety stock just wasted cash?
No. It is insurance against lost sales and unhappy customers. The goal is to size it correctly, not to eliminate it. Too little causes stockouts; too much freezes capital.
How do I decide when to clear dead stock?
Set a clear rule in advance, such as zero sales over a defined number of months. A rule removes the emotional urge to keep waiting and frees cash on a predictable schedule.
References
The concepts here draw on widely used supply-chain fundamentals: ABC analysis based on the Pareto principle, and standard reorder-point and safety-stock methods taught in inventory management. The Economic Order Quantity model was first published by Ford W. Harris (1913) and remains a common reference in the field.