; Human Resources Dashboard Template
Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Human Resources Dashboard Template

VIEWS: 7,751 PAGES: 3

Template for a Human Resources Dashboard Report, including headcount analysis, results from employee engagement survey, staffing analysis.

More Info
  • pg 1
									Sample HR Scorecard
OVERALL ANALYSIS                                      2007                 2008         Target   % Change
                                  Full time headcount 2,881               2,902                     1%
                         Revenue per Employee (FTE) $12,406              $12,556                    1%
               Operating Expense per Employee (FTE) $7,633               $7,955                     4%
                      Net Income per Employee (FTE) $4,773               $4,601                    -4%
                             Total Company Turnover 14.5%                 12.6%                   -15%
                         Management bench strength 29.1%                  28.4%                    -2%
SURVEY RESULTS ANALYSIS
                  Satisfaction level for all employees         79%         81%                     2%
                     All who said "I'm likely to leave"        9.7%        8.3%                   -17%
   All who said "COMPANY" is a great place to work"            74%         77%                      4%
                      Satisfaction level for Managers          72%         77%                      6%
    Managers who said "Leadership is getting better"           91%         90%                     -1%

TURNOVER ANALYSIS
                               Voluntary turnover rate        12.9%        9.7%                   -33%
                             Involuntary turnover rate        1.6%        0.3%                    -433%
           Those with >1 year service who terminated          25.5%       22.1%                    -15%
         Those with 2 -5 years service who terminated         11.1%       10.9%                     -2%
          Those with >5 years service who terminated          1.1%           -                       -
                            Managers who terminated            4.0%        3.2%                   -25%
                Technical/Engineers who terminated            24.1%       19.6%                   -23%
                   Professional Staff who terminated          49.7%       44.9%                   -11%
                            All others who terminated         22.1%       23.3%                    5%

STAFFING ANALYSIS
                                  Offer Acceptance Rate         94%        97%                     3%
         Portion of all employees who are supervisors          11.2%      12.3%                     9%
           Portion of all employees who are managers           6.4%       6.3%                     -2%
    Portion of all employees who are Executive Level           2.1%       2.2%                      5%
                         REPLACEMENT positions filled           81%        71%                    -14%
                             Incremental positions filled       96%        95%                     -1%
                       Number of active open positions          15%        27%                     46%
                          Cost to fill a technical position   $3,654     $3,834                    5%
              Cost to fill a non-technical staff position     $3,120     $2,980                    -5%
           Cost to fill a managerial/executive position       $4,600     $4,100
                                    Days to fill a position      45         48                      6%
        Total staffing cost as % of Operating Expense          5.9%       5.8%                     -2%
           Of all eligible employees, portion promoted          9.0%      10.5%                   14%
                            Hiring Manager Satisfaction       85.20%     90.10%                    5%
  Quality of Hire (Technical and Managerial positions)          85%        89%                     4%
November 2009                                                    Effort to increase =
                                                                 Effort to decrease =
HR Balanced Scorecard Dashboard
 Function                                             Performance
 Employee turnover                                         73%
 Recruiting                                                79%
 Retention                                                 72%
 Training and Development                                  57%
 Total Performance                                        70.1%




 Scorecard details:
                                                         Weight                                                                                                                                          Performance
 Function         Goal                                    (x10)      Description                                                                                                                              (%)
 Employee turnover                                          2                                                                                                                                                73%
                 Cost per Hire                              1        Calculation of advertising, agency fees, employee referrals, relocation, recruiter pay and benefits costs and the number of hires       80%        80%
                 Turnover Cost                              3        Calculation of termination, new hire, vacancy and learning curve costs                                                                  70%       210%
                 Attrition Rate                             1        Average rate of employees leaving (vol and invol) the company                                                                           75%        75%
                 Time to Fill                               3        Average time from when a position opens until a new employee accepts an offer                                                           70%       210%
                 Length of Employment                       2        Average tenure for employee terminated                                                                                                  75%       150%
                 Total Performance in group                          Employee turnover                                                                                                                      72.5%      725%   0.725

 Recruiting                                                 4                                                                                                                                                79%
                  Time to Start                             2        Number of overall days the positions were vacant                                                                                        80%       160%
                  Quality of Hire                           4        Average performance appraisal of new hires, compared to previous period                                                                 90%       360%
                  Manager Satisfaction                      1        Manager satisfaction with recruitment process; quality, quantity of candidates and overall service                                      70%        70%
                  First Year Attrition Rate                 1        Number of new hires that terminate within first twelve months of employment                                                             80%        80%
                  Financial Impact of Bad Hire              2        Cost of replacing a new hire                                                                                                            60%       120%
                  Total Performance in group                         Recruiting                                                                                                                             79.0%      790%    0.79


 Retention                                                  2                                                                                                                                                72%
                  Preventable Turnover                      4        This indicator considers the reasons the employee left the organizations and what measures may be taken to prevent it                   80%       320%
                  Diversity Turnover                        2        Turnover rate for diversity employees                                                                                                   40%        80%
                  Financial Impact of Employee              4        Cost of turnover (vacant position, cost to fill, etc..)                                                                                 80%       320%
                  Total Performance in group                         Retention                                                                                                                              72.0%      720%    0.72

 Training and Development                                   2                                                                                                                                                57%
                  Learning and Growth Opportunities         4        Percentage of employees who are satisfied with the learning and growth opportunities in the organization                                75%       300%
                  On-the-job learning Contentment           3        project assignments for growth and development, and job rotations                                                                       60%       180%
                  Opportunities for New Hires               3        percentage of employees who report training opportunities among the top reasons they accepted the job                                   30%        90%
                  Total Performance in group                         Training and Development                                                                                                               57.0%      570%    0.57

                                                      HR Balanced Scorecard Dashboard                                                                                                                       70.1%

								
To top
;