Skip to content
Omnikalc

EOQ with quantity discounts: which price break gives the lowest total cost?

Enter demand, ordering cost, holding rate and up to three price tiers to find the order quantity that gives the lowest total annual cost.

Updated on
Your inputs

Value out of range

$

Value out of range

%

Value out of range

$

Value out of range

Value out of range

$

Value out of range

Value out of range

$

Value out of range

Results

Best order quantity

2,000

Order at the third price break
Lowest total annual cost
$110,280
Saving against the best order at the first price
$12,143
Total annual cost at the first price
$122,423
Total annual cost at the second price
$115,910
Total annual cost at the third price
$110,280

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.

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.

Frequently asked questions

Why is the plain EOQ not enough with quantity discounts?

The basic EOQ finds the quantity that balances ordering and holding costs for a single price. When the price falls with larger orders, the saving on purchases may outweigh the higher holding cost, so the best order can be larger than the EOQ.

How does the calculator pick the best tier?

It finds a feasible order quantity for each price, adjusting to the range where that price applies, and computes the total annual cost of purchases, ordering and holding. The tier with the lowest total wins, and its quantity is the recommended order.

Is the holding cost a share of price?

Yes, in this model the holding cost per unit is a percentage of the unit price per year, as in most textbook treatments, so a lower price also lowers the cost of holding a unit. Typical holding rates are 15 to 30 percent, covering capital, storage, insurance and obsolescence.

What does the model leave out?

It assumes constant demand, no shortages, instant delivery and fixed prices, and it ignores storage space, shelf life and cash flow limits. If a large order would spoil or tie up too much cash, the real best order may be smaller than the one shown.

Was this calculator helpful?

Thanks for your feedback!

Results are estimates provided for information purposes. They do not replace professional advice.