Bundle Analyser Tool

When to use this tool

Use it when building a discounted deal — a meal deal, drink-and-snack combo or sharing platter — to check each bundle’s contribution and margin against your cost-of-sales budget, and see what you’d make at the volume you forecast.

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.

Bundle analyser features

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

The items

A row for every product in the deal — the whole analysis is built from this table. For each: whether it’s food or drink, how many are in the bundle (Qty), its normal individual price (inc tax), what it costs you to make (ex tax) and how many you sell a period on its own.

Bundle name

A short name for the deal. It shows in the verdict and on the PDF report, so you can tell scenarios apart.

Budgeted C.O.S / GP

Your target food and drink cost of sales — or flip the toggle to gross profit. Not sure? Leave the typical 35% food / 25% drink. The tool blends the two by this bundle’s food/drink mix and checks the deal against it.

Bundle price & discount

The single price for the whole deal, or the discount off buying the items separately — each one fills in the other.

Sales forecast

How many bundles you expect to sell in a period, plus the most you realistically could (which caps the sliders). It drives your total contribution and the verdict, so set it honestly.

Chart & verdict

The chart plots total contribution as bundle sales grow, with a marker at your forecast. The verdict sums it up — contribution, margin, C.O.S or GP against budget, and any royalty — flagging issues in red.

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 bundle 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