Pricing & Costing · $5.99 each

Bakery pricing calculator: three sheets from recipe to price list

These three sheets work as a bakery pricing calculator: start from the recipe, add your time and your margin, and keep every price you charge in one list. $5.99 each.

See the three sheets
A kitchen scale with a bowl of flour, wooden measuring spoons and butter on a marble counter
Batch Recipe Cost, the Recipe tab: ten sample ingredient lines for a cardamom pear cake, with batch cost 11.76 dollars and cost per cake 5.88 dollars
Cake Price and Margin, the Price tab: sample costs for an 8-inch cake with a selling price of 37.33 dollars at a 40% margin
Cake Price List, the List tab: four sample cakes with cost, price, margin and an OK check
The three sheets

Pick one, or take all three

Batch Recipe Cost cover: Pricing & Costing spreadsheet, editable .xlsx for Excel and Google Sheets
Pricing & Costing

Batch Recipe Cost

Cost one cake recipe by the batch: ingredient lines in, cost per cake out.

$5.99
Cake Price and Margin cover: Pricing & Costing spreadsheet, editable .xlsx for Excel and Google Sheets
Pricing & Costing

Cake Price and Margin

One cake in, a selling price out: ingredients, your time, supplies and margin.

$5.99
Cake Price List cover: Pricing & Costing spreadsheet, editable .xlsx for Excel and Google Sheets
Pricing & Costing

Cake Price List

Every cake you sell with cost, price and margin, and a check on each price.

$5.99

Which pricing sheet do I need first?

Start with Batch Recipe Cost if you do not know what a cake costs to make. Move to Cake Price and Margin when you want a selling price that includes your time. Add Cake Price List once you sell several cakes and want every price, cost and margin in one place.

A bakery cost spreadsheet that starts at the recipe

Batch Recipe Cost turns ten ingredient lines into a batch cost and a cost per cake. That is the number every price is built on.

A bakery costing spreadsheet that ends in a price list

Cake Price and Margin adds your time, the box and the margin you want. Cake Price List keeps every cake you sell with its cost, price and a check that the price covers the cost.

Questions

Questions bakers ask

How do I calculate the cost of bakery products?

Cost each ingredient for the amount you use, add your time and the packaging, and divide the batch by the number of cakes it makes. Batch Recipe Cost and Cake Price and Margin do those sums.

How to calculate baking prices?

Work out the total cost of the bake, then divide by one minus the margin you want. Cake Price and Margin shows the cost, the selling price, the profit and the margin side by side.

How to calculate bakery cost?

Add up what each ingredient costs for the amount you use, then add your time and the packaging. Batch Recipe Cost does the ingredient part and gives a cost per cake, and Cake Price and Margin adds your labor and supplies.

What is the best app for bakery costing?

The three pricing sheets are editable spreadsheets, not an app, and they open in Excel and Google Sheets. Batch Recipe Cost, Cake Price and Margin and Cake Price List cost $5.99 each. If you want an app, check that it counts your time and packaging before you trust its price.

Is there a free spreadsheet I can use for food costing?

The three pricing and costing sheets are not free: each costs $5.99, and they open in Excel and Google Sheets. Each one has a filled-in sample, so you can see the sums work before you type your own recipe.

How to make a food cost spreadsheet in Excel?

List each ingredient with the price of the pack, the pack amount and the amount you use, then divide and add up the lines. Batch Recipe Cost is built that way as an Excel file, with the formulas already built and locked and a sample you can clear.