## Julianne's Ultimate Cake Pricing Matrix

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

abccupcakes Posted 17 Jul 2011 , 1:39am
post #1 of 25

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.

Hope it helps!

Keep on caking!
-Julianne

24 replies
abccupcakes Posted 17 Jul 2011 , 1:06pm
post #2 of 25

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

Thank you to both of you.

jennajane Posted 19 Jul 2011 , 6:59pm
post #17 of 25
Quote:
Originally Posted by imagenthatnj

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 :-(

mydearbakes Posted 22 Nov 2012 , 12:05pm
post #23 of 25

I've tried and it works =)

caferock05 Posted 30 Dec 2012 , 6:59pm
post #24 of 25

Thank you for sharing!

cloetzu Posted 8 Mar 2013 , 4:28pm
post #25 of 25

This link doesnt' seem to work ;(  is there an updated one?