Sales Data - 3 Month average
Time Period (Name of product)
42.00
1
2
3 Three Months Average
40.00
4 #DIV/0!
5 #DIV/0!
Units Sold
6 #DIV/0!
7 #DIV/0! 38.00
8 #DIV/0!
9 #DIV/0!
10 #DIV/0! 36.00
11 #DIV/0!
12 #DIV/0!
13 #DIV/0! 34.00
14 #DIV/0!
15 #DIV/0!
16 #DIV/0! 32.00
17 #DIV/0!
18 #DIV/0!
19 #DIV/0!
30.00
20 #DIV/0!
21 #DIV/0!
22 #DIV/0!
28.00
23 #DIV/0!
1 2 3
24 #DIV/0!
25 #DIV/0!
26
27
28
Page 1
Sales Data - 3 Month average
42.00
40.00
Units Sold
38.00
36.00
34.00
32.00
30.00
28.00
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
Time Period
Page 2
Sales Data - MSE
Time Period (Name of product)
1
2
3 Forecast
4 0.00
5 0.00
6 0.00
7 0.00
8 0.00
9 0.00
10 0.00
11 0.00
12 0.00
13 0.00
14 0.00
15 0.00
16 0.00
17 0.00
18 0.00
19 0.00
20 0.00
21 0.00
22 0.00
23 0.00
24 0.00
25 0.00
26
27
28
Page 3
Sales Data - MSE
Parameters 42.00
W3
W2
W1 40.00
SUM 0.00
Units Sold
Perforamnce Measure
38.00
MSE #DIV/0!
36.00
34.00
32.00
30.00
28.00
1 2 3 4 5 6 7 8 Time
9 10 11 12 Period
13 14 15 16 17 18 19 20 21 22
Page 4
Sales Data - MSE
eriod
15 16 17 18 19 20 21 22 23 24 25 26 27 28
Page 5
Sales Data - Exp. Smoothing
Time Period (Name of Product) Forecast Parameters
1 alpha
2 0.00
3 33.00 Performance Measure
4 45.49 MSE
5 45.49
6 45.49
7 45.49
8 45.49
9 45.49
10 45.49
11 45.49
12 45.49
13 45.49
14 45.49
15 45.49
16 45.49
17 45.49
18 45.49
19 45.49
20 45.49
21 45.49
22 45.49
23 45.49
24 45.49
25 45.49
26
27
28
Page 6
Sales Data - Exp. Smoothing
Parameters
42.00
Performance Measure
#DIV/0!
40.00
Units Sold 38.00
36.00
34.00
32.00
30.00
28.00
1 2 3 4 5 6 7 8 Time
9 10 11 12 Period
13 14 15 16 17 18 19 20 21 22 23 24
Page 7
Sales Data - Exp. Smoothing
eriod
15 16 17 18 19 20 21 22 23 24 25 26 27 28
Page 8
Sales Data - Exp. Smoothing
Page 9
Sales Data - Exp. Smoothing
Page 10
Sales Data - Exp. Smoothing
Page 11
Sales Data - Exp. Smoothing
Page 12
Forecast when Adjusted
Time Period (Name of product) α=0.25 Trend Forecast
1 - - -
2 - 0.0000 -
3 - 0.4375 0.44
4 - 0.4375 0.44
5 - 0.4375 0.44
6 - 0.4375 0.44
7 - 0.4375 0.44
8 - 0.4375 0.44
9 - 0.4375 0.44
10 - 0.4375 0.44
11 - 0.4375 0.44
12 - 0.4375 0.44
13 - 0.4375 0.44
14 - 0.4375 0.44
15 - 0.4375 0.44
16 - 0.4375 0.44
17 - 0.4375 0.44
18 - 0.4375 0.44
19 - 0.4375 0.44
20 - 0.4375 0.44
21 - 0.4375 0.44
22 - 0.4375 0.44
23 - 0.4375 0.44
24 - 0.4375 0.44
- -
Parameters
alpha
beta
Performance Measures
MSE #DIV/0!
Year Qtr Time Period Units Sold
2005 1 1 330
2 2 310 420
3 3 370
4 4 300
2006 1 5 378 400
2 6 352
3 7 408
Units Sold
4 8 341
380
2007 1 9 354
2 10 329
3 11 402
360
4 12 303
2008 1 13 358
2 14 317
340
3 15 402
4 16 299
2009 1 17 340
2 18 303 320
3 19 387
4 20 305
2010 1 21 360 300
2 22 346
3 23 396
4 24 324 280
1 2 3 4 5 6 7 8 9 10 11 12 1
Time Pe
7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
Time Period
