Pricing
Cake pricing calculator: the formula and the numbers to put in it
The one division a cake pricing calculator performs, the five inputs it needs, how to get a defensible number for each and a full worked example from ingredients to final price.
the ibakepro team ·
A cake pricing calculator does one division. Everything that makes it right or wrong happens before that division, in the five numbers you feed it.
This post is the calculator on paper: the formula, then each input in the order it arrives, then one worked example carried through to a finished price. Do it by hand once and you can tell whether any calculator you use afterwards is giving you a sane answer.
Every figure below is in units. Substitute your own currency.
The formula
Price = total cost / (1 - target margin)
Margin here is a share of the selling price, so a 45% margin means 45 of every 100 you charge is left after cost. Dividing by (1 minus the margin) is the only way to hit that. Nothing else in this post is arithmetic you can get wrong; this one is, and the last section shows what it costs.
Total cost is four lines added together: ingredients, packaging, labour and overhead. Delivery sits outside all of it.
Input 1: ingredients, at what you paid
The ingredient cost is the pack price divided by the pack quantity, converted into the unit you measure in, multiplied by the quantity that came out of the tub.
Five lines from the example cake:
- Flour: a 5 kg (11 lb) sack at 9.00 is 0.0018 per gram. The cake takes 900 g (2 lb), so 1.62.
- Butter: 1 kg (2.2 lb) at 12.00 is 0.012 per gram. 800 g (1.75 lb) is 9.60.
- Sugar: 2 kg (4.4 lb) at 3.60 is 0.0018 per gram. 850 g (30 oz) is 1.53.
- Eggs: 5.40 a dozen is 0.45 each. Fourteen eggs is 6.30.
- Fondant: a 750 g (1.65 lb) block at 6.75 is 0.009 per gram. 600 g (21 oz) is 5.40.
Colours, vanilla and dusts add 2.55 between them. Ingredients total 27.00.
Two things decide whether that total is right. Cost the quantity you take out of the pack, not the quantity that ends up in the cake, because trimmings are bought and paid for. And keep the decimal places: 0.0018 per gram rounds to 0.00 in a two-decimal cell, and every cake using that flour then prices it at nothing.
Input 2: labour, at a real rate times actual hours
Two halves, both usually understated.
The rate is what you would have to pay a competent decorator to do this instead of you. A rate you never set is a rate of zero, and a price built on zero looks complete. The example uses 25.00 an hour.
The hours are every hour the order consumes, and decorating is the smallest of them. For the example cake: consultation and messages 0.5, sourcing and the shop trip 0.5, baking 1.0, filling and crumb coating 0.75, decorating 1.25, boxing and washing up 0.5. That is 4.5 hours, and at 25.00 an hour the labour line is 112.50.
If you have never timed an order, time the next one from the first message to a clean kitchen. Almost nobody guesses high, and the ratio between your estimate and the clock is the number that transfers to the next twenty quotes.
Input 3: packaging
Its own line, never folded into ingredients, because folding it in makes it invisible and double counting it makes your margin read worse than it is.
For the example cake: a 25 cm (10 in) drum at 1.80, the box at 2.40, non-slip mat 0.35, a metre (about 3 ft) of ribbon at 0.55, four dowels at 0.10 each for 0.40 and a label at 0.10. Packaging totals 5.60.
Count the packages rather than writing 1. Packages needed is quantity divided by package capacity, rounded up, so six cupcakes in single boxes is six boxes. The outer carton and the cold pack exist only because the order travels, so they belong to the delivery and not to a collection order.
Materials, meaning ingredients plus packaging, come to 32.60.
Input 4: overhead, per order
Two different costs that need allocating two different ways.
Costs that scale with the job. Power for a long bake, gas, water, wear on the mixer. Charge these as a percentage of materials plus labour. The example uses 12%, applied to 145.10, giving 17.41.
Fixed monthly costs. Rent or the share of your home the kitchen occupies, insurance, licences, subscriptions, the accountant. These arrive whether or not you bake, so a percentage is the wrong tool. Total them for a month and divide by orders completed in a month. The example uses 960.00 of fixed costs and 40 orders, giving 24.00 an order.
Input 5: delivery, priced separately
Delivery is not part of the cake price and not part of the margin calculation. It is a reimbursement for a round trip, added as its own line after the price is set and measured against the drive rather than the order. Kept outside, a fee cannot flatter your margin, and a fee that fails to cover the trip shows up as a shortfall on the delivery instead of disappearing into the cake.
The worked example, end to end
A two-tier fondant birthday cake, collected.
| Line | Amount |
|---|---|
| Ingredients | 27.00 |
| Packaging, board and box | 5.60 |
| Labour, 4.5 hours at 25.00 | 112.50 |
| Overhead at 12% of materials plus labour | 17.41 |
| Fixed monthly costs, per-order share | 24.00 |
| Total cost | 186.51 |
| Target margin | 45% |
| Price, 186.51 / 0.55 | 339.11 |
Check it backwards. 339.11 minus 186.51 is 152.60 of profit, and 152.60 divided by 339.11 is 45.0%. That is the test to run on any calculator: price minus cost, divided by price, should equal the margin you asked for.
Read the structure, not the proportions. Labour is 60% of cost here because fondant work is time-heavy, and a plain sheet cake sits at the other end of that ratio, as do two decorators of different speed working from the same sketch.
Wrong turn one: multiplying by 1.45
Markup is a multiple of cost. Margin is a share of price. Multiply 186.51 by 1.45 and you get 270.44, which feels like a 45% uplift and is not a 45% margin.
The profit is 83.93 on a price of 270.44, so the margin is 31.0%. Against the 152.60 you meant to make, 68.67 has gone. The general result is worth memorising: use markup where you meant a margin of m, and you give away exactly m of your intended profit. At a 45% target you keep 55% of the profit you planned.
Wrong turn two: labour left at zero
Take the same cake with the labour line blank. Materials 32.60, overhead now 12% of 32.60 which is 3.91, fixed share 24.00. Total cost 60.51, and at a 45% margin the price is 110.02.
That price is 110.02 against a real cost of 186.51, so every one you sell loses 76.49, and the calculator that produced it displayed a confident 45%.
Before you trust the answer
- Does price minus cost, divided by price, equal your target margin?
- Is the hourly rate one you would accept from an employer?
- Are the hours timed or remembered?
- Is the board on the list? The box? The dowels?
- Does anything in the number cover the rent?
- Is delivery outside the margin, priced against the round trip?
What a calculator cannot do
It computes one cake on one day. Every input above moves. Flour moves, your hourly rate should move, your order count moves and with it the per-order share of the rent. The price you published does not move on its own, which is correct, and also means a price set from last spring's costs is quietly earning less than it says. Deciding which products need repricing after an input cost changes is worked through in your flour just went up 20 percent, now what.
Software is for the repetition. ibakepro holds one cost per unit for everything you buy, converts the pack into the gram, keeps packaging on its own line and recosts every product when a supplier price moves. Your hourly rate and your real minutes are the two inputs only you can supply; set them first, because they start at zero. Recipe costing covers what it does with the numbers once you have them.