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

TermMeaningHow it is used
Lead timeDays between placing an order and receiving the goodsLonger lead time needs a higher reorder level
Average daily salesUnits sold per day on averageBase for every other number
Safety stockExtra units kept to cover a sudden rise in sales or a late deliveryThe cushion
Reorder levelStock level at which you place a new orderOrder when stock falls to this level
Minimum stock levelThe lowest stock you want to see before the new delivery arrivesAn alarm line
Maximum stock levelThe most stock you want to holdPrevents overstock
Reorder quantityHow many units you order each timeDepends 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.

StepCalculationResult
Demand during lead time12 units x 5 days60 units
Safety stock(18 - 12) x 5 days30 units
Reorder level60 + 3090 units
Minimum stock levelReorder level - (average daily sales x average lead time) = 90 - 6030 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 typeExampleSuggested approach
Fast-moving stapleAtta, oil, sugarHigher safety stock, reorder often in small lots
SeasonalHeaters, school bagsBuild stock before the season and stop buying near its end
Perishable or expiry-sensitiveDairy, bakery, medicinesLow cover, frequent orders, watch expiry dates
Slow but importantA spare part that rarely sells but is criticalKeep 1 or 2 units regardless of sales
Low value, high volumeMatchboxes, candlesOrder 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.

RankAnnual salesShare of totalCumulative shareClass
1₹4,00,00036.4%36.4%A
2₹3,00,00027.3%63.6%A
3₹1,50,00013.6%77.3%A
4₹80,0007.3%84.5%B
5₹60,0005.5%90.0%B
6₹40,0003.6%93.6%B
7₹30,0002.7%96.4%C
8₹20,0001.8%98.2%C
9₹12,0001.1%99.3%C
10₹8,0000.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.

OptionHow it worksWatch out for
Markdown or discountSell below the normal price to free cashNever go below the cost if you can avoid it, and respect the printed MRP, which is the maximum, not the minimum
BundlePair with a fast seller, for example buy one get one at a reduced priceInvoice the bundle correctly
Return to supplierAsk the supplier to take back unsold stock, with a credit noteCheck the supplier's return policy and the time limit
Repack or re-labelBreak bulk into smaller packs where the law allowsFollow packaging and labelling rules
Write offRemove it from stock as a lossReverse 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