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 26
2/8/11 at 11:15am
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 26
2/8/11 at 11:15am
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 26
2/8/11 at 11:33am
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!
Reply
Reply
post #4 of 26
2/8/11 at 11:40am
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 26
2/8/11 at 12:00pm
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 26
2/8/11 at 12:04pm
Thanks for this- it's great!
Reply
Reply
post #7 of 26
2/8/11 at 12:20pm
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.
Reply
Reply
post #8 of 26
2/8/11 at 5:59pm
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 26
2/8/11 at 6:12pm
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!
Reply
Reply
post #10 of 26
2/8/11 at 7:04pm
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 26
6/24/12 at 8:44pm
how did you determine the second price per unit
Reply
Reply
post #12 of 26
6/25/12 at 4:34am
This is so helpful! thanks!
Reply
Reply
post #13 of 26
8/10/12 at 6:05pm
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
Reply
Reply
post #14 of 26
12/11/12 at 10:51am
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 26
1/8/13 at 5:39pm

This is GREAT! Thanks for sharing.

Reply
Reply
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