Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.35 and 0.20 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.25 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 7 through 10. Use one of the evaluation methods we have studied this term.

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Marketing And Export Management

Authors: Gerald Albaum , Alexander Josiassen , Edwin Duerr

8th Edition

1292016922, 978-1292016924

More Books

Students also viewed these General Management questions

Question

understand possible effects of lifestyle risk factors;

Answered: 1 week ago