Use the first 9 months to forecast for October 2019 using the
following than calculate Exponential smoothing
with αlpha=0.2
2019 Monthly Demand = [1,058,895] [1,098,476] [1,714,796]
[1,469,545] [2,141,204] [940,652] [1,471,479] [1,557,795]
[1,873,287]
Forecast for next month = Alpha * Actual of previous month +(1-Alpha) *Forecast of the previous month.
Since we don't have forecast for Month 1, we take it as actual
Month | Actual Sales | Exponential forecast, Alpha= 0.2 |
1 | 1058895 | 10,58,895 |
2 | 1098476 | 1058895.00 |
3 | 1714796 | 1066811.20 |
4 | 1469545 | 1196408.16 |
5 | 2141204 | 1251035.53 |
6 | 940652 | 1429069.22 |
7 | 1471479 | 1331385.78 |
8 | 1557795 | 1359404.42 |
9 | 1873287 | 1399082.54 |
OCT | 0.2*1873287+0.8*1399082.54=1493923.43 |
Get Answers For Free
Most questions answered within 1 hours.