# Order Quantity Price Break Total Cost Calculator > Source: https://netray.co/tools/order-quantity-price-break-total-cost-calculator > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Decide whether to buy more to reach a supplier price break by comparing total annual purchase, ordering and carrying cost. ## Category supply-chain ## Audience - Buyer - Materials planner - Procurement ## Tool **Kind:** calculator **Currency:** $ **Inputs:** #### Annual demand **Key:** demand **Type:** number **Default:** 12000 **Min:** 1 **Step:** 100 **Unit:** units #### Cost per order placed **Key:** order_cost **Type:** number **Default:** 60 **Min:** 0 **Step:** 5 **Unit:** $ per order **Help:** Buyer time, receiving, inspection and invoice processing. #### Annual carrying cost **Key:** carry_pct **Type:** number **Default:** 22 **Min:** 1 **Max:** 60 **Step:** 1 **Unit:** % of price **Help:** Capital, storage, handling, insurance and obsolescence risk. #### Standard unit price **Key:** price1 **Type:** number **Default:** 5 **Min:** 0.01 **Step:** 0.05 #### Price break quantity **Key:** break_qty **Type:** number **Default:** 2000 **Min:** 2 **Step:** 100 **Unit:** units #### Discounted unit price **Key:** price2 **Type:** number **Default:** 4.6 **Min:** 0.01 **Step:** 0.05 **Outputs:** #### Order quantity at standard price **Key:** q1 **Expr:** min(sqrt(2 * demand * order_cost / ((carry_pct / 100) * price1)), break_qty - 1) **Format:** integer **Description:** EOQ at the standard price, capped just below the break. #### Order quantity at discount price **Key:** q2 **Expr:** max(sqrt(2 * demand * order_cost / ((carry_pct / 100) * price2)), break_qty) **Format:** integer **Description:** EOQ at the discounted price, but never below the break. #### Total annual cost, standard price **Key:** tc1 **Expr:** demand * price1 + demand / q1 * order_cost + q1 / 2 * (carry_pct / 100) * price1 **Format:** currency #### Total annual cost, discount price **Key:** tc2 **Expr:** demand * price2 + demand / q2 * order_cost + q2 / 2 * (carry_pct / 100) * price2 **Format:** currency #### Annual saving from taking the break **Key:** saving **Expr:** tc1 - tc2 **Format:** currency **Primary:** true **Description:** Positive means buy at the break; negative means stay at the standard price. #### Take the price break? (1 = yes) **Key:** decision **Expr:** if(gt(tc1, tc2), 1, 0) **Format:** integer **Primary:** true **Chart:** #### Total annual cost vs annual demand **Type:** line **X:** demand **From:** 1000 **To:** 50000 **Steps:** 25 **Series:** - tc1 - tc2 **Disclaimer:** Uses the classic EOQ cost model with a single price break. It ignores storage limits, shelf life, cash constraints and price changes, so check those before committing. ## Content **Intro:** Suppliers offer lower prices for larger orders, and the question is always whether the saving beats the cost of holding more stock. This calculator compares total annual cost at the standard price and at the break. **Sections:** #### How to use the calculator **Body:** Enter annual demand, your cost to place an order and your annual carrying cost as a percent of price. Then enter the standard price, the quantity needed to earn the discount and the discounted price. The tool computes the best order quantity under each price, adds purchase, ordering and carrying cost for each, and shows the annual saving from taking the break. #### The method **Body:** Total annual cost equals purchase cost plus ordering cost plus carrying cost: D times P, plus D over Q times S, plus Q over two times i times P. At the standard price the best quantity is the EOQ if it falls below the break, otherwise it is capped just under the break. At the discount price the best quantity is the EOQ or the break quantity, whichever is larger, since you must order at least the break to earn the price. **Bullets:** - D annual demand, S cost per order - i annual carrying cost rate, P unit price - Q order quantity #### Reading the result **Body:** A positive saving means the discount covers the extra carrying cost, and you should order at the break. A negative saving means the extra stock costs more than the price cut saves. Look at the chart: the discount usually wins at high demand and loses at low demand, so the decision can change as volume changes. Re-run the calculation when forecasts or prices change. #### Common mistakes **Body:** Setting the carrying rate too low is the most common error, which makes every discount look attractive. Include obsolescence and storage cost. Another is ignoring the shelf life or engineering change risk of the part: a discount on a part likely to be redesigned is no saving at all. Also, check whether the supplier will allow blanket releases to earn the break without taking all stock at once. **Cta:** If you buy thousands of parts with price breaks, we can run this comparison across your whole purchase history. Ask for a review. **Faq:** #### What carrying cost rate should I use? **Answer:** Many manufacturers use a range of roughly 15 to 30 percent of unit value per year, built from capital cost, storage, handling, insurance, shrinkage and obsolescence. Calculate your own with finance rather than borrowing a generic figure. #### Does this handle multiple price breaks? **Answer:** This version compares one break against the standard price. For several breaks, run it for each break against the next lower one and choose the lowest total cost. The method is the same. #### What if the break is a blanket order commitment? **Answer:** Then you may earn the lower price without holding all stock, because releases are spread over time. Carrying cost falls, so the discount is even more attractive. Use the blanket release worksheet to plan it. #### Why does the saving change with demand? **Answer:** At higher demand you reach the break quantity faster and order more often anyway, so the extra stock held to earn the price is small. At low demand the same break means holding a long supply, and carrying cost eats the saving. ## Search terms quantity discount calculator, price break order quantity calculator, eoq with quantity discounts, should i buy more to get discount, total cost of ordering calculator, volume discount inventory calculator --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json