show the working with excel formulas please and how to calculate each cell. thank you.

D H E The data below lists actual averge new car prices from 2012 through 2020 t 3-pt moving avg Forecasts 5-pt moving avg Exp Smoothing alpha = 7 0 1 2 3 4 Year 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Avg New Car Price $30,748 $32,880 $32,386 $33,560 $34,100 $35,041 $35,742 $36,718 $37,851 34,500 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 a 21 22 b. 23 24 25 26 27 28 d. 29 30 5 6 7 8 9 *t is the number of years elapsed since 2012. Calculate a 3-point moving average forecast for years 2017-2021. Put your answers in the designated columns above. Calculate a 5-point moving average forecast for years 2017-2021. Put your answers in the designated columns above, Calculate an exponential smoothing forecast for years 2017-2021 with alpha = 7. Put your answers in the designated columns above + Round all forecasts to the nearest dollar Without calculating any performance measures, why is the 3 point moving average more accurate than the 5 point moving average forecast? Write your answer here