Example of Proportional Factors in Interactive Forecasting

This is what is stored in the planning area:

 Month Region Product APODPDANT 092000 East 1 10 092000 East 2 20 092000 East 3 30 092000 East 4 40 092000 East 5 50 102000 East 1 1 (default value) 102000 East 2 1 (default value) 102000 East 3 1 (default value) 102000 East 4 1 (default value) 102000 East 5 1 (default value)

On the demand planning desktop, this is what you see in the proportional maintenance screen for the characteristic Product and the month 09/2000.

 Product UoM 09/2000 10/2000 Total % 100 - 1 % 6.67 - 2 % 13.33 - 3 % 20.00 - 4 % 26.67 - 5 % 33.33 -

Depending on the structure of the planning area, there may be several characteristic value combinations behind the chosen level (in this example, the chosen level is Product). Each characteristic value combination has a proportional factor stored for it in APODPDANT.

You change the proportional factor of product 3 from 20 to 10 in the month of September. This is the result you see on the demand planning desktop:

 Product UoM 09/2000 Total % 100 1 % 7.50 2 % 15.00 3 % 10.00 4 % 30.00 5 % 37.50

You change the proportional factor of product 4 from 30 to 70. This is the result you see on the demand planning desktop:

 Product UoM 09/2000 Total % 100 1 % 2.50 2 % 5.00 3 % 10.00 4 % 70.00 5 % 12.50

You enter a proportional factor of 20 for product 5 in the month of October. The number changes to 100. This is the result you see on the demand planning desktop:

 Product UoM 09/2000 10/2000 Total % 100 100 1 % 2.50 - 2 % 5.00 - 3 % 10.00 - 4 % 70.00 - 5 % 12.50 100

Now you enter the proportional factors that you would like to have for the month of October.

First, you enter a proportional factor of 20 for product 1. The system fixes this factor. The factor of 100 for product 5 is adjusted automatically, but is not fixed:

 Product UoM 09/2000 10/2000 Total % 100 100 1 % 2.50 20 2 % 5.00 - 3 % 10.00 - 4 % 70.00 - 5 % 12.50 80

Next, you enter a proportional factor of 30 for product 2. The system fixes this factor. The factor of 80 for product 5 is adjusted automatically, but is not fixed:

 Product UoM 09/2000 10/2000 Total % 100 100 1 % 2.50 20 2 % 5.00 30 3 % 10.00 - 4 % 70.00 - 5 % 12.50 50

The proportional factors are saved when you save the plan.