help

Below is a trend adjusted model fitted to quarterly revenues of a startup company Selling PowerDrink, a new energy drink geared toward college millennials. Based on the data and model below, answer the following questions. Alpha 20 Beta .30 t Data Forecast % error Smoothed 1,1400 1.156.8 1.1748 1.183.2 1,201.4 1.228 0 Trend 150 15.5 16.3 13.9 15 2 18 6 17 2 114 4.5 2.0 44 47 -5.4 -83 1.155 1 172 1.191 1.197 1,217 1.247 1.259 1 251 1.232 1 1.164 2 1,186 3 1.152 4 1.219 5 1,272 6 1.221 7 1,163 8 1.136 9 1,127 10 1,168 11 12 1.178 13 1.134 14 1.171 15 1,011 16 1.009 17 991 18 1 105 191.105 20 1.099 1063 22 1.070 23 1080 24 1.106 08 12 -3.4 1.8 43 2.1 -8.3 - 10.1 9 3 35 -03 1.239.8 1 228.0 1/2110 1 200 8 11954 1.188.4 1.173.2 1.166 2 1.128.6 1.091 4 1.052 6 1.041 0 1.035 4 1,034 2 1,0294 1 029 2 1033 6 - 16.8 22.9 -27.7 -229 -177 - 12.7 104 -73 -38 1.196 1.191 1.183 1.165 1.158 1.112 1.068 1025 1018 1.018 1.021 -43 05 - 14.5 -102 -78 72 79 SNS 5. Find the Error in Period 20. 6. Using the trend adjusted model above, with the alpha and beta values provided, develop a forecast for period 28. 7. Using the data in the model, develop a six period moving average for period 26. 8. Using the data in the model, develop a forecast for period 27 using a weighted moving average model with weights of 0.5, 0.2, 0.2, 0.1 (with the first weight on the most recent data). 9. Develop a tracking signal, based on periods 13 through 16. 10. Based on your tracking signal, the model appears to track the data: A. poorly B. okay C. Indicates nothing about the models tracking