Implementasi SaaS Multi-Tenant Berbasis Database-per-Tenant dan Metode FEFO pada Sistem Inventori dan Point of Sale UMKM Bakery
-
Rizki Wahyu
*
Universitas Esa Unggul, Jakarta,
Indonesia
- Jefry Sunupurwa Asri Universitas Esa Unggul, Jakarta, Indonesia
- Nizirwan Anwar Universitas Esa Unggul, Jakarta, Indonesia
- Adi Widiantono Universitas Esa Unggul, Jakarta, Indonesia (*) Corresponding Author
Abstract
Bakery micro, small, and medium-sized enterprises manage products with limited shelf lives, requiring accurate inventory control and product rotation based on expiration dates. Toko Kue Khaerul Akbar continues to face several operational challenges, including manual stock recording, discrepancies in stock-taking results, inadequate prioritization of products nearing expiration, and delays in generating operational reports. This study develops an inventory and Point of Sale system based on the Software as a Service model by implementing a database-per-tenant architecture and the First Expired, First Out method. The system was developed using the Extreme Programming method through four sprints, comprising the development of the multi-tenant foundation, batch-based inventory management, FEFO integration with the POS system, and the Owner Central feature. The FEFO method prioritizes batches according to the earliest expiration date, using the received date as a secondary criterion when expiration dates are identical. Unit testing was conducted on 12 test cases organized into four scenario groups, with all cases successfully passing. In addition, black-box testing involving 31 scenarios achieved a fulfillment rate of 100%. Isolation testing confirmed that cross-tenant access was successfully denied. An evaluation involving 10 respondents yielded a UAT score of 4.4 out of 5.0 and a SUS score of 81.7 out of 100. The developed system improves inventory traceability, prioritizes products according to expiration proximity, provides real-time operational reports, and enables centralized monitoring of multiple business units while preserving the isolation of operational data across tenants. The contribution of this study is the integration of a database-per-tenant SaaS architecture, batch-based FEFO allocation directly connected to POS checkout, and Owner Central for cross-unit monitoring while maintaining operational data isolation for each tenant.
Downloads
References
R. F. J. S. A. Christianti, “Estimasi Jarak Berbasis Convolutional Neural Network dan Regresi Dalam Sistem Deteksi Kendaraan Udara Nirawak Berbasis Suara,” Jurnal SINTA: Sistem Informasi dan Teknologi Komputasi, vol. 2, no. 3, pp. 153–162, Aug. 2025, doi: 10.61124/sinta.v2i3.92.
K. Ismail, M. Rohmah, and D. A. P. Putri, “Peranan UMKM dalam Penguatan Ekonomi Indonesia,” Jurnal Neraca: Jurnal Pendidikan dan Ilmu Ekonomi Akuntansi, vol. 7, no. 2, pp. 208–217, 2023, doi: 10.31851/neraca.v7i2.14344.
M. K. Nugraha, B. A. Sekti, N. Anwar, and A. M. Widodo, “Implementasi Sistem Enterprise Resource Planning pada Industri Makanan Opak C.V. Barokah Pandeglang Menggunakan ODOO,” IKRA-ITH Informatika: Jurnal Komputer dan Informatika, vol. 8, no. 1, pp. 221–233, 2024, doi: 10.37817/ikraith-informatika.v8i1.3216.
F. Rahman Lutfi and C. Sasongko, “Perencanaan Produksi dan Manajemen Persediaan pada Perusahaan Kue dan Roti,” Studi Akuntansi dan Keuangan Indonesia, vol. 5, no. 1, pp. 61–86, 2022, doi: 10.21632/saki.5.1.61-86.
G. H. Rajagukguk and A. Widiantono, “Perancangan dan Implementasi Sistem Monitoring Mesin Produksi Berbasis Lampu IoT dan Web Dashoard di PT XYZ,” Jurnal Minfo Polgan, vol. 14, no. 2, pp. 2303–2317, Oct. 2025, doi: 10.33395/jmp.v14i2.15413.
D. A. K. Wati and Barnad, “Desain dan Implementasi Sistem Inventory Data Ikan CV Pesona Mandiri Berbasis Google Sheets dan Appsheets,” Teknika, vol. 11, no. 3, pp. 163–169, 2022, doi: 10.34148/teknika.v11i3.513.
S. A. Ghiffari and J. Aryanto, “Transformasi Digital Manajemen Stok UMKM melalui Implementasi Sistem E-Inventory Mobile Real-Time,” MALCOM: Indonesian Journal of Machine Learning and Computer Science, vol. 6, no. 1, pp. 11–22, 2026, doi: 10.57152/malcom.v6i1.2334.
P. Fahrizal and N. C. Azhar, “Perancangan Sistem Informasi Laporan Inventori Bahan Baku Berbasis Web dengan Metode Waterfall pada Kedai Kopi Disiniaja,” INFOMATEK, vol. 27, no. 1, pp. 153–164, 2025, doi: 10.23969/infomatek.v27i1.24838.
Y. Siyamto, “Pengggunaan Metode FIFO dan FEFO dalam Mengukur Efisisensi dan Efektifitas Persediaan Obat Paten 2020–2021,” Jurnal Ilmiah Ekonomi Islam, vol. 8, no. 2, p. 2221, 2022, doi: 10.29040/jiei.v8i2.6041.
C. B. Herron et al., “Building ``First Expire, First Out’’ Models to Predict Food Losses at Retail Due to Cold Chain Disruption in the Last Mile,” Front. Sustain. Food Syst., vol. 6, p. 1018807, 2022, doi: 10.3389/fsufs.2022.1018807.
F. A. M. Andy and S. Widiono, “Inovasi Teknologi dalam Manajemen Penjualan: Aplikasi Point of Sales Berbasis Web untuk UMKM,” INFOMATEK, vol. 26, no. 2, pp. 161–174, 2024, doi: 10.23969/infomatek.v26i2.19007.
M. R. Raihan and D. Hidayahtullah, “Pengembangan Sistem Point Of Sale Berbasis User Centered Design,” Jurnal Media Informatika Budidarma, vol. 6, no. 1, p. 74, 2022, doi: 10.30865/mib.v6i1.3412.
H. B. P. Putra and S. D. Sancoko, “Penerapan Sistem Point Of Sale Berbasis Android untuk Peningkatan Kinerja Usaha,” Infotek: Jurnal Informatika dan Teknologi, vol. 7, no. 1, pp. 195–204, 2024, doi: 10.29408/jit.v7i1.23934.
M. Dimyati and A. J. T. Segara, “Rancang Bangun Aplikasi Point of Sales Menggunakan Metode Extreme Programming (Studi Kasus Hadi Sport Shop),” Jurnal Sistem dan Teknologi Informasi (JustIN), vol. 12, no. 3, p. 485, 2024, doi: 10.26418/justin.v12i3.78761.
A. Ahmadi and A. Surachman, “Pengembangan Aplikasi Penjualan dengan Metode Extreme Programming dan Penerapan Model Multi-Tenancy,” STRING (Satuan Tulisan Riset dan Inovasi Teknologi), vol. 8, no. 3, p. 303, 2024, doi: 10.30998/string.v8i3.20276.
M. H. Ratsanjani, I. F. Risnandari, T. W. Sulaiman, and V. M. Hersianty, “Literatur Review: Peran Aplikasi SaaS dalam Kegiatan Bisnis E-Commerce,” SINOMIKA Journal: Publikasi Ilmiah Bidang Ekonomi dan Akuntansi, vol. 1, no. 4, pp. 1009–1020, 2022, doi: 10.54443/sinomika.v1i4.491.
A. Santhosh, D. Unnikrishnan, S. Shibu, M. H. Fathima, G. Lekshmi, and S. G. Joseph, “SaaS (Software as a Service) and Its Impact on Business Scalability,” International Research Journal on Advanced Engineering and Management (IRJAEM), vol. 2, no. 12, pp. 3575–3584, 2024, doi: 10.47392/irjaem.2024.0527.
S. Pushpan, “Multi-Tenant Architecture: A Comprehensive Framework for Building Scalable SaaS Applications,” International Journal of Scientific Research in Computer Science, Engineering and Information Technology, vol. 10, no. 6, pp. 1117–1126, 2024, doi: 10.32628/cseit241061151.
S. K. Pippal, S. Kumar, and R. Rani, “Optimizing Multi-Tenant Database Architecture for Efficient Software as a Service Delivery,” TELKOMNIKA (Telecommunication Computing Electronics and Control), vol. 22, no. 5, p. 1128, 2024, doi: 10.12928/telkomnika.v22i5.26385.
R. K. Sharma, “Multi-Tenant Architectures in Modern Cloud Computing: A Technical Deep Dive,” International Journal of Scientific Research in Computer Science, Engineering and Information Technology, vol. 11, no. 1, pp. 307–317, 2025, doi: 10.32628/cseit25111236.
J. Chi, Q. Ou, and M. Wang, “A Study on SaaS ERP Continuous Use Intention of Fresh Food Distribution SME,” iBusiness, vol. 15, no. 2, pp. 99–111, 2023, doi: 10.4236/ib.2023.152007.
F. Sinlae, E. Irwanda, Z. Maulana, and V. E. Syahputra, “Penggunaan Framework Laravel dalam Membangun Aplikasi Website Berbasis PHP,” Jurnal Siber Multi Disiplin, vol. 2, no. 2, pp. 119–132, 2024, doi: 10.38035/jsmd.v2i2.186.
M. Kleppmann, Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems. O’Reilly Media, 2017. [Online]. Available: https://www.oreilly.com/library/view/designing-data-intensive-applications/9781491903063/
S. Newman, Building Microservices: Designing Fine-Grained Systems. O’Reilly Media, 2015. [Online]. Available: https://www.oreilly.com/library/view/building-microservices/9781491950340/
F. T. Julfia, E. Satryawati, D. Setiadi, and A. C. Umam, “Perancangan Aplikasi Warehouse Management System Berbasis Web Menggunakan Laravel dan MySQL pada PT. Sinergi Dua Akal,” JOINED Journal (Journal of Informatics Education), vol. 6, no. 2, p. 206, 2024, doi: 10.31331/joined.v6i2.3036.
A. Samdono, A. P. Sari, and F. P. Aditiawan, “Pengujian Black Box pada Sistem Informasi Stok dan Penjualan Berbasis Website Menggunakan Metode Equivalence Partitioning,” JATI (Jurnal Mahasiswa Teknik Informatika), vol. 8, no. 1, pp. 880–885, 2024, doi: 10.36040/jati.v8i1.8893.
Bila bermanfaat silahkan share artikel ini
Berikan Komentar Anda terhadap artikel Implementasi SaaS Multi-Tenant Berbasis Database-per-Tenant dan Metode FEFO pada Sistem Inventori dan Point of Sale UMKM Bakery
Pages: 58-67
Copyright (c) 2026 Rizki Wahyu, Jefry Sunupurwa Asri, Nizirwan Anwar, Adi Widiantono
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under Creative Commons Attribution 4.0 International License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (Refer to The Effect of Open Access).
