Cake Central › Cake Forums › Cake Talk › Cake Decorating Business › Determining how much of a sale is profit (- overhead)?
New Posts  All Forums:Forum Nav:

# Determining how much of a sale is profit (- overhead)?

Okay, I know that sounds simple, but I need to figure out how much to deduct for overhead (electricity, etc.) and insurance and everything else. Is there a formula? I generally take my costs and multiply by three to get a price, but is there away to estimate to how much is profit?

Thanks,
Kathi

### Cake Central Top Picks

try this little excel spreadsheet and see if it helps any.

it estimates the overhead based on the items listed.

it does it PER CAKE

(feedback for improvements -- within my limited math abilities -- are most welcome!!)

------------

EDITED -- uploaded version w/ columns set wider for larger numbers
Keep on cakin'!
Keep on cakin'!
You're incredible, Doug! Just one question. When I changed the numbers for my own needs the total shared expenses went over a thousand and that cell only shows "pound" signs. If I mouse over it it tells me the number, but is there a way I can adjust this so I can see the number?

Thanks,
Kathi
Quote:
Originally Posted by kathik

You're incredible, Doug! Just one question. When I changed the numbers for my own needs the total shared expenses went over a thousand and that cell only shows "pound" signs. If I mouse over it it tells me the number, but is there a way I can adjust this so I can see the number?

Thanks,
Kathi

just make that column wider!

go to the top where the column heading are (A, B, C, ...) and mover cursor to right side of column -- when it hits the line it will change to the resize columns cursor (vertical line w/ arrows pointing left/right out of middle) ..
click and hold -- and drag to right to make as large as needed.
Keep on cakin'!
Keep on cakin'!
Thanks, Doug. It's perfect!

Kathi
Thank you Doug - this is just what I have been looking for!!!
Fat and Happy Confections! Business partner with SueBee.
Fat and Happy Confections! Business partner with SueBee.
Quote:
Originally Posted by FatAndHappy

Thank you Doug - this is just what I have been looking for!!!

I know this is a very old thread, but Doug can you please message me the spread sheet i do not see a link here thanks!!!

I'd love to see that as well, please, Doug.  Thanks!

Karen

"Money can't buy happiness, but it can buy cake and that's almost the same thing!"
www.thecakeboxofjackson.com

"Money can't buy happiness, but it can buy cake and that's almost the same thing!"
www.thecakeboxofjackson.com

I do not see a link either

I don't see a link either..

I don't see a link either

I see this post is really old, but i too cannot see the link. I have been looking for a simple way to price/cost my cupcakes, etc. Can anyone who has Doug's link please send it to me.

Thanks so much

@ Baking Me Crazy

Have you had any luck getting Doug's link?

No I Haven't

In order to use any spread sheet, you'd still need to gather your own information/numbers to plug into it. Once you have your base numbers it's not that hard to divide by 365 days or less. There's other online business calculators that do the same thing.

New Posts  All Forums:Forum Nav:
Return Home
Back to Forum: Cake Decorating Business
• Determining how much of a sale is profit (- overhead)?

### Cake Central Top Picks

Cake Central › Cake Forums › Cake Talk › Cake Decorating Business › Determining how much of a sale is profit (- overhead)?