Web-Based Supply Chain Management Information System for Inventory and Distribution Control in Agricultural Trading MSMEs

Erwansyah; Novica Irawati; Sri Rezki Maulina Azmi

doi:10.56427/jcbd.v5i3.1050

Authors

Erwansyah Universitas Royal
Novica Irawati Universitas Royal
Sri Rezki Maulina Azmi Universitas Royal

DOI:

https://doi.org/10.56427/jcbd.v5i3.1050

Keywords:

Supply Chain Management, Web-Based Information System, Inventory Control, Agricultural MSMEs, Black Box Testing

Abstract

Agricultural trading micro, small, and medium enterprises (MSMEs) commonly manage their supply chain manually, leaving procurement, inventory, and sales records disconnected. At UD Tani Makmur, Batu Bara Regency, Indonesia, the supply of ten commodities between January and May 2026 reached 70,500 kg while sales reached only 65,500 kg, leaving 5,000 kg (7.09 percent) unsold and exposed to spoilage. This study designs, develops, and tests a web-based supply chain management information system for inventory and distribution control in such enterprises. Requirements were elicited through interviews, direct observation, and document study. The design was modelled with the Unified Modelling Language and an entity relationship diagram and implemented in PHP and MySQL for four user roles: administration, owner, sales, and supplier. The novelty lies in granting suppliers direct system access to approve or adjust purchase orders, submit product offers, and report price increases, so that information flows bidirectionally within a single centralised database. Black box testing of 33 test cases across eight functional classes returned an accepted status for all cases, confirming that the system meets its functional requirements. The effect of the system on unsold inventory has not yet been measured and requires post-deployment evaluation.

Downloads

Download data is not yet available.

References

[1] A. H. Astrima, N. J. Lona, W. A. Adnyana, Y. N. Muflikh, and S. Suprehatin, “Peran Inovasi dan Teknologi dalam Manajemen Rantai Pasok Berkelanjutan pada Industri Agrifood: Tinjauan Literatur,” Jurnal Agribisnis Indonesia, vol. 13, no. 2, pp. 258–291, Dec. 2025, doi: 10.29244/jai.2025.13.2.258-291.

[2] E. W. Nasution and T. Ningsih, “Optimalisasi Manajemen Rantai Pasok dalam Agribisnis: Studi Kasus Produksi Kelapa Sawit di Negara Berkembang,” Tabela Jurnal Pertanian Berkelanjutan, vol. 3, no. 1, pp. 23–31, Jan. 2025, doi: 10.56211/tabela.v3i1.753.

[3] M. A. Rizkiawan and H. Ramza, “Peningkatan dan Efisiensi Operasional Supply Chain Management (SCM) Dengan Memanfaatkan Teknologi,” Jurnal Masharif al-Syariah: Jurnal Ekonomi dan Perbankan Syariah, vol. 9, pp. 236–252, Nov. 2024, doi: 10.30651/jms.v9i1.21488.

[4] A. Oktalia, Emilya, J. Agriffina, M. Ella, F. Cuandra, and N. B. Laulita, “Analisis Rantai Pasok Serta Sistem ERP Dalam Kinerja Operasional PT Nestle Indonesia,” Transekonomika: Akuntansi, Bisnis dan Keuangan, vol. 2, no. 3, pp. 127–144, May 2022, doi: 10.55047/transekonomika.v2i3.134.

[5] R. Indriani, S. Imran, and M. Mukhlis, “Struktur dan Efisiensi Kinerja Rantai Pasok Beras di Provinsi Gorontalo, Indonesia,” Agro Bali : Agricultural Journal, vol. 7, pp. 542–558, Jul. 2024, doi: 10.37637/ab.v7i2.1648.

[6] C. Yolandika, D. Berliana, and N. Anggraini, “Efisiensi Kinerja Rantai Pasok Ikan Patin Di Kabupaten Pringsewu, Lampung,” Journal of Food System and Agribusiness, pp. 107–115, Oct. 2021, doi: 10.25181/jofsa.v5i2.2085.

[7] S. R. Sinaga, K. F. Kodrat, and B. Harahap, “Model Pengukuran Kinerja Rantai Pasok dengan Metode SCOR dan AHP di PT Sinar Sosro Medan,” Factory Jurnal Industri, Manajemen dan Rekayasa Sistem Industri, vol. 2, no. 3, pp. 147–154, May 2024, doi: 10.56211/factory.v2i3.503.

[8] T. Juniarto, P. P. Surya Negara, and B. Wahyudi, “Pengaruh Kinerja Pemasok Terhadap Kinerja Rantai Pasok Menggunakan Metode Structural Equation Modeling (SEM) pada PT. Tiga Serangkai,” Integrasi : Jurnal Ilmiah Teknik Industri, vol. 6, no. 1, p. 24, Oct. 2021, doi: 10.32502/js.v6i1.3792.

[9] F. Nursalam and W. W. Yunanda, “Analisis SWOT Dalam Manajemen Rantai Pasok Industri Pertahanan Indonesia,” Jurnal Teknik Industri: Jurnal Hasil Penelitian dan Karya Ilmiah dalam Bidang Teknik Industri, vol. 9, no. 1, pp. 331–337, May 2023, doi: 10.24014/jti.v9i1.21820.

[10] I. K. Sriwana, H. K. Pambudi, Y. Nurdiansyah, and S. W. Yakti, “Analisis Rantai Pasok Untuk Pengembangan Produk Olahan Buah Anggur Di Jawa Barat,” Jurnal Ilmiah Teknik Industri, vol. 11, no. 3, pp. 253–260, Mar. 2024, doi: 10.24912/jitiuntar.v11i3.26999.

[11] P. Parjito, O. Rahmawati, and F. Ulum, “Rancang Bangun Aplikasi E-Agribisnis Untuk Meningkatkan Penjualan Hasil Tanaman Hortikultura,” Jurnal Informatika dan Rekayasa Perangkat Lunak, vol. 3, pp. 354–365, Jan. 2023, doi: 10.33365/jatika.v3i3.2362.

[12] A. T. Priandika and D. Riswanda, “Perancangan Sistem Informasi Manajemen Pemesanan Barang Berbasis Online Menggunakan Pendekatan Extreme Programming,” Jurnal Ilmiah Computer Science, vol. 1, no. 2, pp. 69–76, Jan. 2023, doi: 10.58602/jics.v1i2.8.

[13] N. Milandari, N. Irawati, and E. Rahayu, “Penerapan Supply Chain Management untuk Efisiensi Rantai Pasok Produk Cokelat,” Jurnal Algoritma, vol. 22, no. 2, Nov. 2025, doi: 10.33364/algoritma/v.22-2.2974.

[14] S. C. I. Aulia, “Pemanfaatan UML (Unified Modeling Language) Dalam Perancangan Sistem Informasi Rekam Medis Sederhana Pada Kegiatan POSBINDU PTM,” Jurnal Ilmiah Sains dan Teknologi, vol. 6, no. 1, pp. 38–44, Feb. 2022, doi: 10.47080/saintek.v6i1.1665.

[15] M. R. Wayahdi and F. Ruziq, “Pemodelan Sistem Penerimaan Anggota Baru dengan Unified Modeling Language (UML) (Studi Kasus: Programmer Association of Battuta),” Jurnal Minfo Polgan, vol. 12, no. 1, pp. 1514–1521, Aug. 2023, doi: 10.33395/jmp.v12i1.12870.

[16] I. R. Mukhlis and R. Santoso, “Perancangan Basis Data Perpustakaan Universitas Menggunakan MySQL dengan Physical Data Model dan Entity Relationship Diagram,” Journal of Technology and Informatics (JoTI), vol. 4, no. 2, pp. 81–87, Apr. 2023, doi: 10.37802/joti.v4i2.330.