The classified department of a monthly magazine has used a combination of quantitative and qualitative methods...

Transcribed Image Text:

The classified department of a monthly magazine has used a combination of quantitative and qualitative methods to forecast sales of advertising space. Results over a 20-month period are as follows: Honth Error Honth Error -7 11 -2 12 13 14 15 1 2 3 -4 -12 -3 BEBESTRONE 12 5 13 13 14 15 16 17 3 18 Click here for the Excel Data File a. Compute a tracking signal for months 11 through 20. To do so, compute an initial value of MAD for month 11, and then update it for each month using exponential smoothing with a 4. (Leave no cells blank-be certain to enter "0" wherever required. Negative values should be indicated by a minus sign. Round your Intermediate calculations and final answers to 3 decimal places.) 19 4 0 Month The initial MAD Tracking signal 11 20 16 17 2 ✔ 12 Controllimis 5 1 J -5 18 -7 19 -2 b-1. Using the first half of the data, construct a control chart with 2s limits. (Round your Intermediate calculations to 3 decimal places and final answer to 2 decimal places) 01 b-2. What can you conclude? Only the error for month 9 is outside of the limits. O Only the error for month 5 is outside of the limits. All errors are within these limits. The classified department of a monthly magazine has used a combination of quantitative and qualitative methods to forecast sales of advertising space. Results over a 20-month period are as follows: Honth Error Honth Error -7 11 -2 12 13 14 15 1 2 3 -4 -12 -3 BEBESTRONE 12 5 13 13 14 15 16 17 3 18 Click here for the Excel Data File a. Compute a tracking signal for months 11 through 20. To do so, compute an initial value of MAD for month 11, and then update it for each month using exponential smoothing with a 4. (Leave no cells blank-be certain to enter "0" wherever required. Negative values should be indicated by a minus sign. Round your Intermediate calculations and final answers to 3 decimal places.) 19 4 0 Month The initial MAD Tracking signal 11 20 16 17 2 ✔ 12 Controllimis 5 1 J -5 18 -7 19 -2 b-1. Using the first half of the data, construct a control chart with 2s limits. (Round your Intermediate calculations to 3 decimal places and final answer to 2 decimal places) 01 b-2. What can you conclude? Only the error for month 9 is outside of the limits. O Only the error for month 5 is outside of the limits. All errors are within these limits.

Answer rating: 100% (QA)

The image shows a homework assignment or a problem set that looks like its related to forecasting sales for the classified department of a monthly mag... View the full answer