Recipe Cost Calculator: Know What Every Bake Really Costs
A recipe cost calculator turns ingredients, labour and yield into a unit cost and a price. See who it suits and how to use it, in 4 Google Sheets tabs.
A recipe cost calculator adds up the ingredients, labour and overhead behind a recipe and divides by the number of items it makes. The result is a unit cost you can price from. The Recipe Costing & Builder does this in Google Sheets, with a suggested price, profit and break-even units in four tabs.
- Builder, costing and settings
- 4 tabs
- One payment, no subscription
- $9.99
- Editable copy in your Drive
- Google Sheets
- To cost your first recipe
- About an hour
Most bakers price by looking at what others charge. It feels safe, but it ignores your own flour, butter, boxes and time. That is how a popular bake ends up losing money without anyone noticing.
A recipe cost calculator replaces the guess with arithmetic. This guide explains who the recipe costing spreadsheet is for, how to cost a recipe step by step, and when it helps most.
Why bakery recipe costing starts with the batch, not the bag
A bag of flour has a price. A cupcake has a different one. Between the two sit the other ingredients, your time, the oven and the batch size. Food costing means counting all of it.
What goes in?
List each ingredient with its quantity and cost.
What does your time cost?
Add labour and batch overhead, so the price pays you too.
How many does it make?
Divide the batch cost by the items you get out of it.
Do those three steps once for each recipe and you know what one finished item costs. Price, profit and break-even all follow from that one number.
How to use a recipe cost calculator, job by job
Each tab has one job. Here is how a recipe moves through them.
Build the recipe
Start in the Recipe Builder tab. List each ingredient with its quantity and cost. This is the recipe builder side of the file, where a product starts as a list of what goes into it.
Keep those prices current by pairing it with your stock list. Our guide to the bakery inventory spreadsheet shows how pack prices turn into a cost for each unit.
Add labour, overhead and yield
Open the Recipe Costing tab and add labour, batch overhead and the number of items the batch makes. It uses the assumptions you set in Settings, so the sums match how you work.
Read the unit cost and suggested price
The tab shows unit cost, a suggested price, profit per item and break-even units. Here is a batch of 15 cupcakes. The figures are illustrative, so use your own costs.
| Step | Example |
|---|---|
| Ingredients for the batch | $7.80 |
| Labour (20 minutes at $13.50 an hour) | $4.50 |
| Batch overhead | $1.20 |
| Batch cost | $13.50 |
| Batch yield | 15 cupcakes |
| Unit cost ($13.50 ÷ 15) | $0.90 |
| Target margin | 60% |
| Price at that margin ($0.90 ÷ 0.40) | $2.25 |
| Profit per cupcake | $1.35 |
| Break-even for $90 of fixed costs ($90 ÷ $1.35) | 67 cupcakes |
The margin method is a common one, and it lets you sense-check any figure. You still choose the final price, and you can compare it with what your market will pay.
Re-cost when a price changes
Re-cost a recipe whenever a main ingredient changes price. The sheet recalculates from your inputs, so a new cost updates that recipe’s unit cost and suggested price straight away.
Where and when to use it
It is a Google Sheets file, so you can open it from any device where you are signed in to your Google account. Costing for baking is a job you return to, not a one-off. A rhythm that suits most bakeries:
- Before you launch a productCost the recipe first, then decide what to charge.
- Before you set a menuCompare recipes side by side for menu costing, and see which one earns most.
- When an ingredient price risesUpdate the cost and read the new suggested price.
- When you test a new batch sizeChange the yield and see the cost per item for a small batch and a full run.
- Every few monthsRe-check your main recipes against current prices.
Who this recipe costing spreadsheet is for
It suits makers who want to understand their prices before they publish them.
Planning a product menu
Cost each product before you publish a price list.
Comparing recipes
See which bake earns the most for the time it takes.
Reviewing labour and overhead
Spread the costs of a working day across each batch.
Starting a baking business
Build a first set of costed products before the first order.
It also suits any maker who sells in batches and wants to know the cost of one finished item.
Recipe cost calculator vs recipe costing software
Three ways to work out what a recipe costs, compared on the points that matter most to a small food business.
| This template | A one-off online calculator | Recipe costing software | |
|---|---|---|---|
| How you pay | One-time payment | Usually free | Often a monthly or yearly plan |
| Labour, overhead and yield | Included in the costing | Often ingredients only | Usually included |
| Suggested price and break-even units | Built in | Rarely | Varies by product |
| Keeping your recipes | In your own Google Drive | Re-enter each time | On the provider servers |
| Changing assumptions | Edit them in Settings | Limited | Within the app options |
A costing spreadsheet keeps every recipe, so you can compare products and re-cost them when prices change.
Cost your first recipe in about an hour
Start with your best seller. Once one recipe is costed, the rest follow the same pattern.
Buy and download
Complete checkout and your download link arrives straight away.
Make your copy
Open the link and save an editable copy to your own Google Drive. A free Google account is all you need.
Read Start Here
It explains the workflow and which cells are for your inputs.
Set your assumptions
Open Settings and enter your business details and costing assumptions.
Build the recipe
In the Recipe Builder, list each ingredient with its quantity and cost.
Add labour and yield
In Recipe Costing, add labour, batch overhead and the number of items the batch makes.
Read the result
Review unit cost, suggested price, profit and break-even units, then decide on your final price.
The first recipe takes the longest. After that, each new one follows the same pattern.
Is it worth it for your bakery?
It is $9.99 as a one-time payment through Lemon Squeezy, with no subscription. The download link arrives at checkout, and the copy you make in your own Drive is yours to keep.
Costing pairs well with stock and orders. The bakery ingredient and inventory tracker keeps ingredient prices current, and the bakery order tracker spreadsheet logs each order. For everything in one file, see the home bakery business spreadsheet, which includes recipe costing as one of its tabs. You can also browse all Google Sheets templates.
- A recipe cost calculator adds ingredients, labour and overhead, then divides by yield to give a unit cost.
- Unit cost, suggested price, profit and break-even units appear together in one tab.
- The example cupcake costs $0.90 to make and suggests $2.25 at a 60% margin (illustrative).
- Four tabs cover the builder, the costing and your settings, and the first recipe takes about an hour.
- It is $9.99 once, with no subscription.
Frequently asked questions
- What is a recipe cost calculator?
- A recipe cost calculator adds up the ingredients, labour and overhead behind a recipe and divides by the number of items it makes. The Recipe Costing & Builder does this in Google Sheets, then shows unit cost, a suggested price, profit and break-even units, so you can price products from facts.
- How do I work out the cost of one cupcake or cookie?
- Add the ingredients, labour and batch overhead to get the batch cost, then divide by the batch yield. In the example, $13.50 shared across 15 cupcakes gives a unit cost of $0.90. Use your own costs and the number of items your batch makes.
- How do I choose a selling price from the unit cost?
- The suggested price comes from your unit cost and the margin you set. At a 60% margin, a $0.90 unit cost suggests $2.25, because $0.90 divided by 0.40 is $2.25. It is a suggestion. You choose the final price and can compare it with your market.
- What does break-even units mean?
- Break-even units are the number of items you must sell to cover your fixed costs, given the profit each item makes. The costing tab shows this for each product, so you can judge whether a price is realistic for your bakery.
- What costs does it include besides ingredients?
- The costing uses ingredient cost, labour, batch overhead and batch yield. That gives you the cost of one finished item rather than only the cost of a bag of flour. You set your assumptions in Settings, so the result reflects how you work.
- Can I cost different batch sizes?
- Yes. Batch yield is part of the costing inputs, so you can review the cost per finished item for a small test batch and for a full production run. Change the yield and the unit cost and suggested price update straight away.
- Is it a food cost calculator for a bakery?
- Yes. It is built with bakers in mind, and the method works for any made-to-order food product. Cake, cupcake and cookie businesses are the main users. The same logic of ingredients plus labour plus overhead, divided by yield, applies to any small food product.
- Does it track my inventory or orders?
- No. It focuses on costing. For stock and suppliers see the Bakery Inventory & Ingredient Cost Tracker, and for orders see the Order Tracker Command Center. Each one is a separate Google Sheets template, and you can use them side by side.
- Can I use the recipe costing template in Excel?
- It is built for Google Sheets and delivered as a link, not as an Excel file. A Google Sheet can be downloaded as .xlsx, but formulas, dropdowns and charts may not all behave the same way in Excel, so Google Sheets works best.
- Do I need a Google account to use it?
- Yes. A free Google account and Google Sheets are all you need. Open the download link, make your own editable copy in Google Drive and enter your details there. The copy you save is yours to edit and keep.
- Is it a subscription?
- No. It is a one-time payment through Lemon Squeezy with no monthly fee. You pay once, the download link arrives at checkout, and you keep your own copy in Google Drive with nothing to renew.