Use the data given in Table 1 to answer the questions that follow

Table 1: Weekly demand for FedEx parcel delivery in Botswana

Table 1 above shows the weekly demand for FedEx in Botswana. It measures demand on a

weekly basis in terms of the number of parcels which it delivers (irrespective of the size of

each parcel). Each week, the next week 's demand is forecast by taking the moving average

of the previous four weeks' actual demand.

a) Calculate the four-week moving average starting from week 24.

(8 marks)

Week Actual Demand Forecast

20 63,3 63,3

21 62,5 62,9

22 67,8 64,5

23 66,0 64,9

24 67,2 65,9

25 69,9 67,7

26 65,6 67,2

27 71,1 68,5

28 68,8 68,9

29 68,4 68,5

30 70,3 69,7

31 72,5 70,0

32 66,7 69,5

33 68,3 69,5

34 67,0 68,6

b) Show the data for FedEx's parcels forecast using the exponential smoothing method,

where = 0.2