Org Charting Software Tool to Enable Visualization of

Org Charting Software Tool to Enable Visualization of Current and Future Workforce so as to Facilitate an Intended Reduction-In-Force HR Specialty Products & Services Catalogue Executive Summary A No Frills Distillation of Vendor’s Marketing Collateral Thomas A Ference President & CEO Human Resources Mining & Distribution Co Locating, Validating and Accelerating HR Innovation Office: 219 -662 -0201 Cell: 630 -240 -2583 Fax: 219 -661 -0236 e-mail: tference@hrmdco. com Website: www. hrmdco. com

Features and Benefits • When planning for an anticipated reduction-in-force, determining the optimal surviving workforce can take months. • This desk top application integrates with any and all HR files to auto-generate a visualization of the workforce and reporting structures. (A Visio compatible version is available) • A powerful auto-refresh feature updates revised org charts based on changes to underlying HR data files at any desired frequency • Modeling capabilities assess impacts on organization structure changes in terms of span of control, performance levels, training, experience levels, pay, bonuses, etc. • ”Interactive PDF’s” can be peeled off to allow for analysis at the business unit level • Tangentially helps to identify HR data files errors, gaps, overlaps and reporting anomalies that can be seen only via visualization

Visualization of HR and Workforce Data

Case Study – Workforce Reduction • A large Texas oil company was eliminating one of their larger locations with 6, 000 personnel. • A joint company team of business executives and HR analysts were tasked with developing a new organizational plan by identifying which employees to retain or not based on a set of established criteria. • Post vendor search, this technology was selected because of its ability to present a visual roadmap of essential talent that management could leverage into an action plan. • Relevant data from multiple HR and finance data sources (e. g. job titles, performance ratings, compensation amounts, etc. ) were imported into this analytics and visualization tool to develop reports and organization charts showing their leadership organization options that were best for the company. • The project to determine the new, optimal workforce was completed in less than one week versus the typical time frame of two months for completion of such work. • The new workforce data was automatically transferred to the company HRIS system.

Workforce Reduction - Visualization Examples

Next Steps • This product/service is contained in the HR Specialty Products & Services Catalogue™ • Operational level details about this particular service provider can be obtained in conference with the vendor • The HR Mining &Distribution Co. is an independent and contracted representative of the vendor • Upon your request, we will arrange for an introduction that can range from a simple, quick conference call to a services overview / system demo • Tom Ference 219 -662 -0201 (Chicagoland area) or tference@hrmdco. com • Thank you for your potential interest in this fresh thinking