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!
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!
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.
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.
Great! Glad everyone likes it! I can't promise there are no mistakes, but so far it seems ok. Thanks for your feedback.
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!
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...
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
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 [email protected].
Hi, I will start with I am new to all this and hope to open our doors in April. After seeing some replies in some threads I am almost scared to reply to anything. But this spreadsheet is awesome!!!! and thank you for sharing! I have a question not about the spreadsheet but about the fondant recipe in your spreadsheet, Is that really how you make yours. I have only ued fondant a few times and am therefore limited wth cake desgn but the few times I used it I hated it and run from it at this point. Thanks so much again!
Hi
Thanks for sharing.
I have some questions:
a) Why did you add 25% to the cost? what is the 25%?
b) How did you claculate the cost for "time"?
A
Original message sent by sunflowerlove
a) Why did you add 25% to the cost? what is the 25%? b) How did you claculate the cost for "time"?
The extra 25% is a markup for your profit, which should flow to the business. If you have no profit and are only being paid for your ingredients/labor/overhead, your business will never grow.
The cost for time is based on the total number of hours required to complete the order multiplied by your hourly wage.
In addition to this you'll also want to add overhead (insurance, license fees, etc.) broken down on a per-order basis.
Can this be changes without loosing the formulas ? If so, how would I do this. I would like to alter for my own recipes. I am a newbee to selling cakes and want to be sure I am pricing correctly. I am not familiar with creating my own spreadsheets. Any and all info and suggestions are deeply appreciated !
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!
Your spreadsheet is really nice. I like how you've broken it down and included the extra % for profit. Often profit is confused with labor.
Hi, I will start with I am new to all this and hope to open our doors in April. After seeing some replies in some threads I am almost scared to reply to anything. But this spreadsheet is awesome!!!! and thank you for sharing! I have a question not about the spreadsheet but about the fondant recipe in your spreadsheet, Is that really how you make yours. I have only ued fondant a few times and am therefore limited wth cake desgn but the few times I used it I hated it and run from it at this point. Thanks so much again!
Don't be. Just jump right it and swim with the sharks. It's all bark and no bite
Don't be. Just jump right it and swim with the sharks. It's all bark and no bite
Thanks I am minding my own and reading and learning. Thank you again!!
I am still trying to get the file to open
Question to all...how do you work out what to charge for labour? I have been doing hobby cakes for a while now but things are starting to pick up so I need to start charging accordingly. I know some people charge and hourly rate but I've no idea where this rate comes from.
Any assistance would be much appreciated!
A
Original message sent by EmmysCakes
Question to all...how do you work out what to charge for labour? I have been doing hobby cakes for a while now but things are starting to pick up so I need to start charging accordingly. I know some people charge and hourly rate but I've no idea where this rate comes from.
You can find out average cake decorating wages in your area by checking out salary survey web sites like payscale.com.
wow! thanks! im always wondering what spreadsheets are for. im just a newbie in this business. thank you so much for this information.
This is awesome!! I've been looking for something like this for a while. But I have a few questions: What exactly does, "Transfer" mean on the cake orders? How do you determine the amount in your Time?
Thanks for sharing!!
Quote by @%username% on %date%
%body%