On the Payroll worksheet, in cell K6, add a calculation that returns the Final % Increase by dividing the Raise Amt by the Salary. Copy the formula through cell K13. In cell L6, add a calculation that returns the New Salary by adding the Salary and Raise Amt. Copy the formula through cell L13. fx =IF(F6="low"$F$3,0) A 8 c D E G H Painted Paradise Today's Date High Bonus Low Deduct $ $ 2/26/21 750 500 Net Payroll Increase Average Raise % MELHORT SPA + Nome Meda Rodate Christy istas Jason Niese Paul Medina Juanita Gomes 1Susan Brock 2 lay Groth Kate Munson Hire Date Job Title 3/14/10 Spa Manager 8/12/09 Therapist 8/12/09 Massage Therapist 2011 Coffee Shop Manager 3/30/02 Barista 52150 Gift Shop Manager 371602 Sales Associate 6/4/05 Sales Associate Years Salary Employed $ 21 500 10 $ 42.100 11 $ 45,800 11 $ 35,000 10 529.900 537200 $28,100 13 $20.700 15 Ralse Recommend High Standard Standard High Standard Low Lo Standard Standard Raise Low Final New X High Bonus Deduction Raise Amt Increase Salary 4.00% 750 S $ 3,610 4.00% s $1,684 4.00% - $ 1,832 4.00% 750S $ 2,150 4.00% S $ 1195 4.00 $ 500S 4.00 $ S 500 IS 624 4.00%S $ $1,148 elle 988 15 Years Employed 16 0 17 2 18 5 19 2 20 21 Ralse 22 High 23 24 Standard Raise 2.50N 300% 3.50 400 Count Total 3 Rase Ant 22 High 23 Standard 23 LOW 31 12 13 Xfx =IF(C3="Yes", AVERAGE(D3:43),AVERAGE(D3:G3)) A B C D 6 M H 1 Confidential Internal Evaluations Team Collaborator Leadership Innovation Customer Service 5 3 4 4 Title Spa Marae Therapist Massar. There Coffee Shop Mane Barista OUR Shop Manager sales Andate Sales Asociate Manager Reliable Ves 3 No Ne 4 Yes 4 NO 3 res 4 NO 4 NO 3 5 3 4 2 Name Meda Rodate 4. Christy stas 5ason Nies 6. Pad Media 7. Danita Gomet Susan ved lay Groth 30 Kate Muro 11 12 Name Meda Rodate 14 City 15 New 15 Pad Media 17 Tarita Gomes Scale 5-Far Exceeds Expectations 4ces Expectations 2. Meets Expectations Below Expectations Well below Expectations 5 Average Rase hash 125 Standard 3.75 Standard 4,4 ch 3.75 Standard 3.2 low 2.75 Low 3.25 Standard 4 4 4 4 3 2 3 3 5 3 2 4 3 4 Manager Rase Recommendations and Notes sche Very high atomeration comment cards. Great Income Standard Role Standard employee who works with the team standard Raisin last minute to other employees and has a large satisfied dient following Pogh Rise Envisioned and leada rade of the Terracotta Brew that lead to increased sales Standard R. Avere lyte who hasargod raport with the customer Low Bal. A who Nas Nd som daging moves Low Rise Hareived some time complints and meant to retain with them standard Rood ther. However the work a lot and never sin brothers who medoff 10 ly Goth 30 Mo 2
