Cake Central › Cake Forums › Cake Talk › Cake Decorating Business › Alice's Cake Pricing Matrix
New Posts  All Forums:Forum Nav:

Alice's Cake Pricing Matrix - Page 9  

post #121 of 173
I added a new link to the matrix. It should work now.
post #122 of 173
THANK U.....so much....i will take a look at it and figure it out.
post #123 of 173
Thank you for taking so much time to do this and especially for sharing!
post #124 of 173
To Irene and all who want scratch conversions - I have done a few that I have listed below. Converting ingredients is a little harder than liquids because 8oz of weight doesn't always (or ever) equal 1 cup. I found a good link at http://www.onlineconversion.com/weight_volume_cooking.htm. What is nice about this site as compared to others I looked at, is that it has lots of ingredients, and converts both US and UK measures - whichever you prefer.

Here is the way you use it to do conversions for the matrix: For example let's do all purpose flour. In the top box you select your ingredient - so choose flour, US, all purpose. In the next box you put the quantity you want and in the From This box, the weight you want - I buy 5 pounds so 5 goes in quantity and pounds in the From this box. Then in the To this box I select cups [US] and hit recalculate. In the bottom box you get 5lb=22.824 cups. Then divide 22.824 by the 5 and you get 4.56 which is the conversion factor for the matrix.

So here's a few I did
5 lbs AP flour to cups = 4.56
5 lbs granulated sugar to cups = 2.366
2 lbs brown sugar to cups = 2.27
2 lbs confectioners sugar [aka powdered, aka icing] to cups = 3.48
1 lb butter to cups = 2
1 lb butter to tablespoons = 32

Another note: if you are converting large quantity to small [like cup to tsp] then conversion factor should be GREATER than 0. If you are converting small to large [like cup to pound] then conversion factor should be LESS than 0.

Hope this helps - it seems complex but this will give you best answers for non liquid ingredients (sorry - I was a science major in college icon_rolleyes.gif ) Make sure you put in the quantities you buy - you can ignore the density section - it's not necessary unless you have the densities for your ingredients (now that's a REAL science geek)!!!
post #125 of 173
This is amazing! I'm not that savvy in using Excel outside of just basic formulas and you did suchh an awesome job!!! THANK YOU SO MUCH for sharing! I'm downloading, saving, etc etc...WOW.
chocoholic, cake designer, and wanna be pastry master
chocoholic, cake designer, and wanna be pastry master
post #126 of 173
Links are not working for these downloads. Does n e one know why? Is there another place I can go to get the latest version of the matrix?
I don't suffer from insanity....I enjoy every minute of it!
I don't suffer from insanity....I enjoy every minute of it!
post #127 of 173
I get a 404 error pop up when I try to click on this.
post #128 of 173
I'm not able to download this either, but I'd LOVE to!! Anyone have a way to get it??
post #129 of 173
I'm not able to download the matrix either. Could someone e-mail it to me Stacey(mod edited.) Thanks.
post #130 of 173
unable to download the latest matrix. what should i do? my email is (mod edited.) if anyone could email it to me. thanks so much
post #131 of 173
Can I please get a copy as well. I can't download either

(mod edited.)
post #132 of 173
Just a quick question, do you use this pricing for all cakes or just wedding cakes? I make a lot of birthday and other special occasion cakes and I am having a hard time figuring out how much to charge.
Thanks
post #133 of 173
I can't seem to access the file either. Could I also get it sent to my email?

(mod edited.)

Thanks!
"Yesterday was but a dream, and tomorrow is only a vision.
But today, well lived, makes every yesterday a dream of happiness
and every tomorrow a vision of hope."
"Yesterday was but a dream, and tomorrow is only a vision.
But today, well lived, makes every yesterday a dream of happiness
and every tomorrow a vision of hope."
post #134 of 173
I'm not able to download either! Please e-mail with attachment, (mod edited.)

Thank you so much for your help!
post #135 of 173
I would like this excel file alsoicon_smile.gif Please send it (mod edited.) Thank you for your help thumbs_up.gif
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Cake Decorating Business
This thread is locked  
Cake Central › Cake Forums › Cake Talk › Cake Decorating Business › Alice's Cake Pricing Matrix