Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

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.

image text in transcribedimage text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Analysing The Value Proposition Of The Audit Process In Africa The Case Of Malawi

Authors: Daniel Dunga

1st Edition

3659166286, 978-3659166280

More Books

Students also viewed these Accounting questions