A supply chain analyst is analyzing past sales data. He obtained the following numbers: Week Demand...

Transcribed Image Text:

A supply chain analyst is analyzing past sales data. He obtained the following numbers: Week Demand 1 1045 2 1077 3 2346 4 2264 5 2109 6 2115 63 1953 2232 2356 2426 2378 2333 8 9 BEHE 10 11 12 13 14 15 2129 2196 He thinks that two methods could be used to forecast future sales: linear regression and weighted moving average. (1 mark) 3.1 Using Excel, please run linear regression on this data. Based on the results you obtain; do you think that linear regression is appropriate in this case? Why? 3.2 For the weighted moving average, the analyst wants to calculate a three-period weighted moving average with weights 0.6, 0.3 and 0.1. Please apply the weighted moving average methods to calculate the sales forecast in weeks 5-15. A supply chain analyst is analyzing past sales data. He obtained the following numbers: Week Demand 1 1045 2 1077 3 2346 4 2264 5 2109 6 2115 63 1953 2232 2356 2426 2378 2333 8 9 BEHE 10 11 12 13 14 15 2129 2196 He thinks that two methods could be used to forecast future sales: linear regression and weighted moving average. (1 mark) 3.1 Using Excel, please run linear regression on this data. Based on the results you obtain; do you think that linear regression is appropriate in this case? Why? 3.2 For the weighted moving average, the analyst wants to calculate a three-period weighted moving average with weights 0.6, 0.3 and 0.1. Please apply the weighted moving average methods to calculate the sales forecast in weeks 5-15.