Problem 1 (Note Use sheet called sales) Compute the forecast of the given sales projections (quarterly) using the following forecasting methods: a.) 3 month moving average forecast b.) 5 month moving average forecast c.) weighted moving average forecast with the given weights 0.5 (most recent), 0.3, and 0.2 d.) exponential smoothing with an alpha weight of .75 Compute the Mean Absolute Deviation/Error (MAD/MAE) for each forecasting method. Which is the better forecast method?

Year Quarter Sales 1 1 144 2 151 3 134 4 151 2 1 145 2 145 3 141 4 166 3 1 151 2 164 3 151 4 176 4 1 170 2 180 3 156 4 187 5 1 166 2 182 3 154 4 169