Observation
shawezdk8
PayforPerformanceData.xlsxSheet1
| Employee | Employee # | Wage Rate | Annual $ | Total Appraisal | Knowledge | Initiative | Teamwork | Quality | Quantity | Customer Svc | Compa-ratio | Average Score |
| Chaney, Ronald | 12 | $ 15.25 | $ 31,720.00 | 3.8 | 3 | 4 | 3.5 | 4 | 4 | 4 | $0.68 | 3.8 |
| Soto, Sandra | 11 | $ 15.50 | $ 32,240.00 | 3.6 | 3.5 | 3 | 4 | 4 | 3.5 | 3.5 | $0.69 | 3.6 |
| Bush, Gary | 10 | $ 16.25 | $ 33,800.00 | 2.7 | 3 | 2 | 3 | 3 | 2 | 3 | $0.72 | 2.7 |
| Clinton, Marilyn | 9 | $ 16.00 | $ 33,280.00 | 2.8 | 3 | 3 | 2 | 3 | 3 | 3 | $0.71 | 2.8 |
| Perry, Rhonda | 8 | $ 16.50 | $ 34,320.00 | 3.5 | 4 | 3.5 | 4 | 3.5 | 3 | 3 | $0.73 | 3.5 |
| Gibson, Christine | 7 | $ 16.75 | $ 34,840.00 | 3.6 | 4 | 3.5 | 4 | 3.5 | 3 | 3.5 | $0.74 | 3.6 |
| Ahmed, Janel | 6 | $ 17.00 | $ 35,360.00 | 3.8 | 3 | 4 | 3 | 4 | 4 | 5 | $0.76 | 3.8 |
| Lozano, Tina | 5 | $ 17.25 | $ 35,880.00 | 4.3 | 5 | 4.5 | 4.5 | 4 | 3.5 | 4 | $0.77 | 4.3 |
| Porter, Henry | 4 | $ 17.50 | $ 36,400.00 | 3.4 | 4 | 4 | 3 | 3 | 3.5 | 3 | $0.78 | 3.4 |
| Blanco, Maria | 3 | $ 14.75 | $ 30,680.00 | 2.7 | 3 | 3 | 2 | 2 | 3 | 3 | $0.66 | 2.7 |
| Linares, Patricia | 2 | $ 18.00 | $ 37,440.00 | 3.2 | 3.5 | 3 | 3.5 | 3 | 3 | 3 | $0.80 | 3.2 |
| Elsbery, Christine | 1 | $ 18.50 | $ 38,480.00 | 3.0 | 3 | 3 | 3 | 3 | 3 | 3 | $0.82 | 3.0 |
| 3.29 | 3.55 | 3.35 | 3.2 | 3.2 | 3.1 | 3.35 | ||||||
| 5 = Excellent | ||||||||||||
| 4 = Outstanding | ||||||||||||
| Total Salary | $414,440.00 | 3 = Meets Standards | Minimum | $15.00/hr | $31,200 | |||||||
| Budget for Increases | $12,433.20 | 2 = Needs Improvement | Midpoint | $22.50/hr | $46,800 | |||||||
| 1 = Poor | Maximum | $30.00/hr | $62,400 | |||||||||
| Annual $ | Average Score | |||||||||||
| $ 31,720.00 | 3.75 | |||||||||||
| $ 32,240.00 | 3.58 | |||||||||||
| $ 33,800.00 | 2.67 | |||||||||||
| $ 33,280.00 | 2.83 | |||||||||||
| $ 34,320.00 | 3.5 | |||||||||||
| $ 34,840.00 | 3.58 | |||||||||||
| $ 35,360.00 | 3.83 | |||||||||||
| $ 35,880.00 | 4.25 | |||||||||||
| $ 36,400.00 | 3.42 | |||||||||||
| $ 30,680.00 | 2.67 | |||||||||||
| $ 37,440.00 | 3.17 | |||||||||||
| $ 38,480.00 | 3 | |||||||||||
Annual $ vs. Average Score Before Increases
Average Score 35880 35360 31720 32240 34840 34320 36400 37440 38480 33280 33800 30680 4.25 3.83 3.75 3.58 3.58 3.5 3.42 3.17 3 2.83 2.67 2.67Annual Salary (in USD)
Average Score
Sheet3
| Employee | Annual $ | Average Score | Annual $ | New Salary Total | % raise | |||
| Lozano, Tina | $35,880.00 | 4.3 | $35,880.00 | $37,674.00 | 5% | |||
| Ahmed, Janel | $35,360.00 | 3.8 | $35,360.00 | $36,420.80 | 3% | $1,060.80 | ||
| Chaney, Ronald | $31,720.00 | 3.8 | $31,720.00 | $33,207.20 | 3% | |||
| Soto, Sandra | $32,240.00 | 3.6 | $32,240.00 | $35,885.20 | 3% | |||
| Gibson, Christine | $34,840.00 | 3.6 | $34,840.00 | $35,885.20 | 3% | |||
| Perry, Rhonda | $34,320.00 | 3.5 | $34,320.00 | $35,349.60 | 3% | |||
| Porter, Henry | $36,400.00 | 3.4 | $36,400.00 | $37,128.00 | 2% | 75% will get a raise | ||
| Linares, Patricia | $37,440.00 | 3.2 | $37,440.00 | $38,188.80 | 2% | |||
| Elsbery, Christine | $38,480.00 | 3.0 | $38,480.00 | $39,249.60 | 2% | |||
| Clinton, Marilyn | $33,280.00 | 2.8 | $33,280.00 | $33,280.00 | 0% | |||
| Bush, Gary | $33,800.00 | 2.7 | $33,800.00 | $33,800.00 | 0% | |||
| Blanco, Maria | $30,680.00 | 2.7 | $30,680.00 | $30,680.00 | 0% | |||
| $414,440.00 | $426,748.40 | $12,308.40 | total cost | |||||
| Available | $12,433.20 | |||||||
| 8.4 | Remaining Budget | $124.80 | ||||||
Annual Salary vs Average Score
Average Score 35880 35360 31720 32240 34840 34320 36400 37440 38480 33280 33800 30680 4.25 3.83 3.75 3.58 3.58 3.5 3.42 3.17 3 2.83 2.67 2.67Annual Salary
Average Score
Sheet2
| Employee | Employee # | Wage Rate | Annual $ | Total Appraisal | Knowledge | Initiative | Teamwork | Quality | Quantity | Customer Svc | Compa-ratio |
| Bush, Gary | 10 | 16.25 | $33,800.00 | 2.7 | 3 | 2 | 3 | 3 | 2 | 3 | 0.7 |
| Blanco, Maria | 3 | 14.75 | $30,680.00 | 2.7 | 3 | 3 | 2 | 2 | 3 | 3 | 0.7 |
| Clinton, Marilyn | 9 | 16 | $33,280.00 | 2.8 | 3 | 3 | 2 | 3 | 3 | 3 | 0.7 |
| Elsbery, Christine | 1 | 18.5 | $38,480.00 | 3.0 | 3 | 3 | 3 | 3 | 3 | 3 | 0.8 |
| Linares, Patricia | 2 | 18 | $37,440.00 | 3.2 | 3.5 | 3 | 3.5 | 3 | 3 | 3 | 0.8 |
| Porter, Henry | 4 | 17.5 | $36,400.00 | 3.4 | 4 | 4 | 3 | 3 | 3.5 | 3 | 0.8 |
| Perry, Rhonda | 8 | 16.5 | $34,320.00 | 3.5 | 4 | 3.5 | 4 | 3.5 | 3 | 3 | 0.7 |
| Soto, Sandra | 11 | 15.5 | $32,240.00 | 3.6 | 3.5 | 3 | 4 | 4 | 3.5 | 3.5 | 0.7 |
| Gibson, Christine | 7 | 16.75 | $34,840.00 | 3.6 | 4 | 3.5 | 4 | 3.5 | 3 | 3.5 | 0.7 |
| Chaney, Ronald | 12 | 15.25 | $31,720.00 | 3.8 | 3 | 4 | 3.5 | 4 | 4 | 4 | 0.7 |
| Ahmed, Janel | 6 | 17 | $35,360.00 | 3.8 | 3 | 4 | 3 | 4 | 4 | 5 | 0.8 |
| Lozano, Tina | 5 | 17.25 | $35,880.00 | 4.3 | 5 | 4.5 | 4.5 | 4 | 3.5 | 4 | 0.8 |
Sheet4
| Employees | Original Annual Salary | New Annual Salary | |
| Lozano, Tina | $35,880.00 | $37,674.00 | |
| Ahmed, Janel | $35,360.00 | $36,420.80 | |
| Chaney, Ronald | $31,720.00 | $33,207.20 | |
| Soto, Sandra | $32,240.00 | $35,885.20 | |
| Gibson, Christine | $34,840.00 | $35,885.20 | |
| Perry, Rhonda | $34,320.00 | $35,349.60 | |
| Porter, Henry | $36,400.00 | $37,128.00 | |
| Linares, Patricia | $37,440.00 | $38,188.80 | |
| Elsbery, Christine | $38,480.00 | $39,249.60 | |
| Clinton, Marilyn | $33,280.00 | $33,280.00 | |
| Bush, Gary | $33,800.00 | $33,800.00 | |
| Blanco, Maria | $30,680.00 | $30,680.00 |
