Year Month Sales

$($

$ millions

$)$

$2$

$0$

$1$

$7$

$$Jan $

$3$

$4$

$,$

$9$

$3$

$0$

$2$

$0$

$1$

$7$

$$Feb

$3$

$3$

$,$

$2$

$7$

$2$

$2$

$0$

$1$

$7$

$$Mar

$3$

$7$

$,$

$9$

$2$

$2$

$2$

$0$

$1$

$7$

$$Apr

$3$

$8$

$,$

$2$

$7$

$3$

$2$

$0$

$1$

$7$

$$May

$4$

$0$

$,$

$0$

$3$

$9$

$2$

$0$

$1$

$7$

$$Jun

$3$

$9$

$,$

$3$

$0$

$9$

$2$

$0$

$1$

$7$

$$Jul

$3$

$9$

$,$

$0$

$9$

$7$

$2$

$0$

$1$

$7$

$$Aug

$4$

$0$

$,$

$5$

$1$

$7$

$2$

$0$

$1$

$7$

$$Sep

$4$

$0$

$,$

$6$

$4$

$6$

$2$

$0$

$1$

$7$

$$Oct

$4$

$1$

$,$

$0$

$1$

$7$

$2$

$0$

$1$

$7$

$$Nov

$3$

$9$

$,$

$4$

$8$

$6$

$2$

$0$

$1$

$7$

$$Dec

$3$

$9$

$,$

$3$

$4$

$6$

$2$

$0$

$1$

$8$

$$Jan

$3$

$8$

$,$

$5$

$2$

$3$

$2$

$0$

$1$

$8$

$$Feb

$3$

$6$

$,$

$6$

$7$

$7$

$2$

$0$

$1$

$8$

$$Mar

$4$

$1$

$,$

$9$

$4$

$8$

$2$

$0$

$1$

$8$

$$Apr

$4$

$2$

$,$

$4$

$0$

$9$

$2$

$0$

$1$

$8$

$$May

$4$

$7$

$,$

$3$

$4$

$9$

$2$

$0$

$1$

$8$

$$Jun

$4$

$6$

$,$

$8$

$4$

$6$

$2$

$0$

$1$

$8$

$$Jul

$4$

$7$

$,$

$2$

$9$

$1$

$2$

$0$

$1$

$8$

$$Aug

$4$

$8$

$,$

$1$

$3$

$3$

$2$

$0$

$1$

$8$

$$Sep

$4$

$4$

$,$

$8$

$8$

$5$

$2$

$0$

$1$

$8$

$$Oct

$4$

$7$

$,$

$6$

$4$

$2$

$2$

$0$

$1$

$8$

$$Nov

$4$

$2$

$,$

$5$

$3$

$9$

$2$

$0$

$1$

$8$

$$Dec

$3$

$8$

$,$

$9$

$2$

$6$

$$ Click here for the Excel Data File

$$d

$.$

$$Evaluate a seasonally adjusted trend forecasting model. What is the MAD?

$($

Round your answers to

$3$

$$decimal places.

$)$

$$Fill out a table that has trend,index,forecast,and absolute error

e

$.$

$$What are the monthly indexes?

$($

Round your answers to

$3$

$$decimal places.

$)$

$$Fill out a table months

$1$

$-$

$1$

$2$

$$and indexes

f

$.$

$$Forecast sales for January, February, March, and April of

$2$

$0$

$1$

$9$

$.$

$($

Round your answers to

$2$

$$decimal places.

$)$