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)?

post #1 of 25
Thread Starter 
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
post #2 of 25
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 icon_rolleyes.gif -- are most welcome!!)

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

EDITED -- uploaded version w/ columns set wider for larger numbers
Keep on cakin'!
Reply
Keep on cakin'!
Reply
post #3 of 25
Thread Starter 
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
post #4 of 25
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'!
Reply
Keep on cakin'!
Reply
post #5 of 25
Thread Starter 
Thanks, Doug. It's perfect!

Kathi
post #6 of 25
Thank you Doug - this is just what I have been looking for!!! icon_smile.gif
Fat and Happy Confections! Business partner with SueBee.
Reply
Fat and Happy Confections! Business partner with SueBee.
Reply
post #7 of 25
Quote:
Originally Posted by FatAndHappy View Post

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

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

post #8 of 25

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

Reply

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

Reply
post #9 of 25

I do not see a link either
 

post #10 of 25
I don't see a link either.. icon_sad.gif
post #11 of 25

I don't see a link eithericon_sad.gif

post #12 of 25

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

post #13 of 25

@ Baking Me Crazy

 

Have you had any luck getting Doug's link?

post #14 of 25
No I Haven't
post #15 of 25

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
Cake Central › Cake Forums › Cake Talk › Cake Decorating Business › Determining how much of a sale is profit (- overhead)?