Using the MS Excel file attached above ( Merit Pay Worksheet ), calculate and co

Question

Using the MS Excel file attached above ( Merit Pay Worksheet), calculate and complete.

I just need the last three that are blank. All the others are clearly worked.

Merit Increase Grid Performance Rating Exceeds Expectations Above Expectations Meets Expectations Below Expectations Immediate Improvement Needed 80%-90% 8.0% 6.0% 4.0% 2.0% 0.0% Compa-Ratio 91%-110% 5.0% 4.0% 3.0% 0.0% 0.0% 111%-120% 2.0% 2.0% 0.0% 0.0% 0.0% Overall Performance Ratings are based on a Graphical Rating Scale. 5 - Exceeds Expectations 4 Above Expectations 3 Meets Expectations 2 Below Expectation 1 Immediate Improvement Needed

Explanation / Answer

A P Mi Ma S =( Mi+Ma)/2 C= A/S From merit grid : C and P Emp Job Annual Salary Perf rating Min Max Sal Range mid Compa ratio Salary inc % Patty Receptionist 26699 2 25556 34556 30056 89% 2% Phil Office Manager 72988 3 56756 70680 63718 115% 0% Robin Payroll Administrator 69247 1 56551 68551 62551 111% 0% Xavier Control 105473 4 85521 103125 94323 112% 4%

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.