This is one question Answer B, C, D & E please

You were hired as an Assistant Manager at a small company. Part of your responsibilities involves supervision of 5 data entry clerks. The company has initiated a merit pay program. Raises will be given based on performance evaluation scores of employees and the employee's current position in the pay range. A Merit Increase Guidesheet will be used to determine the percentage raise each employee will receive. You are to determine the percentage raise an employee in each pay quartile would receive based on his or her performance evaluation score. This is the merit guidesheet that will be used in this exercise. Companies actually create their own sheets, based on the percentage raises they want to give for their jobs and the budget they have to give raises, but this one is a representative example of the way raises are given based on the employee's current pay and performance evaluation score. Performance Evaluation Score Excellent Very Good Pay Quartile Average Poor Needs Improvement th (top) 5% 4% 13% 10% 0% 3rd 6% 5% 4% 0% 0% 2nd 7% 6% 5% % 14% 0% 1st 8% 7% 6% 5% 0% In this exercise, the pay range for the data entry clerk job is $8.00 to $13.00. The pay range is divided into four equal parts or quartiles as follows: 1st Quartile: $ 8.00 - $9.25 2nd Quartile: $ 9.26 - $10.50 3RD Quartile: $10.51 - $11.75 4th Quartile: $11:76 - $13.00 - On the merit guidesheet, it would look like this: Click Save and Submit to save and submit. Click Save All Answers to save all answers, Save All Answers Save and Submit On the merit guidesheet, it would look like this: Performance Evaluation Score Pay Quartile Excellent Very Good Average Needs Improvement Poor $11.76-13.00 5% 4% 3% 0% 10% $10.51-11.75 6% 5% 4% 0% 0% $ 9.26-10.50 7% 16% 5% 4% 0% % $ 8.00- 9.25 8% 8 7% 7% 6% 5% 5 0% Here is an example of how a raise would be determined: If you have a data entry clerk currently earning $9.50, they would be in the 2nd quartile of the pay range. According to the merit guidesheet above, if that data entry clerk received an Average on their performance evaluation, they would receive a 5% raise. For this exercise, the information on the data entry clerks is as follows: Data Entry Clerk Current Pay Performance Evaluation Score Very Good Clerk A $8.25 Clerk B $8.75 Average Clerk C $12.00 Excellent Clerk D $10.75 Needs Improvement Clerk E $9.75 Average Click Save and Submit to save and submit. Click Save Al Answers to save all answers. Save All Answers Save and Submit Performance Evaluation Score Pay Quartile Excellent Very Good Average Needs Improvement Poor $11.76-13.00 5% 4% 3% 0% 0% $10.51-11.75 6% 5% 4% 0% 0% $ 9.26-10.50 7% 7 6% 5% 4% 0% $ 8.00- 9.25 8% 7% 6% % 5% 10% Based on the information above, and the given merit pay guidesheet, determine what percentage increase each of the clerks would receive, and what their new pay will be. I've filled in Clerk A so you can see how it's done; you will click in the cells and fill in the information for Clerks B, C, D, E. Enter the number for the percentage increase and enter the new hourly pay as a dollar amount rounded to the nearest penny. Clerk: Percentage Increase: A 7% New Hourly Pay: $8.83 (rounded up to the nearest penny) B C D E Click Save and Submit to save and submit. Click Save All Answers to save all answers. Save All Answers Save and Submit