You want to use a fruit premix with varying fruit content and water to produce a fruit juice whose fruit content is always 5 %. During order processing, you always want to use the fruit premix batch with the earliest expiration date. Depending on the fruit content of this batch, you want the system to adjust the quantity of water in such a way that the fruit content intended for the fruit juice is obtained.

You define active ingredient management for the material Fruit premix with the following specifications:

• You classify the material and its batches with a batch class that contains characteristic Fruit content.

• For the batch determination for material Fruit premix, you define a batch search strategy that allows batch determination based on proportion quantities. You use the expiration date and the allowed interval defined for the fruit content as selection criteria for determining the batch.

In the BOM, you enter the required component quantities with reference to a base quantity of the product Fruit juice. For the fruit premix, you use the proportion unit LF, which means that you do not enter the physical quantity of the fruit premix but the fruit quantity it must contain.

The quantities and the characteristic values of material classification are transferred to the Material Quantity Calculation screen in the master recipe. The following data is displayed, for example:

The absolute fruit content that is required in the fruit premix changes in proportion to the fruit juice quantity. You therefore need not enter a formula for the fruit premix:

To obtain the intended fruit content of the fruit juice, you must, however, balance variations in the percent fruit content of the fruit premix. This means that you must adjust the quantity of water. This adjustment is not in proportion to the fruit juice quantity. The following relationship applies:

You can calculate the physical quantity of the fruit premix as follows in the master recipes:

For the system to be able to correctly calculate the physical quantity of the fruit premix after the batch determination and maybe even a batch split in the order, it must calculate the quotient sum of all fruit premix batches. For this reason, you must enter the following formula for the water:

In the order, the material data is processed as follows:

1. You create a process order for an order quantity or fruit juice quantity of 500 l for example.
2. The system calculates the following:

• The required fruit premix quantity in the proportion unit LF in proportion to the fruit juice quantity
• The required quantity of water using the formula

3. You carry out batch determination for the material Fruit premix. Since the batch with the earliest expiration date only covers part of the requirement, you use the following:

• 20 % LF of a batch with 20 % fruit content
• 5 LF of a batch with 15 % fruit content

4. You start material quantity calculation. The system now updates the quantity of water using the formula and batch data.