Problem 4.6 in Microsoft excel

Plot J he monthly sales data. b) Forecast January sales using each of the following. i) Naive method. ii) A 3-month moving average. iii) A 6-month weighted average using .1, .1, .1, .2, .2, and .3, with the heaviest weights applied lo the most recent months. iv) Exponential smoothing using an alpha = .3 and a September forecast of 18. v) A trend projection. c) With the data given, which method would allow you lo forecast next March's sales? The actual demand for the patients at Omaha Emergency Medical Clinic for the first 6 weeks of this year follows