Web-Based Dental Inventory Management and Treatment Automation System

Article Sidebar

PDF
Published: 2026-08-15
DOI: https://doi.org/10.23960/pepadun.v7i2.362
Keywords:
Inventory Management, Bill of Materials, FIFO, Web-Based System, Inventory Depletion Alert

Main Article Content

Imam Fahrurrozi
Dept. of Electrical Engineering and Informatics, Universitas Gadjah Mada
Harnan Malik Abdullah
Dept.of Creative and Digital Industries, Faculty of Vocational Studies, Universitas Brawijaya
Ganjar Alfian
Dept. of Electrical Engineering and Informatics, Universitas Gadjah Mada
M. Alex Syaekhoni
Dept. of Software Engineering, Universitas Prasetiya Mulya
Bima Bayu Sofana
Dept. of Electrical Engineering and Informatics, Universitas Gadjah Mada

Abstract

Currently, inventory management for medical equipment and supplies at the dental clinic relies on conventional methods. This situation leads to various issues, such as stock data discrepancies, delayed updates, recording errors, and difficulties in displaying product availability dates and stock levels in real-time. Furthermore, the use of medical supplies during patient treatment is not directly linked to the inventory system, requiring stock reductions to be processed separately. To address these challenges, an automated, web-based inventory management information system was developed. The proposed system integrates dental treatment procedures using the Waterfall Software Development Life Cycle (SDLC) model and is built on the Laravel, Next.js, and MariaDB platforms. It incorporates the First-In-First-Out (FIFO) principle, a Bill of Materials (BOM) structure tailored to each treatment type, stock reduction alerts based on the Moving Average method, inventory monitoring, and multi-channel notifications via web interface, email, and WhatsApp. Notably, simulation results demonstrate that the automated BOM mechanism reduces the recording process from 5–25 steps to 1–3 steps and cuts processing time from 1–3 minutes to 5–15 seconds per treatment. User Acceptance Testing (UAT) yielded a score of 88.57% (categorized as "Very Good"), confirming the application's suitability for supporting inventory operations at the dental clinic.

Article Details

Issue

Vol. 7 No. 2 (2026): August

Section

Articles
Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.

How to Cite

Web-Based Dental Inventory Management and Treatment Automation System. (2026). Jurnal Pepadun, 7(2), 183-195. https://doi.org/10.23960/pepadun.v7i2.362

References

I. S, R. Rosdianah, D. Mahendika, A. A. Bakri, and I. A. Mas’ud, “The Role of Health Information Systems to Enhance Health Services in Remote and Underserved Areas: Challenges and Solutions,” J. EduHealth, vol. 14, no. 02, pp. 713–719, Jun. 2023.

I. Pusdikasari, “Hospital Management Information System (SIMRS) in Improving Service Quality at Ogan Ilir Regional Hospital,” JKMP J. Kebijak. Dan Manaj. Publik, vol. 13, no. 1, pp. 65–70, Apr. 2025, doi: 10.21070/jkmp.v13i1.1786.

A. B. Bafarat, A. A. Khamis, D. Bassam, M. Ajjawi, and Y. Abdelaziz, “Inventory Management Practices in Hospitals,” Aug. 25, 2025, Engineering Archive. doi: 10.31224/5187.

C. Piffari, A. Lagorio, and R. Pinto, “Challenges in Healthcare Supply Chain Resilience Management : A Conceptual Framework,” IFAC-Pap., vol. 58, no. 19, pp. 1126–1131, 2024, doi: 10.1016/j.ifacol.2024.09.116.

B. V. Neve and C. P. Schmidt, “Point-of-use hospital inventory management with inaccurate usage capture,” Health Care Manag. Sci., vol. 25, no. 1, pp. 126–145, 2022, doi: 10.1007/s10729-021-09573-1.

A. Bekele, W. Kumsa, and M. Ayalew, “Assessment of Inventory Management Practice and Associated Challenges of Maternal, Newborn, and Child Health Life-Saving Drugs in Public Hospitals of Southwest Ethiopia: A Mixed-Method Approach,” Integr. Pharm. Res. Pract., vol. 11, pp. 139–149, Sep. 2022, doi: 10.2147/IPRP.S378340.

J. S Pasaribu, “Development of a Web Based Inventory Information System,” Int. J. Eng. Sci. Inf. Technol., vol. 1, no. 2, pp. 24–31, Mar. 2021, doi: 10.52088/ijesty.v1i2.51.

C. C. Utami, R. I. Desanti, and F. A. Halim, “The Development of Web-based Sales and Inventory System for a Stationary Store,” Ultima InfoSys J. Ilmu Sist. Inf., vol. 14, no. 2, pp. 52–57, Dec. 2023, doi: 10.31937/si.v14i2.3358.

A. Yoraeni, A. Margaret, M. Ifadah, and A. Mulyono, “Implementation of a Web-Based Inventory Management Information System,” Bit-Tech, vol. 8, no. 2, pp. 2338–2347, Dec. 2025, doi: 10.32877/bt.v8i2.3245.

N. Hasanah, E. K. Retno, W. Erwina, and M. A. Wardhana, “Studi Kasus Metode FIF0 (First-In-First-Out) dan FEFO (First-Expired-First-Out) Pengelolaan Obat Generik Tablet dan Kapsul dalam Penggunaan BPJS Klinik X Balikpapan,” PHARMACIA, vol. 2, no. 2, pp. 33–47, Sep. 2024.

B. L. Y. Atmojo and I. K. D. Nuryana, “Design of Inventory Stock Information System Using Laravel Framework with FIFO Method,” Journal of Emerging Information Systems and Business Intelligence (JEISBI), 6(3), 376~383, 2025, doi: 10.26740/jeisbi.v6i3.70863.

M. Selpiyana, A. Fergina, and I. Yustiana, “Web-Based Drug Inventory System with FIFO Method and SCM Approach at Risa Farma Pharmacy,” Bit-Tech, vol. 8, no. 2, pp. 1446–1454, Dec. 2025, doi: 10.32877/bt.v8i2.2951.

F. A. Zalukhu, R. D. Arista, and A. Badawi, “Designing an Inventory Management Information System Using the FIFO Method at PT Matahari Department Store,” Proceedings of International Conference on Islamic Community Studies, pp. 3212–3222, 2025.

R. Shinta, B. Hartanto, and Y. R. W. Utami, “Penerapan Metode First In First Out Pada Sistem Manajemen Persediaan Stok Janti Park,” Journal of Information Technology, Computer Engineering and Artificial Intelligence (ITCEA), vol. 1, no. 1, pp. 35–46, 2024.

D. Sinaga, N. Silalahi, R. U. Pangaribuan, and W. Simangunsong, “Material Requirement Planning (MRP) dalam Proses Perencanaan dan Pengendalian Produksi Pembuatan Ragum,” Talenta Conference Series: Energy and Engineering (EE), vol. 3, no. 2, pp. 170-178, 2020, doi: 10.32734/ee.v3i2.990.

L. N. R. Mudunuri and V. M. Aragani, “Bill of Materials Management: Ensuring Production Efficiency,” International Journal of Intelligent Systems and Applications in Engineering, vol. 12, no. 23s, pp. 1002–1012, 2024, Retrieved from https://www.ijisae.org/index.php/IJISAE/article/view/7102.

M. A. Kamal, F. D. Effendi, M. R. Utomo, S. Sucipto, I. Santoso, and U. Effendi, “Bill of material analysis framework of food menu to increase raw material inventory efficiency and halal food inspection of culinary business,” IOP Conf. Ser. Earth Environ. Sci., vol. 733, no. 1, p. 012043, Apr. 2021, doi: 10.1088/1755-1315/733/1/012043.

M. Sasikanth and Dr. D. R. Krithika, “Restaurant Inventory Management System,” Int. J. Adv. Res. Sci. Commun. Technol., pp. 87–92, Jul. 2024, doi: 10.48175/IJETIR-1217.

S. George and S. Elrashid, “Inventory Management and Pharmaceutical Supply Chain Performance of Hospital Pharmacies in Bahrain: A Structural Equation Modeling Approach,” Sage Open, vol. 13, no. 1, p. 21582440221149717, Jan. 2023, doi: 10.1177/21582440221149717.

T. Abu Zwaida, C. Pham, and Y. Beauregard, “Optimization of Inventory Management to Prevent Drug Shortages in the Hospital Supply Chain,” Appl. Sci., vol. 11, no. 6, p. 2726, Mar. 2021, doi: 10.3390/app11062726.

O. A. Gonzatto Junior et al., “Safety-Stock: Predicting the demand for supplies in Brazilian hospitals during the COVID-19 pandemic,” Knowl.-Based Syst., vol. 247, p. 108753, Jul. 2022, doi: 10.1016/j.knosys.2022.108753.

M. W. Rhamadani, A. Ardi, and A. Apriyani, “Optimizing Medical Equipment Inventory Management through Web-Based System Implementation for Real-Time Monitoring and Alerts,” Journal of Information and Technology, vol. 14, no. 1, pp. 130-140, 2026, doi: 10.32664/j-intech.v14i01.2221.

J. Surya, G. C. Rodillas, X. J. Tubog, and R. C. Doctor, “Sort Out: A Smart Inventory Management System Using Descriptive Analytics and Rule-Based Algorithm for Mini Grocery Stores,” Int. J. Res. Innov. Appl. Sci..

G. Engels, A. Förster, R. Heckel, and S. Thöne, “Process Modeling using UML,” in Process‐Aware Information Systems, 1st ed., M. Dumas, W. M. P. Van Der Aalst, and A. H. M. Ter Hofstede, Eds., Wiley, 2005, pp. 83–117. doi: 10.1002/0471741442.ch5.

F. M. Akmal and J. Suhada, “Perancangan Basis Data: Konsep Entitas, Atribut, dan Relasi,” Buletin Ilmiah Ilmu Komputer dan Multimedia (BIIKMA) (INPRESS), vol. 3, no. 3, pp. 473–478, 2025, Retrieved from https://jurnalmahasiswa.com/index.php/biikma/article/view/2934.

H. Subagja, T. Rihanjaya, F. N. Afansyah, A. Rahman, and Y. Prasetyo, “Application of the First-In First-Out (FIFO) Method of Computerized Inventory Management in Warehousing to Optimize Inventory Turnover,” Inventa: Journal of Science, Technology, and Innovation, vol. 1, no. 2, pp. 157-169, 2025, doi: 10.65310/x8vyy927.

F. S. Titong, “Penerapan Metode Fifo (First in First Out) dalam Menjaga Efektivitas Warehouse pada PT. Mutiara Luwuk Bintang Lestari,” J. Syntax Admiration, vol. 5, no. 10, pp. 3762–3768, Oct. 2024, doi: 10.46799/jsa.v5i10.1500.

O. Gauri, R. Rahmawati, and I. Sujana, “Perencanaan Produksi dan Pengendalian Bahan Baku di IKM XYZ,” Jurnal Teknik Industri Universitas Tanjungpura, vol. 9, no. 2, pp. 294-302, 2025.

B. N. Sari, O. Komarudin, T. N. Padilah, and M. Nurhusaeni, “Bill of Material (BoM) pada Sistem Inventori Kawasan Berikat untuk Pelacakan Material Movement,” Ilk. J. Ilm., vol. 10, no. 3, pp. 323–330, Dec. 2018, doi: 10.33096/ilkom.v10i3.381.323-330.

J. Suya, G. C. Rodillas, X. J. Tubog, and R. C. Doctor, “Sort Out: A Smart Inventory Management System Using Descriptive Analytics and Rule-Based Algorithm for Mini Grocery Stores,” International Journal of Research and Innovation in Applied Science, vol. 11, no. 2, pp. 136-148, 2026, doi: 10.51584/IJRIAS.2026.110200012.