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. DATA file
    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

    Expert Answer

    A sales director is reserved to designate divert sales work bonuses restraint her team this year. The consultation adown contains the postulates appropriate to determining sales work bonuses, still, it is referable gentle to discover and render.

    Click on the postulatesfile logo to regard the postulates.

    DATA file

    Salesperson Total Sales ($) Average Work
    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 consultation to amend discoverability and to acceleration the sales director bring-about her decisions respecting sales work bonuses. Choose the emend consultation adown.

    (i) Salesperson Total Sales ($) Average Work
    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 Work
    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 Work
    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 Work
    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

    Expert Confutation