Question: Develop a Simple Exponential Smoothing Model (the SES tab) Develop a model that incorporates both a Trend and Seasonal adjustment (trend and seasonal tab). For

Develop a Simple Exponential Smoothing Model (the

  • Develop a Simple Exponential Smoothing Model (the SES tab)
  • Develop a model that incorporates both a Trend and Seasonal adjustment (trend and seasonal tab).
  • For your two models, develop a forecast for the four periods beyond your data.
  • For your two models calculate a MAD and Bias based on the last 12 periods of known data. Interpret your MAD and Bias for each mode

Year 1999 Qtr 1 Qtr2 Qtr3 Qtr4 Year 2004 3,007 3,264 3,318 3,632 13,220 2003 2,716 2,988 3,113 3,359 12,176 2002 2,574 2,737 2,759 2,947 11,016 2001 2,517 2,585 2,594 2,647 10,343 2000 2,590 2,586 2,570 2,579 10,325 1999 2,486 2,617 2,719 2,689 10,511 2000 Whirlpool Corporation 2001 4,000 3,500 Quarter Revenue Qtr 1 2,485 Qtr2 2,617 Qtr3 2,719 Qtr4 2,689 Qtr 1 2,590 Qtr2 2,586 Qtr3 2,570 Qtr4 2,579 Qtr 1 2,517 Qtr2 2,585 Qtr3 2,594 Qtr4 2,647 Qtr 1 2,574 Qtr2 2,737 Qtr3 2,759 Qtr4 2,947 Qtr 1 2,716 Qtr2 2,988 Qtr3 3,113 Qtr4 3,359 Qtr 1 3,007 Qtr2 3,264 Qtr3 3,318 Qtr4 3,630 3,000 2002 Revenue 2,500 2,000 1,500 1,000 2003 500 0 0 atr1 Qtr2 Qtr3 Qtr4 Qtr1 Qtr2 Qtr3 Qtr4 Qtri Qtr2 Qtr3 Qtr4 Qtr1 Qtr2 Qtr3 Qtr4 Qtr1 Qtr2 Qtr3 Qtr4 Qtr1 atr2 Qtr3 Qtr4 2004 1999 2000 2001 2002 2003 2004 Time

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!