Please show formulas input in excel and the solver parameters (i.e objective, changing variable cells, and constraints). Please provide a detailed step-by-step description of your proposed solution. Thank you!

The file Walmart Closing Prices, posted on Canvas contains a little more than a year's worth of the daily closing values of Walmart's stock from 2003 and 2004.Use this data to develop a forecast for the day following the end of the data (October 16 2004.)

Use the following forecasting methods:

i)Moving average forecasting with a span of 3.

ii)Exponential Smoothing with a smoothing constant =0.5.

Use a data table to give the Forecast for 10/16/2004, MAD and MSE as the smoothing constant in part ii) varies from =0.1 to 0.6 in increments of 0.1.

Please check the following table for Walmart Stock Closing Prices:

Date Close

15-Oct-03 59.07

16-Oct-03 59.39

17-Oct-03 58.84

20-Oct-03 59.00

21-Oct-03 58.97

22-Oct-03 58.24

23-Oct-03 58.70

24-Oct-03 58.11

27-Oct-03 57.79

28-Oct-03 58.76

29-Oct-03 58.85

30-Oct-03 58.80

31-Oct-03 58.95

3-Nov-03 59.04

4-Nov-03 58.66

5-Nov-03 57.92

6-Nov-03 58.61

7-Nov-03 58.42

10-Nov-03 58.12

11-Nov-03 58.28

12-Nov-03 57.96

13-Nov-03 55.52

14-Nov-03 55.00

17-Nov-03 55.00

18-Nov-03 54.72

19-Nov-03 55.21

20-Nov-03 55.07

21-Nov-03 54.81

24-Nov-03 56.08

25-Nov-03 56.04

26-Nov-03 55.70

28-Nov-03 55.64

1-Dec-03 54.50

2-Dec-03 53.02

3-Dec-03 52.69

4-Dec-03 53.02

5-Dec-03 53.48

8-Dec-03 53.40

9-Dec-03 52.61

10-Dec-03 52.95

11-Dec-03 52.81

12-Dec-03 52.50

15-Dec-03 50.74

16-Dec-03 51.39

17-Dec-03 51.90

18-Dec-03 52.60

19-Dec-03 52.35

22-Dec-03 53.07

23-Dec-03 52.77

24-Dec-03 52.44

26-Dec-03 52.52

29-Dec-03 52.90

30-Dec-03 52.78

31-Dec-03 53.05

2-Jan-04 52.30

5-Jan-04 52.12

6-Jan-04 53.34

7-Jan-04 53.48

8-Jan-04 53.26

9-Jan-04 52.40

12-Jan-04 52.51

13-Jan-04 52.76

14-Jan-04 53.14

15-Jan-04 53.49

16-Jan-04 53.48

20-Jan-04 52.95

21-Jan-04 53.45

22-Jan-04 53.18

23-Jan-04 54.21

26-Jan-04 54.61

27-Jan-04 54.43

28-Jan-04 53.27

29-Jan-04 54.48

30-Jan-04 53.85

2-Feb-04 54.69

3-Feb-04 55.01

4-Feb-04 55.39

5-Feb-04 56.25

6-Feb-04 57.58

9-Feb-04 57.32

10-Feb-04 57.53

11-Feb-04 57.07

12-Feb-04 56.98

13-Feb-04 56.32

17-Feb-04 57.52

18-Feb-04 57.20

19-Feb-04 58.38

20-Feb-04 59.43

23-Feb-04 60.05

24-Feb-04 59.95

25-Feb-04 59.88

26-Feb-04 59.40

27-Feb-04 59.56

1-Mar-04 60.45

2-Mar-04 59.55

3-Mar-04 60.36

4-Mar-04 61.05

5-Mar-04 60.24

8-Mar-04 60.46

9-Mar-04 60.28

10-Mar-04 58.76

11-Mar-04 57.90

12-Mar-04 58.48

15-Mar-04 57.90

16-Mar-04 57.97

17-Mar-04 58.35

18-Mar-04 58.94

19-Mar-04 58.60

22-Mar-04 58.10

23-Mar-04 58.21

24-Mar-04 58.58

25-Mar-04 59.82

26-Mar-04 59.41

29-Mar-04 60.13

30-Mar-04 60.00

31-Mar-04 59.69

1-Apr-04 58.35

2-Apr-04 58.60

5-Apr-04 58.64

6-Apr-04 59.02

7-Apr-04 57.98

8-Apr-04 56.69

12-Apr-04 57.34

13-Apr-04 56.47

14-Apr-04 57.42

15-Apr-04 57.79

16-Apr-04 58.44

19-Apr-04 58.37

20-Apr-04 58.10

21-Apr-04 58.35

22-Apr-04 58.60

23-Apr-04 58.97

26-Apr-04 58.14

27-Apr-04 58.60

28-Apr-04 57.98

29-Apr-04 57.57

30-Apr-04 57.00

3-May-04 56.54

4-May-04 56.00

5-May-04 55.86

6-May-04 54.58

7-May-04 53.90

10-May-04 55.22

11-May-04 54.53

12-May-04 55.06

13-May-04 55.25

14-May-04 55.06

17-May-04 54.70

18-May-04 55.21

19-May-04 54.78

20-May-04 54.84

21-May-04 55.09

24-May-04 54.99

25-May-04 55.49

26-May-04 55.28

27-May-04 55.97

28-May-04 55.73

1-Jun-04 55.44

2-Jun-04 56.35

3-Jun-04 56.60

4-Jun-04 56.59

7-Jun-04 57.50

8-Jun-04 57.68

9-Jun-04 57.03

10-Jun-04 57.20

14-Jun-04 56.38

15-Jun-04 56.71

16-Jun-04 56.12

17-Jun-04 55.85

18-Jun-04 55.62

21-Jun-04 54.93

22-Jun-04 54.06

23-Jun-04 53.55

24-Jun-04 53.15

25-Jun-04 52.51

28-Jun-04 52.46

29-Jun-04 51.98

30-Jun-04 52.50

1-Jul-04 51.76

2-Jul-04 51.93

6-Jul-04 52.08

7-Jul-04 52.32

8-Jul-04 52.18

9-Jul-04 51.76

12-Jul-04 52.21

13-Jul-04 53.01

14-Jul-04 52.58

15-Jul-04 52.33

16-Jul-04 52.65

19-Jul-04 52.86

20-Jul-04 53.25

21-Jul-04 53.12

22-Jul-04 52.91

23-Jul-04 53.16

26-Jul-04 52.65

27-Jul-04 53.90

28-Jul-04 53.91

29-Jul-04 53.48

30-Jul-04 53.01

2-Aug-04 53.18

3-Aug-04 52.87

4-Aug-04 53.20

5-Aug-04 52.05

6-Aug-04 51.33

9-Aug-04 51.37

10-Aug-04 52.11

11-Aug-04 51.63

12-Aug-04 52.65

13-Aug-04 53.40

16-Aug-04 54.30

17-Aug-04 54.97

18-Aug-04 54.46

19-Aug-04 54.86

20-Aug-04 54.65

23-Aug-04 53.80

24-Aug-04 53.86

25-Aug-04 54.10

26-Aug-04 53.88

27-Aug-04 53.56

30-Aug-04 53.20

31-Aug-04 52.67

1-Sep-04 52.63

2-Sep-04 53.12

3-Sep-04 53.25

7-Sep-04 53.29

8-Sep-04 53.08

9-Sep-04 52.57

10-Sep-04 53.45

13-Sep-04 53.35

14-Sep-04 53.22

15-Sep-04 52.91

16-Sep-04 52.77

17-Sep-04 52.48

20-Sep-04 52.20

21-Sep-04 52.26

22-Sep-04 51.67

23-Sep-04 52.54

24-Sep-04 52.81

27-Sep-04 52.52

28-Sep-04 52.78

29-Sep-04 53.00

30-Sep-04 53.20

1-Oct-04 53.13

4-Oct-04 53.31

5-Oct-04 53.41

6-Oct-04 53.98

7-Oct-04 53.55

8-Oct-04 52.85

11-Oct-04 52.90

12-Oct-04 52.92

13-Oct-04 52.55

14-Oct-04 52.10

15-Oct-04 52.53