Analyze the Efficiency of Expenditure Budget Income, Phuket Campus Office, Prince of Songkla University Phuket Campus, Fiscal Year 2019-2022

Abstract

The decrease in the number of students at Prince of Songkla University, Phuket Campus, has impacted the income of the Phuket Campus Office. Therefore, it is necessary to analyze the efficiency of budget expenditures from income-type revenue and compare the budgets of the Phuket Campus Office for the fiscal years 2019-2022 to demonstrate trends and directions in financial management. The data sources are derived from the financial summary report, the annual budget list from the PSU Management Accounting System (MAS), and the budget expenditure plan. The analysis is conducted using Microsoft Excel, involving data analysis, percentage calculations in table format, and graph creation using the Forecast command set. The analysis reveals that for the fiscal years 2019–2022, a significant portion of the Phuket Campus Office's income, 31.29%, was derived from tuition fees, while the majority of expenses, 45.45%, were allocated to personnel expenses. Furthermore, the net income experienced a consistent decrease each year. The forecast for fiscal years 2023–2026 indicates a decrease in actual income compared to estimates by 27.70%, 10.95%, -5.80%, and -22.55%, respectively. Similarly, actual expenses compared to estimates decreased by 58.68%, 53.76%, 48.84%, and 43.92%, respectively. However, actual expenses compared to actual income increased continuously by 162.30%, 182.51%, 202.72%, and 222.93%, respectively. This suggests that the Phuket Campus Office is experiencing a declining ability to generate income despite maintaining effective control over budget expenditures.