Problem 3-34 (Algo) A manager uses a trend equation plus quarterly relatives to predict demand Quarter relatives are SR -0.9, SR, -0.95, SR;=105 and SR = 11 The trend equation is Ft= 12 +41 Over the past nine quarters, demand has been as follows Periodi Demand: 5 6 15 20 25 28 31 33 7 8 9 39 41 47 Click here for the Excel Data File Compute the MAD and tracking signal for each period (Negative values should be indicated by o minus sign. Round your intermediate calculations and final answers to 3 decimal places.) Answer is complete but not entirely correct. Period MAD 1 2 3 4 15 20 25 28 31 33 39 41 47 5 Tracking slonal 1.000 2000 (1.000) (3143) (1410) (1 800) (3.733) (5691) (3879) 0.600 0.300 0.600 1.400 3 1560 3 1333 1714 2425 25783 6 7 8 9