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
Thread Starter 

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

post #2 of 9
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
post #3 of 9
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?

post #4 of 9
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).
post #5 of 9
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!

post #6 of 9

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

post #7 of 9

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

post #8 of 9
Thread Starter 

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

post #9 of 9
Thread Starter 

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

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