Getting started
Bakery Costing Spreadsheet: 5 Columns That Show Real Profit
Build a bakery costing spreadsheet with ingredients, labor, and overhead, so every price you set shows a real margin.
On this page
- What columns does a bakery costing spreadsheet need?
- How do you add labor and overhead?
- A worked example with real numbers
- How do you handle batch sizes and yield?
- How do you keep the sheet current when prices move?
- How do you price custom orders and market days?
- How do you use the sheet to choose what to sell?
- Mistakes that cost you money
- What to check before you commit to a price
- How do you know your margin is enough?
What to remember
- Cost the whole batch, not just the flour.
- Add your time before you add profit.
- Overhead is real money, even if it is small.
- Check the price against what your market already pays.
You do not need accounting software to build a bakery costing spreadsheet. A notebook page or a free sheet works, as long as every column has a job. The goal is to see your cost per item before you promise a price. If you want a ready made grid, start with our bakery spreadsheet template.
What columns does a bakery costing spreadsheet need?
Start with the cost of what you buy. Then add what you spend to make it sellable. Then add your own time. The last column is the price you charge. Each column feeds the next one, so you never guess.
List every ingredient and its pack price
Write the pack size and what you paid. You will use the cost per ounce or per cup later.
Add packaging and labels
Boxes, bags, stickers, and liners belong in the cost of the item, not in a separate pile.
Put your time in one column
Decide an hourly rate for yourself and multiply it by the minutes the item takes.
Add overhead per batch
Oven power, water, and a share of your kitchen supplies go in this column.
Divide by the number of items
Batch cost divided by the count gives you the cost of one cupcake, loaf, or cookie.
Set the price and check the margin
Price minus total cost is your margin. If it is too thin, change the size or the recipe.
How do you add labor and overhead?
Pick an hourly rate you would pay someone else to do the same work. Then time yourself for one batch. If a batch takes 45 minutes and your rate is $20 an hour, that batch carries $15 of labor. Write that number in its own column so you can see it every time.
Overhead is everything that keeps the kitchen running. That includes power, water, and a share of your tools and cleaning supplies. Add up a month of those costs, then divide by the number of batches you sell in that month. If you sell 20 batches and overhead is $40, each batch carries $2.
A worked example with real numbers
Say you make a batch of 24 cookies, and you want to see the margin after all three costs. Ingredients cost $10, and packaging costs $2, so your materials total $12 for the batch. Your time is 30 minutes at $20 an hour, so labor is $10. Overhead is $2 per batch, which covers power, water, and a share of supplies. Total cost is $24, or $1 per cookie when you divide by 24. If you sell them at $2 each, your margin is $1 per cookie. That is a 50 percent margin after ingredients, labor, and overhead, so all three costs are covered. If the market only pays $1.50, your margin is 50 cents per cookie, or about 33 percent. That lower price still covers all three costs, but it leaves less margin for your work.
How do you handle batch sizes and yield?
A batch size is the number of items one recipe makes, and your sheet should show both the batch cost and the count. Divide the batch cost by the count to get the cost of one item. If you change the recipe or the size, update the count in the same row.
A larger batch spreads overhead over more items, while a smaller batch carries more overhead per item. That is why a dozen cookies can cost more per cookie than a full tray. Check the yield before you compare two items, because the count changes the cost per item.
How do you keep the sheet current when prices move?
Update the ingredient column when you buy a new pack, and do not wait for a perfect number. The sheet does not need to be perfect on day one, and a rough number is better than no number. Over time, you will see which ingredients move the most and you can adjust your prices.
A quick check once a month keeps it useful, and you should update it when a supplier price changes. Update it when you change a recipe or when you add a new item to your list. If you wait until tax time, you will have a pile of receipts and no clear cost per item.
How do you price custom orders and market days?
Start with the same columns you use for a standard item, then add any special ingredients. Add extra packaging and the extra time the order takes, then add your overhead share. If the custom price does not cover all of that plus a margin, say no or offer a smaller version.
Market fees and shipping change the math, so you must add them before you set a price. If you pay a table fee, add it to overhead for that day, and if you ship, add the box and label. Then check the margin again, because the price may no longer leave enough for you.
How do you use the sheet to choose what to sell?
Compare the margin on each item, not just the price, because a high price can hide a thin margin. If the margin is too low, change the size or simplify the recipe before you cut your own pay. Do not cut your own pay to make a price work, because that hides the real cost.
The sheet shows which items carry their weight and which ones only look popular. If your market will not pay a higher price, shrink the item or drop it. Keep the items that pay for ingredients, labor, and overhead, and let the others go.
Mistakes that cost you money
Another mistake is pricing from memory. You remember the flour, but you forget the butter, the eggs, and the box. A bakery costing spreadsheet fixes that because every cost has a line. Check your sheet before you quote a price, not after. For a full picture of costs and margins, read is a home bakery profitable.
Another mistake is using the price you paid last month, because butter and eggs move. If a supplier price went up, your old number is wrong, so update the sheet before you quote.
What to check before you commit to a price
Check that your price covers the cost of the next batch, not just this one. Check that your market will pay it. Check that you are paying yourself for every hour. If the price is too low, shrink the item or simplify the recipe before you cut your own pay. For the records you need at tax time, read cottage bakery bookkeeping.
To stop waste, use a bakery inventory list template. It helps you see what you have before you buy more. And if you are just starting, the getting started guide walks through the first steps.
How do you know your margin is enough?
A margin is what is left after every cost. If you sell a loaf for $8 and it costs $6 to make, your margin is $2. That $2 has to cover your time, your overhead, and still leave something for you. If it does not, the price is too low or the item is too big.
Market fees and shipping change the math. If you pay a table fee, add it to overhead for that day. If you ship, add the box and the label to the item cost. Then check the margin again.
Try the free bake pricing calculator
Free, no signup.
- Bakery Spreadsheet Template: Free Download and 4 Columns
- Cottage Bakery Bookkeeping: 4 Records, One Afternoon
- Bakery Inventory List Template: 6 Columns That Stop Waste
Common questions
Do I need Excel for a bakery costing spreadsheet?
No. A notebook page or a free online sheet works. The important part is the columns, not the software. You need a line for ingredients, a line for packaging, a line for your time, a line for overhead, and a line for the price you charge.
How do I price a custom order with a bakery costing spreadsheet?
Start with the same columns you use for a standard item. Add any special ingredients, extra packaging, and the extra time the order takes. Then add your overhead share. If the custom price does not cover all of that plus a margin, say no or offer a smaller version.
What if my ingredients cost changes every week?
Update the ingredient column when you buy a new pack. The sheet does not need to be perfect on day one. A rough number is better than no number. Over time, you will see which ingredients move the most and you can adjust your prices.
How often should I update my bakery costing spreadsheet?
Update it when a supplier price changes, when you change a recipe, or when you add a new item. A quick check once a month keeps it useful. If you wait until tax time, you will have a pile of receipts and no clear cost per item.
This is general information, not financial or tax advice. Check your state rules and talk to a tax professional.