Human Resources Dashboard Template

Document Sample
Human Resources Dashboard Template Powered By Docstoc
					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%

				
DOCUMENT INFO
Shared By:
Stats:
views:7751
posted:8/21/2009
language:English
pages:3
Description: Template for a Human Resources Dashboard Report, including headcount analysis, results from employee engagement survey, staffing analysis.
BUY THIS DOCUMENT NOW PRICE: $2.95 100% MONEY BACK GUARANTEED
PARTNER Kirk Podawiltz
Kirk Podawiltz has over 18 years of corporate staffing leadership and executive recruiting experience; working in corporate staffing leadership positions with companies such as Nortel Network, Lucent Technologies, Google, and Merrill Lynch. He has also spent many years working as in-house and external executive recruiter. Some of his in-house engagements have been with Apple, Intuit, and CSAA where he has successfully executed recruiting strategies and developed leadership assessment guide for almost every search he conducted to hire top executives for his clients. • Recruitment & Retention • Assessment & Evaluation • Compensation & Benefits • Performance Management • Learning & Development • Workforce Planning & Staffing Models • On-Boarding and New Hire Assimilation • Quantitative Evaluation of Human Resources Function and Strategic HR Reporting • Succession Planning