Question A supply chain analyst is analyzing past sales data. He obtained the following numbers: Week 1 2 3 4 5 6 7 Demand 2200 2100 2050 2120 2550 2340 2400 2370 2290 2020 2110 2105 2340 2410 2560 8 9 10 11 12 13 14 15 He thinks that three methods could be used to forecast future sales: 4-weeks simple moving average, and weighted moving average. 2.1 For the weighted moving average, the analyst wants to calculate a four-week weighted moving average with weights 0.4 for the most recent week, 0.3 for 2 weeks ago, 0.2 for 3 weeks ago and 0.1 for 4 weeks ago. Please apply the weighted moving average method to calculate the sales forecast in weeks 5 to 15 (1 mark) 2.2 For the simple moving average, the analyst wants to calculate a four-weeks simple moving average, Please apply the simple moving average methods to calculate the sales forecast in weeks 5 to 15. (1 mark) 23 For each of the two methods above (simple moving average & weighted moving average), calculate MAD and MAPE. Comment on these values. Which method do you recommend and why? (2 marks)