Question: 2. A company records reported below indicate monthly sales data for XYZ Company. Use the below mentioned techniques to help the administration: Month October November
2. A company records reported below indicate monthly sales data for XYZ Company. Use the below mentioned techniques to help the administration: Month October November December January February March April May June July Sales (units) 9 11 13 13 14 14 15 16 18 20 a) Compute and explain the 2-month moving average. b) Calculate exponential smoothing with smoothing constant 0.4 and forecast value 12 for the first period. Briefly explain. c) Use RMSE model and decide which technique (simple moving average or exponential smoothing) is better? Briefly explain. d) Plot the monthly data, moving averages and exponential smoothing estimates on a line graph. Briefly explain the pattern
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
