The order size that minimises ordering plus holding cost, with the number of orders, the cost of each side and what your current batch size costs you. Free, in the browser, no sign-up.
The economic order quantity is EOQ = √(2 × D × S ÷ H): twice the annual demand times the cost of one order, divided by the cost of holding a unit for a year, square-rooted. With the defaults below, 95,680 units a year, 385 an order and a 28.60 unit held at 13.4 per cent a year, the EOQ is 4,384.5 units, about 22 orders a year, at a minimum annual cost of 16,803.18.
| Result | Value |
|---|---|
| Holding cost per unit per year | 3.8324 |
| Economic order quantity (EOQ) | 4,384.5 |
| Orders a year | 21.82 |
| Weeks between orders | 2.38 |
| Annual ordering cost | 8,401.59 |
| Annual holding cost of cycle stock | 8,401.59 |
| Total annual cost at the EOQ | 16,803.18 |
| Total annual cost at your current order size | 22,250.80 |
| Extra cost of your current order size | 32.42% |
Runs in your browser: nothing you type is sent anywhere.
EOQ = √(2 × D × S / H), with H = unit cost × holding rate
Total cost = D / Q × S + Q / 2 × H, at its lowest when the two terms are equal
In Excel: =SQRT(2*D*S/(UnitCost*HoldingRate))
The holding rate should include the cost of capital, storage, obsolescence and insurance: 13.4 per cent in the default case. At the EOQ the annual ordering cost equals the holding cost of the cycle stock, which gives a quick test of any batch: if ordering costs far more than holding, the batch is too small.
The cost curve is flat near the minimum: a batch 25 per cent away from the EOQ usually costs only a few per cent more. Round to a pack or pallet size without worry; a batch half the EOQ, like the 2,000 in the defaults, costs a third more.
Go further with the worked example, step by step and the companion files for Supply Chain Management.
EOQ = square root of (2 × annual demand × cost per order / holding cost per unit per year). For 95,680 units, 385 per order and 3.8324 holding cost, EOQ is 4,384.5 units.
Cost of capital tied up in the stock, storage, obsolescence and insurance, usually as a percentage of unit cost. In the default case they add up to 13.4 per cent, 3.8324 per unit a year.
EOQ says how much to order; the reorder point says when. Use the reorder point calculator with safety stock for the second.
This calculator comes from Supply Chain Management by Julian R. Sterling, which works the same case in full, with every figure in a free workbook.
Get the book on Amazon → DRM-free PDF edition, $19.99
If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review.
Not on Amazon: 36 paperbacks by Julian R. Sterling on how to read the documents, printed on demand and shipped worldwide. Browse the bookshop →