Free calculators

EOQ calculator: economic order quantity

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.

Calculate

Results, updated as you type. The defaults reproduce the worked case.
ResultValue
Holding cost per unit per year3.8324
Economic order quantity (EOQ)4,384.5
Orders a year21.82
Weeks between orders2.38
Annual ordering cost8,401.59
Annual holding cost of cycle stock8,401.59
Total annual cost at the EOQ16,803.18
Total annual cost at your current order size22,250.80
Extra cost of your current order size32.42%

Runs in your browser: nothing you type is sent anywhere.

Using this for a real deal?

The formula

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))

How it works

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.

Embed this calculator

Free to embed on your website, blog or intranet, with no sign-up and no tracking. Copy the code below and paste it into any HTML block; the calculator resizes itself to fit.

Preview the embedded version

Questions people ask

What is the EOQ formula?

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.

What costs go into the holding cost?

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.

When should I reorder?

EOQ says how much to order; the reorder point says when. Use the reorder point calculator with safety stock for the second.

The book behind this calculator

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 →

All free calculators → · Free Excel templates →