X A sales manager is trying to determine appropriate sales performance bonuses for her team this year. The table below contains the data relevant to determining sales performance bonuses, however, it is not easy to read and interpret Click on the datafile logo to reference the data DATA file A ...... 124 Salesperson Total Sales ($) Average Performance Customer Years with Bonus Previous Years (S) Accounts Company Smith, Michael 3,25,000.78 12,499.3452 14 Yu, Joe 13,678.21 239.9434 9 7 Reeves, Bill 4,52,359.19 21987.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 2,34,091,39 14,567.9833 48 9 Graves, Lorrie 3,79,401.94 27,981.4432 121 12 Sun, Y 31,733.59 672.9111 > Thompson, Nicole 1,27,145.22 13,322.9713 12 n Reformat the table to improve readability and to help the sales manager make her decisions regarding sales performance bonuses. Choose the correct table below (1) Average Performance Salesperson Total Sales ($) Bonus Previous Years ($) Customer Years with Accounts Company Smith, Michael 3,25,000.78 12,499.35 124.00 14.00 Yu, Joe 13,678.21 239.94 9.00 7.00 Reeves, Bill 4,52,359.19 21957.25 175.00 21.00 Hamilton, Joshua 87,423.91 7.642.90 28.00 3.00 Harper, Derek 87,654.21 1250.14 21.00 4.00 Quinn, Dorothy 2,34,091.39 14,567.98 48.00 9.00 Graves, Lorrie 3,79,401.94 27981.44 121.00 12.00 Sun, YI 31,733.59 672.91 7.00 1.00 Thompson, Nicole 1,27,845.22 13,322.97 17.00 3.00 (W) Salesperson Smith, Michael Yu, Joe Reeves, Bill Average Performance Customer Years with Total Sales (5) Bonus Previous Years ($) Accounts Company 325,001 12,499 124 14 13,678 240 9 7 452,359 21.987 175 21 87.424 7,643 28 3 87.654 1,250 21 4 234,091 14,568 48 9 Hamilton, Joshua Harper, Derek Quinn, Dorothy Graves, Lomne 379,402 27,981 121 12 Sun, Y 31,734 673 7 1 Thompson, Nicole 127,845 13,323 17 (III) 21 Salesperson Total Sales ($) Average Performance Customer Years with Bonus Previous Years ($) Accounts Company Smith, Michael 3,25,000.78 12,499.3452 124 14 Yu, Joe 13,678.21 239.9434 7 Reeves, Bill 4,52,359.19 21,987.2462 175 Hamilton, Joshua 87,423.91 7,642.9011 28 3 Harper, Derek 87,654.21 1,250.1393 21 Quinn, Dorothy 2,34,091.39 14,567.9833 48 Graves, Lorrie 3,79,401.94 27,981.4432 121 12 Sun, Y 31,733.59 672.9111 7 Thompson, Nicole 1,27,845.22 13,322.9713 17 4 9 1 3 (iv) Salesperson Average Performance Total Sales ($) Bonus Previous Years ($) Customer Years with Accounts Company 3,25,001 12,499.35 Smith, Michael Yu, Joe 124.00 14.00 13,678 239.94 9.00 7.00 Reeves, Bill 4,52,359 21,987.25 175.00 21.00 87,424 7,642.90 28.00 Hamilton, Joshua Harper, Derek 3.00 87,654 1,250.14 21.00 4.00 2,34,091 14,567.98 48.00 9.00 Quinn, Dorothy Graves, Lorrie 3,79,402 27,981.44 121.00 12.00 Sun, Yi 672.91 7.00 1.00 31,734 1,27,845 Thompson, Nicole 13,322.97 17.00 3.00 Table (ii)
