Spreadsheet For Pricing

Decorating By sccandwbfan Updated 31 Mar 2011 , 5:41am by JanH

sccandwbfan Posted 20 Mar 2011 , 9:21pm
post #1 of 41

Hi,

I took a post that someone made about figuring out the number of servings that can be attained by volume and an image that showed pricing levels and turned them in to calculating spreedsheets. My apologies to the posters, but please don't be upset, I didn't do it on purpose. Please note that it's yours if you see this.

The cells that are colored bordered are all that you need to change.

On the Pricing tab, you can enter the no. of servings, filling charge and delivery charge. This one shows the amounts for the levels of the original poster but they can be updated, you only have to change them on the first set (Buttercream or Cream Cheese) and the rest will update automatically.

On the serving size calculator tab, you start with the serving size at the top. Either enter numbers for rectangle or round and it will calculate. You can also put a cost in to show that.

Let me know if you see any errors or any way this can be improved.

Christy

40 replies
sccandwbfan Posted 20 Mar 2011 , 9:25pm
post #2 of 41

Okay, my attachment didn't work. Any tips?

MissCakeCrazy Posted 20 Mar 2011 , 9:30pm
post #3 of 41

Hello Christy. I have just seen this post. Can you tell me what this spreadsheet is about? Can anybody use it? Would you be able to send it to me if I PM you my e-mail?

paoli96 Posted 20 Mar 2011 , 9:48pm
post #4 of 41

I would love to see your spreadsheet - - sounds wonderful. Can you attach in PM?

ATCakes Posted 21 Mar 2011 , 12:39am
post #5 of 41

Christy-

Can you send me a copy of your spreadsheet? It sounds very interesting.

Amy

K1976 Posted 21 Mar 2011 , 12:55am
post #6 of 41

I hope you can upload for all us to see, thanks for doing this.

LisaPeps Posted 21 Mar 2011 , 12:56am
post #7 of 41

Could you email or PM me a copy please? TIA!!

annie84 Posted 21 Mar 2011 , 12:59am
post #8 of 41

I would love to see your spreadsheet! Hopefully you can get it posted, so nice of you to do this icon_smile.gif

Sorelle Posted 21 Mar 2011 , 1:00am
post #9 of 41

This would be great to have! Waiting to see if you get it worked outicon_smile.gif

SweetSouthernBakery Posted 21 Mar 2011 , 1:03am
post #10 of 41

Hey Christy I can see that you are getting a lot of requests for your spreadsheet but I have one more request for it if possible. I can pm you with my email.


Thanks

joyofcakes Posted 21 Mar 2011 , 1:21am
post #11 of 41

Christy Would you please pm me also and thank you for doing this for everyone.

jennilynn03 Posted 21 Mar 2011 , 1:39am
post #12 of 41

I would also love to see the spreadsheet as well! Thanks

cmehend Posted 21 Mar 2011 , 1:52am
post #13 of 41

This would be a great help if you are able to post this for us! Thanks!

lovecakes52 Posted 21 Mar 2011 , 1:53am
post #14 of 41

Hi Christy, this is so nice of you to do this spreadsheet! I also would like to see the spreadsheet.
Could you pm it to me as well?
Thanks So Much!!!!!

prichardsk Posted 21 Mar 2011 , 2:00am
post #15 of 41

Is this posted somewhere? If not can you send it to me too? Thanks, Kari

VaBelle Posted 21 Mar 2011 , 2:06am
post #16 of 41

You can try making it a google doc. Then you can just post the website. I haven't done it before, but I just pulled up the website and it doesn't look hard. Then you don't have to PM everyone.

Sounds like you've got a great creation! I love Excel!

crushed Posted 21 Mar 2011 , 2:13am
post #17 of 41

Can you PM this to me as well? Thanks in advance. thumbs_up.gif

jennifer22780 Posted 21 Mar 2011 , 2:10pm
post #18 of 41

me too please! pm me too =)

sccandwbfan Posted 21 Mar 2011 , 2:26pm
post #19 of 41
Quote:
Originally Posted by VaBelle

You can try making it a google doc. Then you can just post the website. I haven't done it before, but I just pulled up the website and it doesn't look hard. Then you don't have to PM everyone.

Sounds like you've got a great creation! I love Excel!




I will research how to do this in the future, but for now... I'm off to send a bunch of PM's. icon_smile.gif

luckylibra Posted 21 Mar 2011 , 2:27pm
post #20 of 41

This sounds fabulous. If you can post it where we can access it or PM it to me I would love to ccheck it out. I am hoping to start my HBV business in June. Thanks

sccandwbfan Posted 21 Mar 2011 , 2:33pm
post #21 of 41

It doesn't look like the attacher is working in the PM either. Annoying. icon_smile.gif If you PM me your email I will email it to you as an attachment.

Jules429 Posted 21 Mar 2011 , 2:55pm
post #22 of 41

I have been trying to get my hands on this forever! Could you PM me what I need to do!!! PLEASE

sccandwbfan Posted 21 Mar 2011 , 3:09pm
post #23 of 41

Okay, I've emailed two copies out; waiting to hear if they like it or that it will come in handy. icon_smile.gif

SamanthasCakes Posted 21 Mar 2011 , 3:20pm
post #24 of 41

Hiya all
Great site, new but please can i have a copy of your pricing guide.

Thank you x

keriofcakes Posted 21 Mar 2011 , 3:35pm
post #25 of 41

Hi! I would love if you could send me a copy as well..if you don't mind sending another PM icon_biggrin.gif Thank you soo much in advance!!

alvarezmom Posted 21 Mar 2011 , 3:40pm
post #26 of 41

Sounds great. The other spread sheets are to much for me!

usmdesigner Posted 21 Mar 2011 , 3:51pm
post #27 of 41

I'm not sure if this is the same one you modified, but it was posted on CC.

http://cakecentral.com/cake-decorating-ftopic-80371-0-days0-orderasc-.html

About the 5th or 6th post down.

I was actually looking over it this weekend and was going modify it myself. Of course you have to modify it on your own due to the fact not everyone's prices are the same in the grocery store. Also the quantities are most likely different as well than what you buy.

For example: This formula uses a 30 egg formula, while I buy cartons of 18. Therefore that is one thing I would have to modify.

You can also google, cake pricematrix if you need to.

alvarezmom Posted 21 Mar 2011 , 3:58pm
post #28 of 41

EASY EASY EASY!!!! Lovely spreadsheet! And it's not at all complicated!

sccandwbfan Posted 21 Mar 2011 , 4:29pm
post #29 of 41

To this that I first sent my email out ot: I forgot to unprotect the Rolled fondant basic butter cream and cream cheese cells so that they could be updated with your prices. If you don't know how to do this, email me back and I will send an updated version to you.

Annabakescakes Posted 21 Mar 2011 , 4:30pm
post #30 of 41

I would seriously try to get it to google docs and get this thread locked! I have seen it happen in the past where hundreds of people request something to be emailed to them for years on end! Awful!

Quote by @%username% on %date%

%body%