Article Per Year (5 Year)
p-Index From 2021 - 2026
0.444
P-Index
This Author published in this journals
All Journal JPM
Dewi Sekar Ayu
Politeknik Negeri Bandung
Humanities Economics, Econometrics & Finance Public Health Social Sciences Other

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

 1 
Pendampingan Optimalisasi Pencatatan Data Daily worker Berbasis Microsoft Excel pada Departemen Human Resources Hotel APendampingan Optimalisasi Pencatatan Data Daily worker Berbasis Microsoft Excel pada Departemen Human Resources Hotel A Vivin Alifianti Rusyana; Koernia Purwihartuti; Dewi Sekar Ayu
Jurnal Pengabdian Masyarakat Vol. 4 No. 2 (2026): July- JPM
Publisher : PDPI

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.58818/jpm.v4i2.207

Abstract

The hospitality industry requires an orderly workforce administration system, particularly in managing daily workers who support daily operational needs. In the human resources Department of Hotel A in Bandung, daily worker data recording was initially conducted using physical forms before being recapitulated into a digital file. This condition made the data less structured, increased the possibility of misplaced documents, and made it difficult to monitor the number of workers by department. This community service activity aimed to optimize daily worker data recording through assistance in developing and implementing a Microsoft Excel-based template. The implementation method consisted of partner needs identification, workflow mapping, template development, template implementation, and evaluation of the application results. The results show that the Excel template helped organize daily worker data more systematically based on department, section, working date, payment method, and worker category, namely approval and additional. The implementation also improved data accessibility through a shared folder, supported weekly recapitulation, and reduced dependence on physical documents. This activity indicates that simple digitalization using Microsoft Excel can serve as a practical solution for improving human resources administration efficiency in the hospitality industry.
Co-Authors Berni Rahman Iskandar Koernia Purwihartuti Novi Fitriani Vivin Alifianti Rusyana