Examples of Forecast Processing in Replenishment Plans
This topic provides examples of forecast processing in replenishment plans with various planning time levels, forecasting time levels, and calendars.
Example 1
In this example, the replenishment plan has a daily planning time level and forecasting time level. In the manufacturing calendar for the item-location combination, all days of the week are working days.
|
|
Day 1 |
Day 2 |
Day 3 |
Day 4 |
Day 5 |
Day 6 |
Day 7 |
Day 8 |
Day 9 |
Day 10 |
Day 11 |
Day 12 |
Day 13 |
Day 14 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Demand Forecast |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
15 |
15 |
15 |
15 |
15 |
15 |
15 |
|
Spread Forecast |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
15 |
15 |
15 |
15 |
15 |
15 |
15 |
|
Sales Orders |
0 |
0 |
30 |
0 |
5 |
0 |
0 |
20 |
0 |
5 |
0 |
0 |
0 |
0 |
|
Net Forecast |
0 |
0 |
0 |
5 |
10 |
10 |
10 |
0 |
5 |
15 |
15 |
15 |
15 |
15 |
|
Total Demand |
0 |
0 |
30 |
5 |
15 |
10 |
10 |
20 |
5 |
20 |
15 |
15 |
15 |
15 |
Note these points:
-
The sales orders start consuming the forecast from Day 1.
-
The sales orders of 30 units on Day 3 consume the spread forecast (stored in the Gross Forecast measure) on Days 1 through 3. The net forecast is zero on Days 1 through 3.
-
The sales orders of 5 units on Day 5 consume the spread forecast on Day 4. The net forecast is 5 units on Day 4.
-
The sales orders of 20 units on Day 8 consume the spread forecast on Days 8 and 9. The net forecast is zero on Day 8 and 10 units on Day 9.
-
The sales orders of 5 units on Day 10 consume the remaining spread forecast of 10 units on Day 9. The net forecast on Day 9 is 5 units, and the spread forecast and net forecast on Day 10 remain unchanged.
Example 2
In this example, the replenishment plan has a daily planning time level and forecasting time level. In the manufacturing calendar for the item-location combination, only five days of the week are working days.
|
|
Day 1 |
Day 2 |
Day 3 |
Day 4 |
Day 5 |
Day 6 |
Day 7 |
Day 8 |
Day 9 |
Day 10 |
Day 11 |
Day 12 |
Day 13 |
Day 14 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Demand Forecast |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
15 |
15 |
15 |
15 |
15 |
15 |
15 |
|
Spread Forecast |
10 |
10 |
10 |
10 |
30 |
0 |
0 |
15 |
15 |
15 |
15 |
45 |
0 |
0 |
|
Sales Orders |
0 |
0 |
30 |
0 |
5 |
0 |
0 |
20 |
0 |
5 |
0 |
0 |
0 |
0 |
|
Net Forecast |
0 |
0 |
0 |
5 |
30 |
0 |
0 |
0 |
5 |
15 |
15 |
45 |
0 |
0 |
|
Total Demand |
0 |
0 |
30 |
5 |
35 |
0 |
0 |
20 |
5 |
20 |
15 |
45 |
0 |
0 |
Note these points:
-
The sales orders of 30 units on Day 3 consume the spread forecast (stored in the Gross Forecast measure) on Days 1 through 3. The net forecast is zero on Days 1 through 3.
-
The sales orders of 5 units on Day 5 consume the spread forecast on Day 4. The net forecast is 5 units on Day 4.
-
Days 6 and 7 are nonworking days, and the spread forecast for these days is added to that on Day 5 (10 + 10 + 10).
-
The sales orders of 20 units on Day 8 consume the spread forecast on Days 8 and 9. The net forecast is zero on Day 8 and 10 units on Day 9.
-
The sales orders of 5 units on Day 10 consume the remaining spread forecast of 10 units on Day 9. The net forecast on Day 9 is five units, and the spread forecast and net forecast on Day 10 remain unchanged.
-
Days 13 and 14 are nonworking days, and the spread forecast for these days is added to that on Day 12 (15 + 15 + 15).
Example 3
In this example, the replenishment plan has a daily planning time level and weekly forecasting time level. In the manufacturing calendar for the item-location combination, all days of the week are working days.
|
|
Day 1 |
Day 2 |
Day 3 |
Day 4 |
Day 5 |
Day 6 |
Day 7 |
Day 8 |
Day 9 |
Day 10 |
Day 11 |
Day 12 |
Day 13 |
Day 14 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Demand Forecast |
0 |
0 |
0 |
0 |
0 |
0 |
70 |
0 |
0 |
0 |
0 |
0 |
0 |
105 |
|
Spread Forecast |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
15 |
15 |
15 |
15 |
15 |
15 |
15 |
|
Sales Orders |
0 |
0 |
30 |
0 |
5 |
0 |
0 |
20 |
0 |
5 |
0 |
0 |
0 |
0 |
|
Net Forecast |
0 |
0 |
0 |
5 |
10 |
10 |
10 |
0 |
5 |
15 |
15 |
15 |
15 |
15 |
|
Total Demand |
0 |
0 |
30 |
5 |
15 |
10 |
10 |
20 |
5 |
20 |
15 |
15 |
15 |
15 |
Note these points:
-
The demand forecast for 70 units in the first week is spread across seven days (10 units per day).
-
The sales orders of 30 units on Day 3 consume the spread forecast (stored in the Gross Forecast measure) on Days 1 through 3. The net forecast is zero on Days 1 through 3.
-
The sales orders of 5 units on Day 5 consume the spread forecast on Day 4. The net forecast is 5 units on Day 4.
-
The demand forecast for 105 units in the second week is spread across seven days (15 units per day).
-
The sales orders of 20 units on Day 8 consume the spread forecast on Days 8 and 9. The net forecast is zero on Day 8 and 10 units on Day 9.
-
The sales orders of 5 units on Day 10 consume the remaining spread forecast of 10 units on Day 9. The net forecast on Day 9 is five units, and the spread forecast and net forecast on Day 10 remain unchanged.
Example 4
In this example, the replenishment plan has a daily planning time level and forecasting time level. In the manufacturing calendar for the item-location combination, all days of the week are working days. The values of the Past Due Forecast Days and Past Due Sales Order Days fields on the Organizations tab on the Maintain Supply Network Model page for the organization are 2. The replenishment plan is run on Day 4.
|
|
Day 1 |
Day 2 |
Day 3 |
Day 4 |
Day 5 |
Day 6 |
Day 7 |
Day 8 |
Day 9 |
Day 10 |
Day 11 |
Day 12 |
Day 13 |
Day 14 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Demand Forecast |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
15 |
15 |
15 |
15 |
15 |
15 |
15 |
|
Spread Forecast |
0 |
0 |
0 |
30 |
10 |
10 |
10 |
15 |
15 |
15 |
15 |
15 |
15 |
15 |
|
Sales Orders |
0 |
0 |
30 |
0 |
5 |
0 |
0 |
20 |
0 |
5 |
0 |
0 |
0 |
0 |
|
Net Forecast |
0 |
0 |
0 |
0 |
5 |
10 |
10 |
0 |
5 |
15 |
15 |
15 |
15 |
15 |
|
Total Demand |
0 |
0 |
0 |
30 |
10 |
10 |
10 |
20 |
5 |
20 |
15 |
15 |
15 |
15 |
Note these points:
-
The spread forecast (stored in the Gross Forecast measure) on Days 2 through 3 is carried over to Day 4, which is the plan start date. The total spread forecast on Day 4 is 30 (10 + 10 + 10). The spread forecast on Day 1 isn't considered because the Past Due Forecast Days field is set to 2.
On Day 4, the value of the Gross Forecast measure is 10 units, and the value of the Past Due Gross Forecast measure is 20 units.
-
The sales orders of 30 units on Day 3 are carried over to Day 4, which is the plan start date.
The sales orders of 30 units on Day 4 consume the spread forecast on Day 4. The net forecast is zero units on Day 4.
-
The sales orders of 5 units on Day 5 consume the spread forecast on Day 5. The net forecast is 5 units on Day 5.
-
The sales orders of 20 units on Day 8 consume the spread forecast on Days 8 and 9. The net forecast is zero on Day 8 and 10 units on Day 9.
-
The sales orders of 5 units on Day 10 consume the remaining spread forecast of 10 units on Day 9. The net forecast on Day 9 is five units, and the spread forecast and net forecast on Day 10 remain unchanged.
Example 5
In this example, the replenishment plan has a weekly planning time level and forecasting time level. In the manufacturing calendar for the item-location combination, all days of the week are working days.
|
|
Day 1 |
Day 2 |
Day 3 |
Day 4 |
Day 5 |
Day 6 |
Day 7 |
Day 8 |
Day 9 |
Day 10 |
Day 11 |
Day 12 |
Day 13 |
Day 14 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Demand Forecast |
0 |
0 |
0 |
0 |
0 |
0 |
70 |
0 |
0 |
0 |
0 |
0 |
0 |
105 |
|
Spread Forecast |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
15 |
15 |
15 |
15 |
15 |
15 |
15 |
|
Sales Orders |
0 |
0 |
30 |
0 |
5 |
0 |
0 |
20 |
0 |
5 |
0 |
0 |
0 |
0 |
|
Net Forecast |
0 |
0 |
0 |
5 |
10 |
10 |
10 |
0 |
5 |
15 |
15 |
15 |
15 |
15 |
|
Weekly Net Forecast |
0 |
0 |
0 |
0 |
0 |
0 |
35 |
0 |
0 |
0 |
0 |
0 |
0 |
80 |
|
Total Demand |
0 |
0 |
0 |
0 |
0 |
0 |
70 |
0 |
0 |
0 |
0 |
0 |
0 |
105 |
Note these points:
-
The demand forecast for 70 units in the first week is spread across seven days (10 units per day).
-
The sales orders of 30 units on Day 3 consume the spread forecast (stored in the Gross Forecast measure) on Days 1 through 3. The net forecast is zero on Days 1 through 3.
-
The sales orders of 5 units on Day 5 consume the spread forecast on Day 4. The net forecast is 5 units on Day 4.
-
The demand forecast for 105 units in the second week is spread across seven days (15 units per day).
-
The sales orders of 20 units on Day 8 consume the spread forecast on Days 8 and 9. The net forecast is zero on Day 8 and 10 units on Day 9.
-
The sales orders of 5 units on Day 10 consume the remaining spread forecast of 10 units on Day 9. The net forecast on Day 9 is five units, and the spread forecast and net forecast on Day 10 remain unchanged.
-
The net forecast is aggregated at the ends of the weekly buckets.