INVENTORY CONTROL OF BOLTS, NUTS, RIVETS, SCREWS, AND SEALS USING DISCRETE SIMULATION AND EXCEL SOLVER (GENETIC ALGORITHM) IN THE UNIT OUTBOUND PT AVIA TECHNICS DIRGANTARA

Ekra Sanggala; Raihan Tsani; Amri Yanuar

doi:10.69933/hpw6dd27

Authors

Ekra Sanggala Universitas Logistik dan Bisnis Internasional Author
Raihan Tsani D4 in Business Logistics, School of Logistics and Transportation, International University of Logistics and Business Author
Amri Yanuar Universitas Logistik dan Bisnis Internasional Author

DOI:

https://doi.org/10.69933/hpw6dd27

Keywords:

genetic algorithm, discrete simulation, excel solver

Abstract

PT Avia Technics Dirgantara is a company engaged in aircraft Maintenance, Repair, and Overhaul (MRO). This study focuses on the phenomenon of urgent shipments that occur repeatedly in the Outbound Unit, particularly domestic PLB shipments destined for FL Technics Denpasar, which result in logistics cost inefficiencies due to the use of shipping services with minimum charge rates that are not utilized optimally. This study uses a discrete simulation method combined with optimization using Excel Solver based on a Genetic Algorithm to determine the optimal procurement interval and shipment quantity. The results show that the proposed model is able to reduce total costs by 0.93% compared to actual conditions, with the largest savings coming from shipping costs, which account for 66% of the total actual shipping costs, making the method effective in improving the efficiency of inventory control and shipping operations.

Abstract

PT Avia Technics Dirgantara is a company engaged in aircraft Maintenance, Repair, and Overhaul (MRO). This study focuses on the phenomenon of urgent shipments that occur repeatedly in the Outbound Unit, particularly domestic PLB shipments destined for FL Technics Denpasar, which result in logistics cost inefficiencies due to the use of shipping services with minimum charge rates that are not utilized optimally. This study uses a discrete simulation method combined with optimization using Excel Solver based on a Genetic Algorithm to determine the optimal procurement interval and shipment quantity. The results show that the proposed model is able to reduce total costs by 0.93% compared to actual conditions, with the largest savings coming from shipping costs, which account for 66% of the total actual shipping costs, making the method effective in improving the efficiency of inventory control and shipping operations.

Downloads

Download data is not yet available.

Author Biographies

Ekra Sanggala, Universitas Logistik dan Bisnis Internasional

D4 Logistik Bisnis, Sekolah Logistik dan Transportasi
Raihan Tsani, D4 in Business Logistics, School of Logistics and Transportation, International University of Logistics and Business

D4 Logistik Bisnis, Sekolah Logistik dan Transportasi
Amri Yanuar, Universitas Logistik dan Bisnis Internasional

D4 Logistik Bisnis, Sekolah Logistik dan Transportasi

References

Urjiyah, N., Apriliana, I., & Wulandari, S. (2026). Simulation of Raw Material Inventory Control with Continuous Review System and Arena Models [Simulasi Pengendalian Persediaan Bahan Baku Dengan Model Continuous Review System dan Arena].

Chandra, A., Juliana Kristina, H., & Andres. (2022). Analisis Pengendalian Persediaan Bahan Baku Akrilik Menggunakan Metode EOQ Probabilistik dan Simulasi Monte Carlo pada PT. XYZ. Jurnal Mitra Teknik Industri, 1(1), 94–105.

Nirmal, A., Ahmad, & Kristina, J. (2022). PENGENDALIAN PERSEDIAAN BAHAN BAKU CABAI BUBUK UNTUK MENGELIMINASI STOCKOUT DENGAN SIMULASI MONTE CARLO. Jurnal Mitra Teknik Industri, 1(3), 329–339.

Sahban, M. A., Tri, I., Pristiyanilicia, B., Farida, P., Bara, T., Havid, W., Rina, S., Dwi, S., Tanto, G., Tantowie, A., Nur, M., & Wekke, I. S. (2024). METODOLOGI PENELITIAN. https://pustakainspirasi.com/

Mukhyi, A. M. (2023). METODOLOGI PENELITIAN (Vol. 1).

Shofiudin, M., Nur Aini, S. A., Ihsan, M. S., Wibowo, R. A. T., & Rolliawati, D. (2024). Discrete Event Simulation untuk Analisis Pelayanan Bisnis Kuliner (Studi Kasus : Gacoan Merr). JITU : Journal Informatic Technology And Communication, 8(1), 63–72. https://doi.org/10.36596/jitu.v8i1.1048

Fajarlestari, M. K., & Hardiyanti, M. (2024). Sistem Penjadwalan Karyawan dengan Algoritma Genetika. Jurnal Buana Informatika, 15(2), 142–152.

Iqbal, & Budi Santoso, E. (2025). FAKTOR-FAKTOR YANG MEMPENGARUHI KEPATUHAN WAJIB PAJAK BUMI DAN BANGUNAN DI KOTA SOLOK PROVINSI SUMATERA BARAT. Program Studi Akuntansi Keuangan Publik, Fakultas Ekonomi Dan Bisnis, Universitas Terbuka, 25(1).

Quraisy, A. (2022). Normalitas Data Menggunakan Uji Kolmogorov-Smirnov dan Saphiro-Wilk. J-HEST Journal of Health Education Economics Science and Technology, 3(1), 7–11. https://doi.org/10.36339/jhest.v3i1.42.

Aprillia, B., Nugraha, A. E., & Herwanto, D. (2022). Pengendalian Persediaan Bahan Baku Dengan Metode Economic Order Quantity (EOQ) Multi Item Pada Rumah Makan. JURMATIS (Jurnal Manajemen Teknologi Dan Teknik Industri), 4(2), 137. https://doi.org/10.30737/jurmatis.v4i2.2165

Wahyu purwanza, sena, wardhana, Dr. aditya, mufidah, ainul, reny renggo, yuniarti, kabubu hudang, adrianus, setiawan, Dr. jan, darwin, badi’ah, Dr. atik, putri sayekti, siskha, fadlilah, maya, luba kata respati nugrohowardhani, Dr. rambu, Dr. amiruddin, saloon, gazi, hardiyani, tati, banne tondok, santalia, dewi prisusanti, retno, & Dr. rasinus. (2022). METODOLOGI PENELITIAN KUANTITATIF, KUALITATIF DAN KOMBINASI.

Eska, J., Yani, Z., Afira, R., dkk. (2023). Konsep Dasar Pemodelan dan Simulasi. Padang Tekno Medika. https://buku-padangtekno.web.id/index.php/buku/article/view/5

Syaiful Anam, M., & Ramadhan, G. (2024). Pemanfaatan Solver Excel untuk Menentukan Mahasiswa Yang Layak Mendapatkan Beasiswa. In Exact Papers in Compilation (Vol. 6, Number 2).

Dzuldah Yudistira, F., Larasati, A., & Nurdiansyah, R. (2024). PERENCANAAN DAN PENGENDALIAN PERSEDIAAN MATERIAL MENGGUNAKAN SIMULASI MONTE CARLO DAN EOQ PROBABILISTIK (STUDI KASUS: PT PLN UP3 KEDIRI). Jurnal Teknik Industri ITN Malang.

Artika, C., Dur, S., & Husein, I. (2023). ANALISIS PENGENDALIAN PERSEDIAAN BAHAN BAKU TANDAN BUAH SEGAR (TBS) DENGAN METODE SIMULASI MONTE CARLO. Lebesgue: Jurnal Ilmiah Pendidikan Matematika, Matematika Dan Statistika, 4(1).