Forecasting Techniquezs

Burn Dressing roll Demand
Simple Average Technique
Time Period	Sales(Di)		Fi	(Fi-Di)	Σ(Fi-Di)	Σ│Fi-Di│	Di
1	1084		X	X
2	1056		1070	14
3	1090		1073	-17
4	953		1021.5	68.5
5	858		905.5	47.5
6	868		863	-5
7	1034		951	-83
8	1088		1061	-27
9	1069		1078.5	9.5
10	856		962.5	106.5
11	876		866	-10
12	796		836	40	154	998	937.041
13	1023		909.5	-113.5
14	1003		1013	10
15	1036		1019.5	-16.5
16	835		935.5	100.5
17	747		791	44
18	856		801.5	-54.5
19	1008		932	-76
20	1036		1022	-14
21	920		978	58
22	805		862.5	57.5
23	816		810.5	-5.5
24	776		796	20
25	X		776	X
MAD						43.3913043
CV						4.63067297
BIAS					6.69565217
Burn Dressing roll Demand
Weighted Average Technique
Time Period	Sales(Di)	Weight	Fi	(Fi-Di)	Σ(Fi-Di)	Σ│Fi-Di│	Di
1	1084	1	X	X
2	1056	2	1084	28
3	1090	3	1065.333	-24.6667
4	953	4	1077.667	124.6667
5	858	5	1027.8	169.8
6	868	6	971.2	103.2
7	1034	7	934.6	-99.4
8	1088	8	952.72	-135.28
9	1069	9	975.0667	-93.9333
10	856	10	1001.743	145.7429
11	876	11	983.275	107.275
12	796	12	972.4222	176.4222	656.727903	2517.86	937.041
13	1023	13	921.46	-101.54
14	1003	14	921.2364	-81.7636
15	1036	15	918.15	-117.85
16	835	16	954.9077	119.9077
17	747	17	939.9	192.9
18	856	18	919.2	63.2
19	1008	19	888.1125	-119.888
20	1036	20	895.9882	-140.012
21	920	21	903.7667	-16.2333
22	805	22	918.9368	113.9368
23	816	23	923.1	107.1
24	776	24	911.1429	135.1429
25	X	25	864.9273		X
MAD						104.910833
CV						11.1959704
BIAS					27.3636626
Burn Dressing roll Demand
Simple Moving Average Technique
Average of 2 previous periods
Time Period	Sales(Di)	Fi	(Fi-Di)	Σ(Fi-Di)	Σ│Fi-Di│	Di
1	1084	X	X
2	1056	X	X
3	1090	1070	-20
4	953	1073	120
5	858	1021.5	163.5
6	868	905.5	37.5
7	1034	863	-171
8	1088	951	-137
9	1069	1061	-8
10	856	1078.5	222.5
11	876	962.5	86.5
12	796	866	70
13	1023	836	-187	414	2444		937.041
14	1003	909.5	-93.5
15	1036	1013	-23
16	835	1019.5	184.5
17	747	935.5	188.5
18	856	791	-65
19	1008	801.5	-206.5
20	1036	932	-104
21	920	1022	102
22	805	978	173
23	816	862.5	46.5
24	776	810.5	34.5
25	X	796	X
MAD					101.833333
CV					10.867543
BIAS				17.25
Burn Dressing roll Demand
Weighted Moving Average
Average of 2 previous periods
Weights are respectively 1and 2
Time Period	Sales(Di)	Fi	(Fi-Di)	Σ(Fi-Di)	Σ│Fi-Di│	Di
1	1084	X	X
2	1056	X	X
3	1090	1065.333	-24.6667
4	953	1078.667	125.6667
5	858	998.6667	140.6667
6	868	889.6667	21.66667
7	1034	864.6667	-169.333
8	1088	978.6667	-109.333
9	1069	1070	1
10	856	1075.333	219.3333
11	876	927	51
12	796	869.3333	73.33333	369.3333	2234	937.041
13	1023	822.6667	-200.333
14	1003	947.3333	-55.6667
15	1036	1009.667	-26.3333
16	835	1025	190
17	747	902	155
18	856	776.3333	-79.6667
19	1008	819.6667	-188.333
20	1036	957.3333	-78.6667
21	920	1026.667	106.6667
22	805	958.6667	153.6667
23	816	843.3333	27.33333
24	776	812.3333	36.33333
25	X	789.3333	X
MAD					101.545455
CV					10.8368209
BIAS				16.78788
Burn Dressing roll Demand
Naïve Forecasting Technique
Time Period	Sales(Di)	Fi	(Fi-Di)	Σ(Fi-Di)	Σ│Fi-Di│	Di
1	1084	X	X
2	1056	1084	28
3	1090	1056	-34
4	953	1090	137
5	858	953	95
6	868	858	-10
7	1034	868	-166
8	1088	1034	-54
9	1069	1088	19
10	856	1069	213
11	876	856	-20
12	796	876	80	308	1996	937.041
13	1023	796	-227
14	1003	1023	20
15	1036	1003	-33
16	835	1036	201
17	747	835	88
18	856	747	-109
19	1008	856	-152
20	1036	1008	-28
21	920	1036	116
22	805	920	115
23	816	805	-11
24	776	816	40
25	X	776	X
MAD					86.7826087
CV					9.26134595
BIAS				13.3913