Create a cake costs spreadsheet

Рет қаралды 39,600

Күн бұрын

Build your own bakery costs calculator within Google Sheets (or Excel or Numbers).
To accurately price your cakes you need the exact amounts you are spending in your bakery. Also, having the facts and figures written down will give you confidence if a customer questions your prices!
If you don't feel like making your own, check out Cake Pricing Plus. My cake pricing course includes this spreadsheet and many more to make pricing a breeze!
Cake Pricing Plus - www.bakethishappen.com/cake-p...
Free Cake Pricing Calculator - www.bakethishappen.com/cake-p...
0:00 - Intro
0:29 - Use a cake pricing calculator
2:21 - How the costs spreadsheet works
5:44 - Walkthrough of building a costs spreadsheet from scratch

Пікірлер: 43

@vivianturner9434 Жыл бұрын

Thank you so much for this video. U am just a home baker starting out selling a few items and already have spent a lot of time doing this on paper. This has been super helpful 🙏🏼

@stephaniefuller4333 2 жыл бұрын

Thank you so much! This video has been extremely helpful. You explained everything very well.

@mimissweetandsavorylife3294 2 жыл бұрын

This has been very helpful! Thank you for helping me figure things out.

@adrianh6012 2 жыл бұрын

Thanks a lot!!! very helpful and it was super easy with your help, been looking for a tutorial and yours is the best! thanks!!!

@stephaniesimonsen1526 2 жыл бұрын

Bless you for making this video!

@sunnie153 Жыл бұрын

Thank you for this video!! Super helpful and easy to follow

@Leonardfilming 2 жыл бұрын

The only column I've added is the unit measurement, for instance grams or tsp or tbsp. Also I prefer the total cost at the top of the spreadsheet, then I can flick to that tab and immediately see the cost. Otherwise a great simple spreadsheet

@damianmendez5534 4 ай бұрын

Thank you so much we are just starting our business and this has help immensely thank you thank you 🙏🏽

@bmscts Жыл бұрын

This is great! Thanks so much for sharing 👍👍👍

@007kidronnie 2 жыл бұрын

thanks for this info ... this help me out very well ..

@iesharoper5861 Жыл бұрын

Thank you so much! This video was extremely easy to follow to create my own sheets for my recipes! I feel like i can now get started with my small business a little less stressed out! lol

@BakeThisHappen Жыл бұрын

You are very welcome and I'm so happy to hear it has been helpful! Good luck with your business :)

@cristinasalcedo8296 2 жыл бұрын

So easy to follow thanks

@salmoghul9395 2 жыл бұрын

Hello, this was very informative and very easy to follow. I’m so grateful, I have now been able to price my cakes properly and with confidence 😀

@BakeThisHappen 2 жыл бұрын

I'm so glad you found it helpful and are feeling more confident with your cake pricing now 😊 All the best with your baking business!

@leviackermn007 Күн бұрын

You're an angel 💕🌟

@gelicaperez3956 Жыл бұрын

Miss Ma’am!!!! You are AMAZING!!!!!!!!!

@michellecruz796 2 жыл бұрын

Thank you so much for this video. It has definitely helped me out sooo much.

@BakeThisHappen 2 жыл бұрын

You're welcome! I'm so glad it helped!

@GharsayHamesha 2 ай бұрын

GREAT! Thanks a million!

@mrsvoice7292 2 жыл бұрын

Thanks so much

@koolboy895 4 ай бұрын

This is such great information but how do I put liquids, since they don’t all weigh the same

@CPfaith 2 ай бұрын

Do the conversions for sugars as it may not be the same as flours.

@GharsayHamesha 2 ай бұрын

LIKED & SUBSCRIBED GOOD JOB!

@matthewmontaleone758 Жыл бұрын

What is the formal you are using to figure in the scaling price?

@BritanyWeddington-eu2mg 10 ай бұрын

How do you save the master copy and then the individual recipes?

@preethisarvi688 2 жыл бұрын

how does the "scale this recipe" change? that you have on the side of the recipe costs and do we have to change ml to grams?

@elinaavelar627 3 ай бұрын

Hi i saw the video is great the whole step by step is very helpful. But I have questions for the section size can I measure it as pounds or oz or does have to be all in grams? And how can I use google conversions so it does the math for me? Thank you.

@merlincampbell1145 7 ай бұрын

Nice!

@jojomartin338 8 ай бұрын

HI! I loved your video, but could you please explain to me how to convert liquids such as oil? It's complicated when it comes to gallons/quarts 5qts dealing with this huge container (liquids in cups) to 1/2 cup.

@yasminbrown9173 2 жыл бұрын

Hi There! Thank you so much this has been so easy to follow and helpful - i work with Grams and i buy for example a 1.5kg bag of flour and only use lets say 270g for one of my recipes. how do i add this to the sheet? Thank you x

@BakeThisHappen 2 жыл бұрын

Thanks Yasmin, glad it was helpful! When you are entering the 1.5kg bag of flour, add this as 1500g. That way you'll get the correct price when you enter your 270g for the recipe :)

@marissaramos9696 2 жыл бұрын

Hello, It was a very informative video! I'm just a little confused on how I would convert cups into grams or why I would need to convert grams into ounces when usually my recipes call for grams or cups? If you can please make a video focusing more on that aspect, that would be great! Thank you!!

@BakeThisHappen 2 жыл бұрын

Hi Marissa, no problem. You don’t need to convert to grams if you don’t use that measurement. The important thing is that the unit you are using for the raw ingredients matches the unit from your recipe. For example, if your bag of flour comes in a 1kg bag, and you type 1 into the spreadsheet, you need to make sure when adding the measurement from your recipe it is also in kilograms. Otherwise the calculation will be off. So if the recipe wanted you to use 500g of flour, you would need to convert that to kg first and enter 0.5. Because nothing is sold in cup quantities, you will usually need to convert the amounts in your recipe to kilograms/grams or pounds/ounces. Hope that helps but I should do a full video!

@rosenicholas2027 Жыл бұрын

Hi I created this sheet, I have two questions 1. How do you make an entry if there's no info of size and how much people it serves. 2. How to do the formula for scalping the recipe. Thanks

@neelamjain6368 Жыл бұрын

How you made that cake price calculator in pdf

@kedanpie4409 2 жыл бұрын

Thanks so much for sharing. Love love your layout. Just one question do you take into account any yields for ingredients used?

@BakeThisHappen 2 жыл бұрын

Hey, sorry for missing this question! Can you explain exactly what you mean and I'll be happy to help :)

@kedanpie4409 2 жыл бұрын

@@BakeThisHappenthe yield is accounting for any wastage you might incur in using your ingredient.

@BakeThisHappen 2 жыл бұрын

I don’t take into account any waste within this spreadsheet. This would probably be best added into your overheads when actually pricing your item for sale. This spreadsheet shows you how much a receipt would cost to make, based on the cost of the ingredients/materials. Thanks for watching!

@alenabcb7347 2 жыл бұрын

Hello how do I get the spreadsheet

@BakeThisHappen 2 жыл бұрын

Hi, You can download the free calculator here - www.bakethishappen.com/cake-pricing-calculator Or you can get the premium paid version here - www.bakethishappen.com/cake-pricing-plus