-
Excel workbook preview
Negotiation, Cost Analysis and Savings
Volume Discount and Price Break Calculator
3 downloads per free account, no card needed.
Who this is for
A buyer weighing a supplier's tiered price list who must decide how much to order at a time and whether to buy up to the next break.
What is inside
- Tier table of 5 sample price breaks with 3 blank tiers
- All-units and incremental totals for 10 sample order sizes, 14 blank rows
- Next break quantity, units to it and the total cost at the break
- Buy-up check: flags when ordering more costs less
- Annual cost per order size with ordering and holding costs
- Lowest annual cost order size highlighted
How to use it: Enter the supplier's price breaks in ascending order, your annual demand, order cost and holding cost, and the order sizes you want to compare.
Files & formats
- XLSXvolume-discount-price-break-calculator.xlsx12 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.
Free downloads & full access
Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.
Bought with a different email? Open your account and enter your order number.
Licence
Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves.



