A manager uses a trend equation plus quarterly relatives $to$ predict demand. Quarter relatives are $SR1=0\mathrm{.}9,SR2=0\mathrm{.}95,SR3=1\mathrm{.}05,$ and $SR4=1\mathrm{.}1.$ The trend equation $is$: $Ft=8+4t.$ Over the past nine quarters, demand has been $as$ follows:

A manager uses a trend equation plus quarterly relatives $to$ predict demand. Quarter relatives are $S{R}_1=0\mathrm{.}9,S{R}_2=0\mathrm{.}95,S{R}_3=1\mathrm{.}05,$

and $S{R}_4=1\mathrm{.}1.$ The trend equation $is$: $F_t=8+4t.$ Over the past nine quarters, demand has been $as$ follows:

Click here for the Excel Data File

Compute the MAD and tracking signal for each period.

Note: Negative values should $be$ indicated $by$ a minus sign. Round your intermediate calculations and final answers $to3$ decimal

places.