Management Would Like Experiment Forecasting Models Determine Used New System Implemented Q34316126

Management would like you to experiment with some forecastingmodels to determine what should be used in a new system to beimplemented. The new system is

WEEK12345678910111213AVERAGEAtlanta   33   45   37   38   55   30   18   58   47   37   23   55   40   40Boston   26   35   41   40   46   48   55   18   62   44   30   45   50   42Chicago   44   34   22   55   48   72   62   28   27   95   35   45   47   47Dallas   27   42   35   40   51   64   70   65   55   43   38   47   42   48LA   32   43   54   40   46   74   40   35   45   38   48   56   50   46Total162199189213246288245204236257174248229222

Consider using a simple moving average model. Experiment withmodels using five weeks’ and three weeks’ past data. The past datain each region are given below (week –1 is the week before week +in the table, –2 is two weeks before week 1, etc.). Evaluate theforecasts that would have been made over the 13 weeks using theoverall (at the end of the 13 weeks) mean absolute deviation, meanabsolute percent error, and tracking signal as criteria.

WEEK–5–4–3–2–1Atlanta   45   38   30   58   37Boston   62   18   48   40   35Chicago   62   22   72   44   48Dallas   42   35   40   64   43LA   43   40   54   46   35Total254153244252198

2Next, consider using

OR

 

PayPal Gateway not configured

OR

 

PayPal Gateway not configured