How You Analyze Forecast Consumption
This topic explains how you can use the Past Due Gross Forecast measure to analyze forecast consumption in your replenishment plan. By using this measure, you can better understand how forecast is consumed before the plan start date.
You can specify optimal values for the Past Due Forecast Days and Past Due Sales Order Days fields on the Organizations tab on the Maintain Supply Network Model page by understanding the forecast consumption process.
In the rest of this topic, the use of this measure is explained, and some related points are provided.
Use the Past Due Gross Forecast Measure
Consider an example in which the value of the Past Due Forecast Days field is 3, the value of the Past Due Sales Order Days field is 3, and the plan start date is March 15.
The initial calculations for various measures when the replenishment plan is run and which aren't visible are listed in this table:
|
Measure |
March 12 |
March 13 |
March 14 |
March 15 |
March 16 |
March 17 |
March 18 |
|---|---|---|---|---|---|---|---|
|
Gross Forecast |
10 |
20 |
15 |
15 |
20 |
10 |
25 |
|
Net Forecast |
0 |
8 |
15 |
15 |
20 |
10 |
25 |
|
Sales Orders |
0 |
15 |
0 |
0 |
7 |
0 |
0 |
The final calculations for various measures when the replenishment plan is run and which are visible are listed in this table:
|
Measure |
March 12 |
March 13 |
March 14 |
March 15 |
March 16 |
March 17 |
March 18 |
|---|---|---|---|---|---|---|---|
|
Final Shipments Forecast |
10 |
20 |
15 |
15 |
20 |
10 |
25 |
|
Gross Forecast |
0 |
0 |
0 |
15 |
20 |
10 |
25 |
|
Past Due Gross Forecast |
0 |
0 |
0 |
45 |
0 |
0 |
0 |
|
Net Forecast |
0 |
0 |
0 |
38 |
20 |
10 |
25 |
|
Sales Orders |
0 |
0 |
0 |
15 |
7 |
0 |
0 |
|
Total Demand |
0 |
0 |
0 |
53 |
27 |
10 |
25 |
These points explain how you use the Past Due Gross Forecast measure to understand how the gross forecast is consumed:
-
When the replenishment plan is run on March 15, as shown in the first table, the sales orders of 22 units (15 + 7) consume 10 units of the gross forecast on March 12 and 12 on March 13. After this consumption, the net forecast is set to 8 units on March 13.
-
When the replenishment plan is run on March 15, note these calculations in the second table:
-
The past due net forecast is moved to that date and calculated as 38 units (8 + 15+ 15).
-
The gross forecast is always shown from the current date and is 15 units on March 15.
-
The Past Due Gross Forecast measure sums up the gross forecast before the plan start date and is 45 units (10 + 20 + 15) on March 15.
-
-
For clarity, you can calculate the total gross forecast as 60 units on March 15 (45 units for the Past Due Gross Forecast measure and 15 units for the Gross Forecast measure). When you subtract the sales orders of 22 units from the total gross forecast of 60 units, you get a figure of 38, which is the value of the net forecast.
Additional Information About the Use of the Past Due Gross Forecast Measure
Note these points about the use of the Past Due Gross Forecast measure:
-
If you're using a user-defined measure catalog, add this measure to the catalog.
-
Only forecasts that are after the start of the current plan bucket but before the plan start date are considered in the measure calculation.
Forecasts that are before the start of the current plan bucket but within the past due forecast days aren't considered in the measure calculation.
-
Open sales orders that are before the start of the current plan bucket but within the past due sales order days are carried over to the plan start date. These sales orders don't consume the forecast of the current bucket.
-
The past due forecast days and past due sales order days should be set to meaningful values.
If no values are specified for these fields, the values are considered to be zero.