please use data given

Question 3 Week TimeSeries Value 1 2 3 4 5 6 238 294 266 322 252 224 280 252 308 280 210 308 7 8 9 10 11 12 3. Consider the sales given in Excel for Question 3. a. Apply moving average (MA), weighted moving average (WMA), exponential smoothing (ES). Have a sheet for each method and show your calculations in detail. Make sure you label your Excel sheets for each method such as "Question3_MA", "Question3_WMA" and "Question3_ES". Note you can use k and weights from the class notes. b. Compute the forecast accuracy using MAE, MSE, MAPE in Excel for each method. Make sure to report your results in Word using the following table format. Activity Moving Weighted Exponential Average Moving Smoothing Average MAE MSE MAPE C. Report your prediction for the next time period for each forecasting method. Moving Average Weighted Exponential Moving Smoothing Average Prediction