Keywords
shelf-life control
dashboard analytics
Laravel
aviation maintenance
How to Cite
Abstract
Aircraft maintenance operations require accurate and traceable spare-part information, yet satellite-warehouse monitoring may remain dependent on spreadsheets even when an enterprise system is available. This study developed SkyStore, a web-based operational inventory application for a satellite warehouse at PT GMF AeroAsia Tbk. Requirements were identified through non-participant observation, a semi-structured interview with a warehouse supervisor, document review, and analysis of receiving, issuing, return-to-warehouse, in-transit, bin-location, and shelf-life processes. The application was developed through Rapid Application Development using Laravel and MySQL. SkyStore consolidates warehouse transactions, reference data, user permissions, dashboard summaries, import-export functions, and shelf-life notifications without replacing the corporate SAP platform. Functional evaluation covered 59 black-box scenarios across 15 modules, all of which produced the expected results. White-box basis-path evaluation covered 13 independent paths: three in login, five in incoming, and five in shelf-life processing, with cyclomatic complexity values of 3, 5, and 5. All tested paths conformed to the expected outcomes. The findings demonstrate functional and logic-path conformity, but do not establish improvements in processing time, inventory accuracy, or user acceptance because those outcomes were not measured.
References
1. Haya R. Hasan, Khaled Salah, Raja Jayaraman, Raja Wasim Ahmad, Ibrar Yaqoob, and Mohammed Omar “Blockchain-Based Solution for the Traceability of Spare Parts in Manufacturing,” IEEE Access, vol. 8, art. 100308-100322, 2020, doi: 10.1109/access.2020.2998159.
2. Yash Madhwal and Peter Panfilov “Blockchain And Supply Chain Management: Aircrafts’ Parts’ Business Case,” DAAAM Proceedings, art. 1051-1056, 2017, doi: 10.2507/28th.daaam.proceedings.146.
3. Harald Rødseth, Per Schjølberg, and Andreas Marhaug “Deep digital maintenance,” Advances in Manufacturing, vol. 5, no. 4, art. 299-310, 2017, doi: 10.1007/s40436-017-0202-9.
4. Abhijeet Ghadge, Georgia Karantoni, Atanu Chaudhuri, and Aravindan Srinivasan “Impact of additive manufacturing on aircraft supply chain performance,” Journal of Manufacturing Technology Management, vol. 29, no. 5, art. 846-865, 2018, doi: 10.1108/jmtm-07-2017-0143.
5. Sherif Mostafa, Sang-Heon Lee, Jantanee Dumrak, Nicholas Chileshe, and Hassan Soltan “Lean thinking for a maintenance process,” Production & Manufacturing Research, vol. 3, no. 1, art. 236-272, 2015, doi: 10.1080/21693277.2015.1074124.
6. Jean-Claude Baraka Munyaka and Sarma Venkata Yadavalli “INVENTORY MANAGEMENT CONCEPTS AND IMPLEMENTATIONS: A SYSTEMATIC REVIEW,” South African Journal of Industrial Engineering, vol. 33, no. 2, art. 15-36, 2022, doi: 10.7166/33-2-2527.
7. Ming K. Lim, Witold Bahr, and Stephen C.H. Leung “RFID in the warehouse: A literature analysis (1995–2010) of its applications, benefits, challenges and future trends,” International Journal of Production Economics, vol. 145, no. 1, art. 409-430, 2013, doi: 10.1016/j.ijpe.2013.05.006.
8. Saleh Alyahya, Qian Wang, and Nick Bennett “Application and integration of an RFID-enabled warehousing management system – a feasibility study,” Journal of Industrial Information Integration, vol. 4, art. 15-25, 2016, doi: 10.1016/j.jii.2016.08.001.
9. Aldona Jarašūnienė, Kristina Čižiūnienė, and Audrius Čereška “Research on Impact of IoT on Warehouse Management,” Sensors, vol. 23, no. 4, pp. 2213, 2023, doi: 10.3390/s23042213.
10. Setyawan Bayu Erlangga, Ajeng Yunita, and Sekarjatiningrum Rasmaydiwa Satriana “Development of Automatic Real Time Inventory Monitoring System using RFID Technology in Warehouse,” JOIV : International Journal on Informatics Visualization, vol. 6, no. 3, pp. 636, 2022, doi: 10.30630/joiv.6.3.1231.
11. Nadya Amanda Istiqomah, Putri Fara Sansabilla, Doddy Himawan, and Muhammad Rifni “The Implementation of Barcode on Warehouse Management System for Warehouse Efficiency,” Journal of Physics: Conference Series, vol. 1573, no. 1, art. 012038, 2020, doi: 10.1088/1742-6596/1573/1/012038.
12. Daria Minashkina and Ari Happonen “Warehouse Management Systems for Social and Environmental Sustainability: A Systematic Literature Review and Bibliometric Analysis,” Logistics, vol. 7, no. 3, pp. 40, 2023, doi: 10.3390/logistics7030040.
13. Josephine Katabaazi Nakyanzi, Freddy Eric Kitutu, Hussein Oria, and Pakoyo Fadhiru Kamba “Expiry of medicines in supply outlets in Uganda,” Bulletin of the World Health Organization, vol. 88, no. 2, art. 154-158, 2010, doi: 10.2471/blt.08.057471.
14. Hannatama Manik “Inventory Information System: Optimizing Inventory Management for Company Business Sustainability,” Information Technology and Systems, vol. 1, no. 1, art. 26-35, 2023, doi: 10.58777/its.v1i1.126.
15. Annanda Joti Sutejo and Andeka Rocky Tanaamah “Perancangan dan Implementasi Sistem Informasi Pendataan Barang dengan Aplikasi WDCSI “Warehouse Data Collection with System Information”,” AITI, vol. 19, no. 1, art. 103-119, 2022, doi: 10.24246/aiti.v19i1.103-119.
16. Mukti Ali, Yulianti, and Emil Riza Putra “Information Systems Stock Inventory in CV Kencana Motor using Laravel Frame,” TEPIAN, vol. 2, no. 4, art. 136-141, 2021, doi: 10.51967/tepian.v2i4.182.
17. Rakan Lawahiz Zhafran Ferial Faiz Al Laitsi and Ai Rosita “Making Web-Based Product And Inventory Applications Using The Laravel Framework (Case Study : Cv. Global Best Ls),” Jurnal Sains dan Informatika, vol. 8, no. 2, art. 144-150, 2022, doi: 10.22216/jsi.v8i2.1451.
18. Halimah Tus Sadiah and Muhamad Saad Nurul Ishlah “DESIGN OF THE INVENTORY APPLICATION OF CV DIVA KARYA MANDIRI USING RAD (RAPID APPLICATION DEVELOPMENT),” International Journal of Quantitative Research and Modeling, vol. 4, no. 2, art. 82-89, 2023, doi: 10.46336/ijqrm.v4i2.377.
19. Valian Yoga Pudya Ardhana, Muhammad Sapi’i, Hasbullah Hasbullah, and Eliyah A M Sampetoding “Web-Based Library Information System Using Rapid Application Development (RAD) Method at Qamarul Huda University,” The IJICS (International Journal of Informatics and Computer Science), vol. 6, no. 1, pp. 43, 2022, doi: 10.30865/ijics.v6i1.4031.
20. Per Runeson and Martin Höst “Guidelines for conducting and reporting case study research in software engineering,” Empirical Software Engineering, vol. 14, no. 2, art. 131-164, 2009, doi: 10.1007/s10664-008-9102-8.
21. Muhammad Miftakhul Syaikhuddin, Choirul Anam, Ade Rizky Rinaldi, and Moch El Bahar Conoras “Conventional Software Testing Using White Box Method,” Kinetik: Game Technology, Information System, Computer Network, Computing, Electronics, and Control, art. 65-72, 2018, doi: 10.22219/kinetik.v3i1.231.
22. Citra Teguh Pratala, Ebenhaezer Mahardhika Asyer, Ima Prayudi, and Aries Saifudin “Pengujian White Box pada Aplikasi Cash Flow Berbasis Android Menggunakan Teknik Basis Path,” Jurnal Informatika Universitas Pamulang, vol. 5, no. 2, pp. 111, 2020, doi: 10.32493/informatika.v5i2.4713.
23. Asri Maspupah “LITERATURE REVIEW: ADVANTAGES AND DISADVANTAGES OF BLACK BOX AND WHITE BOX TESTING METHODS,” Jurnal Techno Nusa Mandiri, vol. 21, no. 2, art. 151-162, 2024, doi: 10.33480/techno.v21i2.5776.
24. Supriyanto Supriyanto, Iskandar Fitri, and Nurhayati Nurhayati “Aplikasi Inventory Peralatan Mekanik Unit BRT UNAS Berbasis Web Menggunakan Metode Black-Box dan White-Box Testing,” Jurnal JTIK (Jurnal Teknologi Informasi dan Komunikasi), vol. 6, no. 2, art. 224-233, 2022, doi: 10.35870/jtik.v6i2.409.
25. Ogan M. Yigitbasioglu and Oana Velcu-Laitinen “The Use of Dashboards in Performance Management: Evidence from Sales Managers,” The International Journal of Digital Accounting Research, vol. 12, art. 36-58, 2012, doi: 10.4192/1577-8517-v12_2.
26. Daria Minashkina and Ari Happonen “Decarbonizing warehousing activities through digitalization and automatization with WMS integration for sustainability supporting operations,” E3S Web of Conferences, vol. 158, art. 03002, 2020, doi: 10.1051/e3sconf/202015803002.
27. Dewan Hafiz Nabil, Md. Habibur Rahman, Altaf Hussain Chowdhury, and Brenno Castrillon Menezes “Managing supply chain performance using a real time Microsoft Power BI dashboard by action design research (ADR) method,” Cogent Engineering, vol. 10, no. 2, art. 2257924, 2023, doi: 10.1080/23311916.2023.2257924.
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
Copyright (c) 2026 Muhamad Iqbal, Meidy Fajar Wahyu (Author)