• Preview of Volume Discount and Price Break CalculatorExcel workbook preview

Negotiation, Cost Analysis and Savings

Volume Discount and Price Break Calculator

$17.99 Free XLSX
Excel workbook · 12 KB

3 downloads per free account, no card needed.

Need more than 3? Get all 300 templates for $249 One payment, lifetime access, including every template added later.

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.