Reference no: EM132665093

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.

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