What you bake
Baking Spreadsheet Template: Cost, Price, and Margin
A free template to cost your recipes and set prices that pay you.
On this page
You can download a free template below. It has columns for each cost and a formula that adds them up. The template shows you the margin left after ingredients, labor, and overhead.
What a good template includes
Your template needs more than an ingredient list. It must account for every cost that comes out of your pocket. A simple list of flour and sugar will not show your true profit.
What to remember
- Track ingredients by the batch, not the recipe.
- Include a column for your time at a fair hourly rate.
- Add a fixed overhead cost to every item you sell.
- The final column shows your margin after all costs are covered.
How to structure your costing columns
A clear column structure prevents missed costs and math errors. Start with a column for the ingredient name and another for its cost per batch. The next column should be for units used, like cups or grams.
Follow this with a labor column showing hours spent and your hourly rate. Then add an overhead column with a calculated share of monthly fixed costs. The final column subtracts total cost from your selling price to show margin.
A worked example with real numbers
Let’s cost a batch of 24 chocolate chip cookies. Assume you buy ingredients in bulk. Your template will have a row for each cost.
Add up the batch ingredients
Flour, sugar, chocolate chips, butter, and other ingredients cost $4.50 for the whole batch. Packaging for 24 cookies adds $1.20.
Add your labor cost
Mixing, baking, and packing takes 1.5 hours. Pay yourself $18 an hour for your skilled work. Labor cost is $27.
Include a share of overhead
Monthly costs like power, internet, and licensing are $120. If you sell 20 batches a month, add $6 of overhead to this batch.
See the total cost and margin
Total batch cost is $38.70. If you sell the batch for $48, your profit margin is $9.30. That margin is your pay for the batch after covering ingredients, labor, and overhead.
Setting your ingredient prices accurately
Accurate ingredient costing starts with bulk purchase prices. Find the price per ounce or gram from your supplier. Then calculate how much of that unit your recipe uses.
For example, a 5-pound bag of flour costs $6. There are 80 ounces in 5 pounds. The cost per ounce is 7.5 cents. If your recipe uses 10 ounces, the flour cost is 75 cents. This method from the same guide ensures consistency.
Update these bulk prices in your template every few months or when you switch suppliers. Price changes directly affect your cost per batch and your final margin.
Calculating and applying overhead
Overhead costs are fixed monthly expenses that do not change with sales volume. Common examples are kitchen electricity, business insurance, website fees, and car registration for deliveries.
First, tally all these monthly costs into one total. Then estimate how many batches or items you sell per month. Divide your total overhead by that number to find the overhead cost per batch.
If your sales vary, use a conservative average. Applying this cost to every item ensures your prices gradually recover these necessary business expenses.
Common mistakes that cost you money
Small errors in your template lead to prices that do not cover costs. Check these points before you set your prices.
Using retail ingredient prices inflates your costs and scares you into charging too much. Buy in bulk and use the price per ounce in your template. Learn more about inventory in our spreadsheet for baking inventory guide.
Forgetting to pay yourself a fair hourly rate means you work for free. Your time is a real business cost. Decide your rate and stick to it in the labor column.
Skipping overhead because it feels small per item means your profit vanishes. Spread your monthly fixed costs across everything you sell. See how this works for cupcakes.
When to move past a spreadsheet
A spreadsheet works until you have more than a few recipes. Updating prices for every ingredient change becomes a chore. You need a system that updates costs automatically.
Your shop can show prices that always reflect your true costs. This is part of running a reliable home bakery. Explore more craft guides for bakers.
Your next steps
Download the template and cost your best selling recipe. See if your current price leaves a margin after ingredients, labor, and overhead. If it does not, you know where to adjust.
Try the free bake pricing calculator
Free, no signup.
- How Much to Charge for Baking a Cake: 2026 Cost and Margin
- What You Need to Set Up a Baking Business at Home (2026)
Browse more craft guides.
Common questions
What software should I use for the template?
Use Google Sheets or Excel. Both are free and work on your phone. The formulas are simple addition and division. You can access them anywhere.
How do I set my hourly labor rate?
Start with a rate that feels fair for your skilled work, like $15 to $25 per hour. Check what local bakeries pay their staff. Your time is not free.
What counts as overhead?
Overhead is any monthly cost that does not change with sales: kitchen power, internet, business licensing, website hosting, and car insurance for deliveries. Divide your total monthly overhead by how many items you sell.
Should I cost by the item or by the batch?
Always cost by the batch first. Add up all ingredients for one batch, then divide by the number of items to find the cost per cookie, cupcake, or slice.
What if my margin is negative?
A negative margin means your price is too low or your costs are too high. First, check if you are using bulk ingredient prices. Then, see if you can make the recipe more efficient before raising your price.
Sources
General business information, not legal or financial advice.