Period Actual Forecast Deviation Cumulative Absolute Deviation Deviation Cumulative Absolute Deviation MAD Tracking Signal Q1 100 Q2 105 Q3 110 04 90 Q5 110 Q6 120 Q7 130 QB a) Plot the data and use the linear fitting to determine the prediction line, interpret the R2 value. b] Use the weighted Moving average (3) with weights (4.2.1) to calculate the forecasts for Q8 c) Use the exponential smoothing with a = 0.7, calculate to calculate the forecasts for 08 d) Which technique you prefer to implement? Why? e) The company uses a tracking signal trigger of +4 to decide whether a forecast should be reviewed, determine in which period the forecast should be reviewed Excel