Hi please answer the following question accordingly. I will ONLY positively rate if all parts are sufficiently complete including and espcially part D. Please understand that I need this question to be wholely complete to compare my answers. Thank you in advance.

Question 1: The monthly sales for Telco Batteries, Inc. in a given year were as follows: Month Demand Jan. 46 Feb. 47 Mar 50 Apr. 49 May 50 June 48 July 51 Aug. 49 Sep. 52 Oct. 53 Nov. 52 Dec. 54 a. Forecast next year January sales using each of the following methods: i. Naive method ii. A four-month moving average A five-month weighted moving average using the weights 0.1, 0.1, 0.2, 0.2, and 0.4 (the heaviest weights applied to the most recent months). iv. Exponential smoothing using an a=0.2 and a September forecast of 50. b. Show the plot of the monthly sales data on excel. What demand pattern do you see in the plot? C. Forecast next year January sales using the following methods: i. Linear regression (You can use excel to get slope and intercept) ii. Trend adjusted exponential smoothing model. Use a = 0.2, B = 0.3 for the month September stationary component is 50 and trend is 1.5 d. Forecast next year February sales using each of the following methods: i. Naive method il. A four-month moving average A five-month weighted moving average using the weights 0.1, 0.1, 0.2, 0.2, and 0.4 (the heaviest weights applied to the most recent months). iv. Exponential smoothing using an a=0.2 and a September forecast of 50