When to reorder and how much: reorder point and EOQ
Run out and you lose sales; overstock and you tie up cash. Two simple numbers tell you when to order and how much.
Know the stock level that should trigger a new order, and the order size that keeps ordering and holding costs lowest.
Use last year’s sales, or this year’s forecast.
Extra days of sales kept for delays and busy weeks.
Admin, delivery and receiving for one order.
Storage, insurance, damage and cash tied up, as % of stock value. 20% to 30% is common.
Reorder when stock falls to
210units
How much to order
When stock on hand falls to 210 units, place the next order.
Results are estimates for guidance. Check important figures with your accountant.
Daily sales = units sold a year ÷ 365. Safety stock = daily sales × safety days.
Reorder point = daily sales × lead time + safety stock.
Economic order quantity (EOQ) = √(2 × yearly units × cost per order ÷ yearly holding cost per unit).
Yearly holding cost per unit = cost per unit × holding %.
You sell 3,650 units a year (10 a day), the supplier takes 14 days, and you keep 7 days of safety stock. Reorder at 210 units. With SAR 200 per order and a unit costing SAR 50 at 20% a year to hold, the best order size is about 382 units, roughly every 38 days.
Bigger orders mean fewer deliveries but more cash and space tied up in stock. EOQ balances the two.
Work out the reorder point with the daily sales of the coming season, not the yearly average.
Order at least the minimum. If it is much larger than the EOQ, compare the extra holding cost with any price discount.
Run out and you lose sales; overstock and you tie up cash. Two simple numbers tell you when to order and how much.