Chapter $3-$ Forecasting

Using the following data, IN EXCEL complete the chart similar to Example #$3$ from our In$-$Class Problems and compute the MAD, MAPE and TRACKING SIGNAL. Then include what each of these means in terms of describing the forecast errors in this example. Note: Do not just repeat the definition of the forecast erros. Cut and paste your chart in your Homework Document. You must include formulas in your Excel file so I can see how you calculated each value.

$\backslash$table$[[$Monih$,$Forecest,$\backslash$table$[[$Afual$],[$Dethand$]],\backslash$table$[[$Deviatio$],[$n $($Frior$)]],$RSFE,$\backslash$table$[[$Abs$.],[$Dev$.],[$of$],[$Abs$.],[$Dev$.]],$MAD,TS$,],[$January$,105,110,,,,,,],[$February$,203,197,,,,,,],[$March$,305,256,,,,,,],[$April$,395,455,,,,,,],[$May$,422,510,,,,,,],[$June$,530,395,,,,,,],[$July$,400,240,,,,,,],[$August$,300,228,,,,,,],[\backslash$table$[[$Septembe$],[$r$]],200,150,,,,,,]]$