Pricing & Costing
Batch Recipe Cost
Cost one cake recipe by the batch: ingredient lines in, cost per cake out.
$5.99
Pricing & Costing
Cake pricing calculator: the price from your costs and your margin
Cake Price and Margin is a cake pricing calculator that starts from what the cake costs you: ingredients, your minutes, your hourly rate and the box. Pick the margin you want. The sheet gives you the selling price and the profit.
$5.99Cake Price and Margin
- 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 Cake Price and Margin work?
Cake Price and Margin turns what a cake costs you into a selling price. You type the ingredient cost, your minutes, your hourly rate and the box, then the margin you want. The sheet adds labor and supplies to the ingredients, divides the total cost by one minus the margin, and shows the price and the profit.
Type your costs
Ingredient cost, labor minutes, your hourly rate, and what the box, board and liner cost.
Set the margin you want
Type a target margin. The selling price follows from it, and the margin shown is profit divided by that price.
Read the price
Labor cost, supply cost, total cost, selling price and profit. A status word tells you when something is missing.
The sample in the file
June Hale’s 8-inch cardamom pear cake: 6.40 dollars of ingredients and 45 minutes at 18 dollars an hour come to 22.40 dollars. At a 40% margin the price is 37.33 dollars and the profit 14.93 dollars.
How to price a cake: cost first, then margin
Add up what the cake costs you, including your own time, then divide by one minus the margin you want. At a 40% margin a 22.40 dollars cake sells for 37.33 dollars. The sheet does the sum, so the price is a number you can stand behind.
A baking pricing calculator that counts your time
Labor is minutes times your hourly rate, so the hours you spend at the counter are in the price. Minutes in an hour is locked so nobody types over it.
Good to know before you buy
- It prices one cake at a time. Copy the file or clear the sample for the next cake.
- It does not read another file. Type in the ingredient cost yourself. Batch Recipe Cost gives you that number.
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
Jobs & Work Orders
Cake Order Form
One row per cake order: date, size, flavor, writing, servings, allergens, status.
$4.99
Questions
Questions about this sheet
How do you price your cake for sale?
Start from cost: ingredients, your time at an hourly rate, and the box, board and liner. Then choose the margin you want and divide the total cost by one minus that margin. Cake Price and Margin runs that sum and shows the selling price and the profit.
How much should I charge for making a cake?
There is no one number, because the price depends on your costs, your time and the margin you want. Type those into Cake Price and Margin and you get a price for that cake.
What is the 1-2-3-4 cake rule?
The 1-2-3-4 cake rule is a classic cake recipe ratio: 1 cup butter, 2 cups sugar, 3 cups flour and 4 eggs. It describes the batter, not the price. To price a cake made from it, cost the recipe first, then put that cost into Cake Price and Margin.
How to decide cake price?
Decide the margin you want first, then work back from what the cake costs you. Cake Price and Margin takes your ingredient cost, labor and supplies, divides the total by one minus that margin, and shows the selling price.
How do I calculate the price of a cake?
Add up the ingredients, your time at an hourly rate and the box, board and liner, then divide that total by one minus the margin you want. At a 40% margin, a cake that costs 22.40 dollars sells for 37.33 dollars.
What to charge for an 8 inch cake?
There is no one price for an 8-inch cake, because it depends on your costs and your margin. In the sample file, an 8-inch cardamom pear cake costs 22.40 dollars and sells for 37.33 dollars at a 40% margin. Type your own costs to get your price.
How to work out cake prices?
Work out the total cost of the cake first: ingredients, labor and supplies. Then choose a margin and divide the total cost by one minus that margin. Cake Price and Margin runs the sum and shows the cost, the price and the profit side by side.
Cake Price and Margin$5.99