Economic order quantity · Calculation guide

Balance the annual cost of ordering stock against the cost of holding it.

Calculation guide

Constant demand, instant replenishment, no stockouts or quantity discounts. Holding cost is currency per unit per year. The optimum can be fractional; suppliers may require whole packs.

quantity = sqrt(2*demand*ordering/holding); orders = demand/quantity; cost = orders*ordering+quantity*holding/2

Inputs

Annual demand in units

Example entry 10000.

Cost to place one order

Example entry 25 (in the selected currency).

Annual holding cost per unit

Example entry 2 (in the selected currency).

Worked example

InputValue
Annual demand in units10,000
Cost to place one order25
Annual holding cost per unit2
ResultValue
Economic order quantity500
Orders per year20
Annual ordering and holding cost1,000

Calculation steps

Economic order quantity = √((((2 × Annual demand in units) × Cost to place one order) ÷ Annual holding cost per unit))

√((((2 × 10,000) × 25) ÷ 2)) = 500

Orders per year = (Annual demand in units ÷ Economic order quantity)

(10,000 ÷ 500) = 20

Annual ordering and holding cost = ((Orders per year × Cost to place one order) + ((Economic order quantity × Annual holding cost per unit) ÷ 2))

((20 × 25) + ((500 × 2) ÷ 2)) = 1,000

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Annual demand in units10,00011,000Economic order quantity500524.404424
Cost to place one order2528Economic order quantity500529.150262
Annual holding cost per unit23Economic order quantity500408.24829
Economic order quantity →

Sources