Abstract
The motivation of this study originates from the need for the United States Transportation Command (USTRANSCOM) to estimate the annual flying hours budget for future fiscal years. USTRANSCOM is responsible for managing the global defense transportation network and creating movement plans in response to various world events. Recently, USTRANSCOM has overestimated annual flying hours by 25% and underestimated by 402%. This article presents analyses of historical flight data and a methodology to forecast annual flying hours. A main contribution of this article is the meticulous coupling of the forecasting methodology and intricacies of a complex and challenging real-world problem. The methodology may be extended to applications where historical data are used to predict future demand and requirements under uncertainty. An application using the programming language R and open source platform R Studio is developed to ingest data and produce forecasts using the methodology developed in this article. Due to data classification concerns, a representative data set of annual flights in and out of Los Angeles International Airport from 2006–2016 is used as a case study to validate the methodology for public release.
Similar content being viewed by others
References
Air Mobility Command (2005) AMC unveils new generation command and control system. Air Mobility Command, Retrieved May 31, 2017, https://www.amc.af.mil/News/Article-Display/Article/148923/amc-unveils-new-generation-command-and-control-system/
Anwar MW, Lewnard JA, Parikh S, Pitzer VE (2016) Time series analysis of malaria in Afghanistan: Using ARIMA models to predict future trends in incidence. Malaria Journal 15:566–576, DOI: 10.1186/s12936-016-1602-1
Bergmeir C, Benitez JM (2012) On the use of cross-validation for time series predictor evaluation. Information Sciences 191:192–213, DOI: 10.1016/j.ins.2011.12.028
Bleikh HY, Young WL (2014) Time series analysis and adjustment: Measuring, modelling and forecasting for business and economics. Gower Publishing Ltd., Aldershot, UK
Brockwell PJ, Davis RA (2002) Introduction to time series and forecasting. Springer, New York, NY, USA
Carey AF (2009) Transportation for DOD personnel and cargo relocation from the Iraq drawdown. U.S. Department of Defense, Retrieved May 31, 2017, https://media.defense.gov/2009/Dec/11/2001712406/-1/-1/1/10-025.pdf
DASD(SCI) (2014) DoD supply chain 2014 fact book. Deputy Assistant Secretary of Defense for Supply Chain Integration, Retrieved May 31, 2017, http://www.acq.osd.mil/log/sci/.inventory_mgmt.html/2014_Supply_Chain_Facts.pdf
DATA.GOV (2017) Los Angeles international airport - Flight operations by month. Data. Gov, Retrieved May 31, 2017, https://catalog.data.gov/dataset/los-angeles-international-airport-flight-operations-by-month-afb2a
Davey AM, Flores BE (1993) Identification of seasonality in time series: A note. Mathematical and Computer Modelling 18(6):73–81, DOI: 10.1016/0895-7177(93)90126-J
Defense Industry Daily Staff (2013) US defense logistics by the numbers: The cheat sheet. Defense Industry Daily, Retrieved May 31, 2017, https://www.defenseindustrydaily.com/usa-defense-logistics-data-014152/
Deshmukh SS, Paramasivam R (2016) Forecasting of milk production in India with ARIMA and VA R time series models. Asian Journal of Dairy and Food Research 35(1):17–22, DOI: 10.18805/ajdfr.v35i1.9246
Farooqi A (2014) ARIMA model building and forecasting on imports and exports of Pakistan. Pakistan Journal of Statistics & Operation Research 10(2):157–168, DOI: 10.18187/pjsor.v10i2.732
Gamberini R, Lolli F, Rimini B, Sgarbossa F (2010) Forecasting of sporadic demand patterns with seasonality and trend components: An empirical comparison between Holt-Winters and (S)ARIMA methods. Mathematical Problems in Engineering 2010:1–15, DOI: 10.1155/2010/579010
Granger CW, Newbold P (1974) Spurious regressions in econometrics. Journal of Econometrics 2:111–120
Hu S (2007) Akaike information criterion. North Carolina State University, Raleigh, NC, USA
Hyndman RJ (2006) Another look at forecast-accuracy metrics for intermittent demand. Foresight 4(4):43–46
Hyndman RJ, Athanasopoulos G (2013a) Selecting predictors. OTexts, Melbourne, Australia
Hyndman RJ, Athanasopoulos G (2013b) Forecasting: Principles and practice. Otexts, Melbourne, Australia
Hyndman RJ, Koehler AB (2005) Another look at measures of forecast accuracy. Monash University, Melbourne, Australia
Khuntia SR, Rueda JL, van der Meijden MA (2016) Forecasting the load of electrical power systems in mid- and long-term horizons: A review. IET Generation, Transmission & Distribution 10(16):3971–3977, DOI: 10.1049/iet-gtd.2016.0340
Kuzhda T (2014) Exponential smoothing for financial time series data. Socio-Economic Problems and the State 10(1):177–184
Ledolter J, Abraham B (1981) Parsimony and its importance in time series forecasting. Technometrics 23(4):411–414
McLeod AI (1992) Parsimony, model adequacy and periodic correlation in time series forecasting. The University of Western Ontario, Ontario, Canada
NIST/SEMATECH (2012a) Autocorrelation plot. NIST SEMATECH, Retrieved May 31, 2017, http://www.itl.nist.gov/div898/handbook/eda/section3/autocopl.htm
NIST/SEMATECH (2012b) Partial autocorrelation plot. NIST SEMATECH, Retrieved May 31, 2017, http://www.itl.nist.gov/div898/handbook/pmc/section4/pmc4463.htm
Racine J (2000) Consistent cross-validatory model-selection for dependent data: Hv-block cross-validation. Journal of Econometrics 99(1):39–61, DOI: 10.1016/S0304-4076(00)00030-0
Rani S, Raza I (2012) Comparison of trend analysis and double exponential smoothing methods for price estimation of major pulses in Pakistan. Pakistan Journal of Agricultural Research 25(3):233–239
Reifsnyder JS (2010) Working capital fund. American Society of Military Comptrollers, Retrieved May 31, 2017, www.asmconline.org/wp-content/uploads/2010PDIPresentations/14.pptx
StatSoft (2013) How to identify patterns in time series data: Time series analysis. StatSoft, Retrieved May 31, 2017, http://www.statsoft.com/Textbook/Time-Series-Analysis
Tashman LJ (2000) Out-of-sample tests of forecasting accuracy: An analysis and review. International Journal of Forecasting 16(4):437–450, DOI: 10.1016/S0169-2070(00)00065-0
The Pennsylvania State University (2017a) The periodogram. The Pennsylvania State University, Retrieved May 31, 2017, https://onlinecourses.science.psu.edu/stat510/node/71
The Pennsylvania State University (2017b) Partial autocorrelation function (PACF). The Pennsylvania State University, Retrieved May 31, 2017, https://onlinecourses.science.psu.edu/stat510/node/62
The Pennsylvania State University (2017c) Diagnostics. The Pennsylvania State University, Retrieved May 31, 2017, https://onlinecourses.science.psu.edu/stat510/node/65
Tratar LF, Strmcnik E (2016) The comparison of Holt-Winters method and multiple regression method: A case study. Energy 109:266–276, DOI: 10.1016/j.energy.2016.04.115
U.S. Joint Chiefs of Staff (2013) The defense transportation system. Joint Chiefs of Staff, Washington, DC, USA
USTRANSCOM (2016a) United States Transportation Command strategy. United States Transportation Command, Retrieved May 31, 2017, http://www.ustranscom.mil/cmd/USTRANSCOM_Strategy_current.pdf
USTRANSCOM (2016b) Organizational structure-program analysis and financial management. United States Transportation Command, Retrieved May 31, 2017, http://www.ustranscom.mil/cmd/organization/tcj8.cfm
Yaffee RA, McGee M (2000) Introduction to time series analysis and forecasting: With applications of SAS and SPSS. Academic Press, Cambridge, MA, USA
Acknowledgements
The authors would like to thank The MITRE Corporation and USTRANSCOM for their support for this research project.
Author information
Authors and Affiliations
Corresponding author
Electronic supplementary material
Rights and permissions
About this article
Cite this article
Schneider, R., Chen, X. Predicting Flight Demand under Uncertainty. KSCE J Civ Eng 24, 635–646 (2020). https://doi.org/10.1007/s12205-020-0857-9
Received:
Revised:
Accepted:
Published:
Issue Date:
DOI: https://doi.org/10.1007/s12205-020-0857-9