Salesperson Total Sales ($) Average Performance Customer Years with Bonus Previous Years ($) Accounts Company 3,25,000.78 12,499.3452 124 14 Smith, Michael 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, Yi 31,733.59 672.9111 7 1 Thompson, Nicole 1,27,845.22 13,322.9713 17 3 Reformat the table to improve readability and to help the sales manager make her decisions regarding sales performance bonuses. Choose the correct table below. (i) Salesperson Average Performance 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 21987.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 (ii) Average Performance Customer Years with Total Sales ($) Bonus Previous Years ($) Accounts Company Salesperson Smith, Michael 325,001 12,499 124 14 Yu, Joe 13,678 240 9 7 Reeves, Bill 452,359 21,987 175 21 Hamilton, Joshua 87,424 7,643 28 3 Harper, Derek 87,654 1,250 21 4 234,091 Quinn, Dorothy D 14,568 48 Graves, Lorrie 379,402 27,981 121 12 Sun, Yi 31,734 673 7 1 Thompson, Nicole 127,845 13,323 17 3 (iv) Salesperson Average Performance Total Sales ($) Bonus Previous Years ($) Customer Years with Accounts Company 3,25,001 12,499.35 124.00 14.00 Smith, Michael Yu, Joe 13,678 239.94 9.00 7.00 Reeves, Bill 4,52,359 21,987.25 175.00 21.00 Hamilton, Joshua 87,424 7,642.90 28.00 3.00 Harper, Dere 87,654 1,250.14 21.00 4.00 Quinn, Dorothy 2,34,091 14,567.98 48.00 9.00 Graves, Lorrie 3,79,402 27,981.44 121.00 12.00 Sun, Yi 31,734 672.91 7.00 1.00 Thompson, Nicole 1,27,845 13,322.97 17.00 3.00 - Select your answer - Select your answer - Table (0) Table (ii) Table (iii) Table (iv)
