$\backslash$table$[[2016,77],[2017,85],[2018,94],[2019,96],[2020,100],[2021,93],[2022,104],[2023,109]]$

You want to forecast the average number of economy class passengers per flight for this year $(2024).$ Upload an excel sheet showing your calculations and clearly labeled answers to the following questions:

a$)$ What would be the forecast for this year $(2024)$ using the last$-$value forecasting method?

b$)$ What would be the forecast for this year $(2024)$ using the averaging forecasting method?

c$)$ Determine the forecast for this year $(2024)$ using the simple moving$-$average method, where the average calculation is based on data for the past five years.

d$)$ Determine the forecasts for the past $12$ years using exponential smoothing with trend. Use $5$ as the value for the first trend, and use $65$ as the value for the first smoothed forecast. Use smoothing constants alpha $=0\mathrm{.}2$ and beta $=0\mathrm{.}25.$ Calculate MAD, MSE, and MAPE. What would be the forecast for this year $(2024)?$

e$)$ Use regression to develop a forecast for this year $(2024)?$