Ice cream mix calculations

Category: Site calculators and spreadsheet queries
Forum Name: Spreadsheet and site calculators
Forum Description: Support queries about calculators and spreadsheets downloaded from Dairy Science and Food Technology website or the ice cream mix subscription service
URL: https://www.dairyscience.info/forum/forum_posts.asp?TID=231
Printed Date: 18 Jun 2021 at 10:47pm
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com

Topic: Ice cream mix calculations
Posted By: ultratech2008
Subject: Ice cream mix calculations
Date Posted: 23 Aug 2010 at 9:20pm
 HiNew to this forum - I am hoping someone can help. I am trying to develop a scaleable recipefor Gelato bases so I can experiment in small batches and when applicable reproduce these recipeson a large (commercial) scale. I have some guidelines to follow concerning ingredient percentages, but I am unsure how to go aboutmaking these percentages into a recipe based on weights.  I currently use bakers percentages to make pizza dough, but ice cream and gelato present further challenges due to the ingredientscontaining some percent of other ingredients ie milk 91% h20 and 9 % MSNF so when a certain ingredient is increased other ingredients may need to be decreased.I am going with these as a starting point: sugar 14%fat 7%msnf 10%stabilizer .5%H20 %60I was unsure how to convert this to a recipe based on weights ie for 1000g of baseI would need 140g of sugar, 70g of fat, 100g of MSNF etc.  I am just a bit confused about where I should begin my calculations because of the relationships between the ingredients. So far I have come up with the following - if anyone can shed some light on what I am missing or direct me to a more simplistic method I would be grateful. I looked under the spreadsheet section of this forum, but don't see any ss?TOTAL MIX 1000gsugar 14% = 140g sugarfat 7% = 84g butter @ 84% fat = 70g FATMSNF 10% skim pwdr @95% MSNF 5% H20 100g   37g = 35g msnf + 66g from skim milk =101 gH20 (skim milk) @91% H20, 9% msnf 660g skim milk = 600g H20, 66g MSNFStabilizer is where it all gets hazy. Using Egg yolk at a recommended .5%where egg yolk = 30% fat,17% Other solids, 53% water. half a percent of 1000g would be 5g 30g of egg yolk should net 5g of stabilizer and some additional h20, and fat.For anyone with experience using scalable ice cream formulas do these calcs look pretty good? Not so much what the percentages are to make gelato or ice cream, but the way I reverse calculated these percents from a 1000g total base. Thanks for reading my terribly long post. I am attending a course in November, but would prefer not to wait until then to begin researching my base composition. CheersAlex W

Replies:
Date Posted: 24 Aug 2010 at 12:20am
 Alex   I have just noted your post but it is too late to respond now, after midnight. I will respond at around 8 PM tomorrow.   Have you downloaded the custom spreadsheet at http://www.dairyscience.info/technology/180-excel-ice-cream.html - http://www.dairyscience.info/technology/180-excel-ice-cream.html  ? Look at the screen shot of the spreadsheet.   More at 8 PM or so.

Posted By: ultratech2008
Date Posted: 24 Aug 2010 at 3:59pm
 Hello Michael Thanks for your prompt reply. Admittedly no - I was unable to find the spreadsheet information pages until late last night when I got home.  I will be downloading them sometime this week as I am home from work.   I am currently using fresh egg yolk as an emulsifier and a very small amount of guar gum 1/8 teaspoon for 1000g of mix as a stabilizer that have to weigh it to get its percentage. I would like to explore other stabilizers, thickeners etc as my current mix isnt quite where I would like it to be in terms of creaminess,  etc. and I know commercially available Gelato bases are using guar/xanthan blends, carageenan, etc.    Thanks for your help - I will await your assesment.   Ciao