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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Business Analytics Data Questions!