Question: 1. Sales Performance Bonuses. A sales manager is trying to determine appropriate sales performance bonuses for her team this year. The following table contains the
1. Sales Performance Bonuses. A sales manager is trying to determine appropriate sales performance bonuses for her team this year. The following table contains the data relevant to determining the bonuses, but it is not easy to read and interpret. Reformat the table to improve readability and to help the sales manager make her decisions about bonuses.

Average Performance Total Sales Bonus Previous Customer Years with Salesperson ($) Years ($) Accounts Company Smith, Michael 325,000.78 12,499.3452 124 14 Yu, Joe 13,678.21 239.9434 9 7 Reeves, Bill 452,359.19 21,987.2462 175 21 Hamilton, Joshua 87,423.91 7,642.9011 28 3 Harper, Derek 87,654.21 1,250.1393 21 4 Quinn, Dorothy 234,091.39 14,567.9833 48 9 Graves, Lorrie 379,401.94 27,981.4432 121 12 Sun, Yi 31,733.59 672.9111 7 1 Thompson, Nicole 127,845.22 13,322.9713 17 3
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
