View Share Window Help 126% Zoom + Add Page MGT 413 CHAPTER 4 ASSIGNEMENT 2 T Chart Text Shape Media Comment Insert Table THE FOLLOWING TABLE IS FOR PROBLEMS 1 TO 6. Month Actual Sales Forecast January February March April May June 24 28 27 32 36 44 25 30 31 34 33 45 1. 2. 3. 4. What is the 4-month moving average forecast for July? Using a weighted 4-month moving average, with a weight of 0.4 for the most recent value and weights of 0.3, 0.2 and 0.1 for successively older sales data, obtain the forecast for July. Use single exponential smoothing with a smoothing constant of .65 to forecast sales for July. Calculate the MAD measure of accuracy for the forecasts in the Table above. Calculate the MSE measure of accuracy for the forecasts in the Table above. Calculate the MAPE measure of accuracy for the forecasts in the Table above. House Depot Inc. has accumulated data relating the number of furnaces sold to the number of times their advertisement appeared on television the previous week. Using the data, develop a simple linear regression model to predict sales for a week following the one during which they advertised four times on television 5. 6 7. Number of TV Adverts 2 5 Units Sold (y) I 26 14 24 33 5 6 3