Solve the question if you provide an excel file *this question should be done in excel with formula

Question 5:

The worksheet Q5 contains data on the demand of a particular product for each month of the previous year. a)

Forecast demand for the first month of the current year using a linear trendline, and an exponential smoothing model with a=0.6.

Note: for the linear trendline, include a graph with fitted forecasting result as part of your analysis; for the exponential smoothing model, assume F1=D1.

b)

Evaluate the MSE, MAD, MAPE and Bias based on the forecasting results from the previous year by each model. Which one of the two models do you prefer? Type your answers/explanations below your analysis.