# Homework Solution: A sales manager is trying to determine appropriate sales performance bonuses for her t…

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.
 Salesperson Total Sales (\$) Average Performance Bonus Previous Years (\$) Customer Accounts Years with Company Smith, Michael 3,25,000.78 12,499.3452 124 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, 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 Total Sales (\$) Average Performance Bonus Previous Years (\$) Customer Accounts Years with 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)
 Salesperson Total Sales (\$) Average Performance Bonus Previous Years (\$) Customer Accounts Years with Company 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 Quinn, Dorothy 234,091 14,568 48 9 Graves, Lorrie 379,402 27,981 121 12 Sun, Yi 31,734 673 7 1 Thompson, Nicole 127,845 13,323 17 3
(iii)
 Salesperson Total Sales (\$) Average Performance Bonus Previous Years (\$) Customer Accounts Years with Company Smith, Michael 3,25,000.78 12,499.3452 124 14 Yu, Joe 13,678.21 239.9434 9 7 Reeves, Bill 4,52,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 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
(iv)
 Salesperson Total Sales (\$) Average Performance Bonus Previous Years (\$) Customer Accounts Years with Company Smith, Michael 3,25,001 12,499.35 124.00 14.00 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, Derek 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

A sales overseer is intricate to particularize embezzle sales enterprise bonuses ce her team this year. The consideration adown contains the axioms appropriate to determining sales enterprise bonuses, so-far, it is referable unconcerned to unravel and expone.

Click on the axiomsfile logo to allusion the axioms.

Salesperson Total Sales (\$) Average Enterprise
Bonus Previous Years (\$)
Customer
Accounts
Years with
Company
Smith, Michael 3,25,000.78 12,499.3452 124 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, Yi 31,733.59 672.9111 7 1 Thompson, Nicole 1,27,845.22 13,322.9713 17 3

Reformat the consideration to emend unravelability and to succor the sales overseer produce her decisions touching sales enterprise bonuses. Choose the amend consideration adown.

(i) Salesperson Total Sales (\$) Average Enterprise
Bonus Previous Years (\$)
Customer
Accounts
Years with
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) Salesperson Total Sales (\$) Average Enterprise
Bonus Previous Years (\$)
Customer
Accounts
Years with
Company
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 Quinn, Dorothy 234,091 14,568 48 9 Graves, Lorrie 379,402 27,981 121 12 Sun, Yi 31,734 673 7 1 Thompson, Nicole 127,845 13,323 17 3 (iii) Salesperson Total Sales (\$) Average Enterprise
Bonus Previous Years (\$)
Customer
Accounts
Years with
Company
Smith, Michael 3,25,000.78 12,499.3452 124 14 Yu, Joe 13,678.21 239.9434 9 7 Reeves, Bill 4,52,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 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 (iv) Salesperson Total Sales (\$) Average Enterprise
Bonus Previous Years (\$)
Customer
Accounts
Years with
Company
Smith, Michael 3,25,001 12,499.35 124.00 14.00 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, Derek 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