## Alice's Cake Pricing Matrix

By alicegop Updated 22 Jun 2016 , 4:13pm by mabv812

CarolAnn Posted 18 May 2007 , 2:23pm
post #31 of 175

Alice, You're a dear to do this and a genius! Ü Boy, the time you're putting into this. Wow, thanks so much! I'll be studying it too. Looks like just what I've been needing AND everything I didn't know I needed.

Thanks again,
Carol

anatmb Posted 6 Jun 2007 , 4:34pm
post #32 of 175

WOW, WOW, WOW!!!

You did an amazing job!!!
I am still studying the matrix and trying to figure out what everything means, but it seems quite incredible.

Well done!

Anat

randipanda Posted 6 Jun 2007 , 11:26pm
post #33 of 175

Alice can you help me? I'm not understanding the Unit Conversion cells in the Cake and Frosting and Filling Recipes tabs. Or what each of the headings mean where you actually put in the recipes. Item would be what you buy obviuosly, the ingredient, is item amount the amount you usuallly buy it in? 18 eggs, 1 gallon of milk, etc? Then the unit amount is who much the recipe actually needs right? But then the unit conversion has me stumped. From your formula it looks like it is figureing how many sets of 2 Tablespoons you can get from a gallon for instance.., right? I think that makes the most sense and works for almost all of the amounts...the one that throws me is you say that there are 2 T per oz of meringue powder and 6 t per oz of vanilla but a T is worth three t, but I guess we are talking weight vs. volume there. Ounces are so hard for me to understand. I have recipes that call for 5 oz of glucose or such of making fondant and I don't know if I should go by weight or volume...ahhhh

Sorry, just making sure I understand

randipanda Posted 6 Jun 2007 , 11:29pm
post #34 of 175

Sorry, I forgot to mention how much I love this worksheet. I don't know that I will use it for pricing exactly right now, but more to help me get in the ball park of what I could/should be charging. Gives me a ballpark. I was telling my husband that he was supposed to do a summer project to make me something like this. And here we are a month into his summer break and he hasn't started! you just saved him alot of work!!

Thanks again!

OhMyGoodies Posted 6 Jun 2007 , 11:43pm
post #35 of 175

I guess you actually need to enter you Excell product key to be able to edit anything in this file huh? lol I have an excell disc but I don't have it installed on my laptop because I don't know how to use it yet lol... so is that why I can't edit any of the information in the blue boxes?

moxey2000 Posted 6 Jun 2007 , 11:48pm
post #36 of 175

Along with all of the others....Thank you!

You are awesome for sharing this with everyone.

Sweetcakes23 Posted 7 Jun 2007 , 12:35am
post #37 of 175

Just letting you know we are all watching and learning from this, I'm just following all the updates! I feel a bit technically challenged, but am still learning. Thanks for all your work!

alicegop Posted 7 Jun 2007 , 3:58pm
post #38 of 175

Okay, I put the guide to cake matrix R on my website so if you go to http://www.selfservebaker.com/guide.pps you can get the powerpoint.

alicegop Posted 7 Jun 2007 , 4:02pm
post #39 of 175
Quote:
Originally Posted by randipanda

Alice can you help me? I'm not understanding the Unit Conversion cells in the Cake and Frosting and Filling Recipes tabs. Or what each of the headings mean where you actually put in the recipes. Item would be what you buy obviuosly, the ingredient, is item amount the amount you usuallly buy it in? 18 eggs, 1 gallon of milk, etc? Then the unit amount is who much the recipe actually needs right? But then the unit conversion has me stumped. From your formula it looks like it is figureing how many sets of 2 Tablespoons you can get from a gallon for instance.., right? I think that makes the most sense and works for almost all of the amounts...the one that throws me is you say that there are 2 T per oz of and 6 t per oz of vanilla but a T is worth three t, but I guess we are talking weight vs. volume there. Ounces are so hard for me to understand. I have recipes that call for 5 oz of or such of making fondant and I don't know if I should go by weight or volume...ahhhh

Sorry, just making sure I understand

Usually I go to www.ask.com and type in what I am converting to get the unit conversions. Unit conversions SHOULD be if I buy pounds but my recipe calls for tablespoons how to convert from pounds to tablespoons....

Yes on the weight vs. volume... that is why they are different.

mrsw Posted 7 Jun 2007 , 4:08pm
post #40 of 175

thank you so much for putting this together and sharing it with us. A definite save for me.

oneprimalscream Posted 7 Jun 2007 , 4:11pm
post #41 of 175

Thanks, Alice!

rits Posted 7 Jun 2007 , 11:01pm
post #42 of 175

This is truly a work of art! I am going to try to tweak it in my free time (ha ha!, it's wedding season!!) for people who don't use cake mixes...thank you again for sharing this - I'm sure it took you a gazillion hours to develop it.

rits Posted 7 Jun 2007 , 11:11pm
post #43 of 175

ok, uh DUH, it looks like you already have a way to do that (see my post above re: adding our own recipes), so DOUBLE thanks!

rikley Posted 8 Jun 2007 , 5:29pm
post #44 of 175

THANK YOU SO MUCH FOR DOING THIS!!! YOU'VE MENTIONED THINGS I HADNT EVEN THOUGHT OF!! I AM GOING TO STUDY THIS AND UTILIZE IT!!! THANK YOU!!!!!!

pumpkinroses Posted 13 Jun 2007 , 1:35am
post #45 of 175

Again thank you so much.

naz1905 Posted 20 Jun 2007 , 10:22am
post #46 of 175

Hi all!! Just dowloaded version R, Alice how can i ever thank you enough! It's a wonder work! I applaud you and hope to be able to use it soon! Still studying and reading instrutions. Will in no doubt be a helpful asset! Just wantedc to ask though, i notice that you have the cake mix in the recipes, I the uk we don't use cake mixes rather from scratch so how do i put these in there? I have to say that i have never used an excell sheet before!

Thaks a lot!

DecorateMe Posted 3 Jul 2007 , 8:46am
post #47 of 175

Wow, you just saved me HOURS of work!! I was wondering how I could adjust the chart so that it's metric. I use grams and kilograms and am not sure where to change what.
Thanks

MandysCakeandCandy Posted 3 Jul 2007 , 6:14pm
post #48 of 175

How can i get this cake matrix?

cakebaker1957 Posted 3 Jul 2007 , 6:21pm
post #49 of 175
Quote:
Originally Posted by MandysCakeandCandy

How can i get this cake matrix?

i would like to know also, Thanks

kcjc Posted 3 Jul 2007 , 6:30pm
post #50 of 175

If you go to the beginning of the thread you will see it.
Thank you so much Alice I'm also new. I downloaded it a few days ago...I'm studying it but it is also helping me to understand all that is involved & how we can justify our pricing. I so appreciate this.
kcjc-Karen

jnestor Posted 7 Jul 2007 , 4:39pm
post #51 of 175

Thank you, thank you, thank you!!! I was so lost, and your spreadsheet has really helped. I am proficient in Excel, but would have never been able to put together what you've done. Thanks again!!

kackie3 Posted 10 Jul 2007 , 6:36am
post #52 of 175

alicegop Posted 19 Jul 2007 , 4:27am
post #53 of 175
Quote:
Originally Posted by naz1905

Hi all!! Just dowloaded version R, Alice how can i ever thank you enough! It's a wonder work! I applaud you and hope to be able to use it soon! Still studying and reading instrutions. Will in no doubt be a helpful asset! Just wantedc to ask though, i notice that you have the cake mix in the recipes, I the uk we don't use cake mixes rather from scratch so how do i put these in there? I have to say that i have never used an excell sheet before!

Thaks a lot!

There is a cake recipes tab, you can put your recipes in there, they don't have to be cake mix

Someone asked about converting measurements... there are a lot of places where units are put in..... it might be a big task to convert to metric. I don't ever use metric so while I am sure that I COULD do it (math teacher... would be embarrassing if I couldn't) I would have to check every cell of the spreadsheet to see if any of my formulas are using non metric conversions...

The matrix took me over a year to get to the stage it is in right now where I worked on it for hours each day. I really enjoy using excel!

nanc Posted 24 Jul 2007 , 4:50pm
post #54 of 175

Wow this spreadsheet is awesome! Thank you so much. I am a full time accountant and, granted I haven't been decorating cakes that long, I wouldn't have been able to come up with this in such detail.
Great work!

joeycakes Posted 26 Jul 2007 , 2:43pm
post #55 of 175

Alice! This is great - I love it! Thank you soooooo much for sharing with everyone!

marquesha613 Posted 27 Jul 2007 , 10:28pm
post #56 of 175

Hi Alice,
I would like to join everyone else by saying "thank you" for the pricing matrix . I have a question /problem though. I'm not very good with excel.I needed to add a few rows on the basic price sheet for cake boards.It calculated all the way over until I got to the blue cell asking how much was used.How do I adjust the formula or format, so it will work all the way across to the yellow column where it adds the total with sales tax included?

SugarMoonCakeCo Posted 5 Aug 2007 , 2:42pm
post #57 of 175

THANK YOU THANK YOU THANK YOU!!!

but now i have a question...

version R

when i am putting in my layers - i'm confussed - i use three 1.5x8" round pans and my ONE layer is composed of 3 layers of cake (one batch of scratch) - what do i enter under 8? one layer with 2 tortes or 3 layers with no tortes? also, if i ice in buttercream but do decorating in fondant, is there enough being charged if i just put "extra decorations yes" or do i need to add that in the "extras" tab?

i'm trying to price out my first "chargable" cake and still it's a little confussing...and i need to give her a price by the end of the weekend!

this is a FABULOUS little gem though!

mcook1670 Posted 24 Aug 2007 , 1:35am
post #58 of 175

I'm new to cake decorating and I found the pricing martix and it looks great... I have a few questions about pricing though. In the charges section..what is a normal price to charge for fondant, butter cream and fillings? any help would certainly be appreciated

jmcooley Posted 27 Aug 2007 , 1:37pm
post #59 of 175

Thank you so so much for sharing. This is such a time saver.

hwhite0131 Posted 11 Sep 2007 , 12:07am
post #60 of 175

Thank you for posting this!! I do have one question if anyone has time to answer it. Do you all include taxes on the products used for example cake mixes, etc.? Thanks in advance!

Heather