supply chain

A supply chain analyst is analyzing past sales data. He obtained the following numbers: 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-month weighted moving average with weights 0.65,0.3, and 0.05 . 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: 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-month weighted moving average with weights 0.65,0.3, and 0.05 . Please apply the weighted moving average methods to calculate the sales forecast in weeks 5-15