Alice's pricing matrix

Hi

Does anyone maybe have Alice’s cake pricing matrix or know where I can download it? It is supposed to be a free sheet to help with calculating cake prices.

Thanks.

Cakes by lili --- Bloemfontein, South Africa

6,736 views

24 0
Share Tweet
Follow

24 Replies

Sarah ...

Hi lili,
Give this link a try:
http://cakecentral.com/cake-decorating-ftopic-148801-75.html

Version “S” is the one that I work from, but there may be another updated one out there. This one works just fine for me though. As long as you have Excel you will be just fine. Good luck! :)

Lize van den Heever ...

Thanks :-)

Brittany ...

Hello. I am having trouble understanding the Matrix??? [confused look] Maybe I rushed through it, but there were so many columns and information, my mind couldnt process it at a glance, lol. I’m going to go back and view it and REALLY look at it and dissect it. Thanks alot for the link

Karen MacFadyen ...

I am in the process of making a less confused one! I have one which is a cake portion guide, another which is ingredients costings which works out the prices automatically and I am working on one that tracks time input too.
I agree – my mind just went blank trying to process all the information contained on the one sheet, so am setting about to simplify!

CrystalMemories ...

Oh…that sounds good, Karen….let us know when its up & running :)

Lize van den Heever ...

That sounds great, Karen! I tried to make sense of Alice’s one as well, since I mainly want to use the ingredients costing, but it just has so many variables, and then I was also trying to update it to metric (I am in South Africa), but I just gave up after a couple of hours.

I am sure there are a lot of us who would greatly appreciate a simplified sheet, if you would be willing to share all your hard work!

Brittany ...

Thanks Karen! Keep us posted on how it turns out

Karen MacFadyen ...

OK – so I am in London UK – and we can weigh in both ounces and grams. Could someone please give me a lesson as to what ‘cups’ are all about? If I can get this sheet to work for each kind of measurement – without being massively confusing, I am guessing this would help! So first is there a standard cup size? And is this USA and Canada that weigh in cups, and UK in grams (and in England using an older recipe it might be in ounces and lbs) Let me know. Cheers,

Lize van den Heever ...

Hi Karen. A cup is usually 250 millilitres, (ml), no matter the weight.

Karen MacFadyen ...

Thanks for that. OK another question then – litres measure water and fluid. Do you use cups to measure flour?

Karen MacFadyen ...

So in my store cupboard – in London UK everything is in grams or in ml (if it is a fluid) Only the pickled onions – onions in vinegar – are different only because they have a weight and then a drained weight. So need to get to grips with all the differing ways of weighing outside UK. What do your recipes normally quote as a measurement. We have grams and ml. (Rarely use the word cup) Let me know how you measure butter, flour, sugar dried fruit etc. It would really help me. Cheers, K

Lize van den Heever ...

I am in South Africa, and we mostly use grams and ml for measurement too. The cups (and teaspoon/tablespoon) is just a more “informal” way of measuring I think – it all depends on what your recipe uses. But for butter (unless melted) and dried fruit, etc. weighing will obviously be more accurate. I think weighing is probably the most accurate way of measuring in any case, as long as you have a good (electronic?) scale, especially for baking, although I grew up with using cups in many recipes (especially hand-me-downs) as well. If you are not sure about conversions (i.e. your recipe specifies cups/tablespoons and you want grams/mls), I find that doing a quick search on Google usually gives many conversions – sometimes this is just easier than for instance measuring out 8 tablespoons of something. This is also handy for finding out how many grams of a specific item is in a cup for instance, since it will differ between flour, sugar, etc.

Prima Cakes Plus ...

Karen,
Here in the US we use cups/tablespoons/teaspoons to measure dry or wet ingredients. Now that is not to say that we don’t weight our ingredients too. It all depends on the recipe I guess.

An example a lot of my recipes say 1cup of butter which equals 2 sticks.

Hopefully that explains some of it.

mydearbakes ...

This is very useful! I really hard a tough time finding a good pricing matrix. Alice’s seem to be a very robust one. Now to find time to understand how the entire spreadsheet works ^^

Karen MacFadyen ...

Tell me about butter then – what weight is on the pack that you buy from the store. We do not have butter in sticks in UK. We have sticks of celery and that is about it!!! My simpler pricing matric nearly ready – just having it checked over to make sure it all works – and will let you know.