Julianne's Ultimate Cake Pricing Matrix Update
Business By abccupcakes Updated 22 Apr 2017 , 3:13pm by sistersvillesweets
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.
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!! :)
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
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
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.
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!!
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?
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.
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
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!!
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!
Quote by @%username% on %date%
%body%