Cake Central › Cake Forums › Cake Talk › Cake Decorating › Calculate your costs spreadsheet
New Posts  All Forums:Forum Nav:

Calculate your costs spreadsheet

post #1 of 34
Thread Starter 
Hi, I wanted a really easy spreadsheet just to get a basic idea of how much it costs to make a cake- nothing fancy or too confusing. Here's what I put together: https://spreadsheets.google.com/ccc?key=0Ap7LLc7KQ-6ldHNQbWxhb0dFUDlvcU9uby1UcUF4cEE&hl=en#gid=4

Let me know if you see any mistakes, or anything to add, thanks!
www.cantstopbaking.blogspot.com
Join in the craziness!
Reply
www.cantstopbaking.blogspot.com
Join in the craziness!
Reply
post #2 of 34
Thread Starter 
Note the tabs on the bottom for different recipes.
www.cantstopbaking.blogspot.com
Join in the craziness!
Reply
www.cantstopbaking.blogspot.com
Join in the craziness!
Reply
post #3 of 34
I like your spreadsheet. It's not as complicated as "The Matrix" (which is a detriment to those who sell cakes for a living, and sellers definitely need to consider more cost detail). But this looks good for those of us who just make cakes as a hobby. I don't need/want to calculate my overhead expenses into my cake costs. I'm just curious about how much the ingredients cost per cake or per project. This is also good for those who are intimidated by spreadsheets. Yours is easy to follow and use.

Thanks for sharing!
post #4 of 34
Thanks for this Niki. I hate working out prices but this will Make it much easier.
The secret of success is enthusiasm!
Reply
The secret of success is enthusiasm!
Reply
post #5 of 34
That's really nice. I did one just for the cost of ingredients for a batch of WASC (2 mixes) and a double batch of buttercream but I haven't even thought about taking the time to figure out the cost with the supports and decos. Thanks for sharing this.
Visit me at www.keeponcaking.com for tutorials and other cake stuff.
Reply
Visit me at www.keeponcaking.com for tutorials and other cake stuff.
Reply
post #6 of 34
Thanks for this- it's great!
post #7 of 34
This is perfect! thanks so much, I never have the patience to work out the exact prices and on the odd occasion that I've tried I haven't been able to work out the small details so this is great, much appreciated.
post #8 of 34
Thread Starter 
Great! Glad everyone likes it! I can't promise there are no mistakes, but so far it seems ok. Thanks for your feedback.
www.cantstopbaking.blogspot.com
Join in the craziness!
Reply
www.cantstopbaking.blogspot.com
Join in the craziness!
Reply
post #9 of 34
Wow - this spreadsheet opened my eyes! I need cheaper ingredients!!!! I don't really buy in bulk because I just bake for friends and family and their requests aren't very regular, so I don't want giant amounts of ingredients to store...but man!!! What a price difference. I am paying almost double for nearly everything!
post #10 of 34
Thread Starter 
Well, I do buy almost all my ingredients from Costco, so that cuts down ALOT. Plus it saves lots of trips to the grocery store...
www.cantstopbaking.blogspot.com
Join in the craziness!
Reply
www.cantstopbaking.blogspot.com
Join in the craziness!
Reply
post #11 of 34
how did you determine the second price per unit
post #12 of 34
This is so helpful! thanks!
post #13 of 34
I like the spreadsheet put together and want to create something similar to price cost of my cakes. The only component I did not understand was the calculation for the second price / unit. Please tell me where the number comes from that is divided by the first calculated price / unit.

Thank you
post #14 of 34
Thread Starter 

The first price per unit is the total price for the unit that that ingredient uses- so if the ingredient calls for 2 cups sugar, then the first price per unit would be the price for 1 cup sugar. The second price per unit is the total price for the ingredient in the recipe, so that would be the first price per unit x2. I hope that explains it. I'm sorry for the late reply, but I dont check CC so often. If you have any more questions you can email me at nechama.fiddle@gmail.com. 

www.cantstopbaking.blogspot.com
Join in the craziness!
Reply
www.cantstopbaking.blogspot.com
Join in the craziness!
Reply
post #15 of 34

This is GREAT! Thanks for sharing.

New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Cake Decorating
Cake Central › Cake Forums › Cake Talk › Cake Decorating › Calculate your costs spreadsheet