Help Center
Tutorial – AI Formulation, Process Cheese Food Formula Example
The following ratio properties are available in TechWizard Online™ – FDM, Lactose/Water, and Ortho/Water.
To use these ratio properties, the formula must contain these properties – Total Fat, Total Solids, Water, Lactose, and Orthophosphate Solids. This example introduces formulating for ratio properties.
What Are We Trying to Accomplish?
In plain English this is what we are asking TechWizard Online™ to do in this example:
TechWizard Online™ please make a processed cheese recipe containing cheese, lactic acid, salt, sodium citrate, sorbic acid, whey concentrate, delactosed whey, concentrated milkfat, water and sodium phosphate. The recipe should have between 36 and 60% Cheese Solids, no more than 6% lactose, and no more than 5% added fat solids coming from the ingredient concentrated milkfat. Limit the total salt content from all sources to 2%. Since I already know these amounts work well please use 0.2% lactic acid, 3% sodium citrate, and 0.2% sorbic acid. Please do not use more than 10% whey concentrate, 7% delactosed whey, and 10% water in the recipe. I would like the ratio of fat to total solids to be between 42.5 and 42.525. The ratio of lactose to water should be between 10 and 15 and the ratio of orthophosphate solids and water should be 4 exactly. I leave it up to you, TechWizard Online™ to determine how much of the ingredients to use that are not specified by me. Please find a combination of ingredients that reduces the cost as much as possible.
Build a Formula
In the Formula Development Section, prepare a formula based on the information listed below, formulate and save the formula.
Press the Clear Formula button (A).

Click the Formula Name text box (B) and enter the following in the appropriate boxes.
Formula Name: Process Cheese Food Example
Formula ID: 123456
Formula Notes: Training Formula
Close the Formula Name & Notes window.
Click Add Ingredients button. Search for each ingredient by reference number and add each ingredient. Close the Add Ingredients window. Search for each ingredient by reference number from the list below and add each ingredient. Close the Add Ingredients window. To search by reference number, click the Ref. # option, enter the reference number, and press the Search button or press the Enter key on your keyboard. Close the Add Ingredients window.
Modify the Min, Max and Price per Lb. in the blue cells next to each ingredient using the values provided below.
Ingredient Settings:
| Ref # | Ingredient | Min | Max | Price per Lb. |
| Twz 898115 | Cheese (Fiber barrels) | 0.000 | 100.000 | 1.520 |
| Twz 50096 | Lactic Acid (88%) | 0.200 | 0.200 | 0.500 |
| Twz 0106 | Salt | 0.000 | 100.000 | 0.060 |
| Twz 50100 | Sodium Citrate | 3.000 | 3.000 | 0.350 |
| Twz 50104 | Sorbic Acid | 0.200 | 0.200 | 1.200 |
| Twz 50107 | Whey Conc (sweet) | 0.000 | 10.000 | 0.700 |
| Twz 50108 | Whey (lactose reduced) | 0.000 | 7.000 | 0.400 |
| Twz 0012 | Milkfat, Conc. Anhydrous Unsalted | 0.000 | 100.000 | 1.200 |
| Twz 0140 | Water | 0.000 | 10.000 | 0.001 |
| Twz 0160 | Sodium Phosphate, Dibasic | 0.000 | 100.000 | 1.000 |
Click the Add Properties button and make sure the Data Property tab is selected. 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.
Property Settings:
| Property | Min | Max |
| SALT | 2.000 | 2.000 |
| CHEESE SOLIDS | 36.000 | 60.000 |
| Lactose | 0.000 | 6.000 |
| ADDED FAT | 0.000 | 5.000 |
| Total Fat | 0.000 | 100.000 |
| Total Solids | 0.000 | 100.000 |
| Water | 0.000 | 100.000 |
| Orthophosphate Solids | 0.000 | 100.000 |
Click the Add Properties button again and make sure the Complex Property tab is selected. 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.
Complex Property Settings:
| Property | Min | Max |
| FDM | 42.500 | 45.525 |
| Lactose/Water | 10.000 | 15.000 |
| Ortho/Water | 4.000 | 4.000 |
Press the Formulate button. Press the OK button when the window appears.
Click the File button and select Save Formula.