This calculator gives estimates for education and planning. It is not investment, tax or legal advice; for decisions about your own situation, talk to a qualified financial professional.
Suppliers often cut the price for larger orders, which changes the best order size. The EOQ with quantity discounts calculator takes the annual demand, the cost of an order, the holding rate and three price tiers, and gives the best order quantity, the lowest total annual cost, the saving against the first price and the total cost at each price.
How the calculation works
- For each price, the EOQ is √(2 × demand × order cost ÷ (holding rate × price)). A supplier’s price break may put it outside the range where that price applies.
- Make the quantity feasible: if the EOQ is below the smallest order size for its price, order at that minimum; if it is above the range, use the top of the range.
- For each price, the total annual cost = purchase cost (demand × price) + ordering cost (demand ÷ quantity × order cost) + holding cost (quantity ÷ 2 × holding rate × price).
- Choose the price with the lowest total cost. A lower price can win even with a quantity far above the plain EOQ.
Example
Demand is 12,000 units a year, an order costs $80 and holding costs 20 % of price. Prices are $10 below 500 units, $9.50 from 500 and $9.00 from 2,000. The first price works with 499 units for $122,423. The second works at its EOQ of 1,005 units for $115,910. The third needs at least 2,000 units and costs $110,280. So the best order is 2,000 units, saving $12,143 against the first price.
Why it matters
Taking a discount can save more on the purchase price than it adds in holding cost, but only up to a point. The calculator compares every tier, with the order quantity each one requires, and shows whether it pays to order more than the plain EOQ.
Good to know
The model has constant demand, a fixed order cost and a holding cost proportional to the unit price. It assumes the discount applies to the whole order, not just the extra units, which is the usual all-units discount. Incremental discounts and limits on storage space or shelf life need a different calculation.
Related tools
The EOQ calculator gives the order size for a single price, the economic production quantity calculator covers production runs and the inventory carrying cost calculator estimates the cost of holding stock.