Build your own cake pricing calculator in Excel

Having a quick way to calculate how much you are going to charge for a cake order will save you so much time when it comes to running your business. Cake pricing is the source of stress, headache, worry and sometimes even disagreements with clients!

If you have a solid method for pricing your cakes you will be able to shake off that doubt and be confident when quoting a new order. Even if your potential customer challenges your pricing, if you’ve done the research and calculations you won’t think twice about justifying your price.

Baking quality cakes takes skill, time and a lot of dedication. You deserve to be paid well for your hard work!

So today I’m going to walk you through creating an Excel spreadsheet version of my Cake Pricing Calculator – just like the one pictured above! This will give you the freedom to tweak the calculations to suit your specific cake pricing issues and your cake business.

To learn about the breakdown of the figures used to calculate your cake price, check out my post on How To Price Your Cakes.

I’m going to use Google Sheets to create this spreadsheet as it’s a free spreadsheet service available to all, but the principles and methods will work just the same in Microsoft Excel, or any other spreadsheet software. It’s really quick and easy – so let’s get started!


Open up the spreadsheet software of your choice. Don’t forget to name it and save it straight away.



Don’t want to spend time creating your own CALCULATOR?

Next step is to type in your inputs. We need 5 cells, I like to leave one blank in between just to make it easier to read. You’ll need to enter Hourly Rate, Time, Material Costs, Overheads and Total.


For your Overheads cell you start by typing an equals sign, then type two open brackets, now click on the blank cell next to hourly rate, then type an asterisk to symbolise multiply, then click the blank cell next to time, one closed bracket, now type a plus sign, another closed bracket, one final asterisk and finally type 0.05. Now press Enter/return on your keyboard.


To calculate the total you will start by typing an equals sign, then one open bracket, now click on the blank cell next to hourly rate, then type an asterisk to symbolise multiply, then click the blank cell next to time, one closed bracket, now type a plus sign, and select the blank cell next to material costs, one final plus and finally click the cell next to overheads. Now press Enter/return on your keyboard.


Double check that your formula are working by typing numbers into the hourly rate, time and material costs cells. Numbers should automatically be generated next to overheads and total.


Now that everything’s working it’s time to make it pretty!

You can add formatting to the whole page by highlighting your text then changing the font, size, colour, etc.


My favourite bit of formatting on a calulator like this is to colour the cells that you need to input figures in to, and leave the ones that automatically calculate figures plain. That way you won’t get confused about what numbers you need to type in!

And you’re done! Be sure to save before you close down.

Don’t have the time or inclination to make your own calculator?

Free blank Bakery Menu templates

Customize a free menu card design for cake shop. Offer your assortment of sweets with cool and professional menus. Create a free price list for your bakery.

Edit a Pastry Menu template

Create a beautiful Bakery Menu card design effortlessly. Edit the customizable menu template you like the most from this article and make your business shine like never before. A design like you are an expert and done in a few minutes. Save time and money.

Customize a free Bakery Price List template for free

Design your own menu without spending money on photographers, advertisers, and designers. Select the template to customize online that you like to make bakery menus. You will save a lot of time using any of our templates since you can create the menu using your cell phone, tablet, or computer. Once you have your finished work you only have to download it in high resolution easily to send it to print to your printer or your trusted printer.

You don’t have to worry about not having complex programs to design. has thought of your needs by creating a free online editor.  Just customize any of our pre-designed templates with examples and provide the information about your sweet bread and delicious cakes worthy of being in a fairy tale.

At we have created a huge gallery of menus of all kinds for your bakery, from dessert menus to coffee menus. Check them out, maybe they will inspire you to improve your business!

  • Customize the Pastry Shop Menu to your liking. Your needs and creativity will find no limits.
  • Save your changes online in our cloud. So you can make price corrections later without having to start all over again.

And you’re done!

Cake shop menu card templates to customize online and print

It’s time to grow your business economy! With you’ll create a menu that will impress your customers. You’ll do it in no time thanks to our wonderful graphic editor. It’s intuitive and fun to use – you’ll look like a Photoshop expert!

Don’t let the challenge scare you! Every day we help entrepreneurs all over the world to create in a comfortable and effortless way. Beat your competition by offering the most appetizing menus, also ideal to offer along with slices of cake, tea, or coffee.

You can add your own photos or add beautiful pictures from our photo gallery. Use pastel shades for the backgrounds as you are the owner of a bakery!

You can download your design right away as a high-resolution PDF, JPG, or PNG in high visual quality to promote your bakery’s new price list. The result will make you happy because, just like you, we have made these templates with a lot of love for professionals like you.

Create your Pastry Shop Menu in minutes, enter’s online editor now!

Free blank Bakery Menu templates

Load more templates (+)

Custom Printed Bakery Forms

We personalize and print paper forms that are used in bakeries. These forms include things like order forms, invoices, and receipts. Having the right forms is an important part of running a bakery as it helps to keep track of orders and transactions and ensures that the bakery is able to provide accurate and efficient service to its customers.

Benefits of having the proper forms in your business.

There are several benefits to having the proper personalized and custom-printed bakery forms in a bakery. Some of these benefits include:

  • Improved organization and record-keeping: Having dedicated forms for orders, invoices, and receipts helps to keep all of the information related to a bakery’s transactions organized and easy to access. This can make it easier to track orders and manage the bakery’s finances.
  • Increased efficiency: With dedicated forms, bakers can quickly and easily input the necessary information, which can save time and reduce errors. This can help to speed up the ordering and payment process, allowing the bakery to serve more customers in a given time period.
  • Enhanced professionalism: Using dedicated forms can help to give a bakery a more professional appearance, which can enhance its reputation and attract more customers.

Overall, having bakery forms can help to improve the organization, efficiency, and professionalism of a bakery, ultimately leading to increased customer satisfaction and success.

  • Personalized with your logo and business information
  • Multi=part carbonless copies
  • Consecutively numbered
  • Different formats, including booklets, register format, snap set, etc.
  • Customizable to make the form more related to your services.

How to order:

Order online by selecting a form, the quantity, size, colors, and the number of parts/copies. You can upload a logo along with your online order. Input your company details to be imprinted such as business name, address, phone, fax, and website. In the “Extra Info.” etxt box you can send us any additional information on your order. We will send you proof via email for any printing to be done.

Choosing The Right Prices Is The Key To A Successful Baking Business.

Here’s how correctly pricing your baked goods can help you:

  • Pay for your supplies and overhead
  • Pay yourself each month
  • Generate profit for your business

Are you ready to stop guessing at prices, and learn how to price your baked goods the right way?

The First Step To Pricing Baked Goods Is To Track The Cost Of Your Ingredients

Figuring out how much you spend on ingredients is the first step to pricing your baked goods. I recommend a master inventory list or spreadsheet with your ingredients and the amount you paid.  Record the size of the package and the cost of the container.

It helps to see the ingredient costs by weight. This number is called the price per unit. To find your price per unit just divide the purchase price by the purchased quantity.

Be sure to update your list every few months. Make a note of which ingredients have increased in price. This will help you keep up with increasing ingredient costs.

Next, You Want To Calculate The Cost Of Ingredients In Your Recipe

Now that you know how much your ingredients cost you to buy, you can move on to calculate the cost to make your recipe.

To calculate the recipe cost, you’ll need to record the cost for the amount of each ingredient used in your recipe.

Here’s an example of how to calculate the cost of ingredients:

  • I buy a 5 lb (80 oz) bag of flour for $2.64
  • My recipe calls for 8 oz of flour.
  • The cost of flour in my recipe is $0.26

How To Account For All The Costs Involved In Making Your Baked Goods

I hear about lots of methods that bakers use to mark up their recipe costs. Some mark up 3x the recipe cost, while others try increasing the recipe cost by 50% to arrive at a selling price. Neither of these is an accurate way to price home-baked goods though.

Let’s take a look at the additional costs that home bakers have and see how to account for them in your prices.

You Should Include Your Labor Cost When Pricing Home-Baked Goods

To add your labor into a recipe you need to decide how much your time is worth. If you were going to work for someone else doing this work, what would you expect to get paid? Remember, the better you are, the more you can charge for your time. You can always increase your hourly rate, but to start with, just pick a realistic hourly rate.

Here’s a look at the process of making sugar cookies and the time involved:

  • Mix the dough (15 min)
  • ed goods.

Are you packaging and labeling your items individually? Then you will need to add the cost of 1 package and 1 label to each baked good that you sell.

If you are selling your baked goods by the dozen and packaging them together, you’ll include the cost of the packaging and label to the price per dozen.

What Are The Overhead Costs For A Home-Based Bakery?

There are two kinds of additional expenses that you can have in your baking business: fixed costs and variable costs. These are expenses for items that are not part of the ingredients or labor involved in making the recipe.

Here is a definition of the types of additional non-food expenses you may have:

Fixed Costs For Home Bakers

Fixes costs are costs associated with running your business that don’t change each month. (rent for kitchen space, farmers’ market fees, website maintenance, etc)

The easiest way to calculate your fixed costs is to add up your monthly expenses and divide them by your monthly sales. This will give you a cost per dollar value. Add this amount to your markup when you are calculating your sales price.

Here’s a look at my monthly fixed expenses for my home baking business

  • Website fees ($20)
  • Farmer’s market costs ($30)
  • Business insurance ($15)

In this example, I have fixed costs of $65/month for running my baking business. In a typical month, I make $1000 in sales. My indirect cost for overhead expenses is $65/$1000=$0.065.

This means that for every dollar I sell, 6 cents of that goes to cover overhead.

Variable Costs For Home Bakers

Variable costs are costs that increase when your production increases. (cupcake liners, parchment paper, packaging, and labels)

Here’s a tip to help keep track of your variable expenses:

Include all your variable costs in your recipes. In addition to recording the cost of each ingredient used, add your variable costs like cupcake liners, parchment, packaging, and labels to each recipe.

Keep reading to find your sales price by combining all the total costs

What Is The Cost Of Goods Sold (CoGS) For Home Bakers?

Cost of goods sold is a term that refers to the direct cost of making your products. These include the cost of ingredients, your labor to make the item, variable costs, and fixed costs.

Did you see in the above section that I said direct costs? The cost of goods sold is the cost directly related to the sale of your product. It doesn’t include general selling expenses like the salary you pay yourself or your marketing expenses. That will come from your profits. (That’s why it’s super important to make a profit from every sale!)

We’ll get into the indirect costs later, but for now, let’s just focus on the cost of goods sold for your recipe.

How To Calculate The Cost Of Goods Sold For Pricing Home-Baked Goods

  • Ingredient cost
  • Labor cost
  • Variable costs
  • overhead

cost of goods sold=ingredient cost + labor cost + variable costs + overhead

Once you have your actual costs (cost of goods sold)  you can mark it up for profit and get your selling price!

How To Calculate Your Sales Price For Home-Baked Items

Your sale price for home-baked goods is calculated by marking up your cost of goods sold. You’ll need to know the cost of goods sold for each bakery item that you sell.

The formula for cost of goods sold is:

cost of goods sold(CoGs)=ingredient cost + labor cost + variable costs + overhead

To mark up the cost of your product by a percentage, you multiply COGS by the percent markup and add that number to your CoGs.

(CoGS x mark up) + CoGS= Sales Price

Here’s what a mark-up looks like with my sugar cookie recipe:

  • CoGS for 1 cookie ($0.66)
  • 50 % mark up ($.66 x .50)+ 0.66-$0.99

Applying a 50%  mark on a cookie that cost me $0.66 to produce, yields a sales price of $0.99 per cookie.

What Is A Good Profit Margin For Home Bakery Items?

Profit margin is the difference between the total cost of your product and the total revenue it brings in. While many home bakers don’t focus on this number, it’s important because it clearly shows you how much money from every sale is profit.

Profit Margin= 100*(sales price – COGS)/sale

Your profit margin is how much money is left after all the expenses have been covered. It is always expressed as a percentage.

Looking at the profit margins of your products makes helps you:

  • Know which items are the most profitable
  • Decide which items you should promote
  • Help you to create more profitable menu items
  • Adjust your prices to maintain ideal margins

You can see the value of knowing your profit margin when it comes to making important decisions for your home bakery.

Charging The Right Amount For Your Bakery Items Is A Great Way To Grow Your Small Business

Now that you know how to price baked goods the right way, you are on the way to making a profit on every sale. Just be sure to factor in the cost of your ingredients, labour cost, packaging, and profit to come up with a good price.

In the beginning stages of your business, it may be hard to imagine that someday your business will grow into something much larger. One day you may decide to expand into a retail or commercial space. You may have a bookkeeper, an accountant, or even an investor. You might even decide to sell your business!

Understanding terms like profit margin, cost of goods sold, and gross profit are going to be important. Start now and learn as much as you can about the business side of baking so that you can build the foundation for success!

Here Is A List Of Other Resources Available That Can Assist You In The Basics Of Pricing Home Baked Goods.

How Do I Update My Prices When The Cost Of Ingredients Goes Up?

When the cost of ingredients goes up you make less profit. Every three months or so, compare what you are paying for supplies now, vs in the prior 3 months. Look for significant increases in commonly used ingredients. (butter. Eggs, oil, flour, sugar, and vanilla). It helps to keep an ingredient list and update it regularly. You’ll need to recalculate your recipes with the new ingredient costs.

You can easily do this with The Perfect Pricing Method. Just update your master inventory list, and it will automatically adjust all your recipes and update your costs.

Do I Include My Start-Up Costs In My Overhead?

Start-up costs are the one-time expenses that you have when you are setting up your business. They should not be included in your overhead. Overhead costs are things that you pay monthly to keep your business running. Typical overhead costs are farmer’s market fees, business insurance, and apps and memberships. You should include overhead costs in your sales price.

Is There An Easy Way To Price Wedding Cakes And Homemade Cakes?

Having been a wedding cake designer for 10 years, I have tried just about every method for pricing wedding cakes! The easiest and most accurate way to price wedding cakes is to set your prices based on the size of each tier, not on how many servings it yields. Create a base price for each tier that includes ingredients, labor, and basic decoration. Add a designer fee for the labor and supplies involved in creating more elaborate designs.

I Sell At The Farmer’s Market And Often Have Leftovers. Should I Factor Leftovers Into My Prices?

Predicting how much to bake for the farmer’s market is really hard. It is common to have leftovers at the end of the market. Instead of factoring leftovers into your prices, I recommend having a flash sale. A flash sale will help you so sell any remaining items.

When I Sell One Dozen Cupcakes, Should I Give A Discount From My Standard Cupcake Price?

Whether or not to offer a discount is a personal decision. I like offering a discount on larger volume sales. You can consider offering an incentive like a reverse baker’s dozen. A reverse baker’s dozen is “buy 11 and get the 12th one free” It gives your customers an incentive to buy a few more. and creates a nice boost for your sales. Inside my Perfect Pricing Method, I show you how to easily price recipes by the piece and by the dozen!

How Do I Know How Much My Labor Costs?

When you’re making your recipes, keep track of the labor involved to mix, portion, decorate and package each menu item. Record the time it takes you to make each recipe you want to price. To calculate your labor costs, you’ll need to decide on your wages as a baker. It’s best to pick something that is standard for your area. This is just compensation for your baking. Later, you’ll pay yourself for your marketing from the business profits. To calculate your labor costs, just multiply the time to prepare a recipe by the selling price.

Good News, My Cottage Food Laws Just Started Allowing Shipping. How Do I Add On That Expense?

The first thing to do is to figure out how you’ll package things for shipping. A good way to do this is to do a trial shipping and mail baked goods to yourself. See if you like the condition they arrive in. Once you know how you will package things for shipping, add up all the additional supplies and the cost to ship. This will be your shipping and handling fee.  Now you can add that to the price of the items you sell.

I Think I Understand The Basic Formula, But Is There An Easy Way To Price All My Recipes?

The easiest way to price baked goods is with my Perfect Pricing Calculator tool. I designed the Perfect Pricing Method to use in my own baking business because I needed to be able to price my baked goods quickly and easily. In my course, I teach you how to set up and install the pricing calculator on your own computer. I then walk you through exactly how to enter your ingredients, packaging, overhead, and labor. The final result is a sales price that tells you exactly how much profit you make from each sale. Now I can look at a recipe in a recipe book and calculate a selling price in just minutes!

Bakery menus are a great way for small businesses to showcase their products, increase customer engagement and drive sales. There are many types of bakery menus including pastries, cakes, breads, hot drinks, cold drinks and breakfast items.

Pastry menus usually feature traditional desserts such as tarts, pies or muffins as well as more elaborate creations like mousses and entremets. Cakes come in all forms from classic sponge to unique tiered masterpieces with fondant or buttercream frosting. Breads can range from artisan loaves to specialty pastries like croissants or danishes. Hot drinks often include standard caffeinated options such as coffee or tea as well espresso-based products like cappuccinos or lattes. Cold drinks mostly consist of frappes or smoothies which can be made with dairy or dairy-free alternatives such as almond milk. Lastly, breakfast items provide customers with warm dishes like scrambled eggs paired with meats and vegetables or sweet offerings such as French toast and waffles.

Bakery menus have many uses for small businesses including providing customers with an overview of the products on offer at the bakery, highlighting specialties that set them apart from competitors and helping staff manage orders efficiently by having all the required items already listed out in one place. In addition they can help reduce customer confusion by displaying prices clearly and avoiding overcrowding the menu board with too many choices.

Leave a Reply

Your email address will not be published. Required fields are marked *