- Determine the number of retiring employees per title.
- Identify employees who are eligible to participate in a mentorship program.
- The following is a retirement table that holds the counts of titles of current employees
- Born between January 1, 1952 and December 31, 1955.
- 90,398 employees who meet the born between range.
- The following highlights retiring employees by department who meet the criteria for retirement
72,458 employees will need to be filled to counter the "silver tsunami" the company will face.
The highest retiring counts by department:
Development: Senior Engineer = 8589, Engineer = 6840
Production: Senior Engineer = 7589, Engineer = 5865
Sales: Senior Staff = 6579
Are there enough qualified, retirement-ready employees in the departments to mentor the next generation of Pewlett Hackard employees?
Of the 72,458 qualified, retirement-ready emplyees 1,940 employees are qualified for mentorship_eligibility.