Working with the panes in the Formula Item Contributions form

Components pane

The item code for each ingredient, component and sub-formula in the formula is displayed in this pane. Sub-formulas, constituents and items are indented according to their level in the formula hierarchy. The item lines appear in the Components grid in red text and the Ingredient Line Type column is available for additional validation of Ingredients versus Byproducts.

Alias 1 - 8

Shows the alias values for the item.

Attribute

Shows the attribute value from the Item Lines tab of the Formula page.

CAS #

Shows the Chemical Abstract Services (CAS) number for the item.

Class

For a directly nested formula, the class defaults from the formula. This also applies to a directly nested formula that has a manufactured item associated with it.

For an indirectly nested formula, the class defaults from the item.

Common Name

Shows the common name for the item.

Component

Shows the item code for each ingredient, constituent, and sub-formula in the formula. Sub-formulas, constituents, and items are indented according to their level in the formula hierarchy.

To see the details for each component, click the link.

Description

Shows the description of the ingredient or sub-formula.

Ingredient Line Type

Shows the ingredient line type as either 0 for Item Lines or 2 for Byproducts.

Mfg Item

Shows the code of the formula associated with the item.

Qty%

Shows the percent of the item contribution to the ingredient total.

Quantity

Shows the amount of the ingredient or sub-formula in the formula according to the unit of measure in the UOM column.

Quantity Hi

Shows the maximum acceptable value for the item.

Quantity Lo

Shows the minimum acceptable value for the item.

Status

Shows the description of the status that is assigned to the item.

For a directly nested formula, the status defaults from the formula. This also applies to a directly nested formula that has a manufactured item associated with it.

For an indirectly nested formula, the status defaults from the item.

Sub Mass%

Shows the Qty% that an ingredient contributes to its containing formula, as opposed to the Qty% an ingredient contributes to the top-level formula.

Suppose Formula FS-0001\0001 has two ingredients.

ITEM01 for 100 KG.

Formula FS-0002\0001 for 100 KG.

Formula FS-0002\0001 has a single ingredient: ITEM02 for 100 KG.

In this example, ITEM02 contributes 50% to the total quantity of FS-0001\0001. But the Qty% (i.e., SubMass) of ITEM02 in its containing formula (i.e., FS-0002\0001) is 100%.

Type

Shows the component type.

0 – ingredient or constituent

10 – top-level formula (super-formula)

11 – sub-formula

UOM

Shows the unit of measure for the component. If the component’s base unit of measure is KG, but the formulation was in G, then KG is displayed here.

Unit Contributions pane

The column headings show each parameter that is defined for the formula. The first row shows the parameter values as they are defined on the formula.

The subsequent rows show the contribution amount for the corresponding component, as defined for that component. For example, item 01001 is defined with a CA parameter value of 2.11 on the Item form. The parameter value is displayed in the Unit Contributions pane.

Extended Contributions pane

The column headings show each parameter that is defined for the formula. The first row shows the parameter values as they are defined on the formula.

The subsequent rows show the extended value for the parameter.

The extended value is calculated as:

Qty % for the component (as shown in the Components pane) multiplied by the Parameter contribution (as shown in the Unit Contribution pane), divided by 100.