Question: ID: Problem 4.14 FORECASTING A local retailer is considering using exponential smoothing to forecast the demand for one of his best- selling products. Based on

ID: Problem 4.14 FORECASTING A local retailer is
ID: Problem 4.14 FORECASTING A local retailer is considering using exponential smoothing to forecast the demand for one of his best- selling products. Based on the historical sales data given in the table, he must decide whether the value of the smoothing constant, should be 0.2 or 0.3. Week Actual 1 107 2 103 3 114 4 101 5 86 110 7 123 8 84 9 72 10 85 11 127 6 If the value of the smoothing constant is 0.2, the mean absolute deviation (MAD) of actual sales from the forecasted value (from the second week to the eleventh) is ?. For the first week, assume that the forecast is equal to the actual sales. If the value of the smoothing constant is 0.3, the mean absolute deviation (MAD) of actual sales from the forecasted value (from the second week to the eleventh) is 2. For the first week, assume that the forecast is equal to the actual sales. Based on the MAD values calculated earlier, for which value of the smoothing constant are the sales forecasts likely to be more accurate? Or, are both values likely to generate equally accurate results

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!