About SVP Algorithms
The following two algorithms are available in the SVP module:
Percentage Change. Modifies the source value by a percentage and populates the target proportionately. A period definition is not required.
Trended Volume Period. Compares the value in the Trended Volume Period to the value in the Source Period to obtain a variance, and uses this variance to extrapolate the value in the target period. A period definition is required. The following table shows an example of trended volume period calculations.
| Source Period | Trended Volume Period | Variance | Target Period |
|---|---|---|---|
Start: Week 1, 1998 (Quantity:100) |
Start: Week 1, 1999 (Quantity: 110) |
10% increase (from source period to trended volume period) |
Start: Week 1, 2000 (Quantity: 121) Apply Variance to the value in the trended volume period to obtain the value in the target period. |
End: Week 2, 1998 (Quantity:100) |
End: Week 2, 1999 (Quantity: 90) |
10% decrease (from source period to trended volume period) |
End: Week 2, 2000 (Quantity: 81) Apply Variance to the value in the trended volume period to obtain the value in the target period. |