A Development of an Application for Managing Surplus Medication Stock and Distribution to Medication-Shortage Hospitals.

Abstract

The increasing volume of surplus medications and improper disposal practices has resulted in adverse environmental and financial impacts. In response, a volunteer initiative was established to collect unused medications from communities. However, the management of medication stock data and the dissemination of this information to target hospitals has presented persistent challenges for effective administration. This research aimed to address these challenges through three primary objectives: to analyze and design a database system for medication stock management, develop an application using Google AppSheet as the management platform and Google Sheets as the database, and evaluate the system's performance. The evaluation employed a questionnaire adapted from the Delone and McLean Information System Success Model, which assesses four dimensions of system success: information quality, system quality, service quality, and user satisfaction. It was found that the overall user satisfaction of 52 purposively selected participants was rated at a very high level (= 4.63). Similarly, the information quality dimension received a very high satisfaction score (= 4.63). These results indicated that the developed system effectively addressed the identified issues, achieving the research objectives and contributing to improved medication stock management for the initiative.