Jurnal Kecerdasan Buatan dan Teknologi Informasi
Vol. 5 No. 3 (2026): September 2026

Web-Based Inventory Information System for Asset and Consumable Management at Ratumbuysang Mental Hospital

Faith Nathaniel Alexander (Universitas Sam Ratulangi)
Chriestie E. J. C. Montolalu (Universitas Sam Ratulangi)
Wisard Kalengkongan (Universitas Sam Ratulangi)
Christian Alderij Soewoeh (Universitas Sam Ratulangi)
Mahardika Inra Takaendengan (Universitas Sam Ratulangi)
Stephano C.W. Ngangi (Universitas Sam Ratulangi)



Article Info

Publish Date
30 Sep 2026

Abstract

This study aimed to design and develop a web-based Inventory Information System for Ratumbuysang Mental Hospital to address inventory management that was previously performed manually. Manual recording made inventory searching, asset tracking, and report preparation less efficient and increasedthe risk of recording errors. The system was developed using the Waterfall method through requirements analysis, system design, implementation, testing, and maintenance. The application uses React.js for the frontend, Node.js and Express.js for the backend, PostgreSQL for data management,and Prisma ORM as the database interface. The implemented functions include item master-data management, incoming assets, outgoing assets, consumable items, user management, report generation, and QR Code-based asset identification. Black Box Testing was conducted using 27 functional scenarios and showed that all tested functions operated according to the expectedresults. User Acceptance Testing (UAT) involved 24 statements using a five-point Likert scale. The overall mean score was 4.68, equivalent to 93.50%, and was categorized as Very Good in the original evaluation. These findings indicate that the developed system was accepted by users and can support structured inventory management at Ratumbuysang Mental Hospital.

Copyrights © 2026






Journal Info

Abbrev

JKBTI

Publisher

Subject

Computer Science & IT

Description

Jurnal Kecerdasan Buatan dan Teknologi Informasi or abbreviated JKBTI is a national journal published by the Ninety Media Publisher since 2022 with E-ISSN : 2964-2922 and P-ISSN : 2963-6191. JKBTI publishes articles on research results in the field of Artificial Intelligence and Information ...