N 0 P . Current XYZ Corporation Employee Table 2018 Bonus Options Quality Efficiency Rating Option 1 Option 2 Option 3 Option 4 Effectiveness Rating 83 Option 5 Option 6 XOOX xox 60 XXX xxx Leslie 65 94 85 65 98 xxx 64 88 6871 84 96 88 70 66 60 XXX xxx xxx xxx XXX XXX XXX XXX 63 XXX XXX XXX XXX XXX 77 First Name Gender Gary F Steve M Cynthia F Gwen M Jean F Cynthia M Kevin M Annette F Barbara F Linda M Megan F Oronzo F Cindy F Maylou | Harold F Laura M Kathy F Wendy F Kordell M Shelly F Crystal Hilary M Betty F Hank F Emit F Lorna M Ashley Julianne M Fran F Lynn Nancy | Holly F Meredith XXX XXX 99 XXX Employee ID Last Name 10000 Aikman 10166 Fisher 10387 Felser 10398 Parsley 10552 Leslie 10640 Imber 10710 Granger 10785 Dunes 10936 Cusak 11048 Noble 11290 Heatley 11309 Bobbitt 11390 Lobree 11447 Sampieri 11493 Crowder 11674 Beamer 11828 Powell 11935 Mills 12080 Cole 12182 Foerster 12276 Cole 12378 Girard 12392 Guilford 12524 Drubin 12549 Wood 12593 Spinale 12797 Bryan 12955 Posten 12961 Watson 13153 Pennekamp 13183 Fegin 13423 Everett 13638 Erpf 13694 White 13703 Jones 13823 Magenheimer 13949 Jackson 14196 Hood 14426 Moss 14518 Walker 14547 Bichette 14548 Eastcott 14696 Bocholis 14752 Vergaldi 14997 Ray M Title Account Rep Senior Account Rep Account Rep Manager Account Rep Senior Account Rep Trainee Senior Account Rep Account Rep Account Rep Senior Account Rep Account Rep Account Rep Account Rep Trainee Trainee Account Rep Manager Account Rep Account Rep Trainee Account Rep Account Rep Account Rep Senior Account Rep Account Rep Manager Trainee Account Rep Account Rep Account Rep Senior Account Rep Account Rep Account Rep Account Rep Trainee Account Rep Account Rep Account Rep Senior Account Rep Senior Account Rep Trainee Senior Account Rep Trainee Senior Account Rep Salary $87,889 $79,122 $51,818 $62,329 $65,447 $56,159 $21,222 $20,551 $26,038 $83,4071 $74,362 $55,039 $83,089 $85,113 $74,421 $22,469 $40,040 $50,892 $27,522 $30,676 $30,079 $67,781 $46,572 $65,046 $53,346 $47,567 $80,109 $71,359 $70,104 $87,083 $74,997 $67,496 $83,157 $59,529 $54,654 $35,757 $88,951 $81,251 $39,895 $87,488 $66,891 $59,564 $85,686 $86,607 $58,484 97 xxx xxx Xxx XXX F SIIS F Jack F Maryanne Ana Marie Heidi 62 Joan IF XXX XXX XXX Lance Denie John Crystal Wendy Deborah Arianne XXX M F F M F M xxx xxx XXX xxx xoxox xxx xxx XXX Bonus Option 1 If the rating on Quality is above 90 then the employee receives a bonus of $7,500. Otherwise, the employee does not receive any bonus (zero dollars). Bonus Option 2 If the rating on Effectiveness is above 90 and the rating on Efficiency is above 85, then the employee receives a bonus of $5,000. Otherwise, the employee does not receive any bonus (zero dollars). Bonus Option 3 If at least two of the three ratings are above 90, then the employee receives a $15,000 bonus. Otherwise, the employee does not receive any bonus (zero dollars). Bonus Option 4 If the ratings on Efficiency and Quality are both above 85, then the employee receives a bonus of $6,000. Otherwise, if the rating on Efficency is above 95 and the rating on Quality is above 90, then the employee receives a bonus of $4,500. Otherwise, the employee does not receive any bonus (zero dollars). Bonus Option 5 If all three ratings are 90 or above, then the employee receives a bonus of 20% of their base salary. Otherwise, if all three ratings are 85 or above then the employee receives a bonus equal to 10% of their base salary. Otherwise, the employee does not receive any bonus (zero dollars). Bonus Option 6 If all three ratings are above 90, then the employee receives a bonus equal to 25% of her base salary. Otherwise, If at least one of the ratings is above 85 and none of the ratings are below 70, then the employee receives a bonus equal to 12% of their base salary. Otherwise, if all three ratings are 80 or above then the employee receives a bonus equal to 5% of their base salary. Otherwise, if at least one of the ratings is above 80, then the employee receives a bonus equal to 2.5% of their base salary. Otherwise, the employee does not receive any bonus (zero dollars). Complete the following table by entering the appropriate formula in cells T40:145. Percentage of Employees Receiving a Bonus Under Each Option Bonus Option 1 1 point Bonus Option 2 XXX Bonus Option 3 XXX Bonus Option 4 Bonus Option 5 XXX Bonus Option 6 XXX XXX N 0 P . Current XYZ Corporation Employee Table 2018 Bonus Options Quality Efficiency Rating Option 1 Option 2 Option 3 Option 4 Effectiveness Rating 83 Option 5 Option 6 XOOX xox 60 XXX xxx Leslie 65 94 85 65 98 xxx 64 88 6871 84 96 88 70 66 60 XXX xxx xxx xxx XXX XXX XXX XXX 63 XXX XXX XXX XXX XXX 77 First Name Gender Gary F Steve M Cynthia F Gwen M Jean F Cynthia M Kevin M Annette F Barbara F Linda M Megan F Oronzo F Cindy F Maylou | Harold F Laura M Kathy F Wendy F Kordell M Shelly F Crystal Hilary M Betty F Hank F Emit F Lorna M Ashley Julianne M Fran F Lynn Nancy | Holly F Meredith XXX XXX 99 XXX Employee ID Last Name 10000 Aikman 10166 Fisher 10387 Felser 10398 Parsley 10552 Leslie 10640 Imber 10710 Granger 10785 Dunes 10936 Cusak 11048 Noble 11290 Heatley 11309 Bobbitt 11390 Lobree 11447 Sampieri 11493 Crowder 11674 Beamer 11828 Powell 11935 Mills 12080 Cole 12182 Foerster 12276 Cole 12378 Girard 12392 Guilford 12524 Drubin 12549 Wood 12593 Spinale 12797 Bryan 12955 Posten 12961 Watson 13153 Pennekamp 13183 Fegin 13423 Everett 13638 Erpf 13694 White 13703 Jones 13823 Magenheimer 13949 Jackson 14196 Hood 14426 Moss 14518 Walker 14547 Bichette 14548 Eastcott 14696 Bocholis 14752 Vergaldi 14997 Ray M Title Account Rep Senior Account Rep Account Rep Manager Account Rep Senior Account Rep Trainee Senior Account Rep Account Rep Account Rep Senior Account Rep Account Rep Account Rep Account Rep Trainee Trainee Account Rep Manager Account Rep Account Rep Trainee Account Rep Account Rep Account Rep Senior Account Rep Account Rep Manager Trainee Account Rep Account Rep Account Rep Senior Account Rep Account Rep Account Rep Account Rep Trainee Account Rep Account Rep Account Rep Senior Account Rep Senior Account Rep Trainee Senior Account Rep Trainee Senior Account Rep Salary $87,889 $79,122 $51,818 $62,329 $65,447 $56,159 $21,222 $20,551 $26,038 $83,4071 $74,362 $55,039 $83,089 $85,113 $74,421 $22,469 $40,040 $50,892 $27,522 $30,676 $30,079 $67,781 $46,572 $65,046 $53,346 $47,567 $80,109 $71,359 $70,104 $87,083 $74,997 $67,496 $83,157 $59,529 $54,654 $35,757 $88,951 $81,251 $39,895 $87,488 $66,891 $59,564 $85,686 $86,607 $58,484 97 xxx xxx Xxx XXX F SIIS F Jack F Maryanne Ana Marie Heidi 62 Joan IF XXX XXX XXX Lance Denie John Crystal Wendy Deborah Arianne XXX M F F M F M xxx xxx XXX xxx xoxox xxx xxx XXX Bonus Option 1 If the rating on Quality is above 90 then the employee receives a bonus of $7,500. Otherwise, the employee does not receive any bonus (zero dollars). Bonus Option 2 If the rating on Effectiveness is above 90 and the rating on Efficiency is above 85, then the employee receives a bonus of $5,000. Otherwise, the employee does not receive any bonus (zero dollars). Bonus Option 3 If at least two of the three ratings are above 90, then the employee receives a $15,000 bonus. Otherwise, the employee does not receive any bonus (zero dollars). Bonus Option 4 If the ratings on Efficiency and Quality are both above 85, then the employee receives a bonus of $6,000. Otherwise, if the rating on Efficency is above 95 and the rating on Quality is above 90, then the employee receives a bonus of $4,500. Otherwise, the employee does not receive any bonus (zero dollars). Bonus Option 5 If all three ratings are 90 or above, then the employee receives a bonus of 20% of their base salary. Otherwise, if all three ratings are 85 or above then the employee receives a bonus equal to 10% of their base salary. Otherwise, the employee does not receive any bonus (zero dollars). Bonus Option 6 If all three ratings are above 90, then the employee receives a bonus equal to 25% of her base salary. Otherwise, If at least one of the ratings is above 85 and none of the ratings are below 70, then the employee receives a bonus equal to 12% of their base salary. Otherwise, if all three ratings are 80 or above then the employee receives a bonus equal to 5% of their base salary. Otherwise, if at least one of the ratings is above 80, then the employee receives a bonus equal to 2.5% of their base salary. Otherwise, the employee does not receive any bonus (zero dollars). Complete the following table by entering the appropriate formula in cells T40:145. Percentage of Employees Receiving a Bonus Under Each Option Bonus Option 1 1 point Bonus Option 2 XXX Bonus Option 3 XXX Bonus Option 4 Bonus Option 5 XXX Bonus Option 6 XXX XXX
