_{Your company has a pay policy that sets wages for employees at the community average for the area. There are two main employee groups in the company; Human Resource Coaches and HR Assistants. The breadth of the pay ranges is 30% for each job, and the ranges are divided into quintiles. The minimum for the HR Assistant job is $12 per hour. The minimum for the Human Resources Coach job is $16 per hour.}

_{Calculate the range for each job, including minimum, midpoint, maximum and the top of the first, second, third and fourth quintile. HR Assistant Pay Range: Minimum Top of 1st Q Top of 2nd Q Midpoint Top of 3rd Q Top of 4th Q Maximum 12.00 HR Coach Pay Range: Minimum Top of 1st Q Top of 2nd Q Midpoint Top of 3rd Q Top of 4th Q Maximum 16.00}

_{The most recent salary survey data shows the median pay for HR Assistants is $14.00, and the median pay for HR Coaches is $18.75. Calculate the percentage increase this represents and apply that percentage increase to the pay ranges for each job. The percentage increase for HR Assistant Pay Range is The percentage increase for the HR Coach Pay Range is}

_{HR Assistant Pay Range Minimum Top of 1st Q Top of 2nd Q Midpoint Top of 3rd Q Top of 4th Q Maximum HR Coach Pay Range Minimum Top of 1st Q Top of 2nd Q Midpoint Top of 3rd Q Top of 4th Q Maximum}

_{You will be adjusting your pay ranges to reflect the new community average pay rates for each job effective July 1. Your Vice President of Finance wants an estimate of the cost of making the necessary adjustments in pay for the last six months of the year. The company is on a semi-monthly pay system, and all employees work full time. Here is the list of your HR Assistants and their current rates of pay. For each employee, calculate the amount of pay increase to be applied, the amount of the increase per pay period, and the total amount of increase over the last 6 months of the year. If the current rate of pay is in the first quintile, apply 1.45%; if the current rate of pay is in the second quintile, apply 1%; if the current rate of pay is in the third quintile, apply .5%. If the current rate of pay is in the fourth or fifth quintile, no adjustment to pay will be made. Name Current Pay Amount of Increase $Amount of Increase per Pay Period $Amount of Increase for the 6 months Angela* $12.00 Betty $12.50 Charlie $12.25 Dottie $13.00 Eric $13.75 Frankie $14.75 Total Amount of Increase for the HR Assistants for the 6 months: *Angela will be starting work as of August 16th.}

_{Here is the list of your HR Coaches and their current rates of pay. For each employee, calculate the amount of pay increase to be applied, the amount of the increase per pay period, and the total amount of increase over the last 6 months of the year. If the current rate of pay is in the first quintile, apply 1.9%; if the current rate of pay is in the second quintile, apply 1%; if the current rate of pay is in the third quintile, apply .5%. If the current rate of pay is in the fourth or fifth quintile, no adjustment to pay will be made. Name Current Pay Amount of Increase $Amount of Increase per Pay Period $Amount of Increase for the 6 months Gerry 16.50 Hannah 17.50 Isaac 17.00 JoAnn 17.00 Kathy 18.00 Larry 18.00 Marilyn 20.00 Nancy 19.95 Owen 18.75 Patrick 18.00 Total Amount of Increase for the HR Coaches for the 6 months:}

_{The total amount that will be applied for the wage adjustments for all of these employees over the 6 months following the adjustment date is:}

_{The comparatio is used as a quick indicator of where an employees wage is within the pay range, and specifically in relation to the midpoint. A comparatio of 100 means that the employees wage is at the midpoint. For each of the employees in the company, calculate their individual comparatio using the updated salary ranges (the salary ranges after the salary survey data was considered and the ranges were updated). Name Current Pay Amount of Increase New Hourly Rate Comparatio Angela $12.00 Betty $12.50 Charlie $12.25 Dottie $13.00 Eric $13.75 Frankie $14.75}

_{Gerry 16.50 Hannah 17.50 Isaac 17.00 JoAnn 17.00 Kathy 18.00 Larry 18.00 Marilyn 20.00 Nancy 19.95 Owen 18.75 Patrick 18.00}

_{How many total employees are being paid at or above the midpoint of the salary range? ___________}