Calculate the Quantities to Weigh#
In this scenario, you will learn how to:
- Calculate the quantity to weigh and the tolerance limits of each ingredient for the Relative and Absolute formula types.
- Understand how the system calculates the minimum tolerance.
- Calculate the quantities automatically with a Rule.
Info
For more information, see:
How the System Calculates the Quantities#
The system calculates the quantity of each ingredient against the Target Material Quantity of the target Material. The calculation depends on the formula type of the BOM.
The following examples use a target quantity of 25 Kg.
Relative Formula Type#
In a Relative BOM, the quantities are percentages and the tolerances are percentages of the calculated quantity. The system calculates the following values for each item:
Required Quantity = Target Quantity × Quantity / Sum of the Quantities
Lower Limit = Required Quantity × (1 - Lower Tolerance / 100)
Upper Limit = Required Quantity × (1 + Upper Tolerance / 100)
The following table shows the calculation for BOM W&D Compound B. The sum of the quantities is 100.
| Product | Quantity (%) | Lower Tolerance (%) | Upper Tolerance (%) | Required Quantity (Kg) | Lower Limit (Kg) | Upper Limit (Kg) |
|---|---|---|---|---|---|---|
Powdered chemical Blue | 20 | 0.1 | 0.01 | 5.0000 | 4.9950 | 5.0005 |
Phthalates | 80 | 2 | 1 | 20.0000 | 19.6000 | 20.2000 |
Table: Quantities to weigh for a Relative BOM
Info
The sum of the quantities of a Relative BOM must be between 99 and 101. When the sum is not 100, the system adjusts the quantities, so that the required quantities add up to the target quantity.
Absolute Formula Type#
In an Absolute BOM, the quantities and the tolerances use absolute values. The sum of the quantities can be any value, so the system scales the quantities and the tolerances to the target quantity with the following factor:
Factor = Target Quantity / Sum of the Quantities
Required Quantity = Quantity × Factor
Lower Limit = Required Quantity - Lower Tolerance × Factor
Upper Limit = Required Quantity + Upper Tolerance × Factor
The following table shows the calculation for BOM W&D Compound G. The sum of the quantities is 55 Kg, so the factor is 25 / 55.
| Product | Quantity (Kg) | Lower Tolerance (Kg) | Upper Tolerance (Kg) | Required Quantity (Kg) | Lower Limit (Kg) | Upper Limit (Kg) |
|---|---|---|---|---|---|---|
Powdered chemical Green | 5 | 0.1 | 0.05 | 2.2727 | 2.2273 | 2.2955 |
Phthalates | 30 | 2 | 1.5 | 13.6364 | 12.7273 | 14.3182 |
Secret Chemical Recipe | 20 | 0.1 | 0.05 | 9.0909 | 9.0455 | 9.1136 |
Table: Quantities to weigh for an Absolute BOM
The required quantities add up to the target quantity of 25 Kg. The tables round the values to four decimals. The Weigh and Dispense page can show a different number of decimals, according to the precision of the selected scale.
Add Notes to Support the Operator#
In both formula types, you can add a Note to each BOM item with instructions for the operator. The system shows the note on the Weigh & Dispense page when the operator selects the ingredient.
How the System Calculates the Minimum Tolerance#
The system calculates the minimum tolerance of an ingredient. The calculation takes into account the Measurement Capabilities of the selected Instruments and the selected BOM items. The calculation has the following steps:
- Calculate the Minimum Tolerance as the smaller of the distances between the Required Quantity and the Lower Limit, and between the Required Quantity and the Upper Limit. If the Required Quantity equals one of the limits, the Minimum Tolerance is the distance to the other limit.
- Divide the Minimum Tolerance by the value of the
PrecisionQuantumconfiguration entry. The result is the Adjusted Minimum Tolerance. -
If you do not set the precision test, calculate the Adjusted Minimum Tolerance with the following formula, where the Accuracy Quantum is the value of the
AccuracyQuantumconfiguration entry:
Info
The PrecisionQuantum and AccuracyQuantum entries are under /Cmf/System/Configuration/WeighAndDispense/. For more information, see Prerequisites.
Calculate the Quantities Automatically with a Rule#
A BOM item can use a Rule and its DEE Action to calculate the Lower Tolerance, the Required Quantity, and the Upper Tolerance.
- Create a Rule that returns the Lower Tolerance, the Required Quantity, and the Upper Tolerance in the units that the BOM defines. For more information, see Rule Page.
- In the BOM Items of the BOM, select the Rule in the Quantity Calculation Rule column of the item.
- Optionally, add a Note to the item with instructions for the operator.
When the operator begins weighing an ingredient with a Rule, the system calls the Rule and behaves as follows:
- If the Rule returns an error, the system shows the error to the operator and the operation cannot begin.
- If the Rule succeeds, the system updates the Lower Tolerance, the Required Quantity, and the Upper Tolerance on the page, and the operator can proceed.
A visual notation next to the ingredient indicates that the quantities come from a Rule.
Expected Result#
You know the quantity and the tolerance limits that the system expects for each ingredient. The next scenarios use these values.
Next Scenario#
Continue with Weigh and Dispense in a Single Step.
