The Development of an Hourly Leave Information System for a Company with a Limited Number of Employees

Abstract

The objectives of this research are 1) to develop an hourly leave system for companies with limited staff, 2) to compare the results between full-day and hourly leave systems, and 3) to enhance project efficiency. The system was developed using Visual Studio Code for programming and Firebase for database management, incorporating essential functions such as hourly leave request submission, manager approval processes for hourly leave, and real-time leave status tracking. The study specifically targeted 12 full-time employees involved in six core projects (totaling 50 personnel, with some employees assigned to multiple projects) in direct information technology development roles. The research findings revealed that 1) the developed hourly leave system reduced absenteeism rates from 34% (17 out of 50 employees) to just 12.75% (equivalent to 6.375 lost workdays) while maintaining employee flexibility and improving workforce availability; 2) when comparing full-day and hourly leave systems, hourly leave reduced productivity loss by 62.5% compared to the full-day system, with Project 4 (previously experiencing 100% absenteeism under the old system) showing clear benefits from the new approach, though Project 2 still had a 31.25% absenteeism rate, indicating room for further improvement; and 3) in terms of project efficiency enhancement, the system helped address staffing gaps in teams with high leave rates (Projects 1, 2, and 4) through balanced leave distribution, while the real-time tracking feature improved workflow management during peak demand periods, identifying critical monitoring points such as June (due to accumulated leave hours risk) and Projects 2 and 5 (which still had absenteeism rates exceeding 30%).