Publication Type

Conference Proceeding Article

Version

publishedVersion

Publication Date

3-2021

Abstract

COVID-19 has severely impacted the global aviation industry, causing many airlines to downsize or exit the industry. For airlines which attempt to sustain their operations, they will need to respond to the increase in passenger and cargo demand, as countries recover slowly from the crisis due to the availability of vaccines. We built a series of spreadsheet models to first project the COVID-19 recovery rates by countries from 2021 to 2025, then forecast the passenger and cargo demand, using historical data as base figures. Using the financial and operation data, the revenue, expense, and profit can be projected, then an optimization model is used to determine the optimal number of aircrafts to be allocated to passenger and cargo respectively, and the number of aircrafts to be put into storage. We applied our models to data extracted on 26 October 2020 to obtain insights on the impact of COVID-19 on Singapore Airline’s profit recovery and aircraft allocation. Our sensitivity analysis shows that Singapore Airline’s profitability and aircraft allocation in 2023 and 2024 will be very sensitive to the vaccine release date. Our models can be applied to another airline, by replacing the financial and operation data, to provide similar insights.

Keywords

COVID-19, Singapore Airlines, spreadsheets modeling, profit recovery, aircraft allocation

Discipline

Asian Studies | Numerical Analysis and Scientific Computing | Operations Research, Systems Engineering and Industrial Engineering | Transportation

Research Areas

Intelligent Systems and Optimization

Publication

Proceedings of the 11th Annual International Conference on Industrial Engineering and Operations Management 2021: Singapore, Virtual, March 7-11

First Page

1

Last Page

13

Publisher

IEOM Society

Embargo Period

7-8-2021

Copyright Owner and License

Publisher

Download

Share

COinS