Selling and marketing
Bakery Pricing Template: 6 Columns and a Real Margin (2026)
A fill in the blanks pricing sheet that shows your true cost and the margin left over.
On this page
- What a bakery pricing template has to show
- The 6 columns to fill in
- A worked example: one dozen cupcakes
- How to cost a half batch or a double batch
- What to do when a supply price changes
- How to use the margin column to pick what to sell
- Mistakes that cost you money
- What to check before you commit to a price
- Keep the template where you will use it
You do not need a paid app or a spreadsheet class to build one. A notebook page with six columns works, as long as you fill in every column for every product you sell. The bakery pricing template below is the version that keeps your own time in the math, where it belongs.
Try the free bake pricing calculator
Free, no signup.
What to remember
- Cost the whole recipe, not one ingredient.
- Your time is a cost line, not a bonus.
- Overhead is real money, even from your own kitchen.
- The margin column decides whether the price works.
- Update the sheet the day a supply price moves.
What a bakery pricing template has to show
A price only works if it covers everything you spent to make the item and still leaves something for you. That means four cost lines before you write a price down: ingredients, packaging, labor, and overhead. Leave any one of them out and the sheet will hand you a price that looks fine and pays you nothing.
The 6 columns to fill in
Ingredients
List what the recipe uses and what you paid for it. Divide a bulk bag by the cups or ounces you actually used, so a $12 bag of flour does not land on one cake.
Packaging
Box, liner, label, bag, ribbon, sticker. This is the line home bakers skip, and it is often bigger than the flour.
Labor
Track your real time, from mixing to cleanup. Pick an hourly rate you would accept from someone else, then multiply.
Overhead
Power for the oven, water, dish soap, foil, and any monthly cost for taking orders. Spread it across the batch or the item.
Your price
Write the price you plan to charge for the item as sold, by the dozen, the loaf, or the cake.
Margin
Subtract all four cost lines from the price. What is left is yours. If it is thin, change the price, the size, or the recipe.
A worked example: one dozen cupcakes
The dozen uses $4.20 of butter, flour, sugar, eggs, and vanilla, which is the first cost line. Packaging adds $1.30 for the box, liners, and a label, and that is the second cost line. Your hands are on it for 45 minutes, and you pay yourself $15 an hour, which is $11.25. Overhead for power, water, and order taking adds $0.75 to the batch.
Add the four lines: $4.20 plus $1.30 plus $11.25 plus $0.75 equals $17.50. At $30 a dozen, the margin is $12.50, which is about 42 percent of the price. That margin is left after you already paid yourself $11.25 for the work. It covers the unsold dozen, the next piece of equipment, and the weeks you sell nothing.
How to cost a half batch or a double batch
Recipes scale, but cost lines do not always scale in a straight line. If you make a half batch, divide the ingredient and packaging cost by two, then track the labor you actually spend. Overhead may stay the same because the oven still runs for the same time.
A double batch often lowers the cost per item because you spread overhead and setup time across more pieces. Fill in the same six columns for the batch, then divide by the number of items you sell. The margin column still decides if the price works.
What to do when a supply price changes
Butter, eggs, chocolate, and boxes move the most, so check the sheet every season. When a receipt shows a higher price, update that one ingredient line the same day. Then redo the margin before you quote the next order.
If the new cost pushes the margin near zero, you have three choices. Raise the price, shrink the item, or simplify the recipe. Do not wait until after you have already promised the old price to a customer.
How to use the margin column to pick what to sell
The margin column is a sorting tool. Line up your products and look at the margin each one leaves after all four cost lines. The items with the strongest margin are the ones that pay you for the work you already did.
A product with a thin margin can still be worth making if it brings repeat customers. But you should know that is why you make it. If a thin margin item takes the same time as a strong one, move it down the list or change the size.
Mistakes that cost you money
The most expensive mistake is pricing from ingredients alone. A dozen that costs $4.20 in butter, flour, and sugar is not a $6 product, because the box, the label, and your afternoon are not in that number. The cookie pricing sheet shows the same trap with a $24 dozen.
The second mistake is discounting to win a customer who was never going to pay your price. A lower price does not fix a thin margin, it makes it thinner. Cut the size or simplify the decoration first, and keep your rate where it is.
Before you commit to a price, add up what it costs you to start selling at all. Trays, boxes, labels, and a scale add up fast, and the low cost startup guide lists what to plan for before your first order.
What to check before you commit to a price
Three checks take five minutes. Does the price cover all four cost lines with something left over. Can you make the item at that price on your busiest week. Will the same customer buy it twice. If any answer is no, change the size or the recipe before you change the price.
Keep the template where you will use it
A sheet in a drawer stops being true within a month. Keep it with your recipes and update a cost line the day a receipt changes. If you take orders on your phone, keep the numbers there too, so you can quote a price at the table instead of promising to check later.
When the order comes in, send an invoice the same day. The free baking invoice template lists the fields that get you paid without a follow up email. More guides like this one live in the selling section.
- Cupcake Pricing Sheet: 6 Columns and Cost per Dozen
- Home Bakery Label Template: 7 Fields and State Rules
Common questions
Can I build a bakery pricing template in a notebook?
Yes. Six columns and one row per product is enough to start. What matters is that every row has all four cost lines filled in, including your time. A notebook you actually update beats a spreadsheet you open once and forget.
How do I work out overhead for a home kitchen?
Add up the power your oven uses for a bake, plus water, soap, foil, and any monthly cost for taking orders. Divide that total by the number of items you baked. The number will be small per item, but it is still a cost line, not free money.
What hourly rate should I pay myself?
Pick a rate you would accept from someone else for the same work, then round it up. If you would not take the job at that rate, it is too low. A rate you resent is how a busy month turns into a reason to quit.
How often should I update the numbers?
Check the sheet every season, and sooner if a supply price jumps. Butter, eggs, chocolate, and boxes move the most. When a cost line changes, redo the margin before your next order, not after you have already quoted the price.
What margin should I aim for?
There is no single right number, because your market and your recipe decide it. What matters is that the margin is positive after ingredients, packaging, labor, and overhead, and big enough to cover an unsold batch. If it is near zero, raise the price or shrink the item.
General information, not legal or tax advice. Check your own state rules and your own numbers before you set a price.