Please do in EXCEL!!!!

Month	Sales (000 unity)
2	19
3	18
4	15
5	20
6	18
7	22
8	20

. Determine forecasts for as many of the months of March through September that you can using each of the following methods: (Assume you are starting at the end of February and revise the forecast as new data is collected)

i. The Naive method

ii. A 3-point moving average

iii. A weighted 4-point moving average using the following weights:

w_t-1 = .65, w_t-2, = .20 w_t-3 = .10, w_t-4 = .05

iv. Exponential smoothing with a = 0.40, assume the forecast for February was 20.