Answer Happy

Please show the work on Excel. Yellow boxes should be
filled
4a. One of your employees developed two models for forecasting sales and tried to fit the model to past sales data, as shown below. You're not sure which method is better so you decide to calculate the Mean Absolute Percentage Error to explain which forecasting method (Method 1 or Method 2) is "better." Show your work in calculating the MAPE and make a conclusion as to which is a "better" method for predicting future sales. e 1 20 e2 -10 |e1| 20 le21 10 |e1/A |e2|A 0.049 0.024 Mo Counter 1 2 3 15 Month J F M А M J J A Actual Sales 410 420 420 445 440 450 445 460 4 Method 1 Method 2 390 420 395 420 380 410 400 450 395 420 445 420 460 450 470 40 5 450 45 5 6 7 8 10 -5 -10 5 -15 40 5 45 30 25 10 5 10 5 15 0.095 0.011 0.102 0.067 0.056 0.024 0.011 0.023 0.011 0.034 30 25 MAPE= 4b. Which forecasting method is better? method 1 gives greater error, so second method is better