Tutorial – AI Formulation, Yogurt Formula Example

TechWizard’s AI is a very powerful tool especially when it comes to determining ingredient amounts based on composition, quality, and least cost requirements.

Introduction

There are two situations when working with a formulation:
• You need to create a recipe based on a known composition (least cost formulation, reverse engineering).
• You know the recipe and want to know the composition. (Preparing a nutrition facts panel is an example of this.)

In the first situation mentioned above, you know the composition, but you need a recipe to match it; this can be a difficult task to accomplish. Luckily you have TechWizard Online™. The formula development section is specifically designed to solve this type of problem which is often referred to as least cost formulation. The process has the following steps:

Provide TechWizard Online™ Information:
• Desired composition (Total Fat, Total Solids, Sucrose Solids, Protein, Stabilizer Solids, etc.). The actual properties of interest depend on the type of product.
• Ingredients to use (Milk, Cream, Liquid Sugar, Skim Milk Powder, etc.)
• The size of the batch (1000 gal, enough to fill particular containers, etc.)
Based on the Information Provided TechWizard Online™ Determines:
• The weight percentage of each ingredient in the recipe (least cost analysis)
• The volume or weight of each ingredient needed to prepare a given amount of product (in gal, L, lb, bottles, bags, etc.). Referred to as a bill of materials in some software programs (BOM).

This example will expose you to the TechWizard Online™ features necessary to build a formula and formulate for least cost. First, we will create a new formula – enter a formula name, add ingredients and add properties. Next, we will set prices, enter compositional constraints, and develop a least cost formulation. If any of the steps below are not clear, please refer to the portion of the manual covering that operation.

This example duplicates the information found in the first cultured products automated example. I suggest you run this example in TechWizard Online™ so you can review the information on your computer screen before starting.

Click the Goto button and select Help.

In the window that appears, select either Cultured Products Automated Examples or Frozen Dessert Automated Examples from the Automated Examples group.

In the Automated Examples window click the button labeled 1. Be sure to click the Next button each time it becomes active. Check the Run Faster box to reduce the time it takes to run the example.

What Are We Trying to Accomplish?

In plain English this is what we are asking TechWizard Online™ to do in the first example:
TechWizard Online™ please make a yogurt recipe containing milk, condensed skim milk, skim milk, modified starch, gelatin, liquid sugar and culture that has 11% MSNF, 1.5% Total Fat, and 8% Sucrose Solids. Since I already know these amounts work well in yogurt, please use exactly 0.8% modified starch, 0.5% gelatin, and 0.002% culture. I leave it up to you, TechWizard Online™ to determine how much of the other ingredients to use. I know these are all good quality ingredients so if you find a combination that reduces the overall cost of the formula that would be helpful. One more thing – let me know what the total solids and relative sweetness of the final recipe is. If you run into trouble, please let me know.

Part A. In the Formula Development Section, build a formula based on the information listed below, formulate and save the formula.

In the Formula Development section, press the Clear Formula button (A see figure below) to make sure the sheet is empty (see figure below).

Click the Formula Name text box (B) and enter the following in the appropriate boxes. Close the Formula Name & Notes window when finished.

Formula Name: Exercise Lowfat Yogurt
Formula ID: 712345
Formula Notes: Training Formula.

Click the Add Ingredients button (C). The Add Ingredient window appears (see figure below).

Search for each ingredient by reference number from the list below and add each ingredient. To search by reference number, click the Ref. # option (J), enter the reference number, and press the Search button (K) (see figure below). Close the Add Ingredients window when finished.

Modify the Min, Max and Price per Lb. in the blue cells (D) next to each ingredient using the values provided below.

Ingredient Settings:

Click the Add Properties button (E). Add each property shown below. Close the Add Properties window.
Modify the Min and Max in the blue cells next to each property using the values provided below (F).
Press the Formulate button. Press the OK button when the window appears.
If you wish to save the formula, click the File button and select Save Formula.

Property Settings:

Part B. After testing Example 1, it was decided less gelatin was needed. The concentration should be reduced from 0.5% to 0.45%.

Modify the Min and Max values in the blue cells next to the ingredient gelatin and press the Formulate button.

Part C. Sort the ingredients in the following order.

Press the Sort button (I in the previous figure). The Sort Window appears.
Press the Sort Descending button. Experiment with the other buttons in the window. Close when finished.

Part D. Would it make economic sense to change the formula replacing condensed skim milk and skim milk, with skim milk powder and water?

Add the ingredients shown below. Click Add Ingredients button (C in previous figures).

Search for each ingredient by reference number and add each ingredient. Close the Add Ingredients window. To search by reference number, click the Ref. # option (J previous figures), enter the reference number, and use the search feature (K previous figures) or press the Enter key on your keyboard. Close the Add Ingredients window.

Modify the price as needed using the values provided below.

Formulate by pressing the Formulate button (G previous figures).

Ingredient Settings:

Notice the amount of skim milk, skim milk powder, and water using in the formula now.

Part E. Could the formula be changed to contain 3% fat without changing the ingredients used?

Change the Min and Max values to 3 in the blue cells next to the property Total Fat.
Formulate by pressing the Formulate button.