Run out of stock and you lose sales. Order too much and your cash sits on shelves. Two numbers help you avoid both: the reorder point says when to order, and the economic order quantity (EOQ) says how much.
The reorder point
Order when the stock you have left will just last until the new delivery arrives, plus a little extra for surprises.
Reorder point = daily sales × lead time + safety stock.
You sell 3,650 units a year, 10 a day. The supplier delivers 14 days after you order, and you keep 7 days of sales as safety stock (70 units). Reorder when stock falls to 10 × 14 + 70 = 210 units.
Safety stock
Safety stock covers late deliveries and busy weeks. Keep more for items that sell unevenly or come from far away, and less for items you can buy locally the same week.
How much to order: EOQ
Each order costs you something: admin, delivery and receiving. Each unit you hold also costs something: storage, insurance, damage and the cash tied up. Big orders save on the first and cost more on the second. EOQ is the order size where the two balance.
EOQ = √(2 × yearly units × cost per order ÷ yearly holding cost per unit).
If an order costs SAR 200, a unit costs SAR 50, and holding stock costs 20% of its value a year (SAR 10 a unit), EOQ = √(2 × 3,650 × 200 ÷ 10), about 382 units. That is about 10 orders a year, one every 38 days.
Make it practical
- Start with your best sellers: a few items usually make up most of your sales.
- Use the coming season's sales, not the yearly average, for seasonal items.
- If the supplier's minimum order is far above EOQ, weigh the extra holding cost against any price break.
Tip: Recheck the numbers every quarter. Sales, lead times and supplier prices change, and yesterday's reorder point quietly goes out of date.
Getting the inputs from your own data
- Daily sales: units sold in the last three months ÷ the number of days. Use the busy season's figures for seasonal items.
- Lead time: the days between order and delivery on the supplier's last five orders, not the time they promise.
- Cost per order: the staff time, delivery and receiving costs of one order. An estimate is fine.
What a stock-out really costs
A missed sale costs the profit on it, and sometimes the customer. If an item makes SAR 30 profit a unit and you run out for a week at 10 units a day, that is SAR 2,100 of profit lost. Holding 70 more units at SAR 10 a year each costs SAR 700. That comparison is what safety stock is about.
Put it into practice
Set the reorder point as the minimum level for each item, check stock against it once a week, and raise the purchase order when an item reaches it.
Try your own items in the reorder point calculator, and see how fast your stock turns with the cost of goods sold calculator.