Reorder Point Formula for Indian Small Businesses: Calculate Safety Stock Without Overstocking

A small retailer can have healthy sales and still lose customers because the best-selling item is out of stock. Another retailer can avoid stockouts by buying too much, only to discover that cash is trapped in unsold goods. A reorder point gives you a more useful decision rule: when should you place the next purchase order? This guide explains the reorder point formula for Indian retailers, ecommerce sellers, distributors and small manufacturers. You will learn how to calculate daily demand, supplier lead time and safety stock, then put the numbers into a spreadsheet. You will also see why a reorder point is not the same as the quantity you should buy. What is a reorder point? A reorder point, or ROP, is the inventory position at which you should place a replenishment order so that new stock arrives before existing stock runs out under your planning assumptions. It is normally expressed in units for each SKU. For example, a reorder point of 240 means that you trigger a purchase when your inventory position reaches 240 units or fewer. Reorder point = (average daily demand × average replenishment lead time) + safety stock. This is the standard formula described in Oracle NetSuite's inventory optimisation documentation and Shopify's reorder point guide. Use consistent units. If demand is units per day, lead time must be in days. If you measure demand by working day, decide whether supplier lead time is also measured in working days. Mixing calendar days and working days creates avoidable errors. A complete Indian business example Imagine a Pune-based homeware seller that ships 18 stainless-steel bottles per day on average. Its supplier takes eight calendar days from purchase order to stock becoming available for sale. The owner keeps 60 units as a planning buffer for demand spikes and late deliveries. InputValueCalculationAverage daily demand18 units540 units sold ÷ 30 daysAverage replenishment lead time8 daysFrom PO release to available stockExpected demand during lead time144 units18 × 8Safety stock60 unitsOwner's initial buffer assumptionReorder point204 units144 + 60 The seller should review a new order when the inventory position reaches 204 units. The safety-stock figure is a planning choice, not a universal recommendation. It should be tested against actual variability and the cost of stockouts. Step 1: measure demand with clean data Use at least 30 to 90 days of sales where possible. Remove duplicate orders, cancellations and returns that did not represent final demand. Mark stockout days separately. If an item was unavailable for seven days, sales recorded during those days may understate customer demand. For an established seasonal business, compare the same period in earlier years instead of using only a recent average. Example: A stationery seller records 720 units sold over 30 days, but the product was unavailable for five days. A naive average gives 24 units per calendar day. A rough in-stock sales rate is 720 ÷ 25 = 28.8 units per available day. That second figure may be a better starting estimate, though it can still be biased by promotions or weekday patterns. Document whether your demand figure represents units sold, units ordered or estimated true demand. Do not switch definitions silently between monthly reviews. If you need a broader demand planning system, see Nitross's small-business demand forecasting guide. Step 2: measure the real replenishment lead time Lead time begins when a replenishment order is released and ends when stock is available for use or sale. Supplier production time is only one part of that journey. Include order confirmation, packing, transport, customs if relevant, receiving checks and putaway. A vendor may quote five days, while the stock becomes usable after eight. Recent orderPO dateAvailable dateElapsed calendar daysPO-1011 Sep8 Sep7PO-10210 Sep19 Sep9PO-10321 Sep29 Sep8 The average is (7 + 9 + 8) ÷ 3 = 8 days. Three observations are not enough for a stable estimate, but they show the method. Review more orders and keep unusually delayed shipments visible rather than deleting them without a reason. Track the supplier's lead-time variability separately from the average. Step 3: choose safety stock for the risk you can afford Safety stock protects against demand and supply uncertainty. It is not simply a percentage added to every item. High-value slow-moving products and cheap fast-moving essentials need different policies. Your target service level should reflect how costly a stockout would be and how much capital a buffer consumes. Simple method for a new business If you do not have enough reliable data, start with a transparent buffer expressed in days of average demand. For the bottle seller, three days of demand is 3 × 18 = 54 units. Rounding to 60 is a reasonable trial assumption if shelf space and cash allow it. Record why you chose it, then review actual stockouts and surplus after four to eight weeks. Statistical method when you have sufficient history For businesses with usable daily demand and lead-time data, a statistical safety-stock calculation can reflect variability. Oracle NetSuite documents an approach using a service-level z-score and the standard deviation of demand over lead time. Its combined formula accounts for variation in both demand and lead time, under simplifying assumptions. Safety stock = z × √[(average lead time × daily demand variance) + (average daily demand² × lead-time variance)]. Here, variance is the square of standard deviation. This approximation assumes independent variation and a suitable distribution of lead-time demand. It may perform poorly for intermittent demand, promotions or strong seasonality. Do not choose a high service-level target simply because it sounds professional; the buffer can become expensive. Step 4: use inventory position, not only shelf stock For a continuous-review reorder system, the trigger should normally use inventory position = on-hand stock + confirmed stock on order − backorders or committed shortages. If 120 units are on the shelf and 100 more are already on a confirmed purchase order, inventory position is 220 before other commitments. That is above the example ROP of 204, so an additional order may not be needed yet. If you ignore stock already on order, you can create duplicate purchases. If you ignore customer backorders, you can wait too long. Businesses that review stock only once per week need to account for the review interval as well, because demand continues between reviews. A basic continuous-review ROP cannot be copied unchanged into a periodic-review system. Reorder point versus reorder quantity These answer different questions. The reorder point tells you when to order. Reorder quantity tells you how much to buy. You might trigger at 204 units but order 300 units because of supplier pack sizes, minimum order quantities, freight economics or a target maximum stock level. One simple order-up-to rule is: order quantity = target stock position − current inventory position, rounded to valid pack multiples. The target must reflect expected demand, review frequency, available cash and shelf space. For an established business, compare this with economic order quantity or minimum-order constraints, rather than assuming the largest supplier discount produces the best outcome. What does too much safety stock cost? Suppose the bottle seller adds another 150 units as a precaution. At a purchase cost of ₹180 each, the additional cash tied up is 150 × ₹180 = ₹27,000. If annual carrying cost is estimated at 20% of inventory value, the annual holding cost of that extra buffer is about ₹5,400, excluding unusual damage or obsolescence. The 20% figure is an example assumption, not an industry rule. Compare that cost with the likely contribution lost during stockouts and the customer impact of late delivery. If an item is easy to substitute, a large buffer may not be justified. If a missing component stops an entire production line, a larger buffer may be rational. Build a spreadsheet without inventory software ColumnWhat to enterSKUUnique product codeAverage daily demandUnits per calendar dayAverage lead timeCalendar days to usable stockSafety stockUnits of bufferReorder pointDemand × lead time + safety stockOn-handUsable physical unitsOpen purchase ordersConfirmed inbound unitsBackordersUnits already owedInventory positionOn-hand + open POs − backordersActionOrder if inventory position ≤ ROP In a spreadsheet where daily demand is in B2, lead time in C2 and safety stock in D2, the formula is =ROUNDUP(B2*C2+D2,0). If inventory position is in H2, a simple flag is =IF(H2<=E2,"REORDER","OK"), assuming E2 holds the reorder point. Verify that your spreadsheet columns match the example before copying formulas. For broader decisions about cash tied up in stock, see Nitross's inventory turnover guide and working-capital guide. Special cases for Indian businesses Festival or promotional demand Demand around Diwali, school reopening or a marketplace sale may be much higher than the historical average. Use a time-specific forecast and an event buffer. Do not let one promotional week permanently raise the reorder point for the rest of the year. Imported inputs Lead time can include customs clearance, shipping disruption and inspection. Keep separate lead-time histories by supplier and route. A global average may hide one unreliable corridor. Review landed cost and working-capital exposure before switching to air freight. Perishable or short-life goods A higher buffer can create spoilage. Include expiry dates, minimum shelf life at receipt and first-expiry-first-out practices. Sometimes smaller, more frequent orders are safer even when unit prices are higher. Slow-moving spare parts Demand may occur only once every few months. Average daily demand can be misleading. Use criticality, equipment downtime cost and supplier alternatives, and consider an intermittent-demand method or manual approval. A 30-day implementation plan Days 1 to 5: Select 20 SKUs that drive most sales, stock value or production risk. Clean product codes and recent transaction records.Days 6 to 10: Calculate average demand and record actual supplier lead times. Identify stockout days and returns.Days 11 to 15: Assign a transparent safety-stock rule to each SKU. Document assumptions and set the first reorder points.Days 16 to 22: Add inventory-position tracking, open PO quantities and backorders. Test the alerts on real orders.Days 23 to 30: Review stockouts, excess inventory, missed alerts and cash committed. Adjust only where evidence supports a change. Common mistakes Using a supplier's quoted dispatch date instead of the date stock becomes usable.Applying one safety-stock percentage to every SKU.Ignoring open purchase orders and triggering duplicate replenishment.Using sales recorded during stockouts as an unbiased demand estimate.Confusing reorder point with minimum order quantity.Using a normal-demand statistical formula for highly intermittent items without testing it.Never reviewing assumptions after supplier or customer behaviour changes. FAQs What is the reorder point formula?Average daily demand multiplied by average replenishment lead time, plus safety stock. Use the same time unit for demand and lead time. Is reorder point the same as minimum stock?Not always. A reorder point is a trigger for placing an order. Minimum stock may refer to a separate policy threshold or a buffer. Define your company's terms clearly. Can I calculate reorder point in Excel or Google Sheets?Yes. You need demand, lead time, safety stock and inventory position for each SKU. A simple spreadsheet can support an initial pilot. What if the supplier has a minimum order quantity?Keep the reorder trigger separate from the purchase quantity. When the trigger is reached, compare the MOQ with cash, space, shelf life and demand before ordering. How often should reorder points change?Review fast-moving items weekly during an initial rollout, then at a frequency matched to volatility. Recalculate after a sustained demand shift, lead-time change or major promotion. Your next useful action Choose ten high-impact SKUs and calculate their reorder points using the last 60 to 90 days of usable data. Compare the proposed triggers with your last three actual stockouts and your current open purchase orders. Fix the assumptions that caused the biggest errors before expanding the system across your catalogue. SourcesOracle NetSuite, Inventory Optimization Calculations.Shopify, Reorder Point Formula.Shopify, Min-Max Inventory Planning.