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.
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
| Input | Value |
|---|---|
| Annual demand in units | 10,000 |
| Cost to place one order | 25 |
| Annual holding cost per unit | 2 |
| Result | Value |
|---|---|
| Economic order quantity | 500 |
| Orders per year | 20 |
| Annual ordering and holding cost | 1,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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Annual demand in units | 10,000 | 11,000 | Economic order quantity | 500 | 524.404424 |
| Cost to place one order | 25 | 28 | Economic order quantity | 500 | 529.150262 |
| Annual holding cost per unit | 2 | 3 | Economic order quantity | 500 | 408.24829 |
