Plainsheet

How to calculate your reorder point

When to reorder, how much buffer to hold, and how much to order. Try your numbers in the free calculator.

Reorder point

Reorder point = average daily sales × supplier lead time + safety stock. If you sell 20 a day, the supplier takes 5 days and you want 2 days of buffer: 20 × 5 + 20 × 2 = 140 units. When stock drops to 140, order.

Safety stock from a service level

If your daily sales vary, a buffer in days is a guess. A common method is z × daily variation × √(lead time). With a 95% service level (z = 1.645), a daily standard deviation of 4 units and a 9-day lead time: 1.645 × 4 × 3 = 19.7 units, so the reorder point is 20 × 9 + 19.7 = 199.7, round up to 200.

How much to order: EOQ

The economic order quantity balances the cost of placing orders against the cost of holding stock: √(2 × yearly demand × order cost ÷ yearly holding cost per unit). With 1,000 units a year, $50 per order and $2 holding cost per unit: √(2 × 1,000 × 50 ÷ 2) = about 224 units, roughly 4.5 orders a year.

Limits

These formulas assume steady demand. Seasonal items, supplier minimums, price breaks and unreliable lead times all call for adjustments.

Small Shop Inventory & Reorder Tracker (Excel)

Track every product, see what to reorder and what your stock is worth. Log stock in and out; see current stock, what to reorder, what your stock is worth and your gross profit.

Get it on Gumroad — $4.99 One-time purchase, instant download.

General information, not business advice.