7_1_Final_Project_Milestone_Three__Recommendations_and_Future_Outcomes
.xlsx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
QSO-520-06
Subject
Industrial Engineering
Date
Jan 9, 2024
Type
xlsx
Pages
7
Uploaded by RosaleeB
Template for Exponential Smoothing Forecasting Method with Trend
Exponential
Range Name
Cells
Time True
Latest
Estimated
Smoothing
Forecasting
Alpha
J6
Period
Value
Trend
Trend
Forecast
Error
Smoothing Constants
Beta
J7
1
52
2.00
52
0
a =
0.2
EstimatedTrend
E6:E35
2
55
2.00
2.00
54
1
b =
0.5
Forecast
F6:F35
3
55
2.20
2.10
56
1
ForecastingError
G6:G35
4
58
1.84
1.97
58
0
Initial Estimates
InitialEstimateAverage
J10
5
59
1.97
1.97
60
1
Average =
50
InitialEstimateTrend
J11
6
63
1.77
1.87
62
1
Trend =
2
LatestTrend
D6:D35
7
65
2.14
2.01
64
1
MAD
J14
8
66
2.22
2.11
66
0
Mean Absolute Deviation
MSE
J17
9
67
2.06
2.09
68
1
MAD =
0.88
TrueValue
C6:C35
10
72
1.83
1.96
70
2
11
73
2.36
2.16
73
0
Mean Square Error
12
74
2.25
2.20
75
1
MSE =
1.11
13
2.03
2.12
77
14
#N/A
15
#N/A
16
#N/A
17
#N/A
18
#N/A
19
#N/A
20
#N/A
21
#N/A
22
#N/A
23
#N/A
24
#N/A
25
#N/A
26
#N/A
27
#N/A
28
#N/A
29
#N/A
30
#N/A
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
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
29
30
31
32
33
34
35
36
37
38
39
40
Template for Exponential Smoothing Forecasting Method with Trend
Exponential
Range Name
Cells
Time True
Latest
Estimated
Smoothing
Forecasting
Alpha
J6
Period
Value
Trend
Trend
Forecast
Error
Smoothing Constants
Beta
J7
1
52
2.00
52
0
a =
0.2
EstimatedTrend
E6:E35
2
53
2.00
2.00
54
1
b =
0.5
Forecast
F6:F35
3
51
1.80
1.92
56
5
ForecastingError
G6:G35
4
50
0.98
1.54
56
6
Initial Estimates
InitialEstimateAverage
J10
5
48
0.28
1.04
56
8
Average =
50
InitialEstimateTrend
J11
6
47
-0.58
0.39
55
8
Trend =
2
LatestTrend
D6:D35
7
49
-1.18
-0.24
53
4
MAD
J14
8
52
-1.05
-0.56
52
0
Mean Absolute Deviation
MSE
J17
9
57
-0.50
-0.54
51
6
MAD =
6.40
TrueValue
C6:C35
10
63
0.62
-0.07
52
11
11
69
2.07
0.78
55
14
Mean Square Error
12
74
3.54
1.89
60
14
MSE =
62.12
13
4.71
3.02
65
14
#N/A
15
#N/A
16
#N/A
17
#N/A
18
#N/A
19
#N/A
20
#N/A
21
#N/A
22
#N/A
23
#N/A
24
#N/A
25
#N/A
26
#N/A
27
#N/A
28
#N/A
29
#N/A
30
#N/A
1
2
3
4
5
6
7
8
9 101112131415161718192021222324252627282930
0
10
20
30
40
50
60
70
80
True Value
Forecast
Time Period
Value
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
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
29
30
31
32
33
34
35
36
37
38
39
40
Template for Exponential Smoothing Forecasting Method with Trend
Exponential
Range Name
Cells
Time True
Latest
Estimated
Smoothing
Forecasting
Alpha
J6
Period
Value
Trend
Trend
Forecast
Error
Smoothing Constants
Beta
J7
1
52
2.00
52
0
a =
0.2
EstimatedTrend
E6:E35
2
53
2.00
2.00
54
1
b =
0.5
Forecast
F6:F35
3
51
1.80
1.90
56
5
ForecastingError
G6:G35
4
50
0.96
1.43
56
6
Initial Estimates
InitialEstimateAverage
J10
5
48
0.19
0.81
56
8
Average =
50
InitialEstimateTrend
J11
6
47
-0.74
0.03
54
7
Trend =
2
LatestTrend
D6:D35
7
49
-1.41
-0.69
52
3
MAD
J14
8
52
-1.31
-1.00
50
2
Mean Absolute Deviation
MSE
J17
9
57
-0.70
-0.85
50
7
MAD =
6.57
TrueValue
C6:C35
10
63
0.56
-0.14
51
12
11
69
2.22
1.04
55
14
Mean Square Error
12
74
3.92
2.48
60
14
MSE =
64.95
13
5.28
3.88
67
14
#N/A
15
#N/A
16
#N/A
17
#N/A
18
#N/A
19
#N/A
20
#N/A
21
#N/A
22
#N/A
23
#N/A
24
#N/A
25
#N/A
26
#N/A
27
#N/A
28
#N/A
29
#N/A
30
#N/A
1
2
3
4
5
6
7
8
9 101112131415161718192021222324252627282930
0
10
20
30
40
50
60
70
80
True Value
Forecast
Time Period
Value
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
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
29
30
31
32
33
34
35
36
37
38
39
40
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help