Question: 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

Please show the work on Excel. Yellow boxes should be filled

Please show the work on Excel. Yellow boxes

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!