1. The business analyst for Video Sales, Inc. wants to forecast this year's demand for DVD decoders based on the following historical data: Year Demand 5 years ago 900 4 years ago 700 3 years ago 600 2 years ago 500 Last year 300 8. What is the forecast for this year using exponential smoothing with alpha = .4?
Year | Demand |
5 years ago | 900 |
4 years ago | 700 |
3 years ago | 600 |
2 years ago | 500 |
Last year | 300 |
A. 163
B. 180
C. 300
D. 504
E. None of the choices
2. What is the MAE for the exponential smoothing with alpha = .4?
A. 64320
B. 198
C. 249
D. 247.8
E. None of the choices
Please show all the steps on excel, thank you in advance!
so, forecast for this year = 503.52 ≈ 504
b) MAE= Σ |et|/n = 991.20/4 = 247.80
please revert for doubt
Get Answers For Free
Most questions answered within 1 hours.