The hospital has announced merit increases. The amount of the raise is based on the evaluation...

 

Transcribed Image Text:

The hospital has announced merit increases. The amount of the raise is based on the evaluation score. Using the the employee information in the table below, calculate the new salary. Use formulas to insert the dollar amount in column D. Employee Toni LaTonya Lori Gloria Ted Current Hourly Rate Gregg Total hourly salaries $38.23 $32.54 $15.75 $16.22 $25.85 $30.22 Evaluation Score 5 3 2 5 3 4 New Salary Evaluation Score & Corresponding Amount of Raise Evaluation Score 5 4 3 2 Amount of Raise 5.0% 4.0% 2.5% 1.0% 0.0% 2. Based on the tables you created for each employee's new annual salary create a spreadsheet showing each employee's monthly salary for each of the 12 months of the fiscal year. Use cell references and/or formulas to calculate. The hospital has announced merit increases. The amount of the raise is based on the evaluation score. Using the the employee information in the table below, calculate the new salary. Use formulas to insert the dollar amount in column D. Employee Toni LaTonya Lori Gloria Ted Current Hourly Rate Gregg Total hourly salaries $38.23 $32.54 $15.75 $16.22 $25.85 $30.22 Evaluation Score 5 3 2 5 3 4 New Salary Evaluation Score & Corresponding Amount of Raise Evaluation Score 5 4 3 2 Amount of Raise 5.0% 4.0% 2.5% 1.0% 0.0% 2. Based on the tables you created for each employee's new annual salary create a spreadsheet showing each employee's monthly salary for each of the 12 months of the fiscal year. Use cell references and/or formulas to calculate.

Answer rating: 100% (QA)

To calculate the new salary based on the evaluation score you can use the following formulas For Ton... View the full answer