Solve the Problem and verify your answers using the Excel Software

A) The sales data of company for 10 years is given the following table Forecast for the company using

a) 3 period moving average b) 4 period moving average c) 5 period moving average d) Using Weighted moving average for four period of 0.4, 0.3, 0.2, 0.1 e) Using Weighted moving average for five period of 0.3, 0.25, 0.2, 0.15, 0.1

Validate the answer for first two periods and last period manually Take screen shot for all the three and paste. Observe what happens to the graph, MAD, MSE. Your observations

2) For the above Data, forecast using Exponential smoothing with a) Exponential smoothing constant as 0.3 b) Exponential smoothing constant as 0.5 c) Exponential smoothing constant as 0.7

Initially to start use Naive method for period 2 and compute using exponential smoothing.

Validate the answer for first two periods and last period manually Take screen shot for all the three and paste. Observe what happens to the graph, MAD, MSE. Your observations

Period Period Actual Demand 1 770 2 789 3 794 4 780 770x 0.1 5 768 789x 0.15 6 772 794x 0.2 7 760 8 775 780x0.25 9 786 768x 0.3 10 790