Make forecasts for months 9-12 and calculate MSE, MAD, and MAPE for each of the forecasting techniques.
You are not sure that the forecasting technique that your company is using is correct for two items that you manage. At this time you want to consider several new options and pick the one that reduces the amount of forecast error. To accomplish this task you will use the data listed below. Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 Speakers 22 29 32 33 25 20 30 32 32 37 35 26 Backup cameras 55 64 69 71 68 71 69 76 71 83 80 77 Step 1. Use the first 8 months of data (Month 1-8) to develop a forecast for Month 9 using 1 month moving average, 3 month moving average, Exponential Smoothing (alpha=.2), Exponential Smoothing (alpha=.4), and linear regression. For Exponential Smoothing you can use the fore casted value of 70 for month 8 for backup cameras and 30 for speakers. Please note that in this step you are pretending like you do not have the information for months 9-12 because you are holding this information aside to test what would have happened using your forecasting techniques. 2. Make forecasts for months 9-12 and calculate MSE, MAD, and MAPE for each of the forecasting techniques. 3. Based on your analysis, make a recommendation to the Operations Manager for which forecasting technique you should use for each of the two items and state why. You should include graphics to support your recommendation. The paper does not have to be in APA format, but it should be professionally written, 12 point font, Times New Roman or Arial, appropriate headers, etc.