Home & Hobby Cake Matrix

Decorating By loriana Updated 12 Mar 2009 , 3:34am by kellertur

loriana Posted 23 Feb 2009 , 4:41pm
post #1 of 21

Hi Folks!

I've recently been getting lots of requests for the Home and Hobby Cake Matrix that I made, based on Alice Keeler's original matrix for business use.

This matrix will help you:

-Determine cake sizes based on design, number of servings needed
-Help determine correct pricing
-Organize and price based on your recipes and/or mixes
-Gumpaste, fondant and other costs
-Invoicing for home and hobby (not for professionals but the occasional and/or home baker).

Note: Thing NOT included in factoring are some things Alice had in the original professional matrix:
-Electricity costs
-Labor costs
-Other business costs (licensing, equipment, etc)

Attached is the Matrix. You will need to have Microsoft Excel 97' or newer to use the matrix. Instructions are on the front page. Hope it is helpful to you!

Lisa (Loriana)

20 replies
Rocketgirl899 Posted 24 Feb 2009 , 1:58am
post #2 of 21

i use my own that I made.. but yours is super detailed icon_biggrin.gif thanks for sharing!

kake4me2 Posted 24 Feb 2009 , 2:06am
post #3 of 21

You have saved me a ton of time with this. Thanks for sharing this great tool!!!!!

mommy_of_3_DDs Posted 24 Feb 2009 , 2:11am
post #4 of 21

WOW This is wonderful!

saramachen Posted 24 Feb 2009 , 2:35am
post #5 of 21

Thanks for sharing - that's a fantastic spreadsheet.

gscout73 Posted 24 Feb 2009 , 2:55am
post #6 of 21

icon_eek.gif Wow, this is great. thank you for sharing. It is exactly what I need. I've learned so much from the pros here on this site.

bobwonderbuns Posted 24 Feb 2009 , 3:07am
post #7 of 21

Thanks for sharing!! icon_biggrin.gif

bizatchgirl Posted 24 Feb 2009 , 3:52am
post #8 of 21

Wow, it's amazing. I love it. Can't wait to use it.

loriana Posted 24 Feb 2009 , 6:29pm
post #9 of 21

I'm so glad it is helping icon_biggrin.gif Yell if you need help!

kellertur Posted 24 Feb 2009 , 6:34pm
post #10 of 21

Can this be used by scratch bakers? icon_smile.gif

loriana Posted 24 Feb 2009 , 6:40pm
post #11 of 21

It sure can. It's actually pretty handy for scratch bakers. The recipe workbook allows you to input the ingredients, amounts and calculate cost per recipe based on your input. For example:

4 cups cake flour @ $.50 per cup X 4 cups = $2.00
3 eggs @ 2.00 per 12 eggs = $.50


so you know the cost per recipe and it will automatically use the data to figure out the cost for, say 25 servings once you enter the necessary data like how many people your recipe feeds.

kellertur Posted 25 Feb 2009 , 1:17am
post #12 of 21

Thank you!! icon_smile.gif

I saved it to my computer and I've tried to enter my info, but my keystrokes don't seem to register. (is this on my end?)
I started with the cake page, and tried entering into the Orange on the left, but it won't work for me. I also went to Recipe page and tried entering a scratch recipe, but same thing. icon_confused.gif

Do you know if I'm missing a step? Sorry...you are very nice to share this.

loriana Posted 25 Feb 2009 , 2:37pm
post #13 of 21

Hi K2,

Hmmm... I'm not sure. Do you have your number lock on? That could be it. It isnt a locked spreadsheet although you are only allowed to type in the colored boxes, the rest are set with automatic functions, etc...

Also try saving the spreadsheet to your hard drive. It's possible you were trying to type in it from the download itself. I would save the spreadsheet and open it from your computer. If you still have trouble, let me know!

kellertur Posted 25 Feb 2009 , 6:11pm
post #14 of 21

Thanks, I'll try that.

I have to ask you this... in your avatar: is that a cheese grater at the end of the slide, or is it my eyes? icon_confused.gif For some reason, it struck me as hilarious. It's a cute pic either way. icon_smile.gif

mashmellow Posted 25 Feb 2009 , 6:21pm
post #15 of 21

Thank you so much I realy needed somethng like this GBY

loriana Posted 25 Feb 2009 , 6:27pm
post #16 of 21
Originally Posted by K2cakes

Thanks, I'll try that.

I have to ask you this... in your avatar: is that a cheese grater at the end of the slide, or is it my eyes? icon_confused.gif For some reason, it struck me as hilarious. It's a cute pic either way. icon_smile.gif

It IS a cheese grater. I have a sick sense of humor icon_wink.gif

When I first saw that picture, I thought it was hilarious!

kellertur Posted 25 Feb 2009 , 7:07pm
post #17 of 21

I think you and I will get along JUST fine... icon_wink.gif

dezzib27 Posted 4 Mar 2009 , 2:56am
post #18 of 21

I totally love this spreadsheet, much simpler for me to use, but I may be retarded when I ask, where is the formula for square cakes under the Master Cake Planner on the Cakes tab? The majority of my cakes at this point are square and round. HELP!!

loriana Posted 4 Mar 2009 , 7:14pm
post #19 of 21

You are SOOOO not icon_biggrin.gif

Row 53 on the "cakes" tab should say Square and not "Embossed Heart" then square.

The heart shape is above it. Row 53 is all about square cakes. Hope this helps and sorry for the confusion. I need to make a change and say Woopsie! Thanks for catching it!

dezzib27 Posted 12 Mar 2009 , 3:25am
post #20 of 21

Thank you!!!!

kellertur Posted 12 Mar 2009 , 3:34am
post #21 of 21

icon_cry.gif I still can't change anything on my end... Do you have to "purchase" Quattro eventhough it's on my computer? It won't let me do anything new, even outside of that Mattrix. icon_cry.gif

aaaaaaaaahhhhhhhhhhhhhhhhhhhhhh icon_cry.gif
(not directed at you, I just need to let out a primal scream... I feel better) icon_smile.gif

Quote by @%username% on %date%