Abstract :

This research delves into strategic financial management solutions for PT ABC during the COVID-19 pandemic, concentrating on the procurement of vital airport equipment. It examines the feasibility of securing essential equipment such as ARFF vehicles, X-ray machines, ambulances, and narcotics & explosive detectors amidst financial challenges. Utilizing financial models like predictive data estimation, Net Present Value (NPV) analysis, owner estimates, and Monte Carlo simulations, the study evaluates risk probabilities and distributions linked to different procurement strategies. The research underscores the pandemic’s profound impact on the global aviation sector, notably the steep decline in passenger traffic and resulting financial strains on PT ABC. Facing stringent regulatory obligations and the urgent need for equipment upgrade, the study investigates cost-effective procurement avenues, weighing the benefits of leasing against purchasing, given the company’s constrained cash flow. The study navigates through the challenges of limited RFI data and internal corporate regulations that restrict leasing durations. It provides a detailed financial analysis to pinpoint the most economical vendors and procurement approaches, leveraging owner estimates as a negotiation tool. Risk evaluation is conducted via Monte Carlo simulation, offering insights into the likelihood and impact of procurement-related risks. Concluding, the research finds that PT ABC can best manage its procurement needs by opting for leasing over buying. This approach aligns with the company’s financial strategy amidst the crisis, allowing for the acquisition of necessary equipment within financial limits. The study identifies Vendor A for ARFF vehicles, Vendor D for X-ray machines, Vendor E for ambulances, and Vendor G for narcotics & explosive detectors as the most cost-effective choices. Leasing, particularly on a 3-year term, emerges as the most viable financial option, in compliance with PT ABC’s internal regulations and operational requirements. Utilizing owner estimates for negotiations ensures more cost-effective procurement. The Monte Carlo simulation proves invaluable in evaluating procurement risks, indicating a higher risk associated with buying than leasing. This research aids PT ABC in strategic decision-making for equipment procurement, offering lessons for the broader aviation sector navigating post-pandemic recovery.

---

Keywords :

aviation industry, COVID-19, equipment procurement, Financial Analysis, Monte Carlo Simulation, NPV analysis, owner estimate, predictive data estimation, PT ABC

---

References :

1. Amarilies, H. S., Erwitie, G., & Sari, A. P. (2022). Comparison of data inquiry and cost structure methods to arrange owner estimate (Case study of carbon steel pipe procurement at PT XYZ). Jurnal Logistik Indonesia, 6(1), 22–31. https://doi.org/10.31334/logistik.v6i1.1851
2. Atems, B., & Yimga, J. (2021). Quantifying the impact of the COVID-19 pandemic on US airline stock prices. Journal of Air Transport Management, 97, 102141. https://doi.org/10.1016/j.jairtraman.2021.102141
3. Badan Pusat Statistik. (2023). Suku bunga kredit rupiah menurut kelompok bank – tabel statistik. Badan Pusat Statistik Indonesia. https://www.bps.go.id/id/statistics-table/2/MzgzIzI=/suku-bunga-kredit-rupiah-menurut-kelompok-bank.html
4. Bank Indonesia. (2023). Inflation Data. https://www.bi.go.id/en/statistik/indikator/data-inflasi.aspx
5. Bierman, H., & Smidt, S. (2007). The capital budgeting decision: Economic Analysis of Investment Projects.
6. Bouwer, J., Krishnan, V., Saxon, S., & Tufft, C. (2022). Taking stock of the pandemic’s impact on global aviation. McKinsey & Company. Retrieved December 17, 2023, from https://www.mckinsey.com/industries/travel-logistics-and-infrastructure/our-insights/taking-stock-of-the-pandemics-impact-on-global-aviation
7. Brigham, E. F., & Houston, J. F. (2018). Essentials of financial management.
8. Choi, J. H. (2021). Changes in airport operating procedures and implications for airport strategies post-COVID-19. Journal of Air Transport Management, 94, 102065. https://doi.org/10.1016/j.jairtraman.2021.102065
9. Danielson, M. G. (2023). Tax Shields, the Weighted Average Cost of Capital, and the Appropriate Discount Rate for a Project with a Finite Useful Life. Journal of Risk and Financial Management, 16(9), 398. https://doi.org/10.3390/jrfm16090398

10. Eastburn, S. (2000). Better Financial Planning with Balance Sheet Modeling: [1]. Journal of Performance Management, 13(2), 20–27.
11. Ferrari, C., Bottasso, A., Conti, M., & Tei, A. (2019). Investment Appraisal. In Elsevier eBooks (pp. 85–114). https://doi.org/10.1016/b978-0-12-813096-4.00005-6
12. Gitman, L. J., & Zutter, C. J. (2015). Principles of managerial finance. Pearson.
13. Huang, G. (2021). Missing data filling method based on linear interpolation and lightgbm. Journal of Physics, 1754(1), 012187. https://doi.org/10.1088/1742-6596/1754/1/012187
14. Hulett, D. (2017). Monte Carlo Simulation for Integrated Cost-Schedule Risk Analysis. In Advances in IT personnel and project management (pp. 29–60). https://doi.org/10.4018/978-1-5225-1790-0.ch002
15. Indonesia Financial Services Authority. (2023). Statistik Lembaga Pembiayaan Periode Agustus 2023. https://ojk.go.id/id/kanal/iknb/data-dan-statistik/lembaga-pembiayaan/Pages/Statistik-Lembaga-Pembiayaan-Periode-Agustus-2023.aspx
16. International Air Transport Association (IATA). (2021). Airline industry statistics confirm 2020 was worst year on record. IATA. Retrieved December 17, 2023, from https://www.iata.org/en/pressroom/pressroom-archive/2021-releases/2021-08-03-01/
17. International Civil Aviation Organization. (2022). Annex 17 – Aviation Security. https://www.icao.int/security/sfp/pages/annex17.aspx

18. International Civil Aviation Organization (ICAO). (2023). Effects of Novel Coronavirus (COVID-19) on Civil Aviation: Economic Impact Analysis. In International Civil Aviation Organization (ICAO). Retrieved December 17, 2023, from https://www.icao.int/sustainability/Documents/Covid-19/ICAO_coronavirus_Econ_Impact.pdf
19. King, R. G., & Watson, M. W. (2012). Inflation and unit labor cost. Journal of Money, Credit and Banking, 44(s2), 111–149. https://doi.org/10.1111/j.1538-4616.2012.00555.x
20. Levy, G. (2016). Generation of random variates. In Elsevier eBooks (pp. 35–56). https://doi.org/10.1016/b978-0-12-803579-5.00010-3
21. Ministry of Finance of the Republic of Indonesia. (2021). Pajak Pertambahan Nilai. https://fiskal.kemenkeu.go.id/fiskalpedia/2021/07/13/173618726358430-pajak-pertambahan-nilai-ppn
22. Ministry of Health of the Republic of Indonesia. (2014). Ministerial Regulation of the Republic of Indonesia Number 44 of 2014 regarding the Implementation of Healthy Ports and Airports. http://hukor.kemkes.go.id/uploads/produk_hukum/PMK%20No.%2044%20ttg%20Pelabuhan%20dan%20Bandar%20Udara%20Sehat.pdf

23. Ministry of Transportation Republic of Indonesia. (2014). Ministry of Transportation Regulation Number PM78 of 2014 Regarding Cost Standards in the Ministry of Transportation Environment. https://peraturan.go.id/id/permenhub-no-pm78-tahun-2014
24. Ministry of Transportation Republic of Indonesia. (2015). Ministerial Regulation of the Republic of Indonesia Number PM 127 of 2015 on the National Aviation Security Program. https://jdih.dephub.go.id/api/media?data=3aGuqq7kJEM590oO2cWiWT4jpNsVNYLQO49WULiJkqfc8m0jtdS0ocN48Xt6xHIOFH49aM7asWYrs8gldOug8tm68MPoIvYnBDO8VyYvF1nuhmKWNZYGC99pbIksibW7fdLTA6n9au3Zu59BdwekGUbD4PARdecFCXOM3G08a0xoN3KnJzOpKhCDoIeIeXi1dyXAswHrzYwLF6h72KC78suHQoXE

25. Ministry of Transportation Republic of Indonesia. (2017). Ministerial Regulation of the Republic of Indonesia Number PM 83 of 2017 on Civil Aviation Safety Regulation Part 139 Regarding Aerodromes. https://jdih.dephub.go.id/peraturan/detail?data=EbmIhiiZIyW0NDQ9CX55Zy8ge9C39k5ag4Odio9wh1Mt4eWrOw2Pve88X11JmgDjT648ZCuJIAHAN4fXmsGPVCbb4UoZoEwv6Gc8W4zsp883DXKM0hPRMD4ar3HJNMpqkDqyLMSV8UErVy56wfZ4iWnNVi

26. Minnullina, A., Minnullin, R., Frolova, О., & Kosyakova, I. V. (2020). Risk insurance cost estimation using the example of a transport company energy saving project. IOP Conference Series, 918(1), 012214. https://doi.org/10.1088/1757-899x/918/1/012214
27. Noor, N. M., Abdullah, M. M. a. B., Yahaya, A. S., & Ramli, N. A. (2014). Comparison of linear interpolation method and mean method to replace the missing values in environmental data set. Materials Science Forum, 803, 278–281. https://doi.org/10.4028/www.scientific.net/msf.803.278
28. Phillips, B. A. (1982). The impact of inflation upon U.S. highway maintenance and construction costs. Transportation Research Part A: General, 16(1), 1–11. https://doi.org/10.1016/0191-2607(82)90029-2
29. Platon, V., & Constantinescu, A. (2014). Monte Carlo method in risk analysis for investment projects. Procedia. Economics and Finance, 15, 393–400. https://doi.org/10.1016/s2212-5671(14)00463-8
30. Safitri, K. S. N., & Rahimudin. (2022). ANALISIS KELAYAKAN FASILITAS UNIT PERTOLONGAN KECELAKAAN PENERBANGAN DAN PEMADAM KEBAKARAN(PKP-PK) DI BANDAR UDARA DEWANDARU KARIMUNJAWA. Jurnal Publikasi Manajemen Informatika, 1(3), 95–101. https://doi.org/10.55606/jupumi.v1i3.511

31. Seyedan, M., & Mafakheri, F. (2020). Predictive big data analytics for supply chain demand forecasting: methods, applications, and research opportunities. Journal of Big Data, 7(1). https://doi.org/10.1186/s40537-020-00329-2
32. The Government of Indonesia. (2021). Law (Act) Number 7 of 2021 concerning Tax Regulation Harmonization. https://peraturan.bpk.go.id/Details/185162/uu-no-7-tahun-2021
33. The Government of Indonesia. (2022). Government Regulation No. 23 of 2022 (GR 23/2022). https://peraturan.go.id/id/pp-no-23-tahun-2022
34. Titman, S., Keown, A., & Martin, J. D. (2017). Financial Management: Principles and Applications.
35. Villadsen, B., Vilbert, M. J., Harris, D., & Kolbe, A. L. (2017). The capital asset pricing model and variations. In Elsevier eBooks (pp. 51–95). https://doi.org/10.1016/b978-0-12-812587-8.00004-6
36. Vinod, B. (2020). The COVID-19 pandemic and airline cash flow. Journal of Revenue and Pricing Management, 19(4), 228–229. https://doi.org/10.1057/s41272-020-00251-5
37. Wicaksono, A. Y. (2020). Applying ISO:31000:2018 as Risk Management Strategy on Heavy Machinery Vehicle Division. International Journal of Science, Engineering and Information Technology, 4(2), 198–202. https://doi.org/10.21107/ijseit.v4i2.6871