Question: A company uses the simple moving average technique using the latest three data points to do its forecasting. Its actual results and its forecasts are

A company uses the simple moving average technique using the latest three data points to do its forecasting. Its actual results and its forecasts are shown below.

Month

Actual

Forecast

Absolute Deviation

1

4

2

6

3

7

4

9

5.67

3.33

5

11

7.33

3.67

Calculate the Mean Absolute Deviation for months 4 and 5.

One of its engineers believes that a weighted moving average would provide better forecasts. In one paragraph describe why this will or will not work?

Propose a set of weighting factors and make new forecasts for months 4 and 5 based on those new weighted moving average factors. Insert these values in the table below along with the Absolute Deviations for months 4 and 5 in then shaded areas below.

Month

Actual

Forecast

Absolute Deviation

1

4

2

6

3

7

4

9

5

11

Calculate the Mean Absolute Deviation for months 4 and 5 in the new table above.

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!