350 likes | 603 Views
2012 Center for Energy Workforce Development Summit November 14-16, 2012 Crystal Gateway Marriott • Arlington, VA. Dominion’s Workforce Readiness Enterprise Scorecard. Overview of Dominion. Serve 6 million utility and retail energy customers in 15 states Headquartered in Richmond, VA
E N D
2012 Center for Energy Workforce Development Summit November 14-16, 2012 Crystal Gateway Marriott• Arlington, VA
Overview of Dominion • Serve 6 million utility and retail energy customers in 15 states • Headquartered in Richmond, VA • 15,800+ employees in four business units • Business includes: electric generation, natural gas transmission, gathering & storage pipeline, electric transmission & distribution lines and a gas storage system • Our values: • Safety • Ethics • Excellence • One Dominion
CEWD’s Key Performance Indicators and Critical Success Factors
WFR Enterprise Scorecard Sections • Section I: Key Observations • Section II: Metrics • Staffing Metrics • Productivity and Compensation Metrics • Movement Metrics • Section III: Appendix
EOP Employee Headcount on Payroll employees = X Movements: HiresQ2 2012 Hires X Exits X Avg. Age: X Years of Service: X Avg. Age: X Years of Service: X Avg. Age: X Female: X% / X Female: X% / X Female: X%/ X Minority: X% / X Minority: X% / X Minority: X% / X NOTE: Data collected from SAP BI * Custom SAP Org Hierarchy as of 7/6/2012 and Energy includes E&P 50005698 NOTE: Hires include mergers and acquisitions Formula: YTD External Hire & Rehire Actions by BU NOTE: Data collected from SAP BI NOTE: Exits = retirements,VSPs, involuntary and Voluntary terminations NOTE: Data collected from SAP BI Formula: YTD External Hire & Rehire Actions / YTD Total Separations and Change in Position Divestitures NOTE: Data collected from SAP BI *Includes Steel River Change in Position Divestitures Excludes co-ops/interns/temp subgroups, contractors, Steel River and Credit Union Q2 2012 Data as of or through: 6/30/2012 Last Refreshed: 7/6/2012
Success Tips • Educate on value of measurements • Obtain management team buy-in on measurements • Develop format and gather input • Gather data • Thoroughly label charts, data, formulas, etc. • Develop a key observations page • Have a definitions page • Determine refresh period-twice a year, quarterly
Business Unit Staffing by Union/Non-Union StaffingQ2 2012 NOTE: Custom SAP Org Hierarchy as of 7/6/2012; Energy includes E&P 50005698 orgs DRI Exec org in Total NOTE: Data collected from SAP BI Formula: EOP Employee Headcount on Payroll by Union and Non-Union Employees by Union Name Formula: EOP Employee Headcount on Payroll by Union Name NOTE: Data collected from SAP BI Employees by State Formula: EOP Employee Headcount on Payroll by Work Location State NOTE: Data collected from SAP BI Excludes co-ops/interns/temp subgroups, contractors, Steel River and Credit Union Q2 2012 Data as of or through: 6/30/2012 Last Refreshed: 7/6/2012
Leadership* Span of Control StaffingQ2 2012 EUHRMG Median 2011 Overall Very Large Companies Formula: EOP Headcount / Leadership Headcount *Leadership = SAP Job Type Indicator (Supervisor and above) NOTE: Data collected from SAP BI Women Leadership* EUHRMG Median 2011 Overall Q2 2012 Total Leadership is X Formula: Women in Leadership Hdct / Leadership Hdct *Leadership = SAP Job Type Indicator (Supervisor and above) NOTE: Data collected from SAP BI Minority Leadership* EUHRMG Median 2011 Overall Q2 2012 Total Leadership is X Formula: Minorities in Leadership Hdct / Leadership Hdct *Leadership = SAP Job Type Indicator (Supervisor and above) NOTE: Data collected from SAP BI Excludes co-ops/interns/temp subgroups, contractors, Steel River and Credit Union Q2 2012 Data as of or through: 6/30/2012 Last Refreshed: 7/6/2012
Women as % of Workforce StaffingQ2 2012 EUHRMG Median 2011 Overall NOTE: Data collected from SAP BI Formula: Women Headcount by BU / Headcount by BU Custom SAP Org Hierarchy as of 7/6/2012 Minorities as % of Workforce EUHRMG Median 2011 Overall NOTE: Data collected from SAP BI Custom SAP Org Hierarchy as of 7/6/2012 Formula: Minority Headcount by BU / Headcount by BU Excludes co-ops/interns/temp subgroups, contractors, Steel River and Credit Union Q2 2012 Data as of or through: 6/30/2012 Last Refreshed: 7/6/2012
Average Pay* Productivity and CompensationQ2 2012 NOTE: Data collected from SAP BI Formula: EOP Average of Annual Salary *NOTE: Pay includes Base Pay only Overtime Pay NOTE: Data collected from SAP (Payroll) Historical numbers are not adjusted for organizational shifts. Formula: Overtime Pay by BU NOTE: Includes temps/interns/co-ops on payroll; excludes contractors not on payroll. Overtime Hours Worked NOTE: Data collected from SAP (Payroll) Historical numbers are not adjusted for organizational shifts. Formula: Overtime Hours Worked by BU NOTE: Includes temps/interns/co-ops on payroll; excludes contractors not on payroll. Excludes co-ops/interns/temp subgroups, contractors, Steel River and Credit Union Q2 2012 Data as of or through: 6/30/2012 Last Refreshed: 7/6/2012
EOP Employee Headcount on Payroll employees = X Hires X Exits X Avg. Age: X Years of Service: X Avg. Age: X Years of Service: X Avg. Age: X Female: X% / X Female: X% / X Female: X%/ X Minority: X% / X Minority: X% / X Minority: X% / X Movements: HiresQ2 2012 NOTE: Data collected from SAP BI * Custom SAP Org Hierarchy as of 7/6/2012 and Energy includes E&P 50005698 NOTE: Hires include mergers and acquisitions Formula: YTD External Hire & Rehire Actions by BU NOTE: Data collected from SAP BI NOTE: Exits = retirements,VSPs, involuntary and Voluntary terminations NOTE: Data collected from SAP BI Formula: YTD External Hire & Rehire Actions / YTD Total Separations and Change in Position Divestitures NOTE: Data collected from SAP BI *Includes Steel River Change in Position Divestitures Excludes co-ops/interns/temp subgroups, contractors, Steel River and Credit Union Q2 2012 Data as of or through: 6/30/2012 Last Refreshed: 7/6/2012 TO BE DISTRIBUTED TO HR EMPLOYEES ONLY PREPARED AT THE DIRECTION OF COUNSEL, PRIVILEDGED AND CONFIDENTIAL
Authorized Budgeted & Actual Staffing Movements: HiresQ2 2012 NOTE: Data collected from SAP BI & HRDs; also used in Farrell Hdct Rpt Financial Considerations NOTE: Data collected from Budgeting & Finance Group & SAP BW for Hdct Percentage of Internal vs. External Hires Formula: Total External or Internal Hires / Total Hires NOTE: Data collected from Kenexa Brassring Excludes co-ops/interns/temp subgroups, contractors, Steel River and Credit Union Q2 2012 Data as of or through: 6/30/2012 Last Refreshed: 7/6/2012
Student Employee to Full Time Conversions Movements: HiresQ2 2012 Formula: Total Student Employee Hires / Total Eligible Student Employees NOTE: Data collected from SAP BI NOTE: Student Employees include interns, co-ops and student workers YTD 2012 Experienced/Entry Level Hires of Critical Jobs NOTE: Data collected from SAP BI *Critical jobs as defined by CEWD across Energy industry Excludes co-ops/interns/temp subgroups, contractors, Steel River and Credit Union Q2 2012 Data as of or through: 6/30/2012 Last Refreshed: 7/6/2012
Movements: HiresQ2 2012 Candidates vs. Hires *# of Candidates Hired will not match those from SAP because of data from different systems and internal hires are included in this chart NOTE: Data collected from Kenexa Brassring % Hired Formula: # of Candidates Hired / # of Candidates Screened YTD 2012 Candidate Screen Out Reasons PIE CHART OF SCREEN OUT REASON PERCENTAGES YTD AS OF Q2 NOTE: Data collected from Kenexa Brassring YTD 2012 Source of External Hires* PIE CHART OF HIRE SOURCE PERCENTAGES YTD AS OF Q2 *Of the external applicants who applied, only X% disclosed their source NOTE: Data collected from Kenexa Brassring Excludes co-ops/interns/temp subgroups, contractors, Steel River and Credit Union Q2 2012 Data as of or through: 6/30/2012 Last Refreshed: 7/6/2012
Movements: HiresQ2 2012 Trainees by Business Unit NOTE: Data collected from SAP BI NOTE: Trainees includes all jobs with trainee in the title & groundman # of Apprentices by Year of Program Development Program Completion NOTE: Data collected from Learning Council Members & Tech Training Depts NOTE: Data collected from Learning Council Members & Tech Training Depts Supply & Demand Analysis of Dominion’s Highest Population States NOTE: Data taken from the 2009 CEWD Supply and Demand Reports States Included: VA. OH, WV, CT & WI where 89% of Dominion’s workforce resides Excludes co-ops/interns/temp subgroups, contractors, Steel River and Credit Union Q2 2012 Data as of or through: 6/30/2012 Last Refreshed: 7/6/2012
Total Separation Rate Movements: SeparationsQ2 2012 EUHRMG Median 2011 Overall Very Large Companies NOTE: Data collected from SAP BI Separations = retirements, VSP, involuntary and voluntary separations **Includes Steel River & HighmountChange in Position Divestitures Custom SAP Org Hierarchy as of 7/6/2012 Formula: YTD Total Separations by BU / YTD Headcount by BU Resignation Rate NOTE: Data collected from SAP BI Custom SAP Org Hierarchy as of 7/6/2012; * Resignations = voluntary separations excluding retirements & VSPs Formula: YTD Resignations by BU / YTD Headcount by BU Voluntary Separation Rate excluding VSPs EUHRMG Median 2011 Overall Very Large Companies NOTE: Data collected from SAP BI * Includes resignations and retirements Custom SAP Org Hierarchy as of 7/6/2012 Formula: YTD Voluntary Separations by BU / Headcount by BU Excludes co-ops/interns/temp subgroups, contractors, Steel River and Credit Union Q2 2012 Data as of or through: 6/30/2012 Last Refreshed: 7/6/2012
Movements: SeparationsQ2 2012 Voluntary* Separation Rate including VSPs EUHRMG Median 2011 Overall Very Large Companies * Includes VSPs, retirements and resignations Custom SAP Org Hierarchy as of 7/6/2012 NOTE: Data collected from SAP BI Formula: YTD Voluntary Separations by BU / Headcount by BU Voluntary Sep Rate 0 to 1 LOS Voluntary Sep Rate 1+ to 3 LOS Formula: YTD Voluntary Separations with Less than 1 Year of Service / Headcount with Less than 1 Year of Service Formula: YTD Voluntary Separations with 1 and 2 Years of Service / Headcount with 1 and 2 Years of Service NOTE: Data collected from SAP BI NOTE: Data collected from SAP BI Voluntary Sep Rate 3+ to 5 LOS Voluntary Sep Rate 10 or More LOS Formula: YTD Voluntary Separations with 3 and 4 Years of Service / Headcount with 3 and 4 Years of Service Formula: YTD Voluntary Separations with 10+ Years of Service / Headcount with 10+ Years of Service NOTE: Data collected from SAP BI NOTE: Data collected from SAP BI Excludes co-ops/interns/temp subgroups, contractors, Steel River and Credit Union Q2 2012 Data as of or through: 6/30/2012 Last Refreshed: 7/6/2012
Turnover by Union/Non-Union/Leadership w/ VSP Movements: SeparationsQ2 2012 NOTE: Data collected from SAP BI Formula: YTD Total Separations by Union/Non-Union/Ldrshp/ YTD Headcount by Union/Non-Union/Ldrshp Custom SAP Org Hierarchy as of 7/6/2012 Turnover by Union/Non-Union/Leadership w/o VSP NOTE: Data collected from SAP BI Custom SAP Org Hierarchy as of 7/6/2012 Formula: YTD Total Separations by Union/Non-Union/Ldrshp/ YTD Headcount by Union/Non-Union/Ldrshp Excludes co-ops/interns/temp subgroups, contractors, Steel River and Credit Union Q2 2012 Data as of or through: 6/30/2012 Last Refreshed: 7/6/2012
YTD 2012 Annual Attrition % of Critical Jobs Movements: SeparationsQ2 2012 Formula: YTD External Hire & Rehire Actions / YTD Total Separations and Change in Position Divestitures NOTE: Data collected from SAP BI Reasons for Leaving Company – YTD 2012 PIE CHART OF REASONS FOR LEAVING COMPANY PERCENTAGES YTD AS OF Q2 NOTE: Data collected from Q2 2012 exit survey report Excludes co-ops/interns/temp subgroups, contractors, Steel River and Credit Union Q2 2012 Data as of or through: 6/30/2012 Last Refreshed: 7/6/2012
Retirement Eligibility (55 yrs of age) Movements: RetirementsQ2 2012 NOTE: Data collected from SAP BI 5 Yrs Ago % & Current Qtr % Formula: EOP Employee Hdct Eligible to Retire (=> Age 55 + LOS 3)/ EOP Employee Hdct on Payroll In 5 Yrs % Formula: EOP Employee Hdct Age 50 and Greater / EOP Employee Hdct on Payroll *Assumes current staffing levels Retirement Eligibility (58 yrs of age) 5 Yrs Ago % & Current Qtr % Formula: EOP Employee Hdct Eligible to Retire (=> Age 58)/ EOP Employee Hdct on Payroll In 5 Yrs % Formula: EOP Employee Hdct Age 53 and Greater / EOP Employee Hdct on Payroll NOTE: Data collected from SAP BI *Assumes current staffing levels Age Distribution Silent Formula: HdctBorn Before 1943 / Hdct Baby Boomer Formula: HdctBorn 1943–1960 / Hdct Gen X Formula: HdctBorn 1961-1981 / Hdct Gen Y Formula: HdctBorn After 1982 / Hdct NOTE: Data collected from SAP BI Formula: EOP Headcount on Payroll by Age Actual Retirements by Month NOTE: Data collected from SAP BI *Includes Voluntary & Involuntary Retirements Formula: YTD Retirement Actions by BU Historical numbers are adjusted for organizational shifts. Excludes co-ops/interns/temp subgroups, contractors, Steel River and Credit Union Q2 2012 Data as of or through: 6/30/2012 Last Refreshed: 7/6/2012
Movements: RetirementsQ2 2012 Retirements – Dominion Overall NOTE: Data collected from SAP BI Retirements - Energy Retirements - Dom VA Power NOTE: Data collected from SAP BI NOTE: Data collected from SAP BI Retirements - Generation Retirements – DRS-Managed NOTE: Data collected from SAP BI NOTE: Data collected from SAP BI Excludes co-ops/interns/temp subgroups, contractors, Steel River and Credit Union Q2 2012 Data as of or through: 6/30/2012 Last Refreshed: 7/6/2012