Question: QUESTION 27 An operation analyst is forecasting this year's demand for one of his company's products based on the following historical data: Year Quantity Sold

QUESTION 27 An operation analyst is forecasting

QUESTION 27 An operation analyst is forecasting this year's demand for one of his company's products based on the following historical data: Year Quantity Sold Four years ago 10,000 Three years ago 12,000 Two years ago 18,000 Last year 20,000 What is this year's forecast using a two-year weighted moving average with weights of.7(for a year ago) and 3 (for 2 years ago)? Formula: WMA, WA i = 1 where Wi = the weight for period i (between 0 and 100%) i= an index that corresponds to age of the period n=number of periods (data points) in the moving average Ai = actual value in period / WMAN = n period moving average 19,400 18,600 19,000 11,400 10,600

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!