Business Analytics Help !

profileDeMario34
McDonald_Excel_BU02_Assessment2_Raises.xlsx

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 4 High 5 = Far Exceeds Expectations
Christy Istas Therapist No 3 3 3 4 3.25 Standard 4 = Exceeds Expectations
Jason Niese Massage Therapist No 4 3 4 4 3.75 Standard 3 = Meets Expectations
Paul Medina Coffee Shop Manager Yes 4 5 4 4 5 4.4 High 2 = Below Expectations
Juanita Gomez Barista No 3 3 5 4 3.75 Standard 1 = Well Below Expectations
Susan Brock Gift Shop Manager Yes 4 3 3 3 3 3.2 Low
Jay Groth Sales Associate No 4 3 2 2 2.75 Low
Kate Munson Sales Associate No 2 4 4 3 3.25 Standard
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.

&F

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 $ 71,500 $ - 0
Christy Istas 8/12/09 Therapist $ 42,100 $ - 0
Jason Niese 8/12/09 Massage Therapist $ 45,800 $ - 0
Paul Medina 2/1/11 Coffee Shop Manager $ 35,000 $ - 0
Juanita Gomez 9/30/07 Barista $ 29,900 $ - 0
Susan Brock 5/15/10 Gift Shop Manager $ 37,200 $ - 0
Jay Groth 3/16/07 Sales Associate $ 28,100 $ - 0
Kate Munson 6/4/05 Sales Associate $ 28,700 $ - 0
Years Employed Standard Raise %
0 2.50%
2 3.00%
5 3.50%
7 4.00%
Raise Count
High
Standard
Low
Raise Amount Total
High
Standard
Low