Pricing & Costing

Cake pricing chart: a price list that checks itself

Cake Price List is a cake pricing chart with one row for every cake you sell: its size, its cost and its price. The sheet works out the margin and tells you when a price is under cost.

$5.99Cake Price List
  • 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
Cake Price List, the List tab: four sample cakes with cost, price, margin and an OK check

One page of two, whole. The file has more.

You type hereLocked formula

How it works

How does Cake Price List work?

Cake Price List holds one row for every cake you sell. You type the cake, the size, what it costs you and the price you charge. The sheet works out the margin on each row and shows a check: OK when the price covers the cost, Under cost when it does not, and Enter price when it is missing.

One row per cake

Type the cake, the size, what it costs you and the price you charge.

Margin works itself out

Margin is a locked formula: price minus cost, divided by price.

Read the check

A tick and OK means the price covers the cost. A triangle and the words Under cost means it does not. A dash and Enter price means a price is missing.

The sample in the file

Four sample cakes, each with a cost, a price and a margin: 8-inch cardamom pear at 32.00 dollars is a 37.5% margin.

A cake price list template with the margin check built in

Most price lists are a column of numbers. This one checks every row against its cost, in words and symbols, so it still reads in black and white when you print it.

Good to know before you buy

  • It is not a recipe calculator. You type each cake’s cost. Batch Recipe Cost or Cake Price and Margin help you find it.
  • It is a list for you and for printing, not a page your customers fill in.

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.

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
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
Bakery Order Form cover: Jobs & Work Orders spreadsheet, editable .xlsx for Excel and Google Sheets
Jobs & Work Orders

Bakery Order Form

Customer, delivery or pickup, total, deposit and the balance still due.

$4.99
Questions

Questions about this sheet

How should I price my cake?

Know the cost first, then set a price that covers it and leaves the margin you want. Keep every cake you sell in one list so the sizes and flavors stay in line with each other. Cake Price List shows the margin for each row and flags any price that is under cost.

How much should I charge for a sheet cake?

The price of a sheet cake depends on your cost and the margin you want, so no single number fits every baker. Add the sheet cake as a row with its cost and price, and the margin and the check tell you whether the price holds up.

How much should I charge for a cake?

Charge at least what the cake costs you plus the margin you want. Cake Price List shows the margin on every row and flags any price that is under cost, so you see which cakes are priced too low.

How do cake shops price their cakes?

Cake Price List cannot tell you how other shops set their prices. It shows the margin on each of your own rows, so you can see whether your prices cover your costs.

How can I create a price list for free?

A price list can be a plain table with the cake, the size and the price. Cake Price List is not free, it costs $5.99, but it adds your cost and a margin check on every row.

How to make a spreadsheet for pricing?

List each cake with its size, its cost and its price, then work out the margin as price minus cost, divided by price. Cake Price List does this on every row and checks each price against its cost.

How to price a cake for sale?

Know what the cake costs you, then set a price that covers it and leaves the margin you want. Cake Price and Margin gives you the price for one cake, and Cake Price List keeps every price in one place.

Cake Price List$5.99