Find answer for question a, b and c

Question 4 Listed below are actual sales data, applied to derive various forecasting models. Year Actual sales 2012 150 2013 120 2014 160 2015 130 2016 170 2017 170 2018 150 (a) Determine the forecast error using MAPE if, the forecasting model is Weighted Moving Average (n-3) where weights are 20, 2,5. Keep 2 decimal points for all calculation step. Show sufficient calculation steps for partial credit. (7 marks) (b) Determine the forecast error using MSE if, the forecasting model is Linear Regression, where slope = 5 and intercept = 130. Keep 2 decimal points for all calculation step. Show sufficient calculation step for partial credit (7 marks) (c) From the perspective forecasting error, explain why it would be incorrect to compare value of MAPE and MSE (5 marks) (d) Between part (a) and part(b), determine which forecasting model in de accurate Perform Question 4 Listed below are actual sales data, applied to derive various forecasting models. Year Actual sales 2012 150 2013 120 2014 160 2015 130 2016 170 2017 170 2018 150 (a) Determine the forecast error using MAPE if, the forecasting model is Weighted Moving Average (n-3) where weights are 20, 2,5. Keep 2 decimal points for all calculation step. Show sufficient calculation steps for partial credit. (7 marks) (b) Determine the forecast error using MSE if, the forecasting model is Linear Regression, where slope = 5 and intercept = 130. Keep 2 decimal points for all calculation step. Show sufficient calculation step for partial credit (7 marks) (c) From the perspective forecasting error, explain why it would be incorrect to compare value of MAPE and MSE (5 marks) (d) Between part (a) and part(b), determine which forecasting model in de accurate Perform