Question: Task 2A. The sales figures for Taym Caf over a 15-day period are shown in Table 1. Forecast the sales for Day 16 for the
Task 2A. The sales figures for Taym Caf over a 15-day period are shown in Table 1. Forecast the sales for Day 16 for the three products using an appropriate naive 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 Coffee Tea Hot chocolate 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 30 34 32 34 35 32 30 29 31 37 34 33 34 31 36 ? 18 17 19 19 22 23 23 25 24 26 27 28 29 31 33 ? 45 26 27 23 22 48 29 20 14 18 47 26 27 24 22 ? 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; il a lower alpha value; Discuss the implications of these results for manager of the caf. (15 marks) 2.2 The moving average method for 4 months. (10 marks) Table 2. Sales for the three products related to Q2. Task 2B Week Request 1 20 2 22 3 18 4 21 5 22 6 ? Task 2A. The sales figures for Taym Caf over a 15-day period are shown in Table 1. Forecast the sales for Day 16 for the three products using an appropriate naive 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 Coffee Tea Hot chocolate 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 30 34 32 34 35 32 30 29 31 37 34 33 34 31 36 ? 18 17 19 19 22 23 23 25 24 26 27 28 29 31 33 ? 45 26 27 23 22 48 29 20 14 18 47 26 27 24 22 ? 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; il a lower alpha value; Discuss the implications of these results for manager of the caf. (15 marks) 2.2 The moving average method for 4 months. (10 marks) Table 2. Sales for the three products related to Q2. Task 2B Week Request 1 20 2 22 3 18 4 21 5 22 6
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
