Week Demand Level Forecast Forecast Error
1120
2127
3114
4122 120.75
5125 122 120.75 -4.25
Week Demand Level Forecast Forecast Error
0 120.75
1120 120.675 120.75 0.75
2127 121.308 120.68 -6.33
3114 120.577 121.31 7.31
4122 120.719 120.58 -1.42
5 120.72
Month Demand Forecast Error Level Trend α β Regression Analysis
07,367 673
0.1 0.2 SUMMARY OUTPUT
18,415 8,040 -375 8,078 681
28,732 8,759 27 8,756 680 Regression Statistics
39,014 9,436 422 9,394 672 Multiple R 0.955665
49,808 10,066 258 10,040 667 R Square 0.913295
510,413 10,707 294 10,677 661
Adjusted R Square
0.891619
611,961 11,338 -623 11,401 673
Standard Error
433.9514
712,074
Observations
6
ANOVA
df SS MS F
Significance F
Regression
17934336 7934336 42.13358 0.002905
Residual 4 753255.3 188313.8
Total 5 8687591
Standard Error
t Stat P-value
Lower 95%
Upper 95%
Lower 95.0%
Intercept 7,367.13 403.99 18.24 0.00 6,245.49 8,488.78 6,245.49 8,488.78
X Variable 1
673.34 103.73 6.49 0.00 385.33 961.36 385.33 961.36
Month Demand Forecast Error Level Trend Seasonal Factors α β ϒ
0 18,439 524 0.1 0.2 0.1
1 8,000 8,913 913 18,769 485 0.47
2 13,093 0.68
3 1.17
4 1.67
5 0.47