Skip to content
Inventory Management | Part 4 of 8

Reorder Points and Order Quantities: When and How Much

Set the reorder point from demand, lead time and safety stock, order on the inventory position, and use the economic order quantity with its limits in mind.

Two questions decide every replenishment: when to order, and how much. They have different formulas.

When: the reorder point

Reorder point = average demand per week x lead time in weeks + safety stock

The motor flange of the drive unit plant needs 400 units per week, the lead time is four weeks, and the safety stock is 885 units. The reorder point is 400 x 4 + 885 = 2,485 units.

The comparison is made with the inventory position, not with the stock on the shelf:

Inventory position = stock on hand + open orders

Without the open orders, every item that is waiting for a delivery would be ordered a second time. The inverter module of the same plant has 150 units on hand and 300 on order. The position is 450, the reorder point 763.

Other ways to trigger an order

The reorder point with a fixed quantity fits A and B items with steady or fluctuating demand. Three other policies have their place:

  • Periodic review: every week or every month, order up to a fixed level. Useful when several items come from one supplier on one truck.
  • Minimum and maximum: below the minimum, fill up to the maximum. Simple enough for C items.
  • Kanban or two-bin: for cheap items with steady demand, a card or an empty bin is the reorder point.
  • Order for demand: no stock, order when a customer or production order needs the part. The right policy for sporadic items where the lead time allows it.

How much: the economic order quantity

The economic order quantity balances the cost of ordering against the cost of holding:

Economic order quantity = square root of (2 x annual demand x cost per order / holding cost per unit and year)

For the motor flange: annual demand 20,000 units, EUR 60 per order, holding cost 20 percent of EUR 18.50, which is EUR 3.70. The result is 805 units, rounded to four pallets of 200: 800 units, two weeks of demand.

Order quantity Orders per year Total cost per year in EUR
400 50 3,740
800 25 2,980
1,200 16.7 3,220
2,400 8.3 4,940

The limits of the formula

The formula is a good first proposal and a poor final answer. Six limits matter in practice.

  • The curve is flat. Fifty percent more than the optimum costs only 8 percent more. Round freely to pack sizes, pallets and delivery days.
  • The inputs are estimates. Nobody knows the cost per order to the euro. Use one value for all items.
  • It assumes steady demand. Use it for X and Y items only.
  • Cheap items explode. For a screw at EUR 0.04, the formula proposes 48,990 pieces, 15 weeks of demand. Cap every quantity at a maximum reach, for example 12 weeks.
  • Minimum quantities and price breaks override it. Calculate them. One percent discount on EUR 370,000 is EUR 3,700 a year, against EUR 1,960 of extra ordering and holding cost for lots of 2,400.
  • Risk is missing. Engineering changes, shelf life, space and cash are not in the formula.

The maximum and the status

Reorder point plus order quantity gives a maximum. For the motor flange: 2,485 + 800 = 3,285 units. With 3,900 units on hand, the item is above its maximum.

With the three parameters, every item has one status each week: reorder, below safety stock, above maximum, no demand or in order. In the pilot group of 40 items, four must be reordered and 24 are above their maximum.

Newsletter

One Lean idea.
Every two weeks.