1a. (15 pts) Use the moving average method (N=1) to forecast sales for each period. Fill out the light gree cells in colume D. Note that the answer may contain empty cells. 1b. (10 pts) Compute the mean absolute deviation (MAD). Show your steps in colume E. \begin{tabular}{|l|r|} \hline MAD & 1,747 \\ \hline \end{tabular} 1c. (20 pts) Use the moving average method (N=3) to forecast sales for each period. Fill out the light gree cells in colume F. Note that the answer may contain empty cells. 1d. (10 pts) Compute the mean absolute deviation (MAD). Show your steps in colume G. \begin{tabular}{|l|r|} \hline MAD & 1,806 \\ \hline \end{tabular} 1e. (5 pts) Which forecasting method is more accurate based on MAD, MA(1) or MA(4) ? Why? The forecasting method for MAD with n=1 period is more accurate. This is because the 1f. (5 pts) Compared to the moving average method, do you think a forecasting method that corrects for trend and seasonality can provide better forecast? Why? Hint. Please check whether the demand history shows trend or seasonality. Yes. PLEASE DO NOT FORGET TO ANSWER THE SET OF QUESTIONS IN THE NEXT EXCEL TAB PLEASE DO NOT FORGET TO ANSWER THE SET OF QUESTIONS IN THE PREVIOUS EXCEL TAB