Q2. (50 Marks in total) Task 2A. The sales figures for Taym Cafe over a 15-day period are shown in Table 1. Forecast the sales for Day 16 for the three products using an appropriate nalve approach. Justify your choice of forecasting approach and explain your answers. (15 marks) Table 1. Sales for the three products related to Q2. Task 2A Day 10 11 12 13 14 15 16 Coffee 37 34 33 34 31 38 ? 1 2 3 4 5 6 7 8 9 30 34 32 34 35 32 30 29 31 18 17 19 19 22 23 23 25 24 45 26 27 23 22 48 29 20 14 Tea 31 33 2 26 27 18 47 28 29 26 27 Hot 24 22 ? chocolate Task 2B. The sales team needs to know the predicted orders for Week 6. Based on the data given in Table 2. provide a forecast of these orders using: 2.1. a) The single exponential smoothing method using alpha value of 0.30 and Week 2 forecasted sales of 20. (10 marks) 2.1. b) Apply the single exponential smoothing method to the same data using a higher alpha value ii. a lower alpha value Discuss the implications of these results for manager of the caf. (15 marks) 1. 2.2 The moving average method for 4 months. (10 marks) 1 Table 2. Sales for the three products related to Q2. Task 2B Week Request 20 2 22 3 18 4 21 5 22 6 ? AN Q2. (50 Marks in total) Task 2A. The sales figures for Taym Cafe over a 15-day period are shown in Table 1. Forecast the sales for Day 16 for the three products using an appropriate nalve approach. Justify your choice of forecasting approach and explain your answers. (15 marks) Table 1. Sales for the three products related to Q2. Task 2A Day 10 11 12 13 14 15 16 Coffee 37 34 33 34 31 38 ? 1 2 3 4 5 6 7 8 9 30 34 32 34 35 32 30 29 31 18 17 19 19 22 23 23 25 24 45 26 27 23 22 48 29 20 14 Tea 31 33 2 26 27 18 47 28 29 26 27 Hot 24 22 ? chocolate Task 2B. The sales team needs to know the predicted orders for Week 6. Based on the data given in Table 2. provide a forecast of these orders using: 2.1. a) The single exponential smoothing method using alpha value of 0.30 and Week 2 forecasted sales of 20. (10 marks) 2.1. b) Apply the single exponential smoothing method to the same data using a higher alpha value ii. a lower alpha value Discuss the implications of these results for manager of the caf. (15 marks) 1. 2.2 The moving average method for 4 months. (10 marks) 1 Table 2. Sales for the three products related to Q2. Task 2B Week Request 20 2 22 3 18 4 21 5 22 6 ? AN