Julianne's Ultimate Cake Pricing Matrix Update

Business By abccupcakes Updated 22 Apr 2017 , 3:13pm by sistersvillesweets

abccupcakes Cake Central Cake Decorator Profile
abccupcakes Posted 23 Nov 2012 , 10:02pm
post #1 of 59

Hi,

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.

 

 

 

58 replies
mydearbakes Cake Central Cake Decorator Profile
mydearbakes Posted 26 Nov 2012 , 9:59am
post #2 of 59

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

simpliterrific Cake Central Cake Decorator Profile
simpliterrific Posted 30 Jan 2013 , 2:14pm
post #3 of 59

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

jstamoore Cake Central Cake Decorator Profile
jstamoore Posted 30 Jan 2013 , 2:32pm
post #4 of 59

Thanks for sharing!

KikisCakery Cake Central Cake Decorator Profile
KikisCakery Posted 23 Feb 2013 , 8:51pm
post #5 of 59

This is amazing! Thanks for sharing.
 

cjett Cake Central Cake Decorator Profile
cjett Posted 26 Feb 2013 , 2:32pm
post #6 of 59

Thank You!!! Very user friendly

crustdust Cake Central Cake Decorator Profile
crustdust Posted 26 Feb 2013 , 2:53pm
post #7 of 59

AThank you!!

Crazy-Gray Cake Central Cake Decorator Profile
Crazy-Gray Posted 26 Feb 2013 , 4:18pm
post #8 of 59

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 Cake Central Cake Decorator Profile
AndiDawn Posted 26 Feb 2013 , 9:10pm
post #9 of 59

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

rocco90046 Cake Central Cake Decorator Profile
rocco90046 Posted 26 Feb 2013 , 9:15pm
post #10 of 59

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 Cake Central Cake Decorator Profile
DaCakeDiva Posted 26 Feb 2013 , 9:17pm
post #11 of 59

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 Cake Central Cake Decorator Profile
dmchagaris Posted 26 Feb 2013 , 9:19pm
post #12 of 59

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

renaeheineck Cake Central Cake Decorator Profile
renaeheineck Posted 26 Feb 2013 , 9:43pm
post #13 of 59

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 Cake Central Cake Decorator Profile
Heatherly30 Posted 26 Feb 2013 , 9:51pm
post #14 of 59

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 Cake Central Cake Decorator Profile
pastrycutie75 Posted 26 Feb 2013 , 10:20pm
post #15 of 59

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

Mamabakescakes Cake Central Cake Decorator Profile
Mamabakescakes Posted 26 Feb 2013 , 10:34pm
post #16 of 59

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 Cake Central Cake Decorator Profile
vcheddar Posted 26 Feb 2013 , 10:35pm
post #17 of 59

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 Cake Central Cake Decorator Profile
vcheddar Posted 26 Feb 2013 , 10:37pm
post #18 of 59
Quote:
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 Cake Central Cake Decorator Profile
lucy74 Posted 26 Feb 2013 , 10:57pm
post #19 of 59

thank you.

ManuelaMM Cake Central Cake Decorator Profile
ManuelaMM Posted 26 Feb 2013 , 11:10pm
post #20 of 59

Thank you for sharing it with us.  Very appreciated.

Bzc8lda Cake Central Cake Decorator Profile
Bzc8lda Posted 26 Feb 2013 , 11:39pm
post #21 of 59

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

kchun Cake Central Cake Decorator Profile
kchun Posted 27 Feb 2013 , 1:13am
post #22 of 59

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

BakinWithBarbie Cake Central Cake Decorator Profile
BakinWithBarbie Posted 27 Feb 2013 , 1:28am
post #23 of 59

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

latoft Cake Central Cake Decorator Profile
latoft Posted 27 Feb 2013 , 2:38am
post #24 of 59

Brilliant!  Thank you!!

bakedindy Cake Central Cake Decorator Profile
bakedindy Posted 27 Feb 2013 , 3:10am
post #25 of 59

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 Cake Central Cake Decorator Profile
krez Posted 27 Feb 2013 , 4:51am
post #26 of 59

thanks so much this is very helpful

plcharles Cake Central Cake Decorator Profile
plcharles Posted 27 Feb 2013 , 4:56am
post #27 of 59

Thank you for sharing!

cakefat Cake Central Cake Decorator Profile
cakefat Posted 27 Feb 2013 , 8:59am
post #28 of 59

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 Cake Central Cake Decorator Profile
Mamabakescakes Posted 27 Feb 2013 , 1:12pm
post #29 of 59

thank you.

Tisha1117 Cake Central Cake Decorator Profile
Tisha1117 Posted 27 Feb 2013 , 2:13pm
post #30 of 59

thaaaaaaaaank you for posting!
 

Quote by @%username% on %date%

%body%