Cake Central › Cake Forums › Cake Talk › Cookies! › Cookie Matrix
New Posts  All Forums:Forum Nav:

Cookie Matrix

post #1 of 38
Thread Starter 
I created an excel spreadsheet for pricing my cakes (if you want a copy just email me: alicegop@gmail.com), I don't do cookies, although I am thinking about branching out. I would like to make an excel spreadsheet like my cake one but for cookies.

So... especially since I don't make cookies, can anyone give me feedback about what I should include? What structure would you like to see? What would be helpful?

I will of course offer it up for free once I get it done!

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

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

Let God's promises shine on your problems. ~Corrie Ten Boom
Reply
post #2 of 38
I don't have any advice, just starting out, but am interested in it.
No longer baking and caking. Medical transcriptionist and Thirty-One Gifts independent consultant.
Reply
No longer baking and caking. Medical transcriptionist and Thirty-One Gifts independent consultant.
Reply
post #3 of 38
Thread Starter 
Michelle, email me and I'll add you to my cookie matrix group so that when I do create one you'll be the first to get a copy. I'll give you a copy of my cake matrix if you can look at it and tell me what would be good for cookies and what wouldn't be. I can't just modify the matrix I have since it references words like "cake" and I would have to change all the formulas or leave the word "cake" in it.... which I would prefer NOT to do. So... I want to take the best parts of my cake matrix and put it together with the elements of cookie making and come up with something really cool.

So I need to know
(a) what kinds of supplies go with cookie making. With cakes you have the cake circles, filling, fondant, gumpaste flowers, etc... all those things you want to account for in your costs and also what you charge for. (bags, sticks... what else?)
(b) what types of things do you charge extra for
(c) how do you do your cookies, there is a platter price, a individual bagged cookie price
(d) how could I do cookie bouquets. What type of formula can I use to price the cookies.
(e) cakes are different sizes, should I account for different size cookies?

I don't make cookies... yet... so I am leaving stuff out. Please, what are all the things you want to consider and I will try and make something you can use!
www.selfservebaker.com
Decorating Supplies-cupcake inserts, fillings, boxes

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

Let God's promises shine on your problems. ~Corrie Ten Boom
Reply
post #4 of 38
I would also be interested in this, I have tried to do one myself, but I am not very computer literate. I will pm you if that is ok.
post #5 of 38
1) packaging materials (price per bag, per yard of ribbon, per sticker to seal or brand the bags, price of boxes & padding for orders to be packed)

2) break down the price per cookie (ingredients, baking time, labour, extra detailing like inscribed names/sugar flowers/dragees)

3) time/labour for packaging factored in

4) delivery/pick up

5) price per cookie = $1 per square inch, which works well for pricing
post #6 of 38
I think Antonia74 is much better qualified than I am at this point! LOL! I have 1 cookie bouquet under my belt and am currently practicing wedding cake cookies for a July wedding. I have a lot to learn, but will help if I can.
No longer baking and caking. Medical transcriptionist and Thirty-One Gifts independent consultant.
Reply
No longer baking and caking. Medical transcriptionist and Thirty-One Gifts independent consultant.
Reply
post #7 of 38
Thread Starter 
antonia74 thanks! That helps alot. Should get me started icon_smile.gif
www.selfservebaker.com
Decorating Supplies-cupcake inserts, fillings, boxes

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

Let God's promises shine on your problems. ~Corrie Ten Boom
Reply
post #8 of 38
Thread Starter 
Here are the supplies I have so far. What additional supplies are there and can anyone help me with prices for the items I don't have already?

Cellophane bags  200  bags  1  bag  1   $5.00
Cookie Sticks            
Ribbon  250  yards  1  foot  3   $2.00
Personalized Tags  300  labels  1  label  1   $14.00
Buckets/baskets  1  bucket  1  bucket  1   $1.00
basket bag  100  bags  1  bag  1   $24.00
Foam  1  block  1  block  1   $1.00
Tape to secure foam            
Cellophane wrapping            
Twist Ties            
Bows            
Paper or Foil Shreds  1  oz  1  oz  1   $1.00
www.selfservebaker.com
Decorating Supplies-cupcake inserts, fillings, boxes

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

Let God's promises shine on your problems. ~Corrie Ten Boom
Reply
post #9 of 38
$1.99 for 20 cookie sticks (from the Wilton website).
No longer baking and caking. Medical transcriptionist and Thirty-One Gifts independent consultant.
Reply
No longer baking and caking. Medical transcriptionist and Thirty-One Gifts independent consultant.
Reply
post #10 of 38
Hi Alice,

I've never sold cookies, but I might in the near future, so I can't be of much help.Anyway I'm very much interested in your cookie matrix and your cake matrix as well.Please, include me in your list.
TIA
Maria
post #11 of 38
Thread Starter 
Okay, I am going to post my PROTOTYPE of the cookie matrix. I just made it today. Remember I do NOT make cookies, so I made up the percentages that go in the blue boxes (based on information some of you emailed me and from this thread, so it was an educated guess...) so I really need feedback. If you want a copy of my matrix once it is improved (and any updates there after) you'll need to email me at alicegop@gmail.com and say you want the COOKIE matrix (and not the cake matrix, or maybe you want both... just let me know). They are FREE, I just like an excuse to play with Excel.

So, please check out my spreadsheet and give me feedback!

THANK YOU IN ADVANCE!
www.selfservebaker.com
Decorating Supplies-cupcake inserts, fillings, boxes

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

Let God's promises shine on your problems. ~Corrie Ten Boom
Reply
post #12 of 38
Thanks!! This is really great! icon_smile.gif
I am going to give it a whirl today.
~Val~
And yes.... I am shaped like <--- that M&M... cute huh?
Reply
~Val~
And yes.... I am shaped like <--- that M&M... cute huh?
Reply
post #13 of 38
Thread Starter 
If anyone would like to help me out but doesn't have excel

http://www.microsoft.com/downloads/Browse.aspx?displaylang=en&categoryid=9

here is the link to Microsoft to download the excel viewer.

THANKS EVERYONE FOR YOUR HELP.
www.selfservebaker.com
Decorating Supplies-cupcake inserts, fillings, boxes

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

Let God's promises shine on your problems. ~Corrie Ten Boom
Reply
post #14 of 38
I would make sure to include the 'detail' work. I sell a lot of cookies (still a hobby!) but whenever you go into adding luster dust with a fine-point paint brush, you are talking some serious time. Also, hand applying dragees in just the right places, or having to duplicate a logo or 'character' just so in order to make it look correct. For instance, Mickey Mouse's smile & eyes, or Hello Kitty's nose in the right spot, Thomas's eyebrows so he doesn't look mad... etc etc etc. Those are things to take into consideration. As far as personalizing the cookies, it takes no more time than adding basic decorations. I scripted "Katie & Matt' on 95 chili pepper cookies and it took less than an hour... but I am very comfortable with writing. Someone who has less experience or is timid about their handwriting could easily factor in three hours for the same workload. Seems very subjective, so not sure if that will fit into your matrix, unless you have different burden rates based on ability (i.e. Rookie - more time, Experienced - less time). Does that make sense?

Also, include luster dust, everclear, personalized gift tags, delivery costs.
"Life is short...Let them eat Brookie's Cookies!"
Reply
"Life is short...Let them eat Brookie's Cookies!"
Reply
post #15 of 38
Oh, I forgot, I want a copy of both your cake and preliminary cookie matrix too! I think that's great that you are willing to share. I am so not an excel person, but I can work with a pre-created spreadsheet!

Another thought...Did you factor in length of oven time based on # of cookies ordered? Over will be on for most of the day with a very large order - you can only roll out and bake so many cookies at a time.
"Life is short...Let them eat Brookie's Cookies!"
Reply
"Life is short...Let them eat Brookie's Cookies!"
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Cookies!
Cake Central › Cake Forums › Cake Talk › Cookies! › Cookie Matrix