Problem 1 (Note Use sheet called sales) Year Quarter Sales 1 1 144 Compute the forecast ofthe given sales projections (quarterly) using the following forecasting methods: 2 151 a.) 3 month moving average forecast 3 134 b.) 5 month moving average forecast 4 151 c.) weighted moving average forecast with the given weights 0.5 (most recent), 0.3, and 0.2 2 1 145 d.) exponential smoothing with an alpha weight of .T5 2 145 141 Compute the Mean Absolute DeviationlError (MADIMAE) for each forecasting method. 155 151 164 151 175 17E] 130 155 187' 166 182 154 169 Which is the better forecast method? wNLthLthL