Assume you are using the moving average forecasting method based on the last four observations. When creating the forecast for the last period, the oldest of the four observations was 1945 and the forecast was 2083. The true value for the last period turned to be to be 1977. Calculate your forecast for the next period within excel and show formulas.