Solve parts c$,$d$,$e$,$f in EXCEL

Therano a healthcare company, has collected the following sales data.

a$)$ Forecast for the month of July using Na$$ve method. Calculate MAD & MSE.

b$)$ Forecast for the month of May using $3-$month moving average. Calculate MAD & MSE

Assume that the base value at the end of month $2$ was $125$ and the trend value was $-10.$

Using $=0\mathrm{.}2$ and $=0\mathrm{.}4,$ answer the following questions.

c$)$ What is the forecast for month of May made at the end of April?

d$)$ What is the forecast for July made as of the end of June?

e$)$ What is the forecast for August made as of the end of July?

f$)$ Which of these forecasts do you prefer and why?