Week Demand WeekDemand Week Demand 73 70 2 69 7 79 12 69 3 7

Week Demand WeekDemand Week Demand 73 70 2 69 7 79 12 69 3 70 13 70 4 68 76 14 71 72 10 72 15 73 Round off all calculations to two decimal places. Maintaining two decimal places is required for all calculations What is the period 15 tracking signal for the forecast with = 0.6? 3 but 5 0-5 but

Solution

(1)

So, correct answer is > 3 but <= 5

(2)

F_t+1 = .A_t + (1 - ).F_t

= 0.2

So, correct answer is > 69 but <= 72

(3)

F_t+1 = .A_t + (1 - ).F_t

= 0.6

The nearest whole number is 72.

So, correct answer is > 69 but <= 72

Week	Demand	Forecast	|error|	error	RSFE	Cumulative Avg. MAD	TS = RSFE/ MAD
1	66	66.00	0.00	0.00	0.00	0.000	-
2	69	66.00	3.00	3.00	3.00	1.500	2.000
3	70	67.80	2.20	2.20	5.20	1.733	3.000
4	68	69.12	1.12	-1.12	4.08	1.580	2.582
5	72	68.45	3.55	3.55	7.63	1.974	3.865
6	73	70.58	2.42	2.42	10.05	2.049	4.907
7	79	72.03	6.97	6.97	17.02	2.752	6.186
8	77	76.21	0.79	0.79	17.81	2.506	7.106
9	76	76.69	0.69	-0.69	17.12	2.304	7.433
10	72	76.27	4.27	-4.27	12.85	2.501	5.138
11	70	73.71	3.71	-3.71	9.14	2.611	3.501
12	69	71.48	2.48	-2.48	6.66	2.600	2.560
13	70	69.99	0.01	0.01	6.66	2.401	2.775
14	71	70.00	1.00	1.00	7.66	2.301	3.332
15	73	70.60	2.40	2.40	10.07	2.307	4.362