## (answered) - Doug Moodie is the president of Garden Products Limited.

Doug Moodie is the president of Garden Products Limited. Over the last 5 years, his vice president of marketing has been providing the sales forecast using his special forecasting technique. The actual sales for the past ten years and the forecasts from the vice president of marketing are given below.

 Year Sales VP/Marketing Forecast 1 170,300 -- 2 168,250 -- 3 165,700 -- 4 169,000 -- 5 168,000 -- 6 167,300 170,000 7 175,250 170,000 8 172,500 180,000 9 156,700 180,000 10 176,300 160,000

Doug wonders if perhaps a weighted moving average or an exponential smoothing approach to forecasting might be better than having the vice president of marketing prepare the forecast. Doug wants to evaluate a three-period weighted moving average with weights of 0.30 and 0.15 for the second most recent and third most recent periods and the remaining weight(s) consistent with how we have used this method this term. He also wants to evaluate the exponential smoothing with an ? = 0.30 and a starting forecast for period 4 of 170,000 units.

a) Which of the three methods (weighted moving average, exponential smoothing and VP/Marketing) provides the best forecasting method if you were to evaluate these methods based on their forecasting accuracy for Years 6 through 10. Use one of the evaluation methods we have discussed.

b) What would be the forecast for Year 11 using both the weighted moving average and the exponential smoothing methods?

Solution details:
STATUS
QUALITY
Approved

This question was answered on: Sep 18, 2020

Solution~0001252009.zip (25.37 KB)

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

STATUS

QUALITY

Approved

Sep 18, 2020

EXPERT

Tutor