Can anyone help me determine which of the two forecasts should be chosen and give the rationale for the decision??? I have attached the two forecasts.

Number of Periods Analysis of Forecast Error Averaged 3 MAD MSE MAPE 5238.85000 91321353.66250 24.42787% Data Indicates which cells Moving average absolute in column to the right value of Period Number Data need a formula forecast percentage error error squared error error $19,761 2 $20,278 3 $20,688 4 $21,222 Formula Needed --> 21222.00000 21222.00000 450373284.00000 100.00% 5 $21,682 Formula Needed --> 20487.25000 1194.75000 1194.75000 1427427.56250 5.51% 6 $22.278 Formula Needed -> 20967.50000 1310.50000 1310.50000 1717410.25000 5.88% 7 $22,852 Formula Needed --> 21467.50000 1384.50000 1384.50000 1916840.25000 6.06% 8 $23,091 Formula Needed --> 22008.50000 1082.50000 1082.50000 1171806.25000 4.69% 9 Formula Needed -> 22475.75000 10 11 In the above figure, I plugged my numbers into the moving average template and found that the next periods 3 month moving average forecast is $22,478.75. Below you will see I used my data for the weighted moving average forecast and found the next periods forecast is $22,465.67 when the following weights are applied: 3 for most recent month, 2 for month before, and 1 for 2 months before. Analysis of Forecast Error Number of Periods MAD MSE MAPE + 5315.03333 91517683.78333 24.76639% Data Indicates which Weighted cells in column to moving average absolute Period the right need a value of percentage number data weight formula forecast error error squared error error $19,761 $20.278 $20,688 $21,222 Formula Needed => 21222.00000 21222.00000 450373284.00000 100.00% $21,682 Formula Needed -> 20396.8333 1285.16667 1285.16667 1651653.3611 5.939% $22,278 Formula Needed --> 20886.66667 1391.33333 1391.33333 1935808.44444 6.25% $22,852 Formula Needed -> 21363.00000 1489.00000 1489.00000 2217121.00000 6.5296 $23,091 Formula Needed --> 21903.3333 1187.66667 1187.66667 1410552.11111 5.1496 Formula Needed --> 22465.66667