Question: EXAMPLE - MAD WITH HISTORICAL DATA The table below provides actual sales for years 1 through 7 . The firm uses a three - year

EXAMPLE-MAD WITH HISTORICAL DATA
The table below provides actual sales for years 1 through 7. The firm uses a three-year moving average to
make forecasts.
a. What is the forecast for year 8?
F8=A5+A6+A73=100+900+8003=600
b. What is the MAD based on these data?
MAD=200+200+633+3334=341.5
c. Suppose the company uses a 4 year MA instead of a 3 year MA for forecasting, what is the new MAD?
 EXAMPLE-MAD WITH HISTORICAL DATA The table below provides actual sales for

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!