Use the data from this problem to perform the following: (similarly set up the problem as your time periods will all be in one column, and your actual forecast all in one column, then first forecast column, then error column, etc.

A) Using a moving average of 6 time periods, forecast the emergency calls for week 25.

B) Using a moving average of 9 time periods, forecast the emergency calls for week 25.

C) Assuming an initial forecast of 50 calls in week 1, use exponential smoothing to forecast calls for week 25. Use alpha = .4.

D) Calculate the MAD for each forecasting technique and determine which is the most accurate? Why?

Emergency calls to Winter Park, Floridas 911 system for the past 24 weeks are as follows

Week	Calls	Week	Calls	Week	Calls
1	50	9	35	17	55
2	35	10	20	18	40
3	25	11	15	19	35
4	40	12	40	20	60
5	45	13	55	21	75
6	35	14	35	22	50
7	20	15	25	23	40
8	30	16	55	24	65