Price-Increase Break-even Tool

When to use this tool

Use it before you put a price up. A price rise adds straight onto the contribution you keep on every sale, so you can afford to lose some customers and still come out ahead — and because you now earn more per unit, the volume you can lose is usually far bigger than people fear. This tool turns “10% on” into the real number of sales you could lose before the rise starts costing you money.

Currency, tax & royalties

These live in the toolbar and work the same on every tool:

Currency

Pick your currency from the selector — it relabels the tax field to match your region.

Tax rate

Type your tax rate in the field beside the currency, or set it to 0 if you don’t want to factor in tax.

Royalties / commission

Optional. Switch on “Factor in royalties or commission” to open a panel where you set the rate with the slider (or type it exactly), rename it Royalty or Commission, and charge it on net or gross sales.

Price-increase break-even features

What you enter for this tool, and what it gives back:

The item

The current sale price (inc tax) and the item cost (ex tax) — everything it takes to make or buy one, waste included, as a single figure.

The price rise

The increase as a % on the current price, or type the new price and the tool works out the %. It re‑runs the maths at the higher price beside the current one.

Your volumes

The units you currently sell, plus a realistic min that frames the forecast slider and marks a guide line on the chart — so the answer reads as real units, not just a %.

Volume forecast

The sales drop you expect. It starts at the typical food & drink fall — about half the rise, so 10% on loses roughly 5% of sales — and the read climbs from optimistic to unlikely as you assume a smaller drop.

Result & export

The drop scale and break‑even chart show whether your forecast stays inside break‑even (green) or clears it (red). Drag the slider to test live, then export a PDF report.

Your data

These buttons sit in the “Your data” panel at the foot of the page and work the same on every tool:

Download template

Downloads a blank Excel template you can fill in offline.

Upload template

Reads a filled‑in template back in and fills the tool in one go.

Save scenario

Saves everything you’ve entered to a file you can back up or share.

Load scenario

Re‑opens a scenario you saved earlier.

PDF report

Generates a clean PDF of the analysis, ready to save, print or share.

Jargon buster

Contribution

Net revenue less cost of sales and any royalty or commission — what a sale adds before labour and overheads.

Cost of sales (C.O.S)

What the product costs you to make or buy — ingredients, packaging and waste — usually shown as a % of net revenue. Excludes labour and overheads.

Gross profit & %

Net revenue less cost of sales; the % expresses it as a share of net revenue — the mirror of cost‑of‑sales %.

Gross revenue

The total the customer pays, including tax.

Labour

The wage cost of the staff involved, usually shown as a cash figure or a % of net revenue.

Margin of safety

How far sales could fall before you stop making a profit — the cushion between your forecast and break‑even.

Net revenue

Gross revenue with tax removed — all the margin maths is worked on this figure.

Royalty / commission

A fee paid as a % of each sale, charged on net or gross. Optional — switch it on only if your business pays one.

Close