11,677
edits
Changes
Updating to match new version of source page
<languages/>
<b style="color:red;">Notice:</b> This template has not yet been translated into ''English'' and ''Spanish''.
In competitive environments and with the lack of qualified human resources, a proper management of those resources has a major role in retaining talents and in maintaining productivity.
In this situation, to achieve these goals, it is vital that the human resources departments provide reliable and up-to-date information on the staff to other managers.
Through the ''HRRH'' template, the HR managers can automate, with a low cost, a generation and a distribution, with security and confidentiality, like information on the staff.
* the distribution of labor force by cost center,
* the HR costs by cost center,
* which employees with the most absences,
Download the example worksheet, using the link below, replace with your data and update the [[Data Sources|datasource]] to start analyzing immediately and improve the management of your employees. If you do not have all the data available, leave the corresponding columns blank.
[[Special:FilePath/RH.xlsx|Download Sample Worksheet]]
Information on the ''HRRH'' spreadsheet:
* '''Data Competência''': Date of data collection on the HR system
* '''Filial''': Name of the branch where the employee works
* '''Tipo Contrato''': Type of employment association with the employee
* '''Remuneração Mês''': The value of the employee's net remuneration in the month of competence
* '''Bnf. Transporte''': Amount paid as a voucher benefit
* '''Bnf.Alimentação''': Amount paid for the food voucher
* '''Bnf. Saúde''': Amount paid as health plan benefit
* '''Bnf. Outros''': Amount paid under other benefits
* '''Qtd.Horas Extras''': The amount of overtime worked
* '''Valor Horas Extras''': The value of overtime worked
* '''Qtd.Horas Pagas''': The number of hours paid
* '''Qtd.Horas Faltas''': The number of hours the employee missed work
Analysis:
* '''Monthly Cost analysis by Cost Center'''
* '''Ranking of employees with more absence'''
[[File:rh_exemplo_1.PNG|link=]]