Question

The manager of a travel agency has been using a seasonally adjusted forecast to predict demand for packaged tours. The actual and predicted values are as follows:

Period			Demand			Predicted
	1			138			113
	2			198			200
	3			158			150
	4			93			102
	5			88			80
	6			133			135
	7			128			128
	8			127			124
	9			92			109
	10			147			150
	11			102			94
	12			87			80
	13			122			140
	14			132			128

     

a. Compute MAD for the fifth period, then update it period by period using exponential smoothing with α = .05. (Round your intermediate calculations and final answers to 3 decimal places.)

t Period	A Demand	MADt
1	138
2	198
3	158
4	93
5	88
6	133
7	128
8	127
9	92
10	147
11	102
12	87
13	122
14	132

b. Compute a tracking signal for periods 5 through 14 using the initial and updated MADs. (Negative values should be indicated by a minus sign. Round your intermediate calculations and final answers to 3 decimal places.)

t Period	A Demand	Tracking Signal
1	138
2	198
3	158
4	93
5	88
6	133
7	128
8	127
9	92
10	147
11	102
12	87
13	122
14	132

Please help

Answer 1