Business Driven Technology 6th Edition by Paige Baltzan

Exercise 103

Turnover Rates
Employee turnover rates are at an all-time high at Gizmo Manufacturing's plants. The company is experiencing severe worker retention issues, which are leading to productivity and quality control problems. The majority of the company's workers perform a variety of tasks and are paid by the hour. The company currently tests potential applicants to ensure they have the skills necessary for the intense mental concentration and dexterity required to fill the positions. Because significant costs are associated with employee turnover, Gizmo Manufacturing wants to find a way to predict which applicants have the characteristics of being a short-term versus a long-term employee.
Project Focus
1. Review the information that Gizmo Manufacturing has collected from two of its different data sources. The first data file, AYK22_Data_A.xlsx, contains information regarding employee wages. The second data file, AYK22_Data_B.xlsx, contains information regarding employee retention.
2. Using Excel analysis functions, determine the employee characteristics that you would recommend Gizmo Manufacturing look for when hiring new personnel. It is highly recommended that you use PivotTables as part of your analysis.
3. Prepare a report based on your findings (which should include several forms of graphical representation) for your recommendations.
Data Files: AYK22_Data_A.xlsx and AYK22_Data_B.xlsx