Julianne's Ultimate Cake Pricing Matrix

Business By abccupcakes Updated 8 Mar 2013 , 4:28pm by cloetzu

abccupcakes Posted 17 Jul 2011 , 1:39am

Dear Fellow cake Decorators
I just finished putting together a cake Matrix on Excel. It took me many months to put together so I am hoping this will help you save some time.

Download it on my website www.abccupcakes.net/matrix.html

Hope it helps!

Keep on caking!
-Julianne

24 replies

abccupcakes Posted 17 Jul 2011 , 1:06pm

post #2 of 25

Please let me know what you think! I can also help you if you've had any issues with the program.

JessiesCreations Posted 17 Jul 2011 , 1:18pm

post #3 of 25

Thank you, I will try it out today.

cole10 Posted 17 Jul 2011 , 1:36pm

post #4 of 25

Me too! Thanks!

ShaunPepe Posted 18 Jul 2011 , 11:30am

post #5 of 25

I only played around with it for a couple minutes, but I could not figure out how to input multiple tiers for a wedding cake. Maybe I need to take a longer look.

jennajane Posted 18 Jul 2011 , 8:33pm

post #6 of 25

Thanks for this Julianne. I took a look at it today and then spent most of the afternoon adding some tweaks. All in the goal to price out the 2 tiered blue cake in my gallery. I added an easy way to do up to 3 tiers and different flavors of cakes. $36 with organic fair trade chocolate, not too bad. I donated the cake, so it was all loss, but I got two other contracts from the donation so for. The total is still calculated with the multiplier factor like you did, but the math could easily be tweaked so you just enter a price per serving, then determine the profit (including labor). Anyway just thought I would share my changes since you were so kind to share the work you did.

Jenna Pricing Matrix

Jenna

abccupcakes Posted 19 Jul 2011 , 11:53am

post #7 of 25

I'll make a few changes and repost later this afternoon.

bobwonderbuns Posted 19 Jul 2011 , 12:39pm

post #8 of 25

Can it take into consideration specialty items such as gumpaste flowers and things like that?

abccupcakes Posted 19 Jul 2011 , 1:43pm

post #9 of 25

You sure can! Check the EXTRAS part and adapt it to your needs.

Lenette Posted 19 Jul 2011 , 1:52pm

post #10 of 25

I haven't looked at it yet but I wanted to thank you for being so generous. Sharing this is a very kind and thoughtful thing to do!

VaBelle Posted 19 Jul 2011 , 2:06pm

post #11 of 25

Thanks for sharing! I can't wait to take a better look at it.

abCakes1 Posted 19 Jul 2011 , 2:20pm

post #12 of 25

Thank you so much for sharing!!! I've been looking for pricing information, and this just came at the perfect time. I've only been doing cakes for family and friends, but I've been asked to sell them, and had no idea where to start. Thank you!!!

jennajane Posted 19 Jul 2011 , 6:34pm

post #13 of 25

Quote:

Originally Posted by jennajane

Thanks for this Julianne. I took a look at it today and then spent most of the afternoon adding some tweaks. All in the goal to price out the 2 tiered blue cake in my gallery. I added an easy way to do up to 3 tiers and different flavors of cakes. $36 with organic fair trade chocolate, not too bad. I donated the cake, so it was all loss, but I got two other contracts from the donation so for. The total is still calculated with the multiplier factor like you did, but the math could easily be tweaked so you just enter a price per serving, then determine the profit (including labor). Anyway just thought I would share my changes since you were so kind to share the work you did.

Jenna Pricing Matrix

Jenna

I found a error in how the costs were summed...fixed, and added the carrot cake recipe I made last night (found here) with costs. I am still missing the price of a few ingredients, but my carrot cupcakes with cream cheese frosting was about $0.45 each in costs. Thanks again Julianne for starting this, I have been looking for a good way to do this for a while.

SadEyes Posted 19 Jul 2011 , 6:46pm

post #14 of 25

Thank you very much for sharing

towenby1 Posted 19 Jul 2011 , 6:49pm

post #15 of 25

wonderful tool. This took a lot of work and thought. Thank you very much.

imagenthatnj Posted 19 Jul 2011 , 6:50pm

post #16 of 25

So, Jenna, did you update? Do I have to download again?

Thank you to both of you.

jennajane Posted 19 Jul 2011 , 6:59pm

post #17 of 25

Quote:

Originally Posted by imagenthatnj

So, Jenna, did you update? Do I have to download again?

Thank you to both of you.

Ya, I just found the adding error and added a new recipe and some of the ingredients I used for it. Just download the link again, it should be filled out for 24 carrot cupcakes.

I would be interested in what people think of the table I made for the amounts of frosting and filling I made for the different cake sizes. Most of this was based on 1/4" of thickness, then based on some algebra converted to volume in cups.

TerriLynn Posted 19 Jul 2011 , 7:08pm

post #18 of 25

Thanks, everyone. What an awesome reference tool! It is so kind of you to share.

jenscreativity Posted 19 Jul 2011 , 7:16pm

post #19 of 25

THIS IS AWESOME! Thank you for putting this together for us to ease our cake lives!

swanson1436 Posted 6 Aug 2011 , 3:24am

post #20 of 25

Thank you very much for posting. I am just starting out making cakes for people and had no idea what to charge or really where to start with the charging. It's an awesome tool. THANK YOU

angeloscakes Posted 6 Aug 2011 , 4:44pm

post #21 of 25

Thank you for sharing

o0zappy0o Posted 21 Nov 2012 , 1:39pm

post #22 of 25

I clicked on the link and I get an error :-(