Understanding Adjustment Calculations

You use the Material Analysis program to adjust the style item quantities on work orders. The Adjustment Calculation form displays the transaction quantity for each child style item and the total quantity for all style items.

The system uses values in the Total Transaction Quantity, New Quantity, Multiplier Quantity, and Minimum Quantity fields to perform adjustment calculations and then updates the quantity of each child style item.

The system completes the following steps to perform adjustment calculations:

1. Calculates the percentage of each style item based on the total transaction quantity.

   Style item percentage = (Item transaction quantity) ÷ (Total transaction quantity) * 100

2. Distributes the new quantity among the style items.

   Style item calculated quantity = (Style item percentage) * (Total new transaction quantity) ÷ 100

3. Compares and verifies that the calculated value is greater than the value in the Minimum Quantity field.

   Calculated value > Minimum Quantity

4. Rounds the calculated quantity so that the value is a multiplier of the value in the Multiplier Quantity field.

   For example, 185 is a multiple of 5. (Rounded calculated quantity) = 37 * 5 = 185

   The rounded calculated value is the final value. This is the new quantity for the style items.

You can also select Automatic Split from the Form menu on the Adjustment Calculation form to distribute the new quantity among the items proportionately. Minimum and multiplier quantity constraints are applied after the automatic splitting occurs.