Cake Central › Cake Forums › Cake Talk › Cake Decorating Business › Alice's Cake Pricing Matrix
New Posts  All Forums:Forum Nav:

Alice's Cake Pricing Matrix  

post #1 of 173
Thread Starter 
I think I've taken this about as far as I can go, I can't imagine what else I could add onto the spreadsheet to improve it (although I am very open to ideas) so I think I'm ready to just post it for all of you to use.

If there are any typos or upgrades I will update this thread so if you click below on watch this topic then you should be sent an email notifying you if there are updates.

If you have a question on how to use the matrix (and there is an instructions tab as the last tab) post them here so everyone can get the answer.

Enjoy!
God Bless
Alice


***See post dated March 10th for download***
www.selfservebaker.com
Decorating Supplies-cupcake inserts, fillings, boxes

Let God's promises shine on your problems. ~Corrie Ten Boom
www.selfservebaker.com
Decorating Supplies-cupcake inserts, fillings, boxes

Let God's promises shine on your problems. ~Corrie Ten Boom
post #2 of 173
How very generous of you to do this! I have made it into a "Sticky" so that it doesn't get lost in the shuffle. Now off to check it out! icon_biggrin.gif
Whatever you do, do with all your heart!
Whatever you do, do with all your heart!
post #3 of 173
I have been using this one and it's great! It is really easy to use and love that I can add my own recipes. Great work!
post #4 of 173
Thread Starter 
I found a typo. (if you previously downloaded, I forgot to multiply filling volume by filling price so 7 ounces added in $7.) Here is the corrected matrix.
www.selfservebaker.com
Decorating Supplies-cupcake inserts, fillings, boxes

Let God's promises shine on your problems. ~Corrie Ten Boom
www.selfservebaker.com
Decorating Supplies-cupcake inserts, fillings, boxes

Let God's promises shine on your problems. ~Corrie Ten Boom
post #5 of 173
I just took a quick look at your matrix. It looks excellent. I have been chenging on one I downloaded from this website about a year ago. I have been working fulltime, plus working for myself, until recently. I am not self employed so I will be able to do cakes again as much as I want. Customizing my matrix is on my list of things to do. I just love excel and try to use it for everything. Looks like you like it too!!!!!

I will try yours out. Thanks for sharing. So far it looks great.
post #6 of 173
Wow, this was alot of work to put together. Now unfortunately I am not that good at Excel, but the instructions are pretty self explanatory. Thanks again!
mom to Christine, John, Michele, Joseph & Peter......grandma to Zachary and Colette
mom to Christine, John, Michele, Joseph & Peter......grandma to Zachary and Colette
post #7 of 173
Thread Starter 
Here is version N if you would like an updated copy.
www.selfservebaker.com
Decorating Supplies-cupcake inserts, fillings, boxes

Let God's promises shine on your problems. ~Corrie Ten Boom
www.selfservebaker.com
Decorating Supplies-cupcake inserts, fillings, boxes

Let God's promises shine on your problems. ~Corrie Ten Boom
post #8 of 173
Thanks for this! I'll see if I'm sharp enough to figure it out! lol icon_lol.gif
COULD SOMEONE PASS THE FROSTING?
Wendy's Cake Space
The Homeschooling Blog
COULD SOMEONE PASS THE FROSTING?
Wendy's Cake Space
The Homeschooling Blog
post #9 of 173
icon_surprised.gif Thanks for sharing, but where are the instructions (LOL!) I just don't even know where to start! icon_redface.gif I thought I was reasonably intelligent! Please help i.e BABY STEPS, please! Thanks
post #10 of 173
Thread Starter 
There is an instructions tab, although I could do a better job of the instructions tab. Here is what I wrote when I emailed out the spreadsheet. I would encourage people to ask questions here so everyone can benefit from the answers.



There is a directions tab at the end of the tabs... it is off the screen so you have to get over to them.

this one includes cupcakes too!

Some basic directions to get you started:
The blue boxes are meant for you to enter values in and change. The yellow boxes automatically calculate so stay away from those. If there is a red triangle you can hover over it for more info!

Tabs:
Pricing - go through each blue square and adjust the values to suit you. I have 2 as the base price per serving before supplies, I use 0.8 though.

Info to Know - these don't link anywhere, they are just a compliation of info that is scattered throughout the spreadsheet that I thought you might like to see in one place.

Base Price - you will enter in the blue cells how many of each item you use EXTRA beyond what is normally included in the cake. The matrix automatically figures out how much cake mix and frosting and stuff, so you do NOT enter them on this base price tab. I frequently will throw in an extra batch of frosting if I am doing a lot of decorating so I would put a 1 in the blue cells next to frosting. Cake circles are NOT automatically included (cupcake liners ARE) so you will need to go through for each cake order and include how many cake circles you are using. Dowels are NOT included either. I also usually go down to the misc. items and throw in a couple of bucks to cover paper towels, dishsoap, etc... make sure you adjust the prices to reflect what YOU pay!

Cakes tab, basically nothing to do here. Although there is one blue cell you can change. I assume that when i do fondant I'll use 90% of the frosting I would have used for a buttercream. You can change that if you want. If the number of servings aren't the same as yours DO NOT CHANGE ON THE CAKES TAB! They are in yellow boxes, so don't touch!

Rental - you can fill in any supplies you own and rent out

Gumpaste - if you charge by the piece you can include here

Invoice - I hate this tab... I should just delete it

Cake recipies - here is where you enter in your cake recipies. The trick is getting the right conversion rates. Good luck!
(ditto for frosting and fillings)

Assumptions - this is where serving sizes are. If you want to change my base assumptions, this is where you do it.

ENJOY!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!


In Christ
www.selfservebaker.com
Decorating Supplies-cupcake inserts, fillings, boxes

Let God's promises shine on your problems. ~Corrie Ten Boom
www.selfservebaker.com
Decorating Supplies-cupcake inserts, fillings, boxes

Let God's promises shine on your problems. ~Corrie Ten Boom
post #11 of 173
Thread Starter 
Here is my latest update:
There is nothing wrong with the previous cake matrix I made, seems like different isses keep coming up and I am adding to it. You might not want this new update if you've taken the time to go through and put in your own recipes and prices (which you should do)

Improvements:
1) you can adjust your cake sizes so your serving sizes are reflected (go to the assumptions tab)
2) I estimate the number of hours required to make the cake. You'll want to assess the decorating numbers that come up and adjust appropriately, but it is a starting point.
3) You can set codes for the type of cake you are making as to what your base price is (b = basic and you might price and time that differently from a difficult or wedding cake) Click on the time tab to adjust my assumptions.
4) In addition to the customer print out page, there is a friend print out page, which is basically the same thing but allows you to put in a discount. This way your friend sees what the regular price is and they know they are getting a discount. This is especially good for those of us who are practicing and feel unsure about the price we charge. Then when your confidence is up, your friends and customers won't suffer sticker shock, they will know what your "real" prices are.
5) When you put in layers on the pricing tab it automatically adds in one cardboard circle.
6) There is an extras tab where if there are some things that are more labor intensive you can charge extra per (wilton size) serving. If you want.

Enjoy!!
www.selfservebaker.com
Decorating Supplies-cupcake inserts, fillings, boxes

Let God's promises shine on your problems. ~Corrie Ten Boom
www.selfservebaker.com
Decorating Supplies-cupcake inserts, fillings, boxes

Let God's promises shine on your problems. ~Corrie Ten Boom
post #12 of 173
THANKS FOR THIS. I'M GONNA STUDY THIS, I THINK YOU SPEND A LOT OF TIME WITH IT. THANKS FOR SHARING IT.
GRACIAS, LO VOY A ESTUDIAR, CREO QUE LE TOMO MUCO TIEMPO HACERLO. GRACIAS POR COMPARTIRLO.
DOLCE MIA CAKES
DOLCE MIA CAKES
post #13 of 173
The only thing I can see right off that you might think about is putting in the different shapes because a square cake servers more than a round. I have a price matrix that does that but I dont like it as much as yours. yours is clearer and much easier to understand. Thank you so much for posting it and doing all the hard thinking for us all.
post #14 of 173
I take it back SO SORRY dunce.gif

Looks like you did that!

I have to study this.

I LOVE LOVE IT!! dunce.gif
post #15 of 173
Thread Starter 
It has definately evolved a lot since my first run last April. It has gotten quite complicated, but only as I have needed it icon_lol.gif I keep finding new information I want to know! Glad you like it!
www.selfservebaker.com
Decorating Supplies-cupcake inserts, fillings, boxes

Let God's promises shine on your problems. ~Corrie Ten Boom
www.selfservebaker.com
Decorating Supplies-cupcake inserts, fillings, boxes

Let God's promises shine on your problems. ~Corrie Ten Boom
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Cake Decorating Business
This thread is locked  
Cake Central › Cake Forums › Cake Talk › Cake Decorating Business › Alice's Cake Pricing Matrix