Template RH

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 HR 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,

• overtime rates by cost center,

• which employees with the most absences,

• if the employee's level of education and age group are within the company's standards.

.

If you do not have all the data available, leave the corresponding columns blank.

.

Information on the HR spreadsheet:

• Data Competência: Date of data collection on the HR system

.

.

• Centro de Custo: Name of the cost center where the employee is designated

• Colaborador: Employee's name and code

.

• Estado Civil: Employee's marital status

.

• Faixa Etária: Employee's age group

• Cargo: Description of the position that the employee occupies within the company

• Tipo Contrato: Type of employment association with the employee

.

.

• Periculosidade: Indicates if the employee performs a function considered dangerous

• Insalubridade: Indicates if the employee performs a function considered unhealthy

.

• Data Demissão: The date when the employee was dismissed from the company

.

• Remuneração Mês: The value of the employee's net remuneration in the month of competence

• Passivo Décimo Terceiro: valor provisionado para o décimo terceiro salário

• Passivo Férias: Amount provisioned for vacations

• Passivo FGTS: valor que foi recolhido para o FGTS do colaborador

• 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

.

.

• Qtd. Horas Faltas: The number of hours the employee missed work

• Percentual de Horas Faltas: Percentage of absences over hours paid

.

• Collaboration analysis by cost center

• Monthly Cost analysis by Cost Center

.

.

• Ranking of employees with more absence

• Summary of employees by Sex, Marital Status, level of education and Age Group