Integrated Registration System with Budget Forecasting for the Office of Senior Citizen Affairs (OSCA) in Bacolod City

Abstract

The Office of the Senior Citizen Affairs (OSCA) in Bacolod City needs help managing a growing number of senior citizen application records due to limited staff resources. This issue is compounded by the difficulties many older adults face related to mobility and health, further hindering the application process. To address these issues, this study aims to integrate a forecasting method with data the archiving facility of a web-based application for OSCA. This study seeks to improve the data management, process efficiency, budget estimation, and service accessibility for senior citizens. Initial investigation revealed that the budget calculation takes at least three months to complete; hence, a budget forecasting algorithm was implemented to predetermine the annual budget release, streamlining this process along the way. The target end-users of the system are residents of Bacolod City (Western Visayas, Philippines) aged 60 and above. The development process was guided by the Rapid Application Development (RAD) model. The pilot project was implemented in Bacolod City with the moving average algorithm used for forecasting. After the development, the system was evaluated by three experts. The results revealed that the system is effective and efficient in addressing the problems of OSCA related to registration process and document management.