Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 MADStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started