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. 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. 1e. (5 pts) 1f. (5 pts) Compared to the moving average method, do you think a forecasting method that corrects for trend Hint. Please check whether the demand history shows trend or seasonality. PLEASE DO NOT FORGET TO ANSWER THE SET OF QUESTIONS IN THE NEXT EXCEL TAB Q2: The quarterly demand (in thousands of units) for "Royale Beverages" headquartered in Casey Illinois, about 80 miles southeast of Urbana-Champaign, are listed in the table abov 2a. (20 pts) Forecast year 4 quarter 1 profit using Exponential Smoothing. Fill out the light gree cells in colume D. Note that the answer may contain empty cells. 2b. (10 pts) Compute the mean absolute deviation (MAD). Show your steps in colume E. 2c. (5 pts) Compared to the exponential smmothing 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. PLEASE DO NOT FORGET TO ANSWER THE SET OF QUESTIONS IN THE PREVIOUS EXCEL TAB