Integration of Reorder Point and Stock Opname in a Web-Based Fuel Oil Inventory Information System at SPBUN

Dini Alilmi; Raissa Amanda Putri

doi:10.56427/jcbd.v6i1.1100

Authors

Dini Alilmi Universitas Islam Negeri Sumatera Utara
Raissa Amanda Putri Universitas Islam Negeri Sumatera Utara

DOI:

https://doi.org/10.56427/jcbd.v6i1.1100

Keywords:

Inventory, Reorder Point, Stock Opname, Waterfall Method, Information System

Abstract

Inadequate oil inventory management can cause delays in reordering and discrepancies between recorded stock data and actual field conditions, a problem identified at PT. Citra Nito Migas, a marine fuel oil supplier and distributor. This study develops a web-based Fuel Oil Inventory Information System for a fishermen’s public fuel station (SPBUN) that integrates the Reorder Point (ROP) and Stock Opname methods to support inventory control. The research applied the Research and Development method with the Waterfall model, covering requirements analysis, Unified Modeling Language design, PHP and MySQL implementation, and Black Box Testing. Data were collected through observation, interviews, and literature review of oil stock data from January 5 to August 31, 2026. The results show an average oil usage of 14,263.39 liters per day and an ROP value of 25,000 liters based on the reference daily demand and a 1-day lead time. Eight months of Stock Opname showed an inventory discrepancy in every period, with a January discrepancy of 16,256 liters and negative discrepancies in the following seven months. Black Box Testing of the main system functions, including login, incoming and outgoing oil recording, ROP status notification, Stock Opname, and reporting, shows that all functions run as designed.

Downloads

Download data is not yet available.

References

[1] D. Santika, D. N. S. Haq, Romlah, S. Anwar, and I. Fatoni, “Pendekatan Sistem dalam Manajemen Pendidikan,” Pendas: Jurnal Ilmiah Pendidikan Dasar, vol. 9, no. 4, pp. 782–789, Dec. 2024, doi: 10.23969/jp.v9i04.19526.

[2] R. Akbar and M. I. P. Nasution, “Peran Sistem Informasi Dalam Mengambil Keputusan,” JoSES: Journal of Sharia Economics Scholar, vol. 1, no. 3, pp. 1–4, Dec. 2023, doi: 10.5281/zenodo.10276994.

[3] E. Kurniawan and M. I. P. Nasution, “Optimalisasi Sistem Informasi Manajemen dalam Mendukung Pengambilan Keputusan Organisasi Modern,” Jurnal Ilmu Ekonomi, Pendidikan dan Teknik (IDENTIK), vol. 3, no. 1, pp. 91–96, Jan. 2026, doi: 10.70134/identik.v3i1.1069.

[4] M. L. Nuryana, T. Ibrahim, and O. Arifudin, “Implementasi dan Transformasi Sistem Informasi Manajemen di Era Digital,” Jurnal Tahsinia, vol. 5, no. 9, pp. 1325–1337, Dec. 2024, doi: 10.57171/jt.v5i9.614.

[5] E. Kartika, V. Prasetya, R. Tanjung, I. Listiyawati, and H. A. Ismail, “Peranan Sistem Informasi Akuntansi dalam Mengambil Keputusan Manajemen pada PT Berkat Sahabat Sukses,” Measurement: Jurnal Akuntansi, vol. 18, no. 2, pp. 378–386, Dec. 2024, doi: 10.33373/mja.v18i2.7113.

[6] N. U. Habibah, “Analisis Pengendalian Persediaan Bahan Baku (ABC Analysis) terhadap Penjadwalan Produksi (pada Barang Habis Pakai),” Jurnal Media Teknologi, vol. 10, no. 2, pp. 119–129, Mar. 2024, doi: 10.25157/jmt.v10i2.3793.

[7] R. E. Anugrah, Y. A. Saputra, and W. Haryono, “Perancangan Sistem Inventory Berbasis Web untuk Optimalisasi Manajemen Persediaan Barang di PT Bumi Daya Plaza,” Bridge: Jurnal Publikasi Sistem Informasi dan Telekomunikasi, vol. 2, no. 4, pp. 342–363, Nov. 2024, doi: 10.62951/bridge.v2i4.317.

[8] J. Suryahusada, T. Setiawati, and T. G. Bhagya, “Evaluasi Pengendalian Persediaan Bahan Baku Menggunakan Metode Min Max Stock dan Economic Order Quantity (EOQ) pada PT XYZ,” Sistemik: Jurnal Ilmiah Nasional Bidang Ilmu Teknik, vol. 14, no. 1, pp. 17–26, Jun. 2026, doi: 10.53580/sistemik.v14i1.203.

[9] A. R. Saputra, E. Darmanto, and S. Muzid, “Penerapan Metode Buffer Stock Dan Reorder Point Purchasing Pada Sistem Informasi Penjualan Dan Monitoring Stok Bahan Baku Berbasis Web Responsive Pada Roti Gembong Gembul,” JoMMiT: Jurnal Multi Media dan IT, vol. 9, no. 1, pp. 29–35, Jun. 2025, doi: 10.46961/jommit.v9i1.1571.

[10] M. R. Nurmatama and T. Haryati, “Optimalisasi Prosedur Stock Opname Dalam Audit Persediaan pada KAP XYZ,” Sustainable Business Accounting and Management Review, vol. 6, no. 3, pp. 1–14, Sep. 2024, doi: 10.61656/sbamr.v6i3.230.

[11] D. Lestari, S. Suendri, and F. H. Sibarani, “Pengembangan Sistem Informasi Akademik pada SMP Negeri 3 Tanah Putih Menggunakan Framework Laravel,” Jurnal Sistem Informasi Bisnis (JUNSIBI), vol. 6, no. 1, pp. 33–42, Apr. 2025, doi: 10.55122/junsibi.v6i1.1534.

[12] C. Bisri and R. Kurniawan, “Sistem Informasi Inventory Barang Pada CV. Delta Power Listrindo Menggunakan Metode Buffer Stock dan Reorder Point (ROP),” SMARTICS Journal, vol. 11, no. 1, pp. 34–44, Apr. 2025, doi: 10.21067/smartics.v11i1.11886.

[13] D. Diniaty, G. M. Rafi, M. Hartati, N. P. Miefthawati, Silvia, and S. Kaidah, “Optimasi Pengendalian Persediaan Spare Part Fuel Filter Pada Pembangkit Listrik Menggunakan Integrasi Metode Abc Dan Economic Order Quantity (Studi Kasus: PT. PLN Nusantara Power Up Tenayan),” Jurnal Teknologi dan Manajemen Industri Terapan (JTMIT), vol. 5, no. 3, pp. 1091–1101, Jul. 2026, doi: 10.55826/jtmit.v5i3.1782.

[14] S. V. Gairwyn and A. Suryadi, “Analisis Persediaan Spare Parts pada Stock Management Menggunakan Metode PDCA dan Kaizen di PT X,” Journal of Industrial Engineering and Operation Management, vol. 8, no. 1, pp. 17–30, Jun. 2025, doi: 10.31602/jieom.v8i1.17473.

[15] D. N. Putri, Samsudin, and R. A. Putri, “Implementasi Metode Waterfall Pada Perancangan Aplikasi Sistem Informasi Manajemen Penggajian Karyawan Berbasis Web (Studi Kasus: PT. Hijau Surya Biotechindo),” JATISI (Jurnal Teknik Informatika dan Sistem Informasi), vol. 10, no. 2, pp. 377–400, Jun. 2023, doi: 10.35957/jatisi.v10i2.4879.

[16] A. T. Hidayati, A. E. Widyantoro, and H. J. Ramadhani, “Perancangan Sistem Informasi Wirausaha Mahasiswa (Siwirma) Berbasis Web dengan Unified Modelling Languange (UML),” Jurnal Penelitian Rumpun Ilmu Teknik, vol. 2, no. 4, pp. 86–107, Nov. 2023, doi: 10.55606/juprit.v2i4.2906.

[17] F. Marisya, R. Aryanti, T. Desliana, and V. W. Putri, “Prosedur Penerapan Stock Opname Persediaan Spareparts Di PT United Tractors Tbk Cab. Palembang,” Jurnal Ilmiah Mahasiswa Perbankan Syariah (JIMPA), vol. 4, no. 1, pp. 325–334, Mar. 2024, doi: 10.36908/jimpa.v4i1.327.

[18] S. Nabila, A. R. Putri, A. Hafizhah, F. H. Rahmah, and R. Muslikhah, “Pemodelan Diagram UML Pada Perancangan Sistem Aplikasi Konsultasi Hewan Peliharaan Berbasis Android (Studi Kasus: Alopet),” Jurnal Ilmu Komputer dan Bisnis, vol. 12, no. 2, pp. 130–139, Nov. 2021, doi: 10.47927/jikb.v12i2.150.