$\backslash$table$[[$Year$,1,2,3,4,5],[$Mileage$,3,050,4,000,3,500,3,750,3,700]]$

a$)$ Using a $2-$year moving average, the forecast for year $6=3725$ miles $($round your response to the nearest whole number$).$

b$)$ If a $2-$year moving average is used to make the forecast, the MAD based on this $=33\mathrm{.}33$ miles $($round your response to one decimal place$).($Hint: You will have only $3$ years of matched data.$)$

c$)$ The forecast for year $6$ using a weighted $2-$year moving average with weights of $0\mathrm{.}45$ and $0\mathrm{.}55($the weight of $0\mathrm{.}55$ is for the most recent period$)=3722\mathrm{.}5$ miles $($round your response to the nearest whole number$).$

The MAD for the forecast developed using a weighted $2-$year moving average with weights of $0\mathrm{.}45$ and $0\mathrm{.}55=53\mathrm{.}3$ miles $($round your response to one decimal place$).($Hint: You will have only $3$ years of matched data.$)$

d$)$ Using exponential smoothing with $=0\mathrm{.}30$ and the forecast for year $1$ being $3,050,$ the forecast for year $6=3,556$ miles $($round your response to the nearest whole number$).$