Pricing & Costing
Cake Price and Margin
One cake in, a selling price out: ingredients, your time, supplies and margin.
$5.99
Pricing & Costing
Recipe costing calculator: know what each cake costs to make
Batch Recipe Cost is a recipe costing calculator for cake bakers. Type in the ingredients of one recipe and how many cakes the batch makes. The sheet adds up the batch and gives you the cost per cake.
$5.99Batch Recipe Cost
- Editable .xlsx for Excel and Google Sheets
- Files arrive by email after checkout
Need more than one sheet? All twelve are $77.00. One by one they add up to $83.91.
Sample data shown
One page of two, whole. The file has more.
You type hereLocked formula
How it works
How does Batch Recipe Cost work?
Batch Recipe Cost adds every ingredient line into a batch cost, then divides it by the number of cakes the batch makes. Each line carries a part, such as sponge, filling or frosting, so the sheet also shows what each part costs. You type the pack cost, the pack amount and the amount you use.
List the ingredients
Type the part (sponge, filling, frosting), the ingredient, what a pack costs, how much is in the pack and how much you use. Use the same unit for both amounts.
Say how many cakes the batch makes
Type the number on the first row only. Leave it blank and the sheet shows a word, not an error.
Read the cost per cake
Batch cost divided by the cakes from the batch, plus what each part costs: sponge, filling and frosting.
The sample in the file
June Hale’s cardamom pear layer cake: ten ingredient lines, 11.76 dollars a batch, two cakes, 5.88 dollars a cake.
Your recipe costing template, already filled in
A blank template makes you guess what goes where. Here a real sample is in every cell, so you see the sums work before you type a thing. Then clear the sample with one range name and use your own recipe.
A baking costing calculator that splits cost by part
Each line has a part: sponge, filling or frosting. The sheet totals each part, so you see where a cake’s cost really sits. In the sample, the sponge costs 4.60 dollars, the filling 3.60 dollars and the frosting 3.56 dollars.
Good to know before you buy
- It costs one recipe at a time. For another recipe, save a copy of the file.
- It covers ingredients only. Labor and boxes live in Cake Price and Margin.
- Each file stands alone. It does not read another file, so you type a number from one sheet into the next.
Opens in the app you use
Excel opens the .xlsx file as it is. For Google Sheets, upload the file to Google Drive and open it with Google Sheets. There is a How to use tab in the file.
Pairs well with
Sheets that sit next to this one
Each file stands alone. These three are the ones bakers open side by side.
Pricing & Costing
Cake Price List
Every cake you sell with cost, price and margin, and a check on each price.
$5.99
Inventory & Purchasing
Order Ingredient List
This week’s cake orders turned into a buy list of ingredients.
$11.00
Questions
Questions about this sheet
How to calculate recipe cost?
Work out what each ingredient costs for the amount you use: pack cost divided by pack amount, times amount used. Add the lines for the batch cost, then divide by the number of cakes the batch makes. Batch Recipe Cost does these sums for every line and shows the cost per cake.
Can you provide an example of recipe costing?
Batch Recipe Cost ships with one. A cardamom pear layer cake with ten ingredient lines comes to 11.76 dollars for the batch. The batch makes two cakes, so each cake costs 5.88 dollars in ingredients.
Is there a free Excel template for recipe costing?
Batch Recipe Cost is not free: it costs $5.99 and is an editable .xlsx file for Excel and Google Sheets. The formulas are already built and locked, so you do not overwrite them by accident.
Can you provide a free recipe cost calculator in Google Sheets?
Batch Recipe Cost is not free, but it works in Google Sheets for $5.99. Upload the .xlsx file to Google Drive and open it with Google Sheets. It also opens in Excel.
Where can I find a template for recipe costing?
Batch Recipe Cost is a recipe costing template with a real sample in every cell. You see the sums work before you type anything, then clear the sample with one range name and use your own recipe.
What is the formula for calculating cost?
For one ingredient, cost is the pack price divided by the pack amount, times the amount you use. Add the lines for the batch cost, then divide by the number of cakes the batch makes. Batch Recipe Cost has this formula built into every line and locked.
Batch Recipe Cost$5.99