AllFreePapers.com - All Free Papers and Essays for All Students
Search

Operations Management - Evaluation of Each Forecasting Methods

Autor:   •  March 21, 2016  •  Case Study  •  791 Words (4 Pages)  •  955 Views

Page 1 of 4

All calculations were computed in the attached excel file.

Question 1

  1. Data Plotted

[pic 1]

Evaluation of each forecasting methods

Naïve Method: This method would not be perform very well in forecasting future sales because the sales fluctuate from month to month resulting first in an upward trend then a slight downward trend then resuming an upward trend at the end of the year. There is also the concern of seasonality in this data and the naïve method does not perform well with this factors.

Moving Average: This forecasting method takes an average of previous periods into consideration as opposed to just the single previous period. By increasing the size of n, which is the number of periods averaged it will smooth out fluctuations but is makes the method less sensitive to real changes in the data. Even with the additional periods used to forecast it is still not an adequate method to use and will not perform well with this data because it does not pick up trend very well and extensive records of past data is require where as we only have 12 months of data.

Simple Exponential Smoothing: This method would perform well with this data because little record keeping of past data is required. The most recent data is weighted heavier, and this method can adjust for stable vs non-stable time series data.

Double Exponential Smoothing: This method will perform the best because the data has trend and the double exponential smoothing method is modified to capture this trend component. As seen in class simple exponential smoothing tends to under forecast values when trend is present as opposed to this method that captures that gap.

b)

Naïve

t

At

Naïve

ERROR

ABS ERR

SQ ERR

Jan

126

 

 

 

 

Feb

137

126

11

11

121

Mar

142

137

5

5

25

Apr

150

142

8

8

64

May

153

150

3

3

9

Jun

154

153

1

1

1

Jul

148

154

-6

6

36

Aug

145

148

-3

3

9

Sep

147

145

2

2

4

Oct

151

147

4

4

16

Nov

159

151

8

8

64

Dec

166

159

7

7

49

MAD=

5.27272727

MSE=

36.1818182

Moving Average

n=4

t

At

M.A

ERROR

ABS ERR

SQ ERR

Jan

126

 

 

 

 

Feb

137

 

 

 

 

Mar

142

 

 

 

 

Apr

150

 

 

 

 

May

153

138.75

14.25

14.25

203.0625

Jun

154

145.5

8.5

8.5

72.25

Jul

148

149.75

-1.75

1.75

3.0625

Aug

145

151.25

-6.25

6.25

39.0625

Sep

147

150

-3

3

9

Oct

151

148.5

2.5

2.5

6.25

Nov

159

147.75

11.25

11.25

126.5625

Dec

166

150.5

15.5

15.5

240.25

MAD=

7.875

MSE=

87.4375

Out of these two methods we would recommend to use the Naïve method because both the MAD and MSE values are lower than the Moving average values resulting in more accurate forecasting over this data.

c)

Exponential Smoothing

a=0.1

t

At

EXP SM

ERROR

ABS ERR

SQ ERR

Jan

126

126

 

 

 

Feb

137

126

11

11

121

Mar

142

127.10

14.90

14.90

222.01

Apr

150

128.59

21.41

21.41

458.39

May

153

130.73

22.27

22.27

495.91

Jun

154

132.96

21.04

21.04

442.77

Jul

148

135.06

12.94

12.94

167.39

Aug

145

136.36

8.64

8.64

74.72

Sep

147

137.22

9.78

9.78

95.64

Oct

151

138.20

12.80

12.80

163.88

Nov

159

139.48

19.52

19.52

381.09

Dec

166

141.43

24.57

24.57

603.66

MAD=

16.2614

MSE=

293.3144

Exponential Smoothing

            a=

0.2

t

At

EXP SM

ERROR

ABS ERR

SQ ERR

Jan

126

126

 

 

 

Feb

137

126

11

11

121

Mar

142

128.20

13.80

13.80

190.44

Apr

150

130.96

19.04

19.04

362.52

May

153

134.77

18.23

18.23

332.41

Jun

154

138.41

15.59

15.59

242.91

Jul

148

141.53

6.47

6.47

41.84

Aug

145

142.83

2.17

2.17

4.73

Sep

147

143.26

3.74

3.74

13.99

Oct

151

144.01

6.99

6.99

48.89

Nov

159

145.41

13.59

13.59

184.78

Dec

166

148.13

17.87

17.87

319.51

MAD=

11.68189

MSE=

169.3648

Exponential Smoothing

            a=

0.5

t

At

EXP SM

ERROR

ABS ERR

SQ ERR

Jan

126

126

 

 

 

Feb

137

126

11

11

121

Mar

142

131.50

10.50

10.50

110.25

Apr

150

136.75

13.25

13.25

175.56

May

153

143.38

9.63

9.63

92.64

Jun

154

148.19

5.81

5.81

33.79

Jul

148

151.09

-3.09

3.09

9.57

Aug

145

149.55

-4.55

4.55

20.67

Sep

147

147.27

-0.27

0.27

0.07

Oct

151

147.14

3.86

3.86

14.92

Nov

159

149.07

9.93

9.93

98.64

Dec

166

154.03

11.97

11.97

143.18

MAD=

7.623846

MSE=

74.57288

0.1

0.2

0.5

MAD

16.2614

11.68189

7.623846

MSE

293.3144

169.3648

74.57288

By comparing a=0.1, 0.2 and 0.5 we would recommend to use a=0.5 because it provides us with the smallest MAD and MSE resulting in the smaller error when forecasting. This result is consistent with our earlier analysis that the time series is not stable.

...

Download as:   txt (10.6 Kb)   pdf (253.8 Kb)   docx (36.5 Kb)  
Continue for 3 more pages »