Excel assignment

profileKeer49
Sharma_e02_grader_hw_Raises.xlsx

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