Question: Given the trouble The Fresh Connection has been having with recent forecast accuracy, they have asked you to evaluate the past year's forecast method against

Given the trouble The Fresh Connection has been having with recent forecast accuracy, they have asked you to evaluate the past year's forecast method against the sales that actually occurred. In the tables below they are providing the sales for last year and the forecast values that were available at the time. You are to use MAPE to determine the level of accuracy for this forecast.
Last Year Sales
129,483
228,833
328,359
430,551
531,433
625,635
730,086
834,403
929,752
1030,667
1138,341
1235,313
Last Year Forecast
122,907
229,751
327,018
431,705
533,619
629,218
726,299
828,628
933,300
1036,873
1130,033
1233,302
Mean Absolute Percentage Error (MAPE), like MAD requires the absolute value of the errors. For MAPE find each absolute error as a percent of the actual sales in the period. Then find the average of those absolute percentage errors.

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!