Development of an Information System for Reducing Delays in Recording Equipment Details with an Investment Budget Management Information System

Abstract

       This research aimed to develop an information system for managing investment budgets and equipment at the Faculty of Science, Khon Kaen University, to reduce delays in recording equipment details. The system's development utilized tools such as JetBrains PhpStorm, Visual Studio Code, Laravel Framework, Navicat for MySQL, MySQL, Docker, and project management software like Microsoft Teams and Microsoft Planner. The study involved 35 selected academic and support staff responsible for recording equipment details, including IT officers, department heads, and administrators. Data analysis was performed using frequencies, percentages, and content analysis. The research led to creating an automated investment budget and equipment management information system based on equipment detail recording forms. This online system allows users to access and manage information through a login interface. The system was reviewed by two experts before implementation. It can automatically generate reports on equipment budget details and store information, as well as record the time spent on each task. Value Stream Maps (VSM) and workflow charts were used to identify operational inefficiencies, and the Eliminate, Combine, Rearrange, and Simplify (ECRS) principles were applied to streamline processes. The improved workflow analysis showed a reduction in the number of steps required to record equipment details from seven to three, and a decrease in work time from 920 minutes to 55 minutes, representing a 94% reduction.