Design and Development of a Web-Based Stock Management Application Integrated with Point of Sale (POS) using the FEFO Method for Roni Frozen Store
Keywords:
Stock Management, FEFO, Point of Sale, Waterfall, WebsiteAbstract
This study aims to design and develop a web-based stock management application implementing the First Expired First Out (FEFO) method integrated with a Point of Sale (POS) system at Roni Frozen Store. The main problem identified is the manual stock-recording process, which is prone to errors, data loss, and difficulties in monitoring products that are approaching expiration. The system was developed using the System Development Life Cycle (SDLC) Waterfall model through the stages of requirement analysis, design, implementation, testing, and maintenance, utilizing PHP (Laravel) and MySQL technologies. The implementation results show that the system can automatically manage stock, provide low-stock notifications, and update stock data in real time through POS integration. Black Box testing confirms that all system functions operate correctly, while the User Acceptance Testing (UAT) demonstrates a very high level of user acceptance, achieving 96.7% for administrators and 93.3% for warehouse staff. Based on the ISO 25010 quality model, the system obtained 100% in functional suitability, 85–100% in performance efficiency, and 90–95% in usability. Therefore, the developed application is proven to be effective in optimizing stock management and improving operational efficiency and service quality at Roni Frozen Store
References
[1] L. zahra Firdausya and D. P. Ompusunggu, “Usaha Mikro Kecil Dan Menengah (Umkm) Di Era Digital Abad 21,” Tali Jagad J., vol. 1, no. 1, pp. 16–20, 2023.
[2] J. Sinuraya, Makmur Tarigan, Wiwin Sry A B, and Orli Binta Tumanggor, “Pengembangan Usaha Industri Rumah Tangga Frozen Food Dapoer Mama Ana Di Kelurahan Gedung Johor Kecamatan Medan Johor Kota Medan Sumatera Utara,” J. Masy. Indones., vol. 2, no. 01, pp. 26–33, 2023, doi: 10.54209/jumas.v2i01.36.
[3] Sumaryanto, Setiyo Prihatmoko, and Purwati, “Analisa Perancangan Sistem Informasi Inventory dengan Metode FIFO (First In First Out) pada Usaha Dagang Retail,” Inform. J. Tek. Inform. dan Multimed., vol. 2, no. 1, pp. 26–34, 2022, doi: 10.51903/informatika.v2i1.136.
[4] R. Yuniarti, I. Hartami Santi, and W. Dwi Puspitasari, “Perancangan Aplikasi Point of Sale Untuk Manajemen Pemesanan Bahan Pangan Berbasis Framework Laravel,” JATI (Jurnal Mhs. Tek. Inform., vol. 6, no. 1, pp. 67–74, 2022, doi: 10.36040/jati.v6i1.4283.
[5] H. Wijaya and J. Devitra, “Sistem Informasi Manajemen Stok Berbasis Web Pada PT Sumber Rejeki Tirta,” J. Manaj. Sist. Inf., vol. 8, no. 1, pp. 105–114, 2023, doi: 10.33998/jurnalmsi.2023.8.1.767.
[6] C. Ziliwu, R. Sitanggang, R. U. Ginting, and A. F. . Sibero, “Rancang Bangun Sistem Informasi Penjualan Produk Handmade Berbasis Web,” J. Mahajana Inf., vol. 6, no. 1, pp. 16–21, 2021, doi: 10.51544/jurnalmi.v6i1.1981.
[7] Sitanggang Rianto, Urian Dachi Teddy, and Manurung H G Immanuel, “Rancang Bangun Sistem Penjualan Tanaman Hiasberbasis Web Menggunakan Php Dan Mysql,” Tekesnos, vol. 4, no. 1, pp. 84–90, 2022.
[8] E. A. Nugraha and R. A. Aziz, “Implementasi Sistem Manajemen 21 Persediaan Berbasis Web Untuk Efisiensi Stok Barang,” Bul. Ilm. Ilmu Komput. …, vol. 2, no. 1, pp. 96–107, 2024, [Online]. Available: http://jurnalmahasiswa.com/index.php/biikm a/article/view/1136%0Ahttps://jurnalmahasi swa.com/index.php/biikma/article/download /1136/701
[9] A. Zahra, S. I. Aulia, S. Destiyani, Susilo, and Y. F. Togatorop, “INVENTORY MANAGEMENT AS THE KEY TO IMPROVING THE COMPANY’S OPERATIONAL PERFORMANCE (MANAJEMEN PERSEDIAAN SEBAGAI KUNCI PENINGKATAN KINERJA OPERASIONAL PERUSAHAAN),” vol. 3, no. 3, pp. 418–428, 2025.
[10] T. S. Cahyani and D. A. Dermawan, “Pengembangan Aplikasi Inventory Barang Berbasis Website Menggunakan Metode First Expired First Out ( FEFO ) Pada Toko SM Mart,” pp. 1–14, 2023.
[11] D. Juliana and R. Amalia, “Seminar Nasional Riset dan Inovasi Teknologi (SEMNAS RISTEK) 2024 Jakarta, 30 Januari 2024 Raya Tengah No. 80,” pp. 113–118, 2024.
[12] M. Rahmatuloh, M. F. A. Kamil, and S. Nirwan, “Rancang Bangun Aplikasi Point Of Sale Toko Fashion Berbasis Website,” J. Tek. Inform., vol. 16, no. 3, pp. 127–135, 2024.
[13] P. Juventauricula, B. T. Hanggara, and D. Pramono, “Pengembangan Sistem Informasi Point of Sale (POS ) berbasis Web menggunakan Pendekatan Metode Waterfall ( Studi Kasus : Restoran Altari ),” J. Pengemb. Teknol. Inf. dan Ilmu Komput., vol. 8, no. 1, pp. 97–106, 2024, [Online]. Available: https://jptiik.ub.ac.id/index.php/jptiik/article/view/13199%0Ahttps://jptiik.ub.ac.id/index.php/jptiik/article/download/13199/5954
[14] Z. Ariza, “Perancangan Sistem Informasi Penilaian Angka Kredit Kenaikan Jabatan Fungsional Atau Pangkat Dosen di Fakultas Tarbiyah Dan Ilmu Keguruan UIN Bukittinggi,” J. Inf. Syst. Educ. Dev., vol. 2, no. 1, pp. 13–19, 2024, doi: 10.62386/jised.v2i1.50.
