Cake Central › Cake Forums › Cake Talk › Cake Decorating Business › Help with Alice's Matirx
New Posts  All Forums:Forum Nav:

Help with Alice's Matirx

post #1 of 9
1/25/13 at 1:49pm
Thread Starter 

How do you figure out the right conversions for Alice's Matrix?

Reply
Reply
post #2 of 9
1/25/13 at 2:52pm
Are you talking about the pricing matrix linked below? If so what type of conversions do you need help with?

https://docs.google.com/spreadsheet/ccc?key=0AvflfTGZ15dhcG1CRzk0dUI1Vzl6YzRYM2UxWmw4ZXc&hl=en#gid=0
.
The Bakery Business Perspective
An experimental blog with new content every Tuesday!

Recent Articles: The Magic Pricing Formula • Copyright Law
Reply
.
The Bakery Business Perspective
An experimental blog with new content every Tuesday!

Recent Articles: The Magic Pricing Formula • Copyright Law
Reply
post #3 of 9
1/27/13 at 9:13am
Thread Starter 

Yes! Thank you..The column that says unit conversions.. How does this work? I put in my recipe .. and the unit price does not come out right.. how do I fix that?

Reply
Reply
post #4 of 9
1/27/13 at 10:01am
The unit price column's calculation is (price * unit amount) / (amount * unit conversion). So if the unit amount you want to use for the unit price is different from the units on the product you purchased, you can use the conversion column to take this into account. For example, the Ribbons line shows an amount in yards (since ribbon is sold by the yard) but the unit amount is inches, so the conversion factor would be 36 (1 yard = 36 inches).
.
The Bakery Business Perspective
An experimental blog with new content every Tuesday!

Recent Articles: The Magic Pricing Formula • Copyright Law
Reply
.
The Bakery Business Perspective
An experimental blog with new content every Tuesday!

Recent Articles: The Magic Pricing Formula • Copyright Law
Reply
post #5 of 9
1/27/13 at 4:43pm
Thread Starter 

Ok so, if I bought 15 dozen eggs at $16.94.. the recipe calls for 4 eggs ..The Item would be Eggs.. The Amount would be $16.94.. the unit amount would be 4 .. the unit conversion would be ??? the price would be $16.94.. and it would calculate to me the price of 4 eggs..?? I'm sorry, I'm just confused..Please explain this way, Thank you so much for helping me!

Reply
Reply
post #6 of 9
1/27/13 at 4:55pm

If you bought ONE dozen eggs for a dollar and the recipe uses 4 eggs, you would be using 12/4=3 or 1/3 of the dozen and the unit price would be 1/3 of the dollar that you paid for the dozen eggs or 33 cents. HTH

Reply
Reply
post #7 of 9
1/27/13 at 5:15pm

This is awesome!  I've been looking for something like this!  Thank you!

Reply
Reply
post #8 of 9
1/27/13 at 6:01pm
Thread Starter 

Is there anyway I can call you and you can walk me through this?

Reply
Reply
post #9 of 9
1/27/13 at 6:36pm
Thread Starter 

Wait!! I think I've figured it out!!!  THank you!!

Reply
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Cake Decorating Business
Cake Central › Cake Forums › Cake Talk › Cake Decorating Business › Help with Alice's Matirx