Click on the Data Sheet in the next tab.
Using the provided data, compute the following 4 tasks:
1- Compute forecasting for that data using 4 methods:
a- Simple moving average with n= 2
b- Weighted moving average with n=4 and weights of 8, 6, 4, and 2
c- Exponential smoothing with alpha= 0.1 (assuming initial forecast of 52)
d- Exponential Smoothing with alpha=0.8 (assuming initial forecast of 52)
2- For each of the four forecasting methods, compute the corresponding error for each week, and then compute the overall MAPE for each method
3- Which of the four forecasting methods can you say best fit the data?
Please provide your rationale for your choice

Cupboard 1 Font Alignmen Number G38 fic D E H 1 J K L M 0 P 1 B C F Emergency Calls Emergency calls to this city's 911 system, for the past 24 weeks are as follows: Forecasting and Error Analysis 2 3 Moving Average (n=2) Forecast Error Weighted Moving Average (n=4 and weights of 8, 6, 4, and 2) Exponential Smoothing Alpha 0.8 4 Exponential Smoothing Alpha 0.1 Forecast Error 52 Forecast Error Error 5 6 Forecast 52 7 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Data Period Demand (calls) Week 1 50 Week 2 35 Week 3 25 Week 4 40 Week 5 45 Week 6 35 Week 7 20 Week 8 30 Week 9 35 Week 10 20 Week 11 15 Week 12 40 Week 13 55 Week 14 35 Week 15 25 Week 16 55 Week 17 55 Week 18 40 Week 19 35 Week 20 60 Week 21 75 Week 22 50 Week 23 40 Week 24 65 Period Week 1 Week 2 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12 Week 13 Week 14 Week 15 Week 16 Week 17 Week 18 Week 19 Week 20 Week 21 Week 22 Week 23 Week 24 MAPE 23 24 25 26 27 28 29 30 31