An EOQ calculator works out the economic order quantity: the number of units to order each time so that the yearly cost of placing orders plus the cost of holding stock is as low as possible. Enter your yearly demand, the fixed cost of each order and the yearly cost of holding one unit. The calculator gives the best order size, how many orders you will place a year, the days between orders and the yearly costs, including purchases if you add the unit price.
The EOQ formula
Q* = √(2DK ÷ h)
Total cost T = PD + KD ÷ Q + hQ ÷ 2
Here D is the annual demand, K the fixed cost per order, h the annual holding cost per unit and P the purchase price per unit. Ford W. Harris derived this square-root rule in 1913 for the most economical lot size, balancing the cost of setting up each order against the cost of carrying stock. The total yearly cost is the purchase cost, plus the ordering cost (K times the D ÷ Q orders a year), plus the holding cost (h times the average stock of Q ÷ 2). Setting the derivative of that cost to zero gives the EOQ. In this form the price P does not appear: only K, D and h matter, although a higher price can raise h, because Harris charged interest on the value of the stock.
How to use the EOQ calculator
- Enter annual demand in units.
- Enter the cost per order: the fixed cost of placing and receiving one order, whatever its size.
- Enter the holding cost of keeping one unit in stock for a year, such as storage and insurance.
- Optionally enter the unit price and an interest rate to add the cost of money tied up in stock to the holding cost.
- Press Calculate.
Worked example
For example, take annual demand of 10,000 units, an order cost of $40, a unit price of $50, a yearly storage cost of $4 per unit and an interest rate of 2 percent. The holding cost is $4 + $50 × 2% = $5 per unit. The EOQ is √(2 × 10,000 × 40 ÷ 5) = √160,000 = 400 units, so the business places 10,000 ÷ 400 = 25 orders a year, about one every 14.6 days. Ordering costs $40 × 25 = $1,000 a year and holding costs $5 × 400 ÷ 2 = $1,000 a year. With purchases of $500,000, the total yearly cost is $502,000.
Why the two costs balance
Ordering more units at a time means fewer orders, so ordering costs fall, but the average stock rises, so holding costs go up. Ordering fewer units does the opposite. The EOQ is the point where the two pull equally, and in the basic model ordering and holding costs are exactly equal there, as the example shows with $1,000 each. Compare other order sizes: ordering 500 units costs $502,050 a year and ordering 300 units costs $502,083.33, both a little more than the $502,000 at the EOQ.
A flat cost curve
Those comparisons show something useful in practice: the total cost changes slowly near the EOQ, as Harris also found. Ordering 25 percent more or less than the ideal quantity adds only about $50 to $83 a year in the example. That means you can round the EOQ to a convenient pack or pallet size, or to a quantity your supplier prefers, without losing much. It also means small errors in your cost estimates usually make little difference to the total cost, even if they shift the calculated quantity.
Estimating the costs
The cost per order should include everything that happens each time you order, whatever the size: the time to raise and approve the order, delivery charges that are fixed per shipment, and the work of receiving and checking goods. The holding cost covers storage space, insurance, handling, damage and the money tied up in stock, which is why the calculator lets you add an interest rate on the unit price. If you only know the holding cost as a percentage of the price, enter zero storage cost and put the whole percentage in the rate box.
Assumptions to keep in mind
The basic model assumes demand continues at a constant rate, with stock running down to nothing before each new lot arrives. Harris himself warned against relying on a formula alone. Real demand varies, deliveries take time and suppliers often offer quantity discounts, which can make larger orders cheaper overall. Businesses usually order a little before stock runs out and keep a safety stock to cover uncertain demand. For stock levels and turnover, try the inventory calculator, and for unit costs the unit price calculator.
Using EOQ for planning
The number of orders a year and the days between orders help plan purchasing work and warehouse space. In the example, an order every two weeks or so for 400 units means the warehouse needs room for up to 400 units at a time, plus any safety stock. If space is limited, you can work out the cost of ordering less often than the EOQ and compare it with the cost of renting more space.
Common mistakes
- Using a per-unit cost as the order cost. K is a fixed cost per order.
- Mixing periods. Use yearly demand with a yearly holding cost.
- Forgetting the cost of money tied up in stock. Add it through the interest rate.
- Treating EOQ as exact. The cost curve is flat, so round to a sensible order size.
What next
Use this often? Add EOQ to your Home screen.
Frequently asked questions
How does an EOQ calculator work?
It takes the square root of twice the annual demand times the order cost, divided by the holding cost per unit per year.
What is the EOQ in the worked example?
With 10,000 units a year, $40 per order and $5 holding cost, the EOQ is 400 units and the total cost $502,000.
Does the unit price change the EOQ?
Not directly. Only the order cost, demand and holding cost matter, though price can raise the holding cost.
Why are ordering and holding costs equal at the EOQ?
In the basic model the total cost is lowest where the two costs balance.
When does EOQ not apply?
When demand is not steady, deliveries are not instant or quantity discounts change the price.
Sources
Was this tool helpful?
What went wrong?
We only receive the reason you pick, never what you typed into the tool.
Thanks for your feedback.