Module 2 Forecasting Assignmen... Student Name: Taiwan Pope 1. Problem 1 The following data describe the monthly volume for an urban courier service. Data are in thousands of pieces handled. a. Calculate both the 3-month and 5-month simple moving average (SMA) forecast for this data within the data table using Excel formulas. Select the appropriate starting month for each. b. Calculate the mean error for both the 3-month and 5-month SMA forecasts within the table below. c. Select the best forecast based upon mean error. Enter choice of best forecast and reason for its choice below. Best forecast: (Enter your recommendation here) Why? (Enter your explanation here) 2. Problem 2 Listed below are the number of movie tickets sold at the Library Cinema-Complex, in thousands, from the period 2007 to 2019. b. Determine the mean absolute deviation (MAD) for this forecast within the table, below. 3. Problem 3 The data in the following table describe U.S. manufacturers' shipments of general aviation jet aircraft from 1979 through 1998 a. Build a simple exponential forecast with for all the years presented within the table. b. Build a simple exponential forecast with for all the years presented within the table. c. Compute the mean absolute deviation (MAD) for both forecasts and compare. Based on the MAD, which is best and why? Module 2 Forecasting Assignmen... 2. Problem 2 Listed below are the number of movie tickets sold at the Library Cinema-Complex, in thousands, from the period 2007 to 2019. a. Compute a four-year weighted moving average, starting in year 2011, using weights of Done