Can someone explain how they get this answer? It would be awesome with excel calculation. Thank you

recasting Questions (PractX a/moodle/pluginfile.php/3038383/mod_resource/content/1/Forecasting%20Questions%20%28Practice%29.pdf Home | Chegg.com MyConcordia - Conc... N http://www.netflix.co.in Dashboard Recipient Info - Tran... Ma The linear trendline forecast appears to be the most accurate. 2 04. (Ref: 2.12-15. p568): The Willow River Mining Company mines and ships coal. It has experienced the following demand for coal during the past eight years. Year Coat Sales (tons 1 4260 4510 3 4050 3720 3900 3470 7 2890 3100 4 5 6 8 Develop an adjusted exponentially smoothed model (a +0.30, B = 0.20) and a linear trend line model, and compare the forecast accuracy of the two using MAD, and indicate which forecast seems to be most accurate. SOLUTION: Adjusted Exponentially Lincar Exponentially Smoothed Trend Smoothed Forecast Line Forecast (a=0.30, y4,690 Year Sales (a=0.30) B=0.20) -211.67x 1 4,260.00 4,478.33 2 4,510.00 4,260.00 4,260.00 4,266,67 3 4,050.00 4,335.00 4,350.00 4,055.00 4 3,720.00 4,249.50 4,244.40 3,843.33 5 3,900.00 4,090.65 4,054,80 3,631.67 6 3.470.00 4,033.45 3.993.34 3,420.00 7 2,890.00 3,864.42 3,798.52 08.33 8 3,100.00 3,572.09 3.460.91 2,996.67 9 3.313.19 2,785.00 Adjusted Exponentially Smoothed Linear Trend Forecast Line MAD 431,71 166.25 E -2.522 The linear trendline forecast appears to be the most accurate. 05. Ref.12.17 0563: Townside Food Vending operates vending machines in office buildings, the airport bus 3 50