Siebel Consumer Goods Guide > Sales Volume Planning >

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. Table 11 shows an example of trended volume period calculations.
    Table 11. 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.

Siebel Consumer Goods Guide Copyright © 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices.