Hr Analytics Analysis Essay Example

starting their employment. The percentage of employees with less than 1 year of service who left the organization. The percentage of employees with less than 1 year of service who resigned. The percentage of employees with less than 1 year of service who left the organization involuntarily. People hired externally as a percentage of headcount. Executives hired externally as a percentage of Executive headcount. Managers hired externally as a percentage of Manager headcount.

Individual Contributors hired externally as a percentage of Individual Contributor headcount. The percentage of people hired externally who self-identify as coming from a diversity category. Count of Vacant Positions/Headcount (Resignations + Retirements + Involuntary terminations) within 0-90 Days of Service / Headcount 90 Days of Service (Resignations + Retirements) within 0-90 Days of Service/ Headcount 90 Days of Service Involuntary terminations within 0-90 Days of Service/ Headcount 90 Days of Service (Resignations + Involuntary terminations) within 0-1 year of service /

Headcount 0-1 Year of Service Resignations within 0-1 Year of Service/Headcount 0-1 Year of Service Involuntary terminations within 0-1 year of service/Headcount 0-1 Year of Service New Hire Total/Headcount New Hire Executive Level Total/Executive Level Headcount New Hire Management Level Total/Management Level Headcount New Hire Individual Contributor Level Total/languidly Contributor Headcount (New Hires who self-identify as an Aboriginal Person, Person with a Disability, or Member of a Visible Minority)/Total New Hires 90 Day Voluntary Turnover Rate 90 Day Involuntary Turnover Rate 1st Year Turnover

Rate 1st Year Resignation Rate 1st Year Involuntary Turnover Rate External Hire Rate External Hire Rate Executive Level External Hire Rate Management Level External Hire Rate Individual Contributor Level Diversity Hire Ratio page 5 of 26 Recruitment

continued Female Hire Ratio Under 25 Years Hire Ratio 25-29 Years Hire Ratio 30-34 Years Hire Ratio 35-39 Years Hire Ratio 40-44 Years Hire Ratio 45-49 Years Hire Ratio 50-54 Years Hire Ratio 55-59 Years Hire Ratio 60-64 Years Hire Ratio 65 Years or Older Hire Ratio External Time-to-Fill employees hired externally who are under the age of 25.

The percentage of employees hired externally who are between the ages of 25 and 29. The percentage of employees hired externally who are between the ages of 30 and 34. The percentage of employees hired externally who are between the ages of 35 and 39. The percentage of employees hired externally who are between the ages of 40 and 44. The percentage of employees hired externally who are between the ages of 45 and 49.

The percentage of employees hired externally who are between the ages of 50 and 54. The percentage of employees hired externally who are between the ages of 55 and 59. The percentage of employees hired externally who are between the gees of 60 and 64. The percentage of employees hired externally who are between the ages of 65 and older. The average number of calendar days taken to fill a position from outside the organization.

New Hires who are female/New Hires Total New Hires who are under 25/New Hires Total New Hires who are between 25-29 Years old/ New Hires Total New Hires who are between 30-34 Years old/ New Hires Total New Hires who are between 35-39 Years old/ New Hires Total New Hires who are between 40-44 Years old/ New Hires Total New Hires who are between 45-49 Years

old/ New Hires Total New Hires who re between 50-54 Years old/ New Hires Total New Hires who are between 55-59 Years old/ New Hires Total New Hires who are between 60-64 Years/ New Hires Total New Hires who are between 65 Years or older/ New Hires Total External Days to Fill/ External Recruits Page 6 of 26 External Time-to-Fill Executive Level Positions External Time-to-Fill Management Level Positions External Time-to-Fill Individual Contributor Level Positions External Cost per Hire External Offer Acceptance Rate The average number of calendar days taken to fill an Executive position from outside the organization. The average number of calendar days taken to fill a Manager position from outside the organization. The average number of calendar days taken to fill an Individual Contributor position from outside the organization. The average direct costs for external hiring per external hire. External people accepting positions as a percentage of total external Job offers. External Days to Fill Executive Level Positions/Executive Level External Recruits External Days to Fill Individual Contributor Level Positions/languidly Contributor Level External Recruits Total External Hiring Costs/External Recruits External Recruits/

Total External Job Offers Extended page 7 of 26 Retention Turnover Voluntary Turnover Rate Executive Voluntary Turnover Rate Management Voluntary Turnover Rate Individual Contributor Voluntary Turnover Rate Cost of Voluntary Turnover Involuntary Turnover Rate Executive Involuntary Turnover Rate Management Involuntary Turnover Rate Individual Contributor Involuntary Turnover Rate Succession Planning Rate Resignation Rate Employees who left the organization, either voluntarily or involuntarily, as a percentage of headcount. Employees who left the organization voluntarily as a percentage of headcount. Executives who voluntarily left the organization as a percentage of Executive headcount. Managers who voluntarily left

the organization as a percentage of Management headcount. Individual Contributors who voluntarily left the organization as a percentage of Individual Contributor headcount. The average cost to replace each employee who left voluntarily. Employees who left the organization involuntarily as a percentage of headcount. Executives who left the organization involuntarily as a percentage of Executive headcount.

Managers who left the organization involuntarily as a percentage of Manager headcount. Individual Contributors who left the organization involuntarily as a percentage of Individual Contributor headcount. The percentage of Executive roles for which there is a succession candidate. Employees who resigned from the organization as a percentage of headcount. (Resignation + Retirements + Involuntary Terminations)/Headcount (Resignations + Retirements)/Headcount (Executive Resignations + Executive Retirements)/Executive Headcount (Management Resignations + Management Retirements)/Management Headcount (Individual Contributor Resignations + Individual Contributor

Retirements)/languidly Contributor Headcount Projected annual base compensation cost / (Resignations + Retirements) Involuntary Terminations/Headcount Executive Involuntary Terminations/Executive Headcount Management Involuntary Terminations/Management Headcount Individual Contributor Involuntary Terminations/languidly Contributor Headcount Number of Succession Planning Candidates/Executive Level Headcount Resignations/Headcount Retention continued First Two Years of Service Resignation Rate Two to Three Years of Service Resignation Rate Three to Five Years of Service Resignation Rate Five to Ten Years of Service Resignation Rate More than Ten Years of Service Resignation Rate Under 25 years Resignation Rate 25-29 Years Resignation Rate 30-34 Years Resignation Rate 35-39 Years Resignation Rate 40-44 Years Resignation Rate 45-49 Years Resignation Rate 50-54 Years Resignation Rate 55-59 Years Resignation Rate The percentage of employees with less than two years of service who resigned. The percentage of employees with between two and three years of service who resigned. The percentage of employees with between three

and five years service who resigned.

The percentage of employees with between five to ten years of service who signed. The percentage of employees with more than ten years of service who resigned. The percentage of employees under 25 years of age who resigned. The percentage of employees between the ages of 25 to 29 who resigned. The percentage of employees between the ages of 30 to 34 who resigned. The percentage of employees between the ages of 35 to 39 who resigned. The percentage of employees between the ages of 40 to 44 who resigned. The percentage of employees between the ages of 45 to 49 who resigned. The percentage of employees between the ages of 50 to 54 who resigned. The percentage of employees between the ages of 55 to 59 who resigned.

Resignations within 0-2 years of service/Headcount 02 Year of Service Resignations within 2-3 years of service/Headcount 23 Year of Service Resignations within 3-5 years of service/Headcount 35 Year of Service Resignations within 5-10 years of service/Headcount 5-10 Year of Service Resignations with more than 10 years of service/Headcount 10 Years or more of Service Resignations of employees 25 years and under/Headcount of employees 25 years and under Resignations of employees between 25-29 years/Headcount of employees between 25-29 years Resignations of employees between 30-34 years/Headcount of employees between 30-34 years Resignations of employees between 35-39 years/Headcount of employees between 35-39 years Resignations of employees between 40-44 years/Headcount of employees between 40-44 years Resignations of employees between 45-49 years/Headcount of employees between 45-49 years Resignations of employees between 50-54 years/ Headcount of employees between 50-54 years Resignations of employees between 55-59 years/Headcount

of employees between 55-59 years Page 9 of 26 60-64 Years Resignation Rate 65 Years or Older Resignation Rate Retirement Rate Average Retirement Age The percentage of employees between the ages of 60 to 64 who resigned.

The percentage of employees aged 65 or older who resigned. Employees who retired as a percentage of headcount. Average age of employees who retired. Resignations of employees 60-64 years/Headcount of employees 60-64 years Resignations of employees 65 years or older/Headcount of employees 65 years or older Retirements/Headcount Total Retirements Age/Retirements page 10 of 26 HRS Efficiency HRS FEET Ratio HRS Headcount Ratio HRS Costs per Employee HRS Costs per FEET HRS Turnover The number of FEET per individual HRS FEET. The number of staff per individual HRS staff person. The cost HRS for each staff member. (Based on headcount) The cost of HRS for each FEET. Based on FEET) The number of HRS staff leaving as a percentage of all HRS staff. FEET/HRS FEET Headcount/HRS Headcount HRS Costs/Headcount HRS Costs/FEET HRS Terminations/HRS Headcount Page 1 1 of 26 Learning & Development Learning & Development Investment per FEET Learning & Development Cost Revenue Hours per FEET Learning & Development FEET Ratio The number of dollars invested in learning and development per FEET. The total costs of learning and development as a percentage of the total revenue from operations. The total costs of learning and development as a percentage of the total labor costs. The numbers of hours spent on learning per FEET. The number of FEET for each FEET working in learning and development.

Learning & Development Cost/FEET Learning & Development Cost/Revenue Learning & Development Cost/Labor Costs Learning &

Development Hours/FEET FEET/Learning & Development FEET page 12 of 26 Workforce Demographics Promotion Rate Career Path Ratio Churner Union Percentage Female Percent Percentage Female at Executive Level Percentage Female at Management Level Percentage Female at Individual Contributor Level Diversity Percentage (Visible Minorities, Aboriginal Persons, Disabled Persons) Percentage Diversity at Executive Level Percentage Diversity at Management Level Percentage Diversity at Individual Contributor Level Management Span of Control Employees promoted as a percentage of headcount. Employees moving upward in the organization as a percentage of all employee movement. Rate of internal movement by employees as percentage of headcount. Employees belonging to a union as a percentage of headcount. Employees who are female as a percentage of headcount.

Executives who are female as a percentage of Executive headcount. Managers who are female as a percentage of Manager headcount. Individual Contributors who are female as a percentage of Individual Contributor headcount. Employees who identify in a diversity category as a percentage of headcount. Executive who identify in a diversity category as a percentage of Executive headcount. Managers who identify in a diversity category as a percentage of Manager headcount. Individual Contributors who identify in a diversity category as a percentage of Individual Contributor headcount. Average number of employees per Manager [Executive. Promotions/Headcount

Headcount Union Headcount/Headcount Female Employees/Headcount Female Executive Level Employees/Executive Level Headcount Female Management Level Employees/Management Level Headcount Female Individual Contributor Level Employees/languidly Contributor Level Headcount (Employees who self-identify as an Aboriginal Person, Person with a Disability, or Member of a Visible Minority)/ Headcount (Executive Level employees who self-identify as an Aboriginal Person, Person with a Disability, or Member of a Visible Executive Headcount (Management Level employees who

self-identify as an Aboriginal Person, Person with Disability, or Member of a Visible Minority)/Total Management Headcount (Individual Contributor Level employees who self-identify as an Aboriginal Person, Person with a Disability, or Member of a Visible Minority)/Total Individual Contributor Headcount Headcount/(Management Level Headcount + Executive Level Headcount) page 13 of 26 Workforce Demographics continued Average Age Average Length of Service Part-time Percent Temporary Staff Percentage Average age of organizations' total employee population. Average length of employee service. (Based on headcount) Permanent employees who work part-time as a argental of headcount.

Non-permanent employees as a percentage of headcount. Total Age of Employees/Headcount Total Length of Service/Headcount Part-time Employees/Headcount (Non-permanent employees + Headcount)/Headcount Page 14 of 26 HRS Metrics Glossary Aboriginal person For the purposes of employment equity, "aboriginal peoples" means persons who are Indian, Intuit or M©its. (From Employment Equity Act, Section 3) Active employee An employee can either be active or inactive. An active employee is one who is not on any leave of absence (short-term disability, maternity leave, Jury duty, etc. ) Age group This demographic category is used to identify patterns and trends.

The age groups are: Under 25 years 25-29 years 30-34 years 35-39 years 40-44 years 45-49 years 50-54 years 55-59 years 60-64 years 65 years or older Benefit paid provincial health care plan premium (I. E. MSP/Health Insurance BC or CHIP), employer-paid pension plan or RASP payments, retirement payouts, maternity leave top-ups, and perquisites (I. E. Club or professional membership dues, parking or car allowance). Do not include any stock payouts. Demotion A type of internal employee movement in which there is an act of lowering in rank or position; may

include a decrease in pay or responsibilities. Diversity group This demographic category is used to identify patterns and trends.

The diversity groups are the four designated group members under the Employment Equity Act (Section 3): Aboriginal peoples Persons with disabilities Members of visible minorities Females page 15 of 26 Employee Any individual with an employment contract with the organization who receives a paychecks from payroll and a TO. For the purpose of the benchmarking revue, "employee" refers to: permanent employees, and employees on a leave of absence, paid or unpaid The definition does not include: non-permanent employees external consultants who receive payment from Accounts Payable, and employees on a long-term disability. Executive The Job level used to describe employees who are in a director position or above. External Days to Fill The total calendar days between when the requisition was approved to the date the offer is accepted. Calculate External Days to Fill for External Recruits only.

Example: 2 employees were hired as follows: Hire #1 Requisition Approved: January 2 Job Offer Accepted: January 30 Time to Fill for Hire #1: 28 days (includes weekends) Hire Requisition Approved: December 24, 2007 Job Offer Accepted: January 30, 2008 Time to Fill for Hire #2: 36 days (includes weekends, Christmas, and New Year's stats holidays) Total Days to Fill: 28 + 36 = 64 days External recruit An external recruit is a person who is has accepted a Job offer but may or may not have started their first day of employment during the reporting period.