What is the best forecasting method based on MAD?

*Please show excel formulas

V MAD A B D E F G H 1 K L M N O P Q R S T U 1 Problem Set 7 2 3 What is the best forecasting method based on MAD? 4 5 Week 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 6 West Chester 45 38 30 58 37 33 45 37 38 55 30 18 58 47 37 23 55 40 7 3-MA 8 Abs. Dev 9 5-MA 10 Abs. Dev 11 ES (3) 45 12 Abs. Dev 13 ES (4) 45 14 Abs. Dev 15 16 Note: To calculate Exponential smoothing method with alpha of 3 and 4, assume that F1=A1 (forecasting for week 1 is the same as actual value for week1) 17 18 Smoothing constant (a): 0.3 19 Smoothing constant (a): 0.4