Ingredient Editor Layout

The ingredient editor is made up of the ingredient descriptions and the information for each ingredient (see figure below). The first column contains the ingredient description (A). The number of properties and ingredients in the file are listed above the Volume Choice column (B). Properties refer to compositional data such as fat, total solids, etc. Ingredients added to the file are placed in alphabetical order in the file by ingredient name. The next three columns to the right of the ingredients are for Volume Choice (C), Source Information (D), and Price respectively. Volume Choice is discussed in more detail below in the section on Density.

There are two types of properties in the ingredient file, non-default properties (E) and default properties (F). Non-default properties (E) can be used for a variety of purposes such as denoting the presence of allergens or providing information for a unique property such as cheese solids. When non-default properties are added, they are placed right after the column containing price. Default properties (F) are properties that always appear in the ingredient file such as total fat, total solids, etc.

The columns on the far right of the table are Density, Ingredient Declaration, Bulky Item, and Reference Number respectively (G).

Density

The Volume Choice value (C) determines how density is calculated (see figure above). The density of an ingredient can be entered in the ingredient file and that density used to calculate ingredient volume. In some cases it is more appropriate to have the density recalculated as the fat and total solids content of an ingredient varies.

How Does the TechWizard Online™ Know Which Density Calculation to Use?
The TechWizard Online™ uses a variable, referred to as the Volume Choice, which is set by the user to determine how density values are obtained. The Volume Choice can be set to 0, 1, 2, or 3 which corresponds to:

0 – no volume for the ingredient is calculated regardless of whether or not density values are provided.
1 – volume calculated using USDA Density Calculation for Milk.
2 – volume calculated using density values provided for the ingredient in the ingredient file.
3 – volume calculated using the Mix Density Equation.

How does the TechWizard Online™ Calculate Density?
There are two main methods used by the TechWizard Online™ to calculate density. The first is referred to as the USDA Density Calculation for Milk.

The USDA Density Calculation for Milk uses the following equation:

Density (kg/L at 40 F) =100/[100 + (%BF x 0.03928) – (%SNF x 0.39221)] Density (lb/gal) = 8.3364 x kg/L
BF – butterfat, SNF – milk solids not fat (MSNF)

The second method is referred to as the Mix Density Equation.
The Mix Density Equation is useful for calculating the density of completely dispersed, water containing liquids only:

Density (kg/L at 60 F) =100/[(%fat/0.9) + (%SNF/1.58) + (100 – TS)] Density (lb/gal) = 8.3364 x kg/L
SNF – solids not fat, TS – total solids

Marking an ingredient as Bulky (G in figure above) means the ingredient does not disperse in water hence none of the equations for calculating density are appropriate. The user should set the volume choice for bulky ingredients to either 0 or 2.