[Inventory & Supply Chain]

EOQ Calculator

Balance setup costs against carrying costs. Economic order quantity.

Demand & Ordering
units
$/order
$/unit
%
Optimal Order

Economic Order Quantity

490units per order

Orders / Year

24.5

Cycle Time

14.9days

Total Cost

$2,449.00/ year

Avg Inventory

245units (EOQ / 2)

Avg Inventory Value

$6,125.00

Cost Balance
Annual Ordering Cost$1,225.00
Annual Holding Cost$1,225.00
Inputs

D = Demand

12,000units / year

S = Setup Cost

$50.00/ order

H = Holding Cost

$5.00/ unit

How EOQ Works

EOQ = √(2DS / H)

Work one part number and one supplier at a time. Annual Demand is twelve months of usage in units, so multiply a monthly figure by twelve first - entering the monthly number shrinks the answer by roughly three times. Order / Setup Cost is what one extra order actually costs you: buyer time, receiving, inspection, and the changeover if you make the part yourself. Unit Cost is the landed cost you pay, freight and duty included. Annual Holding Cost Rate is a percentage of that unit cost, not a dollar amount, and it covers capital, space, insurance and obsolescence. The maths assumes steady demand, so re-run it when usage moves.

D = DemandAnnual units required
S = Setup CostCost per order placed
H = Holding CostUnit Cost × Holding Rate
Frequently Asked Questions

Do I enter annual demand or monthly demand?

Annual. The field is Annual Demand in units, and every output derived from it - orders per year, cycle time in days, total annual cost - assumes twelve months of usage. Feed it a monthly number and the quantity comes out about three and a half times too small, because the formula takes a square root.

What do I do when the EOQ is not a buyable quantity?

Round it to the nearest pack, pallet or minimum order quantity. Total cost changes slowly either side of the optimum, so a quantity rounded to how the part is sold costs little more than the exact figure. The H = Holding Cost card prices the rounding: half the extra units times that figure is a year of it.

Does EOQ still work when demand is lumpy?

Not well. The formula assumes demand arrives at a constant rate, a fixed cost per order and a holding cost that scales with average stock. For a part ordered to a few large project releases a year, size the order to the release and use EOQ only on parts with steady repeating usage.

What does a correct EOQ result look like?

There is no target quantity. The check is the Cost Balance bars: at the economic order quantity, annual ordering cost and annual holding cost come out equal, because that is where the two curves cross. If one bar dwarfs the other, one of the two cost inputs is wrong rather than the quantity.

What is the difference between EOQ and reorder point?

EOQ answers how much to order and the reorder point answers when. They are independent and you need both: the reorder point watches stock on hand against lead time demand, then you place an order for the EOQ. Changing lead time moves the trigger level without changing the economic quantity at all.

[Stop Guessing Batch Sizes]

Optimize Inventory Automatically Across Every SKU.

WorkCell tracks demand, ordering costs, and holding costs in real time - so you always order the right quantity at the right time.