Pricing & Costing
Batch Recipe Cost
Cost one cake recipe by the batch: ingredient lines in, cost per cake out.
$5.99
Cake price calculator and order list for home bakers
This cake price calculator gives every cake order a price and shows the list of what is due. Twelve editable spreadsheets for Excel and Google Sheets cover those two jobs and the rest of the week too.
$77.00for all twelve, one payment
Browse the single sheets- Editable .xlsx files
- Excel and Google Sheets
- One payment, no subscription
- Files arrive by email after checkout
What it does
Four jobs a home bakery does every week
Each job has its own sheets. Use one, or all twelve.
01
Price it
Cost the recipe, add your time, set your margin. Get a selling price for each cake.
Open the sheets →
02
Track it
One row per order, with the balance, the deposit and what is due this week.
Open the sheets →
03
Launch it
The label for the box, the numbers you looked up and your first month of packaging.
Open the sheets →
04
Stock it
What is on the shelf, what to reorder and what this week’s cakes need.
Open the sheets →From recipe to price
How do I get a price for a cake from its recipe?
Cost the recipe first, then add your time, your supplies and the margin you want. The sheet divides the total cost by one minus that margin and gives you the selling price. Here is the sample cake that ships in Cake Price and Margin, worked out line by line.
- Cost the recipe
Batch Recipe Cost turns ingredient lines into a cost per cake.
- Price the cake
Cake Price and Margin adds your time and supplies, then gives the selling price.
- Keep the list
Cake Price List holds every price you charge and flags any under cost.
8-inch cardamom pear layer cake
- Ingredient cost
- 6.40
- Labor: 45 min at 18.00 an hour
- 13.50
- Box, board and liner
- 2.50
- Total cost
- 22.40
- Margin you want
- 40.0%
- Profit
- 14.93
- Selling price
- 37.33
All amounts are in US dollars. The numbers are the sample in the file. Type your own costs in the white boxed cells.
The twelve sheets
Which spreadsheet do I need today?
Start with the job that hurts this week. If you cannot say what a cake costs, take Batch Recipe Cost or Cake Price and Margin. If orders slip, take Cake Order Form or Orders Due This Week. Labels and stock come next. Prices run from $4.99 to $11.00 a file.
| What | Pricing & Costing | Jobs & Work Orders | Startup & Launch | Inventory & Purchasing |
|---|---|---|---|---|
| Use it when | You need to know what a cake costs and what to charge. | Orders are coming in and you need to know what is due. | You are starting to sell from your home kitchen. | Ingredients run out at the wrong moment. |
| The sheets | Batch Recipe Cost, Cake Price and Margin, Cake Price List | Cake Order Form, Bakery Order Form, Orders Due This Week | Cottage Food Label, Cottage Start Records, First Month Packaging | Ingredient On Hand, Supplier Reorder, Order Ingredient List |
| You type | Ingredients, your time and the margin you want. | Each order, the deposit and the due date. | Your details, the numbers you looked up and the cakes you expect. | What is on the shelf, supplier prices and this week’s orders. |
| You get | The cost per cake, the selling price and a checked price list. | One row per cake, the balance still due and the cakes due this week. | A label to print, one sheet of records and the packs of boxes, boards and liners to buy. | A shop list, the cost of a reorder and what this week’s cakes still need. |
| Price of each file | $5.99 | $4.99 | $5.99 | $11.00 |
Each page shows one whole page of the real file with its sample filled in.
Pricing & Costing
Cake Price and Margin
One cake in, a selling price out: ingredients, your time, supplies and margin.
$5.99
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
Jobs & Work Orders
Bakery Order Form
Customer, delivery or pickup, total, deposit and the balance still due.
$4.99
Jobs & Work Orders
Orders Due This Week
Type the week start. Every cake due in that week is flagged and counted.
$4.99
Startup & Launch
Cottage Food Label
Type your details, print the Label tab. The print area is the label.
$5.99
Startup & Launch
Cottage Start Records
Permit number, date, insurer, kitchen address and label statement, kept in one place.
$5.99
Startup & Launch
First Month Packaging
How many packs of boxes, boards and liners the first month needs.
$5.99
Inventory & Purchasing
Ingredient On Hand
Quantity on hand against your threshold, and a shop list of what is low or out.
$11.00
Inventory & Purchasing
Supplier Reorder
Supplier, item, last price and packs to reorder, with the line cost worked out.
$11.00
Inventory & Purchasing
Order Ingredient List
This week’s cake orders turned into a buy list of ingredients.
$11.00
From order to box
Everything between the order and the box
Price the cake, write the order down, label the box, restock the shelf. One folder of twelve sheets covers the whole week.
Best value
All twelve home bakery spreadsheets
Everything a home bakery sells by the order, in one purchase: the price, the order, the label and the shelf.
$77.00Twelve bought one by one add up to $83.91.
- Three pricing and costing sheets: recipe, price and price list
- Three order sheets: the cake, the money and the week
- Three launch sheets: label, records and packaging
- Three inventory sheets: on hand, reorder and buy list
One page of each, wholeHow the files work
They open in the app you already use
Excel or Google Sheets, your choice. Before you buy, here is exactly what you get.
Excel
Open the .xlsx file and start typing. No add-ins and no macros to switch on.
Google Sheets
Upload the .xlsx to Google Drive, then open it with Google Sheets.
White boxes are yours
Type in the bordered cells. Yellow cells hold locked formulas, so you cannot overwrite them by accident.
A sample in every file
June Hale’s cakes are already filled in, so you see it work. Clear them with one range name, then type your own.
Good to know before you buy
- These are spreadsheets you fill in. We do not price the cake for you.
- Each file stands alone. It does not read another file, so you type a number from one sheet into the next.
- Every file has a How to use tab and a status in words as well as symbols, so it reads in black and white.
After you pay
Three steps from checkout to your first cake price
Pay at checkout
Press a buy button and pay on the secure checkout page.
Land on the thank-you page
You come back to this site’s own thank-you page.
Open the files from your email
The files arrive by email. Open them in Excel, or upload them to Google Drive and open them with Google Sheets.
Questions
What bakers ask before they price a cake
Plain answers, from the files themselves.
How much should I charge for a cake?
There is no one number for every cake, because the price depends on what the cake costs you, how long it takes and the margin you want. Type those into Cake Price and Margin and it gives you a price for that cake.
How to calculate the price of a handmade item?
Add up what it costs you: materials, your time at an hourly rate and the packaging. Then divide that total cost by one minus the margin you want. For a cake, Cake Price and Margin runs that sum for you.
Where can I download a free recipe costing template in Excel?
Batch Recipe Cost is a recipe costing template for Excel, and it is not free: it costs $5.99, and all twelve spreadsheets are $77.00. It is an editable .xlsx file with the formulas already built and locked, so you type your ingredients and read the cost per cake.
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.
How to make a cake order form?
Give every order a row and give each thing you need to know its own column: date needed, size, flavor, filling, writing, servings and allergens. Cake Order Form is built that way, with a status drop-down.
How to make a cottage food label?
Type your business name, product, ingredients, allergens, net weight, best before date and your name and address, then print the label. Cottage Food Label lays that out from one details tab. Check your state’s rules for what the label must say.
Is there a cost calculator for bakers?
Yes, Batch Recipe Cost and Cake Price and Margin are cost calculators for bakers, built as editable spreadsheets. Batch Recipe Cost gives the cost of one recipe and of each cake, and Cake Price and Margin adds your time and supplies to give the selling price.
What supplies do I need for a bakery?
A cake bakery usually needs boxes, boards and liners in its first month, plus a steady list of ingredients. First Month Packaging turns the cakes you expect into packs to buy, and Ingredient On Hand shows which ingredients are low or out.
Price the next cake before you say yes
Get all twelve for $77.00, or start with the one sheet that fixes this week.
All twelve home bakery spreadsheets$77.00