Free tool

Recipe cost calculator for bakers

A recipe cost calculator works out what one batch costs and divides it by the pieces it makes: for each ingredient, divide the quantity used by the pack size and multiply by the pack price, then add packaging, your time, the oven and a share of fixed costs, and divide by the yield. Here is the formula step by step and a worked example. If you would rather work in a spreadsheet, download the free version from the link just below.

Start freeDownload the free spreadsheet (CSV)

Worked example: a batch of 24 peanut butter cookies

Example numbers only, in USD. Each ingredient line is quantity used divided by pack size, times pack price.

Ingredients alone come to $8.31, about $0.35 a cookie; labour is the biggest line. Sold at $2.75 each, this cookie has a margin of about 60%.

Download the recipe cost calculator as a spreadsheet

Prefer a sheet you can keep? The free recipe costing template is this calculator as a CSV file that opens in Excel, Google Sheets or Numbers: one row per cost, with its pack size, pack unit, pack price and quantity used, filled in with an example layer cake. Download it from the link at the top of this page or the template page linked below, no email needed.

The downloaded sheet does the sums for you: each line cost is quantity used divided by pack size, times pack price (=ROUND(F2/C2*E2,2) on the first row), the total adds up the lines, and the cost per unit divides the total by the yield. Change a pack price, a quantity or the yield and every result updates.

Read next: Free recipe costing template for bakers, Recipe costing format for bakers, Standard recipe template for bakers

The recipe cost calculator formula, step by step

Every recipe cost calculator, from a spreadsheet to an app, runs the same steps. Use what you actually paid, not the shelf price you remember.

• Ingredient cost: quantity used divided by pack size, times pack price, with both in the same unit.
• Sub-recipes: the cost of the frosting or filling batch times the share of it this recipe uses.
• Packaging: cost per box, bag or label times the number of pieces.
• Labour: minutes divided by 60, times the hourly rate, times the number of people working.
• Machines: minutes of use times the oven or mixer's cost per hour.
• Overhead: monthly fixed costs divided by the hours you bake in a month, times the hours this batch takes.
• Unit cost: the total batch cost divided by the yield.

Unit conversion: where most cost sheets go wrong

You buy flour by the kilo and use it by the gram, buy milk by the litre and pour it by the millilitre, buy eggs by the dozen and crack them one at a time. If the pack size and the quantity used are in different units, the cost is off by a factor of 1,000 or 12 and nothing warns you.

The fix is to convert before you divide: 500 g of flour from a 2 kg bag is 500 divided by 2,000, a quarter of the bag. Farinu converts grams and kilos, millilitres and litres, and units and dozens for you, and refuses a line that mixes weight with volume, so a recipe cannot quietly cost 250 g of milk as if it were 250 ml.

Sub-recipes: frostings, fillings and doughs

Most bakers make a base once and use it across many products: a buttercream, a pastry cream, a sourdough levain. Cost the base as its own recipe, then use a share of it. For example, if a 1,200 g batch of buttercream costs $9.00 and a cake uses 400 g, the cake carries $3.00 of buttercream.

Many simple free calculators stop here. In Farinu, a sub-recipe is just another recipe you pick as an ingredient, at any depth, and when the price of butter changes every cake that uses the buttercream is recosted too.

From unit cost to price and margin

Once you know the unit cost, price from it in one of two ways. With a markup, price equals cost times one plus the markup: a $1.09 cookie with a 150% markup sells at about $2.73. With a target margin, price equals cost divided by one minus the margin: for a 60% margin, $1.09 divided by 0.40 is about $2.73.

Margin is profit over price, not over cost, so a 50% markup is only a 33% margin. Farinu suggests a price from your target markup or price, rounds it to your chosen step, and lets you keep a price list per channel, such as retail and wholesale.

A free recipe cost calculator that keeps up with prices

A spreadsheet is accurate on the day you fill it in. Then the butter goes up and every cost on the sheet is wrong until you remember to fix it. In Farinu, you record the new price once and every recipe that uses it, directly or through a sub-recipe, is recosted, with a margin alert on the products that fall below your target.

The free plan costs up to 10 recipes, with ingredients, packaging, sub-recipes, labour, machines and overhead. On the Team plan, the AI assistant imports recipes from a photo or a spreadsheet, and helpers can log production and sales without seeing your costs.

Read next: Bakery management software for home and small bakeries

Questions

How do I calculate the cost of a recipe?

For each ingredient, divide the quantity used by the pack size and multiply by the pack price. Add packaging, labour, oven time and a share of your fixed costs, then divide the batch total by the number of pieces it makes.

Should I include my time in the recipe cost?

Yes. Put an hourly rate on your own time, even if you don't pay yourself yet. Otherwise the price only covers ingredients and the business cannot grow past you.

Is Farinu a free recipe cost calculator?

The free plan costs up to 10 recipes with sub-recipes, labour, machines and overhead. The Team plan removes the limit and adds the rest of the bakery tools.

Related pages

• How to calculate recipe cost, step by step
• Free recipe costing template for bakers
• Standard recipe template for bakers
• Recipe costing format for bakers
• Recipe scaler with batch cost and yield
• Bakery recipe costing software