PLEASE ONLY SOLVE USING EXCEL and show screenshot

You are employed as an Operations and Planning Manager at Tablon, a growing

multinational engineering firm. The following data are their Operational costs year after

year.

a$)$Plot the given data displaying the Trendline.

b$)$ Forecast for period $8$ using $3-$month moving average and exponential smoothing with

$a=0\mathrm{.}4$

c$)$ Forecast for period $10,11,12$ using trend line projection and calculate the MAPE.

d$)$ Assume the base value at the end of period $2$ was $40$ million and the trend was $-5.$ What

would be the forecast for the period $8(=0\mathrm{.}1,=0\mathrm{.}2)$