Reorder Level, Minimum Stock and Safety Stock: ABC Analysis and Dead Stock Control for a Small Retailer
By BillAmico Tax & Compliance Desk | | 12 min read
Too little stock loses sales. Too much stock locks up cash and ends in markdowns and expiry. The way out is a simple set of numbers for each item: when to reorder, how much to keep as a cushion, and which items deserve the most attention. This guide explains reorder level, minimum stock, maximum stock and safety stock with worked numbers, shows how to run an ABC analysis on your own sales, and gives practical ways to find and clear dead and slow-moving stock in a small retail shop.
1. Why a stock-out and overstock both cost money
A stock-out costs you the sale today and sometimes the customer for good, because the buyer goes to the next shop and may stay there. Overstock costs you in a quieter way. The money paid for goods that sit on a shelf cannot be used for goods that sell. Stock also takes space, can get damaged, can go out of date, and can lose value when the MRP or the fashion changes.
The aim of stock control is therefore not to hold as much as possible or as little as possible, but to hold the right amount for each item, based on how fast it sells and how long the supplier takes to deliver.
2. The key terms in plain language
| Term | Meaning | How it is used |
|---|---|---|
| Lead time | Days between placing an order and receiving the goods | Longer lead time needs a higher reorder level |
| Average daily sales | Units sold per day on average | Base for every other number |
| Safety stock | Extra units kept to cover a sudden rise in sales or a late delivery | The cushion |
| Reorder level | Stock level at which you place a new order | Order when stock falls to this level |
| Minimum stock level | The lowest stock you want to see before the new delivery arrives | An alarm line |
| Maximum stock level | The most stock you want to hold | Prevents overstock |
| Reorder quantity | How many units you order each time | Depends on supplier minimums, cash and storage |
3. Reorder level and safety stock: a worked example
A commonly used formula is: reorder level = (average daily sales x lead time in days) + safety stock. One simple way to set safety stock is: safety stock = (highest daily sales - average daily sales) x lead time.
Worked example. A packaged cooking oil sells 12 units per day on average and 18 units on the busiest days. The supplier takes 5 days to deliver.
| Step | Calculation | Result |
|---|---|---|
| Demand during lead time | 12 units x 5 days | 60 units |
| Safety stock | (18 - 12) x 5 days | 30 units |
| Reorder level | 60 + 30 | 90 units |
| Minimum stock level | Reorder level - (average daily sales x average lead time) = 90 - 60 | 30 units |
When stock falls to 90 units, place the order. If sales stay at the average, the stock will be at about 30 units on the day the goods arrive. If sales rise to 18 per day, the safety stock absorbs the extra.
For the maximum level, one common formula is: maximum level = reorder level + reorder quantity - (lowest daily sales x shortest lead time). If the lowest daily sales are 8 units, the shortest lead time is 3 days and you order 120 units at a time, then maximum level = 90 + 120 - (8 x 3) = 186 units. Stock above 186 means you have ordered too much.
info: These formulas are practical guides, not laws of nature. Review the numbers every month for fast items and every quarter for slow items, because sales and lead times change.
4. Setting minimum stock by type of item
One rule does not fit all items. Match the cushion to how the item behaves.
| Item type | Example | Suggested approach |
|---|---|---|
| Fast-moving staple | Atta, oil, sugar | Higher safety stock, reorder often in small lots |
| Seasonal | Heaters, school bags | Build stock before the season and stop buying near its end |
| Perishable or expiry-sensitive | Dairy, bakery, medicines | Low cover, frequent orders, watch expiry dates |
| Slow but important | A spare part that rarely sells but is critical | Keep 1 or 2 units regardless of sales |
| Low value, high volume | Matchboxes, candles | Order in larger lots because the stock value is small |
For items with expiry dates, do not overstock to get a bulk discount. A discount that saves 3 percent is wiped out if 5 percent of the stock expires. The guide on batch numbers and expiry dates explains how to track shelf life.
5. ABC analysis: where to spend your attention
ABC analysis ranks items by the value they contribute. Class A items are few but account for most of the value. Class C items are many but account for little. The method does not need special software. You need the annual sales value of each item.
Steps.
- List each item with its annual sales value (quantity sold x selling price).
- Sort the list from highest value to lowest.
- Add up the total and work out each item's share and the running (cumulative) share.
- Mark Class A up to roughly the first 70 to 80 percent of value, Class B up to about 95 percent, and the rest Class C. The exact cut-offs are a judgement, not a rule.
Worked example with 10 items and a total annual sales value of ₹11,00,000.
| Rank | Annual sales | Share of total | Cumulative share | Class |
|---|---|---|---|---|
| 1 | ₹4,00,000 | 36.4% | 36.4% | A |
| 2 | ₹3,00,000 | 27.3% | 63.6% | A |
| 3 | ₹1,50,000 | 13.6% | 77.3% | A |
| 4 | ₹80,000 | 7.3% | 84.5% | B |
| 5 | ₹60,000 | 5.5% | 90.0% | B |
| 6 | ₹40,000 | 3.6% | 93.6% | B |
| 7 | ₹30,000 | 2.7% | 96.4% | C |
| 8 | ₹20,000 | 1.8% | 98.2% | C |
| 9 | ₹12,000 | 1.1% | 99.3% | C |
| 10 | ₹8,000 | 0.7% | 100.0% | C |
Three of the ten items (30 percent of items) bring 77.3 percent of sales. Those are your A items. Give them the tightest reorder levels, the most frequent counts and the closest watch on price and supplier. The four C items bring only 6.4 percent of sales together and can run on simple, larger, less frequent orders.
6. Finding slow-moving and dead stock
Dead stock is stock that has not sold for a long time, for example 180 days or more. Slow-moving stock sells, but far slower than you bought it for. The simplest measure is stock cover in days: stock cover = stock quantity / average daily sales.
Worked example. A shop holds 240 units of an item and sells 4 per day on average. Stock cover = 240 / 4 = 60 days. If the supplier delivers in 5 days, you are holding about 55 days of extra stock. If it sells only 1 unit per day, the same 240 units cover 240 days.
Practical steps to find them.
- Run a report of items by last sale date and flag those with no sale in 90 or 180 days.
- Run a stock cover report and flag items above a limit you choose, for example 90 days.
- Value the flagged stock at cost, so you see how much cash is tied up.
- Check for expiry, because dead stock and near-expiry stock are often the same stock.
The financial ratios guide shows how the stock turnover ratio looks at the same problem for the whole shop.
7. Clearing dead stock: options with numbers
Once identified, dead stock should be cleared quickly, because the longer it stays, the less it is worth.
| Option | How it works | Watch out for |
|---|---|---|
| Markdown or discount | Sell below the normal price to free cash | Never go below the cost if you can avoid it, and respect the printed MRP, which is the maximum, not the minimum |
| Bundle | Pair with a fast seller, for example buy one get one at a reduced price | Invoice the bundle correctly |
| Return to supplier | Ask the supplier to take back unsold stock, with a credit note | Check the supplier's return policy and the time limit |
| Repack or re-label | Break bulk into smaller packs where the law allows | Follow packaging and labelling rules |
| Write off | Remove it from stock as a loss | Reverse the input tax credit under Section 17(5)(h), and keep proof |
Worked example. You hold 100 units with a cost of ₹50 each, so ₹5,000 is tied up. You sell all of them at ₹45. You receive ₹4,500 and book a ₹500 loss, but you free ₹4,500 of cash to buy fast-moving goods. If the units had stayed unsold for another year, they might have been written off completely at a ₹5,000 loss plus lost interest on the money.
The tax side of a write-off is explained in the guide on physical stock verification and stock adjustment.
8. A weekly routine that keeps stock healthy
- Review the low-stock alerts and place orders for items at or below their reorder level.
- Check the near-expiry list and move those units to the front.
- Look at the top A items and confirm that no one is close to a stock-out.
- Once a month, run the slow-moving and dead stock report and pick items to clear.
- Once a quarter, redo the ABC analysis and update reorder levels, because sales mix changes.
BillAmico lets you set re-order levels in the item master, shows low stock and reorder alerts on the dashboard, and gives expiry badges at 30, 60 and 90 days. Its Stock Journal helps with repacking and other stock movements.
Frequently asked questions
What is the formula for reorder level?
Reorder level = (average daily sales x lead time in days) + safety stock. For example, 12 units a day x 5 days = 60, plus 30 units of safety stock gives a reorder level of 90 units.
What is the difference between safety stock and minimum stock level?
Safety stock is the extra cushion kept for surprises such as a sales spike or a late delivery. The minimum stock level is the lowest level you want to reach before a new delivery arrives. When lead time is steady, the two are close in value.
How do I decide which items are Class A, B and C?
Rank items by annual sales value, work out the cumulative share, and mark roughly the first 70 to 80 percent of value as A, up to about 95 percent as B and the rest as C. The cut-offs are a judgement and can be adjusted for your shop.
How long before stock is called dead stock?
There is no single legal period. Many retailers treat items with no sale in 90 to 180 days as slow or dead, depending on the product. Choose a limit that suits your goods and review it regularly.
Can I sell dead stock above the MRP?
No. For pre-packed goods, the MRP printed on the pack is the maximum price. You can sell below it. Do not overwrite or add a second MRP on the pack.
Official sources
Related guides
- Stock Transfer Between Godowns and Branches Under GST: Schedule I, Distinct Persons, Challans and E-Way Bills
- Batch Number and Expiry Date: How to Record Them on Purchase and Sale, and What the Law Expects
- Serial Number and IMEI Tracking for Mobile and Electronics Shops: Purchase Scan, Sale Scan, Warranty and Returns