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@example.com
I use it with excel 2010 let me know if some parts don't work for you.
Another great price matrix! Thanks for sharing! Going to try it out =)
this is awesome!!!! this helps me so much
Thanks for sharing!
This is amazing! Thanks for sharing.
Thank You!!! Very user friendly
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!! :)
This is great! This confirms my thought that I am to cheap! Thanks
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.
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
WOW - thank you so much. This is exactly what I needed.
The spreadsheet downloaded, but was distorted, would you please email it as an attachment to firstname.lastname@example.org 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!!
You are an absolute life saver!!!!!!!!!
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.
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 for sharing it with us. Very appreciated.
Oh Wow!!! Thank you, this is a good guide. I been charging too little. :(
Thanks for posting. This matrix is amazing! you just made my life SO much easier lol
This is amazing!! Saving for the future!!
Brilliant! Thank you!!
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!!
thanks so much this is very helpful
Thank you for sharing!
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!
thaaaaaaaaank you for posting!