Selling and marketing
Cupcake Pricing Sheet: 6 Columns and Cost per Dozen
A simple sheet that shows what each cupcake costs you and what you keep.
On this page
- What columns belong on a cupcake pricing sheet
- A worked example with ingredients, labor, and overhead
- How to set an hourly rate for your labor
- How to spread overhead across a batch
- Mistakes that cost you money
- What to check before you commit to a price
- How to test a price before you print a menu
- How to keep your sheet current
- How to use the sheet for custom orders
Try the free cupcake pricing calculator
Free, no signup.
What to remember
- Cost the whole batch, then divide by the number of cupcakes.
- Your time is a cost. Put a dollar amount on it.
- Overhead like power and packaging belongs in the sheet.
- Check the final price against what your market already pays.
You do not need a spreadsheet full of formulas. A cupcake pricing sheet can live in a notebook or in a simple tool, as long as it has the same few columns every time. Start with the selling hub to see how pricing fits with taking orders and getting paid.
What columns belong on a cupcake pricing sheet
A good sheet has six columns. The first is the ingredient and its cost for the whole batch, and the second is the amount used in one batch. The third is the cost per batch, and the fourth is your labor time and rate. The fifth is overhead, and the sixth is the final price per cupcake and the margin.
List every ingredient
Write down each ingredient you use in one batch, from flour to frosting to sprinkles.
Add the batch cost
Put the cost of each ingredient for the whole batch in the next column.
Divide by the cupcake count
Divide the total ingredient cost by the number of cupcakes the batch makes.
Add your labor
Decide an hourly rate for your time, then multiply by the hours one batch takes.
Add overhead
Include power, packaging, labels, and any monthly tool at $20 a month.
Set the price and check the margin
Add ingredient, labor, and overhead cost per cupcake. Then choose a price that leaves a margin you are happy with.
A worked example with ingredients, labor, and overhead
A worked example makes the sheet easier to trust. Suppose one batch of a dozen cupcakes uses $6 of ingredients. Your labor is $12 for the batch, and overhead is $2 for power, a box, and a label.
Ingredients
$6 for the whole batch.
Labor
$12 for the batch. If the batch takes two hours, that is $6 per hour.
Overhead
$2 for power, a box, and a label.
Total cost
$6 plus $12 plus $2 equals $20 for the batch.
Cost per cupcake
$20 divided by 12 equals $1.67.
Price
Sell the dozen for $36, which is $3 per cupcake.
Margin per cupcake
$3 minus $1.67 equals $1.33.
Margin percent
$1.33 divided by $3 equals about 44 percent.
How to set an hourly rate for your labor
Your labor rate is a choice, but it should be a real number you can defend. Pick a rate you would pay someone else to do the same work. Write it at the top of the sheet so you use the same rate every time. If you change the rate, update the sheet and the price before you sell.
For one batch, multiply the rate by the hours the batch takes. If a batch takes two hours and your rate is $6 an hour, labor is $12, which matches the worked example above. Keep the hours honest, including mixing, baking, cooling, and decorating.
How to spread overhead across a batch
Overhead is everything you pay for that is not an ingredient or your time. Power for the oven, boxes, liners, labels, and any monthly tool belong here. Add the overhead for one batch, then divide by the cupcake count. The result is the overhead cost per cupcake.
If you bake several batches in one session, split the power cost across them. A box and a label go with the dozen they hold. The goal is a fair share of overhead per cupcake, not a perfect accounting system. Write the number on the sheet and keep it with the batch.
Mistakes that cost you money
Another common mistake is pricing from ingredients alone. Packaging, power, and your time are often bigger than the flour and sugar. A sheet that only tracks ingredients will show a profit that is not really there. Use the cupcake pricing chart to see how cost per dozen and margin move together.
What to check before you commit to a price
Before you print a menu, check three things. First, does the price cover every cost in your sheet, including a fair wage for you, and second, does it fit what your customers already pay for a similar treat in your area. Third, does it leave room for a small mistake, like a dropped tray or a last minute change. If the answer is no, adjust the recipe size or the price before you sell.
How to test a price before you print a menu
After the sheet gives you a cost per cupcake, add your margin to get a price. Then check that price against what customers already pay in your area. If it is far above the market, adjust the recipe size or the ingredients. If it is far below, you may be leaving money on the table.
A small test helps, so offer the cupcakes at the new price for one market day or one order. Write down what sells and what does not, then use that feedback to set the final price on the sheet.
How to keep your sheet current
Ingredient prices change, so check your sheet every few months and update the numbers. If butter goes up, your cost per cupcake goes up. A quick update keeps your margin honest. You can also use the cupcake pricing calculator to run new numbers fast.
How to use the sheet for custom orders
Custom orders change the math. A customer might want a different frosting, a logo, or a specific color, and each change adds ingredients or time. Write the new cost on the sheet before you quote a price. If the custom work pushes the cost up, the price goes up too, so do not absorb the extra cost yourself.
Brevl keeps your recipes, ingredient costs, and orders in one place. You can see the cost of a batch and set a price without rebuilding the math. It works on your phone and on a computer. One flat $20 a month, no cut of your sales.
- How to price a cupcake: cost per dozen and margin
- Cupcake pricing chart: cost per dozen and margin
- Cupcake pricing calculator: cost per dozen
Common questions
What is a cupcake pricing sheet?
It is a simple list of every cost in one batch of cupcakes, divided down to a single cupcake. It includes ingredients, your labor, and overhead like power and packaging. The sheet helps you set a price that covers all three and still leaves a margin you can keep.
How do I price cupcakes if I sell by the dozen?
Cost the whole batch, then divide by twelve to get the cost per cupcake. Multiply that by twelve to get the cost per dozen. Add your margin to the dozen price. Selling by the dozen is easier for you and for the customer, and it matches how most market tables list them.
Should I include my time in the pricing sheet?
Yes. Your time is a real cost. Decide an hourly rate for your work, then multiply by the hours one batch takes. If you leave it out, the sheet will show a profit that disappears when you count the hours you actually worked. Pay yourself first.
What overhead costs belong on the sheet?
Overhead includes power for the oven, packaging like boxes and liners, labels, and any monthly tools you use. A monthly tool can be one flat $20 a month with no cut of your sales. Add these costs to the batch before you divide by the cupcake count.
How often should I update my cupcake pricing sheet?
Check it every few months, or whenever an ingredient price changes. Butter, eggs, and chocolate move the most. A quick update takes a few minutes and keeps your margin accurate. If you use a calculator, you can run new numbers in seconds.
General information, not legal or tax advice.