Heads up
This tool uses charts, detailed tables and multi-column inputs designed for a laptop or desktop. You can still use it here, but some elements may not display correctly and can be harder to navigate on a smaller screen.
Costing & pricing
See how many more units a discount must sell just to make the same money — with an honest read on whether that’s realistic.
Discount break-even
Use it before you run a promotion. A discount cuts the contribution you keep on every sale, so you have to make up the lost margin with extra volume — and because you now earn less per unit, the extra volume needed is almost always far bigger than the discount itself. This tool turns “20% off” into the real number of units you’d need to sell just to stand still.
A discount only pays off if extra volume more than makes up for the thinner margin. The sales forecast starts your expected uplift at the typical food & drink figure — a price cut tends to lift sales by around 0.8× the percentage off, so 10% off is worth roughly 8% more sales. Set it higher or lower to match your own promotion: the tool shows how far you are from that typical lift and whether the volume you expect would leave you better or worse off than not discounting at all. If a discount pushes contribution to zero or below, no amount of volume can rescue it — you simply lose more on every extra sale.
The item's price and cost, the discount, and how much you currently sell.
Your contribution on a single item — full price vs discounted — after VAT, cost and any royalty. Every pound of discount comes straight off it.
Where the typical lift and your forecast sit against the uplift you'd need just to break even.
Template
Download an Excel template, fill it in offline, then upload it back to populate the tool.
Save & restore
Save the whole scenario and its settings to a file you can back up, share, or reload later.
PDF report
Generate a formatted summary — break-even chart included — ready to save or share.