hello, i just need help with part c, where it asks "The MAD for the forcast develiprd using a weighted 2-year moving adverage with weights of 0.40 and 0.60 = __ miles"

I included my spreadsheets if that helps, thanks!

a) Using a 2-year moving average, the forecast for year 6=3775 miles (round your response to the nearest whole number). b) If a 2 your moving average is used to make the forecast, the MAD based on this = 58.3 mlles (round your response to one decimal place). (Hint: You wil have anly 3 ywars of matahed date.) c) The forecast for year 6 ubing a weighted 2-year moving average with woights of 0.40 and 0.60 (the woight of 0.60 is for the most recent period) * 3770 mies found your response to the nearost whole numbor). The MAD for the forecast deveioped using a weighted 2 -year moving average wath weights of 0.40 and 0.60= miles (round your response to one decimat place). (hink. You wili have only 3 years of mstched data.) Year \begin{tabular}{|r|r|r|r|} \hline & Mileage & Two Year Moving Ave Forcast Erort \\ \hline 1 & 3,050 & & \\ \hline 2 & 3950 & & \\ \hline 3 & 3500 & 3,500 & 0 \\ \hline 4 & 3800 & 3725 & 75 \\ \hline 5 & 3750 & 3650 & 100 \\ \hline \end{tabular}