Forecasting Exercise: Double Exponential Smoothing (Exponential Smoothing with Trend Adjustment)
Given the following demand data and the parameters (highlighted in yellow):
a. Calculate FITt for periods 2 to 9 by using the double exponential smoothing method. Keep your answers in 2 decimals and highlight them in green.
b. Assess the accuracy of your forecasts by using MAD. Keep your answer in 2 decimals and highlight it in red.
Parameters:
alpha = 0.3
beta = 0.2
Period At Ft Tt FITt Error ABS|E|
1 120 110.00 10.00 120.00
2 136
3 143
4 158
5 163
6 172
7 185
8 192
9
MAD =