Selling and marketing
Bakery Cost Spreadsheet: 4 Columns That Show Real Profit
Set up one sheet that costs ingredients, packaging, labor, and overhead, then shows the margin you keep.
On this page
Try the free bake pricing calculator
Free, no signup.
A bakery cost spreadsheet only earns its keep if you fill in every column, every time. The sheet itself is not the hard part. Knowing which numbers belong in it is. Get the columns right once and pricing stops being a guess.
What to remember
- Ingredients, packaging, labor, and overhead. Four lines, not one.
- Labor is a real cost even when nobody hands you a paycheck.
- A price that covers ingredients and nothing else is a discount you did not agree to.
- Update the sheet when a supplier price changes, not once a year.
The four columns every bakery cost spreadsheet needs
Ingredients come first, and they are the easiest to get wrong. A five pound bag of flour does not cost what one batch of flour costs, so divide the bag by how many batches it makes. Packaging is its own column because boxes, labels, and liners add up fast. Labor is the column most home bakers leave empty. Overhead is everything else: power, delivery, market fees, and the wear on your pans.
Packaging is not a rounding error. A box, a label, a liner, and a sticker can run more than the butter in a batch. Count every piece that leaves your kitchen with the product, and check your cost per dozen for cookies against what you actually paid. If you buy in packs of 50, divide the pack price by 50. Round up, not down, because you will lose a few to mistakes.
Overhead is the column people fudge. Pick a month, add the extra electricity, the delivery miles, the market table fee, and any small tools you replaced. Divide by the units you sold that month. If you sold 300 items, a $90 overhead month is 30 cents an item. That is a number you can defend.
Pick one item
Start with your best seller. One item done properly teaches you the whole sheet.
Cost the ingredients for one batch
Take your last grocery receipt and divide each item by how many batches it covers.
Add packaging per unit
Box, label, liner, and tape. If you buy in packs of 50, divide by 50.
Put a dollar value on your time
Track the minutes from mixing to boxing, then multiply by an hourly rate you would pay a helper.
Spread overhead across the batch
Add a month of power, delivery, and market fees, then divide by the units you sold that month.
Subtract the total from your price
What is left is your profit. Divide it by the price to get your margin.
A worked example: one dozen cookies
Say a dozen chocolate chip cookies uses $6.40 of ingredients and $1.10 of packaging. Your hands are on it for 45 minutes, and you pay yourself $18 an hour, so labor is $13.50. Oven time, delivery, and market fees add $0.60 a dozen. The total is $21.60. At $30 a dozen you keep $8.40, a 28 percent margin. At $24 a dozen you keep $2.40, a 10 percent margin.
Same recipe, same cookies, two different businesses. At $30 a dozen you are running a business. At $24 you are running a hobby that pays for itself. The sheet is what tells you which one you have.
Those figures come from bakeries with rent, staff, and a storefront. SharpSheets, working from data on more than 12,900 US bakeries, puts the average profit margin near 15%. A home kitchen carries different costs, so your number will not match theirs. What matters is that your sheet shows a real margin after all four columns.
Mistakes that cost you money
The second mistake is stale numbers. Butter moves. Boxes move. A sheet built in January and never touched again will quietly tell you that you are making money when you are not. The third is spreading overhead evenly across everything you sell. A decorated cake takes more oven time and more counter space than a loaf, so it should carry more of the power bill. Check your packaging cost per box the same way.
The last mistake is copying a price from a bakery down the road. Their rent, their flour contract, and their staff are not yours. Use their price as a ceiling to test against, never as your starting number.
What to check before you commit to a price
Before you post a price, run it past three things. Does it cover all four columns with something left over. Does it sit near what a bakery charges for cupcakes or cookies in your area for the same size item. Can you still make it at that price on your busiest week, when you are tired and rushing. Our other selling guides walk through the same math for cakes and bread.
If the sheet says the item loses money, you have three moves. Raise the price, shrink the item, or stop selling it. Cutting your own labor is not one of them, because that just hides the loss. Pick the move that keeps the customer and keeps you paid.
How often to update the sheet
Update ingredient and packaging lines whenever a receipt changes by more than a few cents. Update your hourly rate once a year, or when you start paying someone to help. Overhead is the slowest to move, so a quarterly look is usually enough. Write the date at the top of the sheet so you know which version you are reading. If you are still adding up startup costs to plan before you sell, build that list into the same file.
- Home bakery cake pricing: cost, labor, and margin
- Sourdough loaf packaging: cost per loaf and your price
- Muffin clamshell packaging: cost per muffin and what to buy
Common questions
What should go in a bakery cost spreadsheet?
Four lines for every item: ingredients, packaging, labor, and overhead. Ingredients and packaging come from receipts divided by how many units a pack covers. Labor is your minutes times an hourly rate. Overhead covers power, delivery, and market fees spread across what you sold.
Do I have to pay myself in the spreadsheet?
Yes, or the sheet will lie to you. Put a dollar value on your hours even if the money stays in the business. If a price only works when your time is free, you are not running a business yet. You are buying ingredients and giving away your evenings.
How do I split overhead across different items?
Add up a month of power, delivery, market fees, and small equipment. Divide that total by the number of units you sold in the month. That gives you a cost per unit. Items that use more oven time or counter space should carry a bigger share than a simple loaf.
What margin should I aim for?
There is no single number that fits every kitchen. Soccash reports that the average U.S. bakery runs a net profit margin of 5% to 10%, and that a home based cookie business can reach 25%. Your own sheet, with your own costs, is the only figure that matters for your prices.
Can I build this on my phone?
Yes. A simple sheet with four columns and one row per item works fine on a phone. The trick is keeping it somewhere you will actually open it, like the notes app or a spreadsheet app you already use. Update it the same day a receipt changes.
Sources
General information, not legal or tax advice. Check your own state rules before you set prices or file taxes.