Web-Based Inventory Management Information System for "Labuhan Kopi" Coffee Shop Using the Economic Order Quantity (EOQ) Method
DOI:
https://doi.org/10.65359/sbqdcr96Keywords:
Conversion Rate, Information System, Inventory, Economic Order Quantity, Waterfall, WebAbstract
The "Labuhan Kopi" coffee shop in Surabaya currently manages raw material inventory manually using logbooks and simple spreadsheets, leading to frequent recording errors, delays in report generation, and difficulties in consolidating real-time stock availability data. This study aims to design and develop a web-based inventory management information system that integrates the recording of stock inflows and outflows with report generation, while also implementing the Economic Order Quantity (EOQ) method to determine optimal raw material order quantities. The system was developed using the Waterfall model, comprising stages for requirements analysis, system design (Utilizing Unified Modeling Language [UML] and Entity Relationship Diagrams [ERD]), implementation (using the Laravel framework and MySQL database), and testing (employing the Black Box Testing method). The results demonstrate that the system successfully automates the management of raw material data, supplier information, stock transactions, and inventory reports. Applying the EOQ method to the coffee bean case study yielded an optimal order quantity of 22 kg per purchase, alongside calculations for the Reorder Point (ROP) and Safety Stock (SS) to serve as triggers for reorder notifications. The developed system has proven capable of enhancing the effectiveness, efficiency, and accuracy of inventory management compared to the previous manual recording process.
Downloads
References
Annisa Tri Hidayati, A. E. (2023). Perancangan Sistem Informasi Wirausaha Mahasiswa (Siwirma) Berbasis Web dengan Unified Modelling Languange (UML). Jurnal Penelitian Rumpun Ilmu Teknik, 2(4).
Assauri, S. (2008). Manajemen Produksi dan Operasi. Jakarta: Lembaga Penerbit Fakultas Ekonomi Universitas Indonesia.
Aulia Deftania, Mufrida Meri, & Rozza Linda. (2022). Analisis pengendalian persediaan bahan baku dengan metode Economic Order Quantity. Unes Journal of Scientech Research, 7(2), 1–10.
Djaksana, Y. M. (2025). Analisa dan Perancangan Sistem Monitoring Inventory Berbasis Website dengan Metode Rapid Application Development. SENTRI: Jurnal Riset Ilmiah, 4(10).
Fabio Santoso, E. D. (2026). Pembuatan Aplikasi Inventory Berbasis Web dengan Metode ROP pada PT. XYZ. Jurnal Komputer Teknologi Informasi Sistem Komputer, 4(3).
Fauzan Firdaus, M. K. (2025). Rancang Bangun Sistem Informasi Stock Opname Berbasis Web dengan Metode Waterfall pada UMKM. Jurnal Teknologi Informasi dan Komputer, 11(1).
Harianto Antonio, N. S. (2012). Rancang Bangun Sistem Informasi Administrasi Informatika (SI-ADIF). Jurnal ELKHA, 4(2).
Irvan Triana, A. N. (2024). Perancangan Sistem Informasi Persediaan Barang Berbasis Web Pada Toko Kuat. Jurnal Informatika dan Rekayasa Komputer (JAKAKOM), 4(1).
Iskandar, F., Al Rasyid, H., Yulandari, P., & Suroso, E. (2022). Analisis pengendalian persediaan bahan baku kopi (Studi kasus: Kopi Rigis). Jurnal Agroindustri Berkelanjutan, 2(1), 206–216.
Jogiyanto, H. M. (2005). Analisis dan Desain Sistem Informasi: Pendekatan Terstruktur Teori dan Praktik Aplikasi Bisnis. Yogyakarta: Andi Offset.
Moh. Rofi’ul Azis, C. M. (2020). Sistem Informasi Manajemen Persediaan Bahan Baku Dengan Menggunakan Metode Economic Order Quantity (EOQ) Dan Just In Time (JIT) Berbasis Web. Jurnal Ilmiah Inovasi Teknologi Informasi, 5(1).
Mulyadi. (2016). Sistem Akuntansi (Edisi 4). Jakarta: Salemba Empat.
O’Brien, J. A., & Marakas, G. M. (2013). Management Information Systems (10th ed.). New York: McGraw-Hill/Irwin.
Pressman, R. S. (2005). Software Engineering: A Practitioner’s Approach (7th ed.). New York: McGraw-Hill Higher Education.
Rekhi Thiara, A. W. (2024). Analisis Pengendalian Persediaan Produk Dengan Metode EOQ Berbasis Web. Jurnal Media Infotama, 20(1).
Render, B., & Heizer, J. (2005). Manajemen Operasi (Edisi 7). Jakarta: Salemba Empat.
Rinda Hesti Kusumaningtyas, A. R. (2025). Analisis dan Rancang Bangun Sistem Informasi Inventory Barang. Jurnal Perangkat Lunak, 7(2).
Sabrina Putri, M. D. (2025). Penerapan Metode EOQ Pada Sistem Informasi Manajemen Stok Bahan Baku Ayam Broiler Berbasis Web. Journal of Students’ Research in Computer Science, 6(1).
Sunggu Minasa, F. S. (2024). Sistem Informasi Pengelolaan Inventaris UMKM Berbasis Web Dengan Pendekatan Agile. Jurnal Teknologi Informasi dan Elektronika, 9(2).
Tiwuk Puji Hariyanti, E. M. (2024). Analisis Sistem Akuntansi Persediaan Barang Dagangan (Studi Kasus Pada Grosir Bonabon Tulungagung). Journal of Accounting and Tax, 3(1).
Wahyu Sidiq Saputra, R. E. (2021). Analysis of Raw Material Inventory Control Using Economic Order Quantity (EOQ) Method at CV. XYZ.
Azis, M. R., Mashuri, C., & Faizah, A. (2020). Sistem informasi manajemen persediaan bahan baku dengan menggunakan metode Economic Order Quantity (EOQ) dan Just In Time (JIT) berbasis web. Inovate: Jurnal Ilmiah Inovasi Teknologi Informasi, 5(1), 31–38.
Djaksana, Y. M. (2025). Analisa dan perancangan sistem monitoring inventory berbasis website dengan metode Rapid Application Development. SENTRI: Jurnal Riset Ilmiah, 4(10), 2341–2354.
Firdaus, F., Komaro, M., & Dwiyanti, V. (2025). Rancang bangun sistem informasi stock opname berbasis web dengan metode Waterfall pada UMKM. Jurnal Teknologi Informasi dan Komputer, 11(1).
Lavappa, P. D. (2008). Guidelines for planning and development of software for buildings and building systems (NISTIR 7499). National Institute of Standards and Technology.
Putri, S., Irawan, M. D., & Santoso, H. (2025). Penerapan metode EOQ pada sistem informasi manajemen stok bahan baku ayam broiler berbasis web. Journal of Students’ Research in Computer Science, 6(1), 11–24.
Saputra, W. S., Ernawati, R., & Wulansari, W. A. (2021). Analysis of raw material inventory control using Economic Order Quantity (EOQ) method at CV. XYZ. International Journal of Computer and Information System (IJCIS), 2(3).
Thiara, R., Wijaya, A., Pahriza, P., & Khairullah, K. (2024). Analisis pengendalian persediaan produk dengan metode EOQ berbasis web. Jurnal Media Infotama, 20(1), 329–335.
Triana, I., Nugroho, A., & Meisak, D. (2024). Perancangan sistem informasi persediaan barang berbasis web pada Toko Kuat. Jurnal Informatika dan Rekayasa Komputer (JAKAKOM), 4(1), 835–844.
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Ferry Rohman Kurniawan, Lukman Junaedi, Natalia Damastuti, Achmad Zakki Falani (Author)
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Copyright & Licensing Policy
Copyright
The copyright of all articles published in JURNAL SINTIKA (Journal of Information Systems, Informatics Engineering, and Computer Systems) remains with the respective author(s). Authors retain full copyright ownership of their work while granting JURNAL SINTIKA the right of first publication.
Upon publication, authors agree that their articles will be distributed under the Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) License.
Under this license, users are free to:
- Share – Copy and redistribute the material in any medium or format.
- Adapt – Remix, transform, and build upon the material for any purpose, including commercial use.
These permissions are granted provided that the following conditions are met:
- Attribution (BY) – Appropriate credit must be given to the original author(s), a link to the license must be provided, and any changes made to the work must be clearly indicated.
- ShareAlike (SA) – If the material is modified, adapted, or remixed, the resulting work must be distributed under the same CC BY-SA 4.0 license.
Licensing Policy
By submitting a manuscript to JURNAL SINTIKA, authors agree that, if accepted for publication, their article will be published under the Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) License.
Authors retain the right to:
- Archive and distribute the published version of their article through institutional repositories, personal websites, academic social networks, or other non-commercial and commercial platforms, provided that the original publication in JURNAL SINTIKA is properly acknowledged.
- Reuse their work in future books, dissertations, conference proceedings, or other scholarly publications, with appropriate citation to the original publication.
JURNAL SINTIKA supports the principles of Open Access and encourages authors to deposit their manuscripts in institutional or subject repositories before submission (preprint), during the review process (where permitted), and after publication, in order to enhance the visibility, accessibility, dissemination, and academic impact of their research.
For complete license information, please visit the Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) website:
https://creativecommons.org/licenses/by-sa/4.0/
