Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.
Salesperson Total
Sales ($) Average Performance Bonus
Previous Years ($) Customer
Accounts Years with
Company
Smith, Michael 325000.7812499.345212414
Yu, Joe 13678.21239.943497
Reeves, Bill 452359.1921987.246217521
Hamilton, Joshua 87423.917642.9011283
Harper, Derek 87654.211250.1393214
Quinn, Dorothy 234091.3914567.9833489
Graves, Lorrie 379401.9427981.443212112
Sun, Yi 31733.59672.911171
Thompson, Nicole 127845.2213322.9713173
Reformat the table to improve readability and to help the sales manager make her decisions about bonuses. (Choose the correct table.)
Salesperson Total
Sales ($) Average Performance
Bonus Previous
Years ($) Customer
Accounts Years with
Company
Smith, Michael 325,000.7812,499.345212414
Yu, Joe 13,678.21239.943497
Reeves, Bill 452,359.1921,987.246217521
Hamilton, Joshua 87,423.917,642.9011283
Harper, Derek 87,654.211,250.1393214
Quinn, Dorothy 234,091.3914,567.9833489
Graves, Lorrie 379,401.9427,981.443212112
Sun, Yi 31,733.59672.911171
Thompson, Nicole 127,845.2213,322.9713173
Salesperson Total
Sales ($) Average Performance
Bonus Previous
Years ($) Customer
Accounts Years with
Company
Smith, Michael 325,00112,49912414
Yu, Joe 13,67824097
Reeves, Bill 452,35921,98717521
Hamilton, Joshua 87,4247,643283
Harper, Derek 87,6541,250214
Quinn, Dorothy 234,09114,568489
Graves, Lorrie 379,40227,98112112
Sun, Yi 31,73467371
Thompson, Nicole 127,84513,323173
Salesperson Total
Sales ($) Average Performance
Bonus Previous
Years ($) Customer
Accounts Years with
Company
Smith, Michael 325000.7812499.3452124.0014.00
Yu, Joe 13678.21239.94349.007.00
Reeves, Bill 452359.1921987.2462175.0021.00
Hamilton, Joshua 87423.917642.901128.003.00
Harper, Derek 87654.211250.139321.004.00
Quinn, Dorothy 234091.3914567.983348.009.00
Graves, Lorrie 379401.9427981.4432121.0012.00
Sun, Yi 31733.59672.91117.001.00
Thompson, Nicole 127845.2213322.971317.003.00
Salesperson Total
Sales ($) Average Performance
Bonus Previous
Years ($) Customer
Accounts Years with
Company
Smith, Michael 325,00112,499124.0014.00
Yu, Joe 13,6782409.007.00
Reeves, Bill 452,35921,987175.0021.00
Hamilton, Joshua 87,4247,64328.003.00
Harper, Derek 87,6541,25021.004.00
Quinn, Dorothy 234,09114,56848.009.00
Graves, Lorrie 379,40227,981121.0012.00
Sun, Yi 31,7346737.001.00
Thompson, Nicole 127,84513,32317.003.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Finance Discussion Papers A Framework For Economic Forecasting

Authors: United States Federal Reserve Board, Neil R. Ericsson, Jaime Marquez

1st Edition

1288733585, 9781288733583

More Books

Students also viewed these Finance questions

Question

How can a business manage the risk of retail theft and fraud?

Answered: 1 week ago