Stock reorder point calculator for shops
Updated · free, no login
Reorder point = average daily sales × lead time + safety stock. Sell 12 a day, wait 5 days for delivery and keep 80 as a buffer, and you reorder when stock falls to 140. Enter your figures below to get the reorder point, safety stock, days of stock left and how much to order, for one item or your whole list.
FreeNo sign-up to useWhatsApp number to download filesWorks on your phone
1. Item ki bikri aur supplier ka time
2. Safety stock (buffer)
- Sales during lead time
- 60 units
- Safety stock
- 80 units
- Reorder point
- 140 units
- Current stock lasts
- 12.5 days
- Suggested order
- 170 units
Jab stock 140 units tak aaye, order de do: reorder when stock falls to 140 units. You have 10 units above it.
3. Many items at once
| Item | Daily sales | Lead days | Safety | Stock | Reorder at | Status | Remove |
|---|---|---|---|---|---|---|---|
| 42 | Order now | ||||||
| 90 | OK, 4.6 days | ||||||
| 27 | Order now |
Know another shop owner who needs this? It is free.
How to use it
- Find average daily sales. Take how many units sold in the last 30 days and divide by 30. Use a normal month, not a festival rush, unless you are planning for one.
- Enter the lead time. The days between placing an order and the goods being on your shelf, including the supplier's delivery day.
- Set a safety stock. From your busiest day and slowest delivery, as a few extra days of sales, or as units you already use. It covers sales spikes and late deliveries.
- Read the reorder point. Reorder when stock falls to this number. Add current stock to see how many days it lasts and how much to order.
- Do it for many items. Fill the table for your fast movers, or download the Excel reorder sheet where rows to order turn red.
Reorder point formulas
| You want | Formula | Example |
|---|---|---|
| Reorder point | Daily sales × lead time + safety stock | 12 × 5 + 80 = 140 |
| Safety stock (max-avg) | Max daily × max lead − avg daily × avg lead | 20 × 7 − 12 × 5 = 80 |
| Safety stock (days) | Daily sales × extra days | 12 × 3 = 36 |
| Days of stock left | Current stock ÷ daily sales | 150 ÷ 12 = 12.5 days |
| Order quantity | Daily × (lead + cover days) + safety − stock | 12 × 20 + 80 − 150 = 170 |
More in reorder level and safety stock for a retail shop, ABC analysis and inventory turnover; how long stock ties up cash is the cash conversion cycle. To count stock, see stock audit by barcode scan, the inventory and barcode features and the free stock register Excel.
Questions
What is the reorder point formula?
Reorder point = average daily sales × lead time in days + safety stock. If you sell 12 a day, delivery takes 5 days and you keep 80 as safety stock, reorder when stock reaches 12 × 5 + 80 = 140 units.
How do I calculate safety stock?
A simple shop method: (most sold in one day × longest delivery time) − (average daily sales × average delivery time). With a best day of 20, a longest delivery of 7 days, 12 a day on average and 5 days usually, safety stock is 140 − 60 = 80 units. Or keep a few extra days of sales, such as 3 days × 12 = 36.
What is lead time?
The time from placing an order to the goods being ready to sell in your shop. Count working days the supplier really takes, plus a day to receive and price the goods.
How much should I order?
Enough to last until your next order. The tool suggests: daily sales × (lead time + days the order should last) + safety stock − current stock. Adjust for pack sizes, supplier minimums and schemes.
Should every item have the same safety stock?
No. Fast movers and items customers will not wait for (milk, bread, popular phone chargers) need more. Slow, costly items need little, because stock sitting on the shelf ties up cash.
How often should I recalculate the reorder point?
Once a month, and before festivals and season changes, because daily sales and supplier lead times change. A wrong old number causes both stock-outs and overstock.
Related
Stock khatam hone se pehle alert: RichPOS free trial
RichPOS keeps your items, stock and purchases in one place, warns you with low-stock alerts before an item runs out, and lets you send reorder lists to suppliers on WhatsApp.
Free 30-day trial, then ₹99/month for the first 3 months (₹199/month after that) or ₹2,000/year. See pricing
Related tools (free, no sign-up)
- Which billing software fits my shop?
- Diwali offer poster maker
- Barcode generator (PNG, SVG)
- Price tag maker
- Barcode label generator
- Free Excel templates for shops
- Udhaar reminder message
- GST invoice generator
- Bill formats by shop type
- GST invoice format & templates
- Profit margin calculator
- Profit & loss calculator
- Discount & offer calculator
- GSTIN checker
- HSN code & GST rate finder
- GST calculator (add or reverse GST)
Har din ka billing, stock aur udhaar ek jagah: Start RichPOS free trial 30 days free, no card. All free tools