SkyStore Web Inventory Management for Aircraft Spare Parts at GMF AeroAsia

Muhamad Iqbal; Meidy Fajar Wahyu

doi:10.69693/jesa.v3i2.41

Authors

Muhamad Iqbal Universitas Pamulang
Meidy Fajar Wahyu Universitas Pamulang

DOI:

https://doi.org/10.69693/jesa.v3i2.41

Keywords:

Rapid Application Development, Laravel, shelf life, Dashboard Analytics, Material Traceability MRO

Abstract

PT GMF AeroAsia Tbk uses SAP as the primary material transaction system, but daily inventory activities at the Satellite Store still rely on spreadsheets, creating risks of input errors, duplicated data, delayed reporting, and limited automated shelf-life monitoring. This study developed SkyStore, a web-based inventory information system for aircraft spare-part operations. Data were collected through non-participant observation, directed interviews, and literature study. Development followed Rapid Application Development and was implemented using Laravel and MySQL. SkyStore centralizes incoming and outgoing materials, Return to Warehouse, in-transit tracking, bin mapping, shelf-life control, analytical dashboards, notifications, and role-based user management. Black Box Testing covered 59 functional scenarios across 15 modules, and all scenarios were successful. White Box Testing examined login, incoming, and shelf-life logic with cyclomatic complexities of 3, 5, and 5, respectively; all 13 independent paths produced the expected results. The system therefore supports more structured, traceable, and timely Satellite Store inventory monitoring.

Downloads

Download data is not yet available.

References

[1] A. A. Abdallah and I.-S. Fan, “Emerging Challenges of Digital Aircraft Operations and Maintenance: A Knowledge Management Perspective,” SSRN, 2020.

[2] F. Yuwaldi Away and S. Huzni, “Risk Mitigation in MRO Spare Parts Procurement Using House of Risk and FMEA (Case Study: PT. Pupuk Iskandar Muda),” Enrichment: Journal of Multidisciplinary Research and Development, vol. 3, no. 4, 2025.

[3] N. Amanda Istiqomah, P. Fara Sansabilla, D. Himawan, and M. Rifni, “The Implementation of Barcode on Warehouse Management System for Warehouse Efficiency,” J. Phys.: Conf. Ser., vol. 1573, no. 1, 2020, doi: 10.1088/1742-6596/1573/1/012038.

[4] M. Ghaddafi, S. Fatimah, A. Soekirman, L. Agusinta, and D. A. Arubusman, “Analysis of the Effect of Warehousing Management System and Employee Ability on Work Productivity through Lean Warehousing in the Warehouses of the National Disaster Management Agency (BNPB) and the Regional Disaster Management Agency (BPBD),” TRANSEKONOMIKA: Akuntansi, Bisnis dan Keuangan, vol. 5, no. 4, pp. 926–944, 2025, doi: 10.55047/transekonomika.v5i4.971.

[5] A. Sasmita br Daulay, E. Girsang, and S. Lestari Ramadhani Nasution, “Analysis of Medicine Procurement Planning using FIFO and FEFO Methods at West Pasaman Regional Hospital,” vol. 9, no. 2, 2024.

[6] B. Rudianto, Y. E. Achyani, and I. Ariyati, “Rancang Bangun Sistem Informasi Persediaan Obat Berbasis Web Menggunakan Model RAD,” Jurnal Teknik Komputer AMIK BSI, vol. 7, no. 2, 2021, doi: 10.31294/jtk.v4i2.

[7] F. G. Benarrivo, “Perancangan Sistem Informasi Inventory Penjualan Sparepart Berbasis Web Menggunakan Metode RAD,” Jurnal Teknologika (Jurnal Teknik-Logika-Matematika), vol. 13, no. 2, 2022.

[8] A. Y. Hasan, Y. N. Dewi, A. S. A. Budiyono, and R. I. Setiawan, “Implementasi Sistem Informasi Inventory Pada Momo Coffee,” Bit-Tech, vol. 7, no. 2, pp. 515–524, 2024, doi: 10.32877/bt.v7i2.1885.

[9] A. Ikhsanto and Y. N. Dewi, “Sistem Informasi Inventori Barang Berbasis Website Pada CV. Tekad Manunggal Menggunakan Analisis PIECES,” J. Inf. Syst. Appl. Manag. Account. Res., vol. 7, no. 4, pp. 1024–1036, 2023, doi: 10.52362/jisamar.v7i4.1267.

[10] S. Zalukhu and I. Handriani, “Aplikasi Sistem Inventory (Studi Kasus: PT. Cakra Medika Utama),” JSAI, vol. 2, no. 1, 2019.

[11] I. Sofani, S. Supriyati, and M. Mukhlisin, “Implementasi Sistem Dashboard Dalam Pemantauan Stok Gudang Dengan Lean Manufacturing Pada Komponen Printed Circuit Board Di PT DEI,” RIGGS: J. Artif. Intell. Digit. Bus., vol. 4, no. 2, pp. 3665–3676, 2025, doi: 10.31004/riggs.v4i2.1081.

[12] Sugiyono, Metode Penelitian Kuantitatif, 2019.

[13] P. Beynon-Davies, C. Came, H. Mackay, and D. Tudhope, “Rapid application development (RAD): An empirical review,” Eur. J. Inf. Syst., vol. 8, no. 3, pp. 211–232, 1999, doi: 10.1057/palgrave.ejis.3000325.

[14] N. Hikmah, I. Aprilia, and A. Fredianto, “Implementation of the Laravel Framework in Developing a Web-Based Credit Application Submission System at KSU Berlian,” INTRO: J. Informatika dan Teknik Elektro, vol. 4, no. 1, pp. 34–42, 2025, doi: 10.51747/intro.v4i1.414.

[15] F. Luthfi, “Penggunaan Framework Laravel Dalam Rancang Bangun Modul Back-End Artikel Website Bisnisbisnis.ID,” JISKa, vol. 2, no. 1, 2020.

[16] A. Syarifudin, H. Prayogo Pangestu, M. Yusuf, and E. Fitri, “Web-Based E-Rapor Application Development Using Laravel 11 at SDN Burangkeng 05,” J. Teknologi dan Open Source, vol. 8, no. 2, pp. 554–568, 2025, doi: 10.36378/jtos.v8i2.4671.

[17] F. Soufitri, Konsep Sistem Informasi, 2023.

[18] R. Fitri, J. Kurniawan Adi, and J. Nasri, “Rancangan Sistem Informasi Persediaan Barang Alat Tulis Kantor (ATK) Berbasis Web Pada PT Sumber Niaga Pratama,” 2023.

[19] N. E. Cagiltay, G. Tokdemir, O. Kilic, and D. Topalli, “Performing and analyzing non-formal inspections of entity relationship diagram (ERD),” J. Syst. Softw., vol. 86, no. 8, pp. 2184–2195, 2023, doi: 10.1016/j.jss.2013.03.106.

[20] S. Mulyati, A. Sujatmoko, T. Irfan, M. Wira, R. Afif, D. Rizky, and A. Pratama, “Normalisasi Database dan Migrasi Database untuk Memudahkan Manajemen Data,” n.d.

[21] D. Puspitasari, C. Rahmad, and M. Astiningrum, “Normalisasi Tabel Pada Basisdata Relasional,” in Prosiding SENTIA 2016, Politeknik Negeri Malang, 2016.

[22] P. N. G. Azra, M. Ikwanda, N. P. Sari, T. W. Prameswari, and F. Tamzil, “Optimalisasi Sistem Database sebagai Pilar Penguatan Sistem Informasi Manajemen di Era Transformasi Digital Modern,” J. Publikasi Sistem Informasi dan Manajemen Bisnis, vol. 4, no. 2, pp. 487–496, 2025, doi: 10.55606/jupsim.v4i2.5031.

[23] Kurniadi, V. A. Andrea, J. Panjaya, and K. Jingga, “Performance Comparison of Relational Database Management Systems for Processing Large Amount of Text Data,” Procedia Comput. Sci., vol. 269, pp. 150–160, 2025, doi: 10.1016/j.procs.2025.08.268.

[24] R. Agarwal, “Optimized Database Sharding Techniques for High-Performance MySQL Applications,” Int. J. Comput. Exp. Sci. Eng., vol. 11, no. 4, 2025, doi: 10.22399/ijcesen.4340.

[25] M. Schneider and D. Martínez, “A Comparative Benchmark Analysis of Transactional and Analytical Performance in PostgreSQL and MySQL,” Int. J. Mod. Comput. Sci. IT Innov., vol. 10, pp. 51–63, 2025.