MIA Final Project: Step by step

1. Create a word report that starts with an executive summary. You do not need to attach spreadsheet.

2. Choose the best fitting forecast. Look up the meaning of moving average and exponential smoothing. In the spreadsheet you can change the smoothing alpha and see what effect it has on the fit.

3. The fit takes the difference between each years forecast and actual, and squares it and adds them all together. Check the cells to see this.

4. To give more emphasis to the recent fit for the last five years, for each of these years take the squared difference between forecast and actual and multiply it by 2.

5. Does this change the best fitting forecast? Remember to retest different alphas.

6. Using their comparative growth between 2020 and 2021 of MIA Cargo volume and Miami-Dade GDP (please add the needed reference to Miami-Dade GDP), has MIA Cargo volume been a major driver of Miami-Dade GDP growth?

7. What would be a better way of testing the relationship between the two growth rates? (Hint you would add another two columns to the analysis). You do not have to do this but if you do, you will earn bonus points. You can still get 100% by not doing it.

8. Please check the annual reports for the years highlighted in the spreadsheet. How does the annual report explain the significant decline or increase in annual growth rate that occurred?

9. From the 2021 annual report is there any statement about a source of future new business that will significantly jump the growth in Cargo weight through MIA and would change future forecasts?

10. Go back to 1. And check to make sure you follow these steps.

lease check annual report to see if it explains why MIA Air Cargo Activity (imillions of tons) Source: MIA Revenue Financial Statistics Annual Reports lease check annual report to see if it explains why MIA Air Cargo Activity (imillions of tons) Source: MIA Revenue Financial Statistics Annual Reports