A cupcake costs about 50 cents in batter, buttercream and a liner; the rest of its cost is hands-on time, filling, frosting and decorating, and the box. A single at the counter keeps a wide margin; a dozen for a café to resell keeps a thinner one, because the decorating takes the same time either way. Margin = (price − cost) ÷ price. In the example below, a single cupcake costs $1.75 to bake and sell and goes for $4.25, a 58.9% margin. A month of four ways of selling brings $9,250 of sales and about $4,970 of gross profit.
The short version
- Margin = (price − cost) ÷ price; markup = (price − cost) ÷ cost.
- Count your time as a cost, even if you don't pay yourself yet.
- A single cupcake: $1.75, $4.25, 58.9%.
- Batter, buttercream and liner: about 50 cents.
- Hands-on time is the biggest cost.
- Café dozens keep less; decorating takes as long either way.
- TaroStack costs each cupcake from what each batch used. More below.
A cupcake, costed
Cotton Row Cupcakes, the made-up cupcake bakery in Huntsville, Alabama, I use in these examples, counts its hands-on time at $20 an hour:
| A single cupcake at the counter | Cost |
|---|---|
| Batter, buttercream and liner | $0.49 |
| Clamshell | $0.18 |
| Hands-on time and the oven | $0.95 |
| Card fees, 3% of $4.25 | $0.13 |
| Cost | $1.75 |
The year is in cupcake business plan, and whole cakes in cake business plan.
Margins by channel
| Product | Sold where | Price | Cost | Gross profit | Margin |
|---|---|---|---|---|---|
| Single cupcake | Markets and counter | $4.25 | $1.75 | $2.50 | 58.9% |
| Dozen, preorder | Customers | $45.00 | $19.80 | $25.20 | 56% |
| Dozen | Cafés, wholesale | $30.00 | $17.40 | $12.60 | 42% |
| Event order, 100 cupcakes | Weddings and parties | $325.00 | $150.00 | $175.00 | 53.8% |
The café dozen keeps 42%; the event order keeps 53.8%, with four hours of decorating in it.
A month's numbers
A month at full speed for Cotton Row Cupcakes:
| Product | Units | Sales | Gross profit |
|---|---|---|---|
| Single cupcake, markets and counter | 600 | $2,550 | $1,502 |
| Dozen, preorder, customers | 80 | $3,600 | $2,016 |
| Dozen, cafés | 60 | $1,800 | $756 |
| Event order, 100 cupcakes, weddings and parties | 4 | $1,300 | $700 |
| Month | $9,250 | $4,974 |
Singles and preorder dozens bring most of the gross profit. The cafés pay $12.60 a dozen after the same half hour of decorating as a preorder, so the bakery offers them a smaller menu of simpler designs. Cookies, by comparison, are in cookie business profit margin.
Get the calculator
Download the cupcake margin calculator. One sheet: one line for each product and channel, with its price, materials, packaging, labor and fee rate; the cost, gross profit, margin, markup and the price your target margin needs fill in. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The calculator holds one cost a cupcake. Butter at a dollar more a pound, or a dozen that came back unsold from a café, changes the month, and only the batch records show it.
How TaroStack does it
TaroStack costs each cupcake from what each batch used, so margins sit on real cost.
True cost from the batch. Each batch takes butter, flour and sugar at the price of the deliveries they came from, so a price rise shows in the next batch's cost.
Labor on the batch. The minutes a batch took are recorded on it, so the hours behind each product are on record.
Margins by product. Margins are reported per product on that actual cost, and a price-creep report per supplier shows whose prices moved.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| What a cupcake cost | One price from last season | Cost from the batch's deliveries |
| The hours behind a batch | Remembered | Labor minutes on the batch |
| An ingredient creeping up | Noticed late | A price-creep report |
| Margins by product | Re-worked by hand | Margins on real cost |
Recipes, batches, costing and margin reports are on every plan, from $49 a month. The first 30 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.