Question 3. Ice cream production (35 points) Consider the total production (and sales) of ice cream in Canada (in millions of liters) for a period of 13 years until 2019 (from left to right) 341, 331, 317, 315, 321, 278, 298, 311, 302, 302, 335, 320, 285 Fit a model to ice cream production data using each of the following techniques and forecast the 2020 production in each case. a) Two-year moving average. (3 point) b) Four-year moving average. (3 point) c) Exponential smoothing with smoothing constant = 0.2. (5 point) d) Exponential smoothing with smoothing constant = 0.4. (5 point) e) Linear trend projection (linear regression). (10 point) f) Plot a graph and determine which of the above techniques would you use to forecast the ice cream production and why? (Hint: The plot overall closest to actual demand will be most accurate). (4 point) g) Alternatively, compute the MAD for each forecasting technique and determine the most accurate technique. (5 point) Question 4. Forecasting Residential Homes (25 points) Data report (refer to the Excel file) the number of new constructions for residential homes, per month, in thousands, from 2013 to 2018 in the state of Oregon. a) Prepare a graph of the data. (4 point) b) Compute forecasts for the twelve months of 2019 using linear regression. (7 point) c) Prepare a graph of the forecast data. (4 point) d) Compute the MAD of your model. (5 point) e) Compute and chart the tracking signal. (5 point) Hint: You can use the Excel template of the similar example in the slides. Accessibility: Unavailable DELL what - came 1:00 Room Car make - And : Phone Mur - Car Colon Blue 1-10-21 - Their phone number 613-415-1056 - Are they reporting it Complaine Notes - Where was car parked ! Darling Solutions) Wa the ste