The following example shows the calculation of the demand estimation for month 24 concerning a part with the following history:
History of Months/Demand - Month 24 is the current month | |||
Months | Demand | Months | Demand |
1 | 100 | 13 | 200 |
2 | 200 | 14 | 300 |
3 | 300 | 15 | 400 |
4 | 200 | 16 | 300 |
5 | 100 | 17 | 300 |
6 | 200 | 18 | 400 |
7 | 300 | 19 | 500 |
8 | 200 | 20 | 400 |
9 | 100 | 21 | 400 |
10 | 200 | 22 | 500 |
11 | 300 | 23 | 600 |
12 | 200 | 24 | ? |
To prepare the estimation for the month 24, you simulate the months 21, 22, 23 do not exist, apply the formulas to estimate the demand of these periods, and identify the formula that adheres to this situation the most.
...