Margin, Markup and VAT Pricing Calculator
Apply explicit purchase and sales VAT treatment to your selling margin.
Business
Recipe and Cake Cost and Pricing Calculator
Calculate the cost of a saleable batch and each portion from quantities and purchase costs. Include waste in the quantities used and keep VAT treatment consistent when choosing a margin or markup price.
Your numbers
How the calculation works
Cost a recipe or cake order before deciding its selling price. The tool combines ingredient quantities, labour and batch expenses, then shows what a chosen margin or markup implies for the batch and each portion.
Ingredient cost = quantity used / pack quantity × pack price. Batch cost adds labour, packaging and overhead. Margin price = cost / (1 − margin); markup price = cost × (1 + markup).
Cost the ingredients used
Divide each recipe quantity by its pack quantity and multiply by pack price. Add these amounts instead of charging every partly used pack in full.
Build the batch cost
Add hours multiplied by labour cost per hour, packaging and allocated overhead. Include preparation and finishing within hours if the order requires them.
Set and allocate the price
For a margin, divide cost by one minus the target percentage. For a markup, multiply by one plus it. Divide batch amounts by saleable portions.
Worked example: Margin pricing
Sample inputs demonstrate the method. They are not a forecast or product offer.
The ingredients cost €1 and €0.80. Labour of €30, packaging of €5 and overhead of €3 bring the batch to €39.80. A 25% margin requires €39.80 divided by 0.75, or about €53.07 for ten portions.
- Ingredient quantities and purchase costs
- 200,1000,5 100,500,4
- Labour hours
- 2
- Labour cost per hour
- 15
- Batch packaging
- 5
- Allocated batch overhead
- 3
- Saleable portions
- 10
- Pricing method
- Target margin on selling price
- Target percentage (%)
- 25
Expected result
- Batch cost
- €39.80
- Batch selling price
- €53.07
Worked example: Markup pricing
Sample inputs demonstrate the method. They are not a forecast or product offer.
- Ingredient quantities and purchase costs
- 1,1,20
- Labour hours
- 2
- Labour cost per hour
- 15
- Batch packaging
- 5
- Allocated batch overhead
- 5
- Saleable portions
- 12
- Pricing method
- Markup on cost
- Target percentage (%)
- 20
Expected result
- Batch cost
- €60.00
- Batch selling price
- €72.00
- Selling price per portion
- €6.00
Understanding your result
The suggested price covers the costs and profit target supplied. It does not establish what customers will pay or whether a particular tax rate applies.
Per-portion pricing allocates this batch. If portion size or yield changes, revise the recipe quantities or portion count before comparing orders.
Questions you might have
Why does a 25% margin differ from a 25% markup?
Margin is profit divided by selling price; markup is profit divided by cost. A 25% margin on a €60 cost requires €80, while a 25% markup gives €75.
Choosing the right inputs
- Ingredient quantities and purchase costs
- Use one row per ingredient: quantity used, pack quantity, pack price. Both quantities must share a unit, such as grams with grams. Omit headings.
- Saleable portions
- Enter saleable portions from this batch, rather than the size of an ingredient pack. This determines the per-portion allocation.
- Pricing method
- Choose margin when profit is a percentage of selling price, or markup when the percentage is applied to production cost.
Common mistakes to avoid
- Do not enter a 25% margin as a 25% markup; they have different denominators.
- Avoid counting packaging or labour twice within overhead and their dedicated fields.
Assumptions to check
- Use amounts in one currency and one reporting period. Results are labelled EUR; the arithmetic also works for another consistent currency.
- Include recipe waste in quantities used and enter only saleable portions. Prices exclude any output VAT unless deliberately included in the inputs.
Sources and method
Read our calculation and testing approach.