Development of Supply Shortage Check Data Processing System: Case study: Warehouse section, Provincial Electricity Authority Kabinburi

Abstract

The objectives of this research were: 1) to develop a Supply Shortage Check Data Processing System for the Warehouse Section of the Provincial Electricity Authority, Kabinburi Branch, and 2) to evaluate the system's efficiency by experts. The study addressed limitations in the existing SAP system regarding automatic data comparison, which previously required manual processing and significant time. To resolve these issues, the researcher utilized Google Apps Script technology to develop a web application for automated summarizing and comparing of Supply Shortage Check Data.

          The research methodology involved a purposive sampling of 5 experts: 2 staff members from the Warehouse Section and 3 information technology specialists. The research instrument was an efficiency evaluation questionnaire based on a 5-point Likert scale. Data were analyzed using descriptive statistics, including Mean and Standard Deviation (S.D.). The results indicated that the overall efficiency of the developed Warehouse Data Processing System was at a "Very Good" level (Mean = 4.53, S.D. = 0.54). When considering individual aspects, both functional requirements (Functional Test) and data security (Security Test) received the highest ratings at a very good level (Mean = 4.60). The usability aspect followed at a good level (Mean = 4.40). In conclusion, the developed system can be effectively implemented to significantly reduce processing time and the workload of staff in warehouse management.