Implementasi Sistem Inventory Coffee Shop dengan Integrasi Resep dan Metode FEFO

Rizki Aditya Ananda (Universitas Muria Kudus)
Tutik Khotimah (Universitas Muria Kudus)
Indra Lina Putra (Universitas Muria Kudus)

Progresif: Jurnal Ilmiah Komputer
Vol. 22 No. 3 (2026): Juli

Coffee shop raw material inventory requires accurate recording because ingredients have different units, storage locations, and expiration dates. This study aims to implement a coffee shop inventory system that integrates menu recipes with automatic stock deduction using the First Expired First Out (FEFO) method. The method follows applied software development stages, including requirements analysis, design, implementation, and black-box testing. The system was developed as a web/PWA application with a Node.js/Express backend and a MySQL database. The implementation includes login, dashboard, supplier, stock, batch, stock-in, stock-out, menu, recipe, report, and role-based access control modules. Black-box testing on core functional scenarios showed that the system outputs matched the expected results. The novelty of this system lies in integrating menu recipes with earliest-expiry batch selection, allowing menu transactions to be directly converted into FEFO-based raw material consumption. Keywords: Inventory system; Coffee shop; Recipe; FEFO; Raw materials.   Abstrak Pengelolaan persediaan bahan baku coffee shop membutuhkan pencatatan yang akurat karena bahan memiliki satuan, lokasi, dan tanggal kedaluwarsa yang berbeda. Penelitian ini bertujuan mengimplementasikan sistem inventory coffee shop yang mengintegrasikan resep menu dengan pengurangan stok otomatis menggunakan metode First Expired First Out (FEFO). Metode yang digunakan adalah pengembangan perangkat lunak terapan melalui analisis kebutuhan, perancangan, implementasi, dan pengujian black-box. Sistem dibangun berbasis web/PWA dengan backend Node.js/Express dan basis data MySQL. Hasil implementasi mencakup modul login, dashboard, supplier, stok, batch, stok masuk, stok keluar, menu, resep, laporan, dan role-based access control. Pengujian black-box pada skenario fungsi inti menunjukkan keluaran sistem sesuai dengan hasil yang diharapkan. Kebaruan sistem terletak pada integrasi resep menu dengan pemilihan batch kedaluwarsa terdekat, sehingga transaksi menu langsung diterjemahkan menjadi pemakaian bahan baku berbasis FEFO.