WebPy-BudgetAnalytics: Budget Monitoring and Analytic Support Tool for State Universities and Colleges

Adrian A. Rodriguez; Michael B. Dela Fuente

Adrian A. Rodriguez Bicol University, Philippines
Michael B. Dela Fuente Polytechnic University of the Philippines, Philippines

Abstract

Purpose - This study aims to develop a web-based budget monitoring system with an analytic support tool using a multiple linear regression model to enhance the financial management system of state universities and colleges (SUCs).|

Method - It follows a descriptive and developmental design to answer the research problem and attain the objective of the study. The descriptive design is applied in the documentary analysis and administration of the survey using survey questionnaires. The developmental approach is applied in developing the web-based software, specifically, the Rapid Application Development (RAD) model.

Results - The study provided ways to address the present problems and difficulties with the current method of managing financial resources: (a) automating budget execution-related processes; (b) recording of budget execution in a central database; (c) real-time monitoring of budget utilization; and (d) projection and forecast of future budget requirements based on previous utilization records for budget planning and preparation.

Conclusion – The developed system is highly acceptable in terms of functionality, usability, reliability, maintainability, and efficiency in managing university financial resources based on user evaluation.

Recommendation - The system includes the following features for the recommendation to be implemented: (1) preparation and management of working financial plan (WFP); (2) preparation and management of sub-allotment; (3) preparation and management of obligation and utilization request; (4) preparation, management, and monitoring of Certificate of Availability of Funds (CAF) request; and (5) reports preparation, budget monitoring and projection of future budgetary requirements.

Research Implications – The study demonstrates how automation of processes and applying multiple linear regression enhance the management and monitoring of SUC financial resources.

Author Biographies

Adrian A. Rodriguez, Bicol University, Philippines

ADRIAN A. RODROGUEZ is from Sto. Domingo, Albay, Philippines. He was a graduate of Bachelor of Science in Computer Science at Bicol University in 2009. He is a graduate of Master in Information Technology (MIT) degree from the Polytechnic University of the Philippines. He is connected to Bicol University in the Philippines currently designated as System Administrator with a permanent position as Information Technology Officer I and a Bids and Awards Committee Technical Member for ICT-related goods and services.

Michael B. Dela Fuente, Polytechnic University of the Philippines, Philippines

MICHAEL B. DELA FUENTE is currently an Associate Professor at the College of Computer and Information Sciences, Polytechnic University of the Philippines, Manila. He was the former Chairperson of the Department of Computer Science from 2009 to 2017 and currently held the position of Laboratory Head since October 2021. His research interests are in telemedicine/telehealth, intelligent systems, e-learning and mobile learning, game-based learning and gamification, augmented reality and hyperreality, assistive and adaptive technologies, and language processing, particularly in sign language, and translation systems.