Julianne's Ultimate Cake Pricing Matrix Update

Business By abccupcakes Updated 19 May 2015 , 6:31pm by SandraDee73

abccupcakes Posted 23 Nov 2012 , 10:02pm
post #1 of 58


I've been working on upgrading my matrix and thought I would share.

Feel free to make the changes you need.

You can also e-mail me with questions if you have any [email protected]

I use it with excel 2010 let me know if some parts don't work for you.




57 replies
mydearbakes Posted 26 Nov 2012 , 9:59am
post #2 of 58

Another great price matrix! Thanks for sharing! Going to try it out =)

simpliterrific Posted 30 Jan 2013 , 2:14pm
post #3 of 58

this is awesome!!!! this helps me so much

jstamoore Posted 30 Jan 2013 , 2:32pm
post #4 of 58

Thanks for sharing!

KikisCakery Posted 23 Feb 2013 , 8:51pm
post #5 of 58

This is amazing! Thanks for sharing.

cjett Posted 26 Feb 2013 , 2:32pm
post #6 of 58

Thank You!!! Very user friendly

crustdust Posted 26 Feb 2013 , 2:53pm
post #7 of 58

AThank you!!

Crazy-Gray Posted 26 Feb 2013 , 4:18pm
post #8 of 58

This is a lovely spreadsheet thank you! It must  have taken you ages to fine tune it so well!


It took me a minute to work out your servings; they’re 1-and-a-half inch by 2 inch servings right?


It might be neat to add a little conditional formatting on your portion/pan guide section that will highlight what pans people could use for the servings they are pricing for;


This is how I would to it:

You would need to add conditional formatting for each of your pan serving numbers (N33 to N42, P33:41 and R33:36)

To highlights the pan serving number if it is equal to, or up to 10 servings more than, the number of servings in C6:

   Go to conditional formatting, ‘choose highlight if between’, for the first value choose C6 and for the second value write C6+10


Set your highlight however you like :)


Great job though!! :)

AndiDawn Posted 26 Feb 2013 , 9:10pm
post #9 of 58

This is great!  This confirms my thought that I am to cheap!  Thanks

rocco90046 Posted 26 Feb 2013 , 9:15pm
post #10 of 58

You are a lifes saver, thanks for sharing.  I noticed you don't have the cost of labor for decorating on your matrix.  The price list i have always followed for wedding cakes is 3.00 a slice and 30.00/hour for decorating.  That was the basic formula I got from culinary school. Would be interested in your input on that formula. Thanks again for sharing your matrix. 


Rocco Camarillo

DaCakeDiva Posted 26 Feb 2013 , 9:17pm
post #11 of 58

AOkay is this the one for math dummies cause if so I need the tutorial. Numbers make sleepy. Can you make one for me and pretend I'm 4. Lol

dmchagaris Posted 26 Feb 2013 , 9:19pm
post #12 of 58

WOW - thank you so much. This is exactly what I needed.

renaeheineck Posted 26 Feb 2013 , 9:43pm
post #13 of 58

The spreadsheet downloaded, but was distorted, would you please email it as an attachment to [email protected] Thanks, hopefully it will come better formatted. I'm sure it has something to do with two different versions of Excell.

Heatherly30 Posted 26 Feb 2013 , 9:51pm
post #14 of 58

This is awesome, amazing!!  I was going to ask what formula you use to determine your cost per serving, and then I saw the second tab in the spreadsheet.  I assume I can edit those fields too.  I'm fascinated!!

pastrycutie75 Posted 26 Feb 2013 , 10:20pm
post #15 of 58

You are an absolute life saver!!!!!!!!!

Mamabakescakes Posted 26 Feb 2013 , 10:34pm
post #16 of 58

Looks great. Thank you for  sharing.  


Am I supposed to be able to change the purple cells?  I'm using a mac and don't have excel.  Any one know if I can use this?

vcheddar Posted 26 Feb 2013 , 10:35pm
post #17 of 58

Thank you so much for sharing! I had no idea how to figure out the cost, and although I don't bake for a living, every now and then I am asked to make one.

vcheddar Posted 26 Feb 2013 , 10:37pm
post #18 of 58
Originally Posted by Mamabakescakes 

Looks great. Thank you for  sharing.  


Am I supposed to be able to change the purple cells?  I'm using a mac and don't have excel.  Any one know if I can use this?

I think you will probably need to get excel or a program that can read and manipulate excel files.  Each cell has formulas that will automatically update the price, etc.  This is for PC, but I am sure macs can read pc files these days assuming you have the correct program to run it. good luck

lucy74 Posted 26 Feb 2013 , 10:57pm
post #19 of 58

thank you.

ManuelaMM Posted 26 Feb 2013 , 11:10pm
post #20 of 58

Thank you for sharing it with us.  Very appreciated.

Bzc8lda Posted 26 Feb 2013 , 11:39pm
post #21 of 58

Oh Wow!!! Thank you, this is a good guide. I been charging too little. :(

kchun Posted 27 Feb 2013 , 1:13am
post #22 of 58

Thanks for posting. This matrix is amazing! you just made my life SO much easier lol

BakinWithBarbie Posted 27 Feb 2013 , 1:28am
post #23 of 58

This is amazing!! Saving for the future!! icon_biggrin.gif Thanks!! 

latoft Posted 27 Feb 2013 , 2:38am
post #24 of 58

Brilliant!  Thank you!!

bakedindy Posted 27 Feb 2013 , 3:10am
post #25 of 58

Thank you!  This is going to be so useful.  I'm just a hobbyist at home caker.  I sell some cakes, like maybe 2 a month and love it.  Pricing is always a tough one for me, so this will help a lot.  Thanks so much!!

krez Posted 27 Feb 2013 , 4:51am
post #26 of 58

thanks so much this is very helpful

plcharles Posted 27 Feb 2013 , 4:56am
post #27 of 58

Thank you for sharing!

cakefat Posted 27 Feb 2013 , 8:59am
post #28 of 58

For the Mac user- you just need Excel software installed on your computer. Macs can read files made by PCs...but you do need that software..just like you would if  you had a PC too.


I use a Mac too and there are not any issues at all in opening/using the price matrix excel file (I do have excel installed).


OP- thank you for the spreadsheet! That is fantastic!

Mamabakescakes Posted 27 Feb 2013 , 1:12pm
post #29 of 58

thank you.

Tisha1117 Posted 27 Feb 2013 , 2:13pm
post #30 of 58

thaaaaaaaaank you for posting!

Quote by @%username% on %date%