Use Trend Adjusted Exponential Smoothing formulas above to find Forecast for 1995-2004 and Calculate Error as Absolute value of Sales minus Forecast

Please show work in excel, I should be able to figure it out from there.

0.3 a = B = 0.3 At = Exponential smoothed average for time period "t" Tt = Exponential smoothed trend for time period "t". Dt = Actual demand in period "t" Ft+1 = Trend-adjusted forecast for time period "t+1" D = Sales Q = 0.1 = starting value for Trend 279.125 At = Dt for 1995 Forecast Error Sm MAD 1845 279.125 Year 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 Sales 1845 2088 2345 2876 2465 3266 3325 3972 4078 MAD Sm MAD 0.3 a = B = 0.3 At = Exponential smoothed average for time period "t" Tt = Exponential smoothed trend for time period "t". Dt = Actual demand in period "t" Ft+1 = Trend-adjusted forecast for time period "t+1" D = Sales Q = 0.1 = starting value for Trend 279.125 At = Dt for 1995 Forecast Error Sm MAD 1845 279.125 Year 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 Sales 1845 2088 2345 2876 2465 3266 3325 3972 4078 MAD Sm MAD