Sales Bags 546 628 491 710 Week Forecast 601 601 628 2 410 S

Sales (Bags) 546 628 491 710 Week Forecast 601 601 628 2 410

Solution

A B C = A-B D E = D/A Week Sales (Bags) Forecast Deviation Absolute Deviation % Deviation 1 546 601 -55 55 10.07% 2 628 601 27 27 4.30% 3 491 628 -137 137 27.90% 4 710 442 268 268 37.75% 5 683 486 197 197 28.84% 6 410 486 -76 76 18.54% Total 760 127.40% ÷ No of Weeks ÷ 6 ÷ 6            126.7 21.2% MAD MAPE Part A Part B