Skip to content
Logistics Engineering

Inventory management: economic order quantity and reorder point

The economic order quantity proved with an example, cost robustness proved, safety stock and reorder point with an example, reorder-point and periodic-review systems.

Ordering small quantities often costs in orders and transport; ordering large quantities rarely costs in storage. The economic order quantity finds the compromise, and the reorder point establishes when to order so as not to run out. In this lesson we look at the economic order quantity formula with its proof, its surprising robustness proved, safety stock and the reorder point with a complete example, and the classification of reorder systems.

The economic order quantity

Consider an item with constant demand D units per year, a fixed cost S per order (issuing, transport, receiving, inspection) and a holding cost H per unit per year. Ordering batches of Q units, stock falls steadily from Q to zero, and averages Q/2.

Inventory pattern
Stock I falls at a constant rate and is replenished by a batch Q when the order arrives. The order is issued when stock falls to the reorder point ROP, and arrives after the lead time L. Below, the safety stock SS protects against demand variations during the lead time.

The total annual cost (excluding the purchase price, which does not depend on Q) is

    \[ TC(Q) = \frac{D}{Q}S + \frac{Q}{2}H \]

Theorem. The cost is minimum for the economic order quantity

    \[ Q^* = \sqrt{\frac{2DS}{H}} \]

and at that point ordering cost and holding cost are equal, with TC(Q^*) = \sqrt{2DSH}.

Proof. TC'(Q) = -DS/Q^2 + H/2, which vanishes for Q^2 = 2DS/H; the second derivative 2DS/Q^3 is positive, so it is a minimum. At that point DS/Q^* = Q^*H/2, since this is equivalent to Q^{*2} = 2DS/H, and the sum of the two equal terms is 2\cdot Q^*H/2 = Q^*H = \sqrt{2DSH}. ∎

Example. D = 12,000 units per year, S = 50 euros per order, H = 2 euros per unit per year (20 % of a value of 10 euros): Q^* = \sqrt{2\cdot 12,000\cdot 50/2} \approx 775 units, about 15 orders a year, cost \sqrt{2\cdot 12,000\cdot 50\cdot 2} \approx 1549 euros.

Robustness

Theorem. Ordering a batch Q different from the optimum, the relative cost is

    \[ \frac{TC(Q)}{TC(Q^*)} = \frac{1}{2}\left(\frac{Q}{Q^*} + \frac{Q^*}{Q}\right) \]

Proof. Dividing TC(Q) by \sqrt{2DSH}: \frac{DS}{Q\sqrt{2DSH}} = \frac{1}{2}\sqrt{\frac{2DS}{H}}\cdot\frac{1}{Q} = \frac{Q^*}{2Q}, and \frac{QH}{2\sqrt{2DSH}} = \frac{Q}{2}\sqrt{\frac{H}{2DS}} = \frac{Q}{2Q^*}. Adding gives the formula. ∎

The function \frac{1}{2}(x + 1/x) is very flat near 1: with a batch 29 % larger than the optimum (1000 units instead of 775) the cost rises by only 3.3 %, to 1600 euros. Batches can therefore be rounded to convenient quantities (a pallet, a case) with almost no loss, and errors in estimating S and H, which enter under a square root, matter little.

Safety stock and reorder point

Demand is not constant, and the order takes a time L to arrive. One reorders when stock falls to the reorder point

    \[ ROP = \bar{d}L + z\,\sigma_d\sqrt{L} \]

where \bar{d} and \sigma_d are the mean and standard deviation of daily demand (assumed independent from day to day, so with variance over L days equal to L\sigma_d^2), and z sets the service level: with normal demand, z = 1.65 gives a 95 % probability of not running out during the lead time. The second term is the safety stock.

Example. With 250 working days, \bar{d} = 48 units a day; L = 5 days; \sigma_d = 15. Safety stock 1.65\cdot 15\cdot\sqrt{5} \approx 55 units; ROP = 240 + 55 = 295. Going from 95 % to 99 % (z = 2.33) raises the safety stock to 78 units: the last percentage points of service cost more and more.

Reorder systems

  • Reorder point (fixed quantity Q, variable interval): order Q when stock falls to ROP; it requires knowing the stock at every moment, which is easy with information systems.
  • Periodic review (fixed interval T, variable quantity): every T days order what is needed to return to a target level; simpler to organise, but needs more safety stock, because it must cover T + L days.
  • For items whose demand depends on a production plan (components of a product), MRP is used instead (Business Management lesson on production planning).

The ABC classification (lesson on warehousing) shows where to invest attention: tight control and frequent reviews for the few high-value items, simple rules for the many low-value ones.

Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
0
Would love your thoughts, please comment.x
()
x