Question: 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

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 f2ile
\table[[Salesperson,Total Sales ($),\table[[Average Performance],[Bonus Previous Years ($)]],\table[[Customer],[Accounts]],\table[[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)
Average Performance
 A sales manager is trying to determine appropriate sales performance bonuses

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!