Excel assignment
Addresses
| Addresses | |||||||
| Name | StreetAddress | City | State | ZipCode | RevisedZip | Phone | RevisedPhone |
| Meda Rodate | 4215 Lupita Rd | Santa Fe | NM | 87505 - | 5055551812 | ||
| Christy Istas | 17324 Camino Dr | Santa Fe | NM | 87501 - | 5055554231 | ||
| Jason Niese | 1542E Abeja Ct | Santa Fe | NM | 87509 - | 5055557810 | ||
| Paul Medina | 1200 Three Trees Rd | Santa Fe | NM | 87508 - | 5055556110 | ||
| Juanita Gomez | 5 Park Rd | Santa Fe | NM | 87500 - | 5055552837 | ||
| Susan Brock | 923 Clark St | Santa Fe | NM | 87501 - | 5055555215 | ||
| Jay Groth | 622 E. High St | Santa Fe | NM | 87511 - | 5055558343 | ||
| Kate Munson | 4476 Wilson Blvd | Santa Fe | NM | 87513 - | 5055557421 |
Evaluations
| Confidential Internal Evaluations | |||||||||||
| Name | Title | Manager | Reliable | Innovation | Customer Service | Team Collaborator | Leadership Rank | Average | Raise | Scale | |
| Meda Rodate | Spa Manager | Yes | 3 | 4 | 5 | 4 | 4 | 5 = Far Exceeds Expectations | |||
| Christy Istas | Therapist | No | 3 | 3 | 3 | 4 | 4 = Exceeds Expectations | ||||
| Jason Niese | Massage Therapist | No | 4 | 3 | 4 | 4 | 3 = Meets Expectations | ||||
| Paul Medina | Coffee Shop Manager | Yes | 4 | 5 | 4 | 4 | 5 | 2 = Below Expectations | |||
| Juanita Gomez | Barista | No | 3 | 3 | 5 | 4 | 1 = Well Below Expectations | ||||
| Susan Brock | Gift Shop Manager | Yes | 4 | 3 | 3 | 3 | 3 | ||||
| Jay Groth | Sales Associate | No | 4 | 3 | 2 | 2 | |||||
| Kate Munson | Sales Associate | No | 2 | 4 | 4 | 3 | |||||
| Name | Manager Raise Recommendations and Notes | ||||||||||
| Meda Rodate | High Raise. Very high customer ratings on comment cards. Great at appeasing an upset customer. | ||||||||||
| Christy Istas | Standard Raise. Standard employee who works with the team well. | ||||||||||
| Jason Niese | Standard Raise. Fills in last minute for other employees and has a large satisfied client following. | ||||||||||
| Paul Medina | High Raise. Envisioned and lead a redesign of the Terra Cotta Brew that lead to increased sales. | ||||||||||
| Juanita Gomez | Standard Raise. Average employee who has a good rapport with the customers. | ||||||||||
| Susan Brock | Low Raise. Average manager who has had some challenging employees. | ||||||||||
| Jay Groth | Low Raise. Has received some customer complaints and seems reluctant to get along with other employees. | ||||||||||
| Kate Munson | Standard Raise. Good at her job. However, she misses work a lot and never fills in for others who need off. |
Payroll
| Today's Date | Net Payroll Increase | ||||||||||
| High Bonus | $ 750 | Average Raise % | |||||||||
| Low Deduct | $ 500 | ||||||||||
| Name | HireDate | JobTitle | Salary | Years Employed | Raise Recommend | Standard Raise % | High Bonus | Low Deduction | Raise Amt | Final % Increase | New Salary |
| Meda Rodate | 3/14/10 | Spa Manager | $ 61,500 | ||||||||
| Christy Istas | 8/12/09 | Therapist | $ 42,100 | ||||||||
| Jason Niese | 8/12/09 | Massage Therapist | $ 45,800 | ||||||||
| Paul Medina | 2/1/11 | Coffee Shop Manager | $ 35,000 | ||||||||
| Juanita Gomez | 9/30/07 | Barista | $ 26,900 | ||||||||
| Susan Brock | 5/15/10 | Gift Shop Manager | $ 37,200 | ||||||||
| Jay Groth | 3/16/07 | Sales Associate | $ 28,100 | ||||||||
| Kate Munson | 6/4/05 | Sales Associate | $ 28,700 | ||||||||
| Years Employed | Standard Raise % | ||||||||||
| 0 | 2.50% | ||||||||||
| 2 | 3.00% | ||||||||||
| 5 | 3.50% | ||||||||||
| 7 | 4.00% |
Documentation
| Create Date | By Whom | Description | Workbook Name |
| dd/mm/yyyy | Firstname Lastname | e02_grader_hw_Raises.xlsx | |
| Mod. Date | By Whom | Mod. Description | Last Version Backup Name : VERSION BACKUP NAME : Before modifying any worksheet, save the original workbook with the following name format: Original name_yyyymmdd |
| Create Date | Sheet Name | Creator | Purpose |