Claim Missing Document
Check
Articles

Web-Based Stock Overstock Warning System for Spare Parts Inventory Using Linear Regression Rizky Fadillah Putra Pratama; R Wisnu Prio Pamungkas; Fried Sinlae
Jurnal Kecerdasan Buatan dan Teknologi Informasi Vol. 5 No. 3 (2026): September 2026 In progress.
Publisher : Ninety Media Publisher

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.69916/jkbti.v5i3.568

Abstract

Inventory management in the automotive spare parts industry faces a criticalchallenge in managing overstock conditions, which lead to increased storagecosts and capital freezing. PT. Dipo Internasional Pahala Otomotif currentlymanages spare parts inventory manually, without any predictive alert systemcapable of detecting potential overstock based on sales data. This study developsa web-based overstock warning system using the Simple Linear Regressionalgorithm implemented in the Laravel framework to predict spare parts stockrequirements and automatically trigger overstock alerts. The system was builtfollowing the Waterfall development methodology through seven sequentialphases: planning, analysis, design, coding, testing, implementation, and maintenance.The linear regression model uses time period as the independentvariable (X) and stock quantity as the dependent variable (Y ), forming theprediction equation Y = a + bX. Based on a simulation with n = 4 periods,the resulting equation Y = 7 + 2.7X predicted a stock of 20.5 units in period5, which exceeded the defined overstock threshold. System evaluation usingBlack Box Testing confirmed that all functional modules operated correctly.The system successfully provides automated overstock detection and real-timealert notifications, enabling more accurate and data-driven inventory decisionsat PT. Dipo Internasional Pahala Otomotif.
Co-Authors Abdillah, Iqbal Ade Irawan Adi Muhajirin Agus Hidayat Ahmad Fajar Ahmad Fajar Ahmad Sofiyan Al Fachri Nurfath Alfaridzy , Muhamad Dicky Alfauzi Hidayatullah, Dimas Alprian Baharaja Sitorus Andoko, Natania Bunga Prameswari Anida Fadla Silvia Anugrah Sandy Yudhasti Ardian Nugraha Siregar, Dika Arfan Dwi Madya Arief Wibowo Arin Novita Dewi Bagas Djoko Haryanto Baharaja Sitorus, Alprian Bayu Adji Anasyah Bowono, Prayuda Danu Righel Wibowo Devi Putri Ningsih Didin Sjarifudin, Didin Dimas Abimanyu Prasetyo Dimas Sanjaya Dwipa Handayani Eka Syahputra, Vicky Elfan, Aditya Erlangga Respaty Fachrudin, Rio Fahrizal Setiawan Fairuz Hadi Farhan Dwi Setiawan Febri Setiyansyah Hafiyan Rizqi Sanjaya Hakiem, Muhammad Luqmanul Hapzi Ali Haryanto , Bagas Djoko Hedi Saepudin, Tubagus Hendharsetiawan, Andy Achmad Herlan Ryuchi Christian Herland Sunaryo Ikbal Eka Saputra Ilham Maulana Ilham Maulana Ilham maulana Ilyas Ahmad Dafianto Ipon Syawal Adilah Irwanda, Eko Istianingsih Sastrodiharjo, Istianingsih Jannah, Wildanul Jeremiah Marvin Kapoyos Kalmany, Laudza K Khoiridha Askiyyah Linda Fitriyani Lubis, Hendarman M Syahrul M. Syahrul M.Syahrul Marinda, Nera Maulana, Zaky Mochamad Reyhan Gusnaldi Muhammad Dicky Alfaridzi Muhammad Rayhan Muhammad Yasir Muhammad Yasir Muhammad Yasir Mukhlis Mukhlis Mukhlis Mukhlis Nanda Eka Rindiati Nani Sudiarti Nani Sudiarti Nurcholis Nurfiyah Nurhidayat, Fadayen Pahrizal Pamungkas, R Wisnu Prio Prayuda Bowono R Wisnu Prio Pamungkas R Wisnu Prio Pamungkas R Wisnu Prio Pamungkas R Wisnu Prio Pamungkas Pamungkas R.Wisnu Prio Pamungkas Rasim, Rasim Rifqi Hafidz Rio Fachrudin Rizky Fadillah Putra Pratama Rizqi Sanjaya, Hafiyan Robertus Suraji Rony, Zahara Tussoleha Rossa, Elia Ruly Setiaji Ruly Setiaji Ryuchi Christian, Herlan Sabila Rosyad, Fatah Safriadi, Wahyu Samidi Samidi Saputra , Ikbal Eka Setiawan, Fahrizal Setiyansyah, Febri Setya Maulana, Richi Situmorang, Lusiana Steno Birama, Perdana Sudiarti, Nani Tawakal, Henryansyah Tawaqal, Henryansyah Tri Bakti Purba, Daud Tri Widyastuti Ulfa Amelia Wildan Hamzah Nur Fadholi Wisnu Saputra Zahwa Erikamaretha