Base to Base is a manufacturer of baseball caps that have various team logos in an assortment of designs and colors. The company had monthly sales for the past 24 months as follows. 1 8.2 2 7.5 3 8.1 4 9.3 5 9.1 6 9.5 7 10.4 8 9.7 9 10.2 10 10.6 11 8.2 12 9.9 13 10.3 14 10.5 15 11.7 16 9.8 17 10.8 18 11.3 19 12.6 20 11.5 21 10.8 22 11.7 23 12.5 24 12.8
1. Develop a forecast table computing the forecasts using the following techniques: 3 month moving average, weighted 3 month moving average (with weights of 0.5, 0.3, 0.2 respectively) and exponential smoothing (alpha 0.2)
2. Calculate the three forecast errors using the MAD
3. Develop an alternative forecast method that has a lower error than the three ones used previously.