GenFrontier homeScope a project
Menu
Filed under
Deliver toBuyers and planners setting order quantities for steady-demand items

EOQ calculator: economic order quantity

Find the economic order quantity from annual demand, order cost, unit cost and carrying cost rate, with the EOQ formula and a worked example.

Plan an inventory project
resources / eoq-calculator
An old balance scale holding perfectly level, with small cartons on one pan, coins on the other and a red pointer in the middle

Calculator

Example values are filled in. Replace them with your own; results update as you type. Nothing you enter leaves your browser.

Results

Holding cost per unit per year
$3.48
Economic order quantity
1,083 units
Orders per year
22.2
Annual ordering cost
$1,884
Annual holding cost (average cycle stock)
$1,884
Total of the two
$3,768

Classic EOQ assumes steady demand, a fixed cost per order and no quantity discounts. Round to a pack, layer or pallet quantity before using it.

The economic order quantity (EOQ) is the order size that balances two costs pulling in opposite directions. Ordering often costs more in purchase orders, receiving and paperwork. Ordering a lot at once costs more to hold. ASCM describes EOQ as a fixed-order-quantity model that minimizes “the combined costs of acquiring and carrying inventory.” This calculator applies the classic formula and shows the cost on each side.

How to use the calculator

  1. Annual demand in units, in the same unit you order in.
  2. Cost to place and receive one order. Include buyer time, purchase order processing, receiving and inspection labor, and any fixed charge per order. Leave out the price of the goods and any freight that changes with quantity.
  3. Unit cost at cost, not selling price.
  4. Annual carrying cost rate as a percentage of unit cost. If you do not have one, build it with the carrying cost calculator.

The formula

H = C × i

EOQ = √(2 × D × S ÷ H)

Symbol Meaning Example value
D Annual demand (ASCM writes A, annual usage) 24,000 units
S Cost to place and receive one order $85
C Unit cost $14.50
i Annual carrying cost rate, as a decimal 0.24
H Holding cost per unit per year Calculated

With ASCM’s letters, the same formula reads EOQ = √(2AS ÷ iC). The calculator also reports orders per year (D ÷ EOQ), annual ordering cost (orders per year × S) and annual holding cost on the average cycle stock (EOQ ÷ 2 × H).

Example (fictional). Item EX-20118 uses 24,000 units a year. Each purchase order costs $85 to place and receive. The unit cost is $14.50 and the carrying rate is 24%.

  • H = $14.50 × 0.24 = $3.48 per unit per year
  • EOQ = √(2 × 24,000 × 85 ÷ 3.48) = √1,172,414 = 1,082.8, shown as 1,083 units
  • Orders per year: 24,000 ÷ 1,082.8 = 22.2, about one every 16 or 17 days
  • Annual ordering cost: 22.17 × $85 = $1,884
  • Annual holding cost: 1,082.8 ÷ 2 × $3.48 = $1,884
  • Total of the two: $3,768

Reading the result

At the EOQ, annual ordering cost equals annual holding cost. That makes a useful check: if your current ordering pattern puts far more money on one side, either the order quantity or the cost inputs are off.

The total cost curve is flat near the bottom. If the item comes 1,200 to a pallet, ordering full pallets gives 20 orders a year ($1,700) and $2,088 of holding cost, a total of $3,788, which is $20 a year more than the EOQ. Ordering 500 at a time costs $4,950. Round the EOQ to a case, layer or pallet quantity without worrying, but do not drift far below it.

Common mistakes

  • An order cost that includes everything. Spreading the whole purchasing budget over the year’s orders overstates S. Use the cost that actually changes when you place one more order.
  • A carrying rate that is only interest. The borrowing rate leaves out storage, insurance, shrink and obsolescence. ASCM puts typical carrying costs at 10% to 35% a year.
  • Units that do not match. Annual demand in eaches with a unit cost per case gives a quantity that is wrong by the pack size.
  • Applying it to every item. EOQ suits steady, independent demand. It is the wrong tool for one-off projects or seasonal buys.

When the simple model stops working

Classic EOQ assumes steady demand, a fixed cost per order, a constant unit price, instant replenishment and no limit on space or shelf life. Expect to adjust it when:

  • Quantity discounts or freight breaks make larger orders cheaper per unit. Compare total cost, including purchase price, at each break.
  • Minimum order quantities sit above the EOQ.
  • Shelf life or obsolescence limits how long stock can sit.
  • Several items come from one supplier and are ordered together to fill a truck.
  • Space is limited, so the warehouse cannot hold the quantity the formula suggests.
  • You make the item yourself, where a production quantity model that accounts for the production rate fits better.

EOQ tells you how much. The reorder point calculator tells you when, and the safety stock calculator sizes the buffer underneath both. To keep those settings maintained per item inside your ERP or WMS, see inventory management software.

Scope your project.

Tell us what you need to track, which systems you run and when it has to work. We reply with questions or a time to talk.