Follow

How are Upper Level Demand Plan Edits Distributed to Lower Levels

When an edit is made at an upper level per the article Editing Demand Plans, the distribution of the edit follows a weighted distribution based on the middle out forecast type or pareto distribution if the forecast is top down. When a lower level period is already edited, the distribution is controlled by the system setting: "Redistribute forecast:"

The options for this setting are Yes or No and are described as follows.

How Edits are Distributed When a Demand Plan Period is Previously Edited

In S&OP Settings under System Settings, there is a setting called Redistribute Forecast that effects how upper level demand plan edits are applied when there are locked demand plan values at lower levels or when there are birth date, discontinue date, or do not forecasts applied to items.

Here is a simple example to describe how the aforementioned setting influences the result.

Per figure 1, lets assume there are 2 items A and B that are under an upper level hierarchical node named P and item B has been previously edited to 20 units. With the running of the pareto, DemandCaster had previously calculated that in a given period the disaggregation distribution percentage is 60% for A and 40% for B.

Now lets assume the plan for P is increased by 100 units in a given period. Per figure 2, if the Redistribute Forecast setting is on (set to yes) the entire 100 unit forecast will be distributed to A only. If there was no previous edit on B, then the distribution would have been distributed with 60 to item A and 40 to unit B per the disaggregation distribution percentage.

Per figure 3, if the Redristibute Forecast is off, then only 60 units would have been distributed to Item A and the balance of 40 would be discarded since item B was previously edited. Since the 40 is discarded, the 100 unit edit made against P would change to 60 since only the A portion was applied.

Redistribute Forecast Option set to YES

Now lets assume the plan for P is increased by 100 units in a given period. Per figure 2, if the Redistribute Forecast setting is on (set to yes) the entire 100 unit forecast will be distributed to A only. If there was no previous edit on B, then the distribution would have been distributed with 60 to item A and 40 to unit B per the disaggregation distribution percentage.

Redistribute Forecast Option set to NO

Per figure 3, if the Redistribute Forecast is off (set to NO), then only 60 units would be distributed to Item A and the balance of 40 would be discarded since item B was previously edited. Since the 40 is discarded, the 100 unit edit made against P would change to 60 since only the A portion was applied.

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk