Selling and marketing
Bakery Pricing Spreadsheet: 6 Columns and Your Real Margin
Build one sheet that costs ingredients, labor, and overhead, then shows the margin you keep.
On this page
Try the free bake pricing calculator
Free, no signup.
A bakery pricing spreadsheet only helps if every line in it is real. The usual reason to start one is a market day that felt busy but left nothing in the jar. The sheet is how you find out which of your items actually pays you.
What to remember
- Cost the whole batch, then divide by the count.
- Your time is a line, not a leftover.
- Overhead is small per item but never zero.
- Update the sheet when butter, eggs, or boxes move in price.
What goes in each column of the sheet
Six columns cover almost every item you sell. Ingredients, packaging, labor, overhead, batch count, and the price you charge. If you want a filled in version to copy, the cupcake pricing sheet uses those same six columns with a dozen as the unit.
List ingredients at the price you paid
Write what the pack cost and how much the recipe uses. A five pound bag of flour is not a cost until you know the cups in it.
Add packaging per item
Box, liner, label, sticker, and bag. These repeat on every single order, so they belong in the cost, not in your head.
Put your hours in at a rate
Pick an hourly rate you would accept from another bakery and multiply it by the time the batch takes, start to finish.
Spread overhead across the batch
Power, water, delivery miles, and market fees divided by the number of items in that batch.
Divide, then add your margin
Total cost divided by the count gives cost per item. Add your margin on top to reach the price you quote.
Keep the unit steady. If you cost a batch of 24 cookies, divide by 24 and price by the dozen from there. Mixing a batch cost with a per item price is the fastest way to a number that looks fine and pays nothing.
Packaging is easy to leave out. A box, a liner, a label, and a sticker can add more per item than the butter does, and you buy them in bulk once a month so the cost hides.
Write the sheet so a stranger could follow it. If you cannot explain a line to your sister in one sentence, that line is probably doing two jobs.
A worked example: one dozen cupcakes
Say a dozen cupcakes uses $6.00 of ingredients and $2.50 of packaging. The batch takes an hour and a half, and you pay yourself $15 an hour, so labor is $22.50. Power, water, and the drive to the drop off add $1.50.
That is $32.50 for the dozen, or about $2.71 a cupcake. At $45 a dozen you keep $12.50, which is 28 percent of the price. If $45 will not sell where you are, the fix is a smaller batch, simpler packaging, or a simpler decoration, not a lower wage for yourself.
Free tools that do the math for you
You do not have to build the sheet from scratch. Stocksmith publishes a bakery costing spreadsheet that works out recipe cost, cost per batch, cost per item, and profit margin. Meyy has a home bakery pricing calculator that returns a price per item, per dozen, or per custom order from ingredient and labor inputs. Bake Pricing offers free costing and pricing tools as well.
Free costing tools named in the sources on this page.
| Tool | What it does |
|---|---|
| Stocksmith | Recipe cost, cost per batch, cost per item, and profit margin |
| Meyy | Price per item, per dozen, or per custom order from ingredient and labor inputs |
| Bake Pricing | Free costing and pricing tools for home bakeries |
A free tool is a fine place to start. The catch is that you still have to type the numbers in, and you have to remember to update them when a supplier changes a price.
Mistakes that cost you money
Pricing from the ingredient list alone is the first mistake. Flour, sugar, and butter are usually the smallest part of what a box of cupcakes costs you. Using last year’s prices is the second, because butter and eggs move.
Pricing every item the same way is the third. A cookie pricing sheet and a cake sheet do not share the same labor line, because a decorated cake takes far longer per dollar of ingredients.
Quoting a custom order from your standard price is the fourth. A different count, a different box, and a different amount of time all change the answer.
What to check before you set the price
Check that the price covers a remake. One ruined batch in ten means every price carries a little of that loss. If you sell larger items, the home bakery cake pricing guide shows how fast the labor line grows.
If the margin comes out under 20 percent, look at the packaging and the batch size before you look at the price. A cheaper box or a bigger batch often fixes it faster than a price rise your customers will notice.
Then check your state rules before you print a price. Cottage food laws set what you can sell and where, and some states cap yearly sales. The selling guides hub collects the pricing and selling pages in one place.
If you are still buying equipment, the low cost startup home bakery guide lists what to plan for before you sell.
Keeping the sheet current
Prices move. Butter, eggs, chocolate, and boxes all change through the year, and a sheet built in January can be wrong by June. Pick one day a month to update the ingredient lines you buy most.
Write down what you actually paid, not what you remember paying. A receipt in a folder or a photo on your phone is enough. When a price changes, the sheet should change the same week.
A price you set in March and never revisit is a guess by fall. The sheet is only worth the last time you opened it.
- Home bakery label template: 7 fields and state rules
- How to do good marketing for a home bakery: 5 free moves
- Home bakery bread packaging: cost, labels, and what to buy
Common questions
Can I use a free spreadsheet template?
Yes, and it is a fine place to start. A template gives you the columns, but you still have to fill in your own ingredient prices, your own hourly rate, and your own overhead. The numbers are the part that makes it work, not the file.
How do I decide what to pay myself per hour?
Pick a rate you would accept from another bakery for the same work. If you would not take $12 an hour from someone else, do not pay yourself $12. Write the rate at the top of the sheet and use the same one on every item.
Should I price by the item or by the dozen?
Price by the dozen if that is how you sell, and keep the per item cost in the sheet for your own math. Customers compare dozens at a market table. You compare cost per item when you decide whether a recipe is worth making again.
How often should I update the numbers?
Once a month works for a small home bakery, plus any week a supplier changes a price you use a lot. Butter, eggs, and chocolate move the most. Keep the receipts in one place so the update takes ten minutes instead of an hour.
What if the margin comes out too thin?
Change the batch before you change the price. A bigger batch spreads the same overhead over more items, and simpler packaging cuts a real cost per order. If the margin is still thin after both, that item may not be worth selling.
Do I need a spreadsheet if I only sell one item?
Yes, and it will take twenty minutes. One item is easier to get wrong because you have nothing to compare it to. A single sheet tells you whether that one item pays for the ingredients, the boxes, and your afternoon.
Sources
General information, not legal or tax advice. Cottage food rules differ by state, so check your own before you sell.