Example 2: Adjustment Calculation
Use the following criteria to perform an adjustment calculation:
Element |
Value |
---|---|
Total Transaction Quantity |
1505 |
Total New Quantity |
2000 |
Item Transaction Quantity |
155 |
New Quantity |
2 |
Multiplier Quantity |
9 |
Minimum Quantity |
170 |
The system completes the following steps to perform adjustment calculations:
-
Style item percentage = (155) ÷ (1505) * 100 = 10.29%
-
Style item calculated quantity = (10.29) * (2000) ÷ 100 = 205.8
-
Calculated value > Minimum Quantity = 205.8 > 170
-
(Rounded calculated quantity) = 22* 9= 198
(Rounded calculated quantity) = 23* 9= 207
Because 207 exceeds the calculated quantity of 205.8, 198 becomes the new quantity for the style items.