Question

The business analyst for Video Sales, Inc. wants to forecast this year's demand for DVD decoders based on the following historical data: Year Enrollments 5 Years ago 900 4 Years ago 700 3 Years ago 600 2 Years ago 500 Last Year 300 What is the forecast for this year using a three-year weighted moving average with weights of 0.5, 0.3, and 0.2?a) 163.
b) 180.
c) 300.
d) 420.
e) 510.

Answer 1

Answer:

d) 420

Explanation:

In three-year weighted moving average with weights of 0.5, 0.3, and 0.2, the forecast can be calculated using the following formula

Forecast(This year) = 0.5*Demand(last year) + 0.3*Demand(2 years ago) + 0.2*Demand(3 years ago)

Forecast(This year) = 0.5*300 + 0.3*500 + 0.2*600

Forecast(This year) = 150 + 150 + 120

Forecast(This year) = 420