1. Go to the Manage Existing Employees and Job Codes task. If the entity in the My Org hyperlink is not a DeptID, change it to a DeptID
2. Go to the menu and select Tools \ Export as Spreadsheet
3. Click on the Distributions tab. Review the distributions. Export the Distributions to Excel.
4. Open the Excel files you downloaded and review them. When you double-click on the file to open it, the system presents a warning message about the file format. It is safe to open the file, so select Yes.
5. Note any employee with a Monthly Pay Rate but no Distribution. Also note any employee with a Distribution but no Monthly Pay Rate. Write the information here.
6. Find an employee with a Distribution of 1. Note the Monthly Pay Rate and then go to the Salary Expense tab. Confirm that the Salary Expense is equal to the Monthly Pay Rate.
7. Go to the Benefits tab and review the benefits for each employee. If you wanted to know the rate for GAEL, how could you determine it?
8. Go to the Total Comp tab. Gray background indicates that cells are read-only. What does the green background indicate?
-----
Return to course: Plan for Existing Employees