Old MathJax webview

you can solve it in excel, but please do not miss even step

you can estimate the trend, there is no exact answer

. Sunglasses A) You are given the monthly demand data about the last three years' sales of sunglasses at the end of this document. Analyze the data to determine an appropriate method for forecasting monthly demands. Steps (Following the Note of Forecasting" course document): Consider different forecasting methods that are applicable for the given data. Determine the initial parameter values of these methods based on the data available in the first two years. Compare these forecasting methods by calculating the one-step-ahead forecast errors in the third year. Use the MAD as the basis to compute forecast error. Find the most appropriate method and its parameter values. B) Using the best method found above, forecast the demand for January and February of the fourth year. Also, forecast the total demand over the fourth year. . Sunglasses: Year 1 89 105 55 55 82 Month January February March April May June July August September October November December 179 86 148 36 87 Year 2 116 4 48 86 70 0 103 143 107 44 2 100 Year 3 108 82 90 80 76 99 149 75 58 51 54 41 20 56 . Sunglasses A) You are given the monthly demand data about the last three years' sales of sunglasses at the end of this document. Analyze the data to determine an appropriate method for forecasting monthly demands. Steps (Following the Note of Forecasting" course document): Consider different forecasting methods that are applicable for the given data. Determine the initial parameter values of these methods based on the data available in the first two years. Compare these forecasting methods by calculating the one-step-ahead forecast errors in the third year. Use the MAD as the basis to compute forecast error. Find the most appropriate method and its parameter values. B) Using the best method found above, forecast the demand for January and February of the fourth year. Also, forecast the total demand over the fourth year. . Sunglasses: Year 1 89 105 55 55 82 Month January February March April May June July August September October November December 179 86 148 36 87 Year 2 116 4 48 86 70 0 103 143 107 44 2 100 Year 3 108 82 90 80 76 99 149 75 58 51 54 41 20 56