Question

d. 0.255, 0.2 e, o. 145, 0.420, 0.428 03-Q5 The number of cans of soft drinks sold in a machine each week is recorded below. Use an exponential smoothing average forecasting method ( 25) to answer the following: Q3 MSE of the system is: 338, 219, 278, 265, 314, 323, 299, 259, 287, 302 d. 2300 b. 500 c. 2175 a. 430 04 Forecast at the beginning of t = l is: d. neither a, nor b, nor c. 338 b. 500 a. 0 QS Forecast at the beginning of t-3 is: d. 230 b. 338 c. 217 a. 308

Answer 1

as for exponential smoothing: forecast for next period =0.25*last period actual+0.75*last period forecast

from above:

period	actual(A)	Forecast(F)	(A-F)^2
1	338	338.00
2	219	338.00	14161.00
3	278	308.25	915.06
4	265	300.69	1273.60
5	314	291.77	494.37
6	323	297.32	659.25
7	299	303.74	22.50
8	259	302.56	1897.24
9	287	291.67	21.79
10	302	290.50	132.23
			2175.23

3)

MSE of the system =2175

4)

forecast at the beginning of period t=1 is option d( neither a, nor b nor c)

5)

forecast at the beginning of period t=3 is 308.0