Related questions with answers

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. Reformat the table to improve readability and to help the sales manager make her decisions on bonuses.

 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\begin{array}{|l|c|c|c|c|} \hline \text { Salesperson } & \begin{array}{c} \text { Total Sales } \\ \text{ (\$) } \end{array} & \begin{array}{c} \text { Average Performance } \\ \text { Bonus Previous } \\ \text{ Years (\$) } \end{array} & \begin{array}{c} \text { Customer } \\ \text { Accounts } \end{array} & \begin{array}{c} \text { Years with } \\ \text { Company } \end{array} \\ \hline \text { Smith, Michael } & 325000.78 & 12499.3452 & 124 & 14 \\ \hline \text { Yu, Joe } & 13678.21 & 239.9434 & 9 & 7 \\ \hline \text { Reeves, Bill } & 452359.19 & 21987.2462 & 175 & 21 \\ \hline \text { Hamilton, Joshua } & 87423.91 & 7642.9011 & 28 & 3 \\ \hline \text { Harper, Derek } & 87654.21 & 1250.1393 & 21 & 4 \\ \hline \text { Quinn, Dorothy } & 234091.39 & 14567.9833 & 48 & 9 \\ \hline \text { Graves, Lorrie } & 379401.94 & 27981.4432 & 121 & 12 \\ \hline \text { Sun, Yi } & 31733.59 & 672.9111 & 7 & 1 \\ \hline \text { Thompson, Nicole } & 127845.22 & 13322.9713 & 17 & 3 \\ \hline \end{array}

Question

The entire calculator value should be used to calculate the overhead in this exercise.

Department 11 had $5,200\$ 5,200 in sales for the month, department 22 had $4,700\$ 4,700. department 33 had $6.520\$ 6.520, department 44 had $4,870\$ 4,870, and department 55 had $2,010\$ 2,010. The total overhead was $10,000\$ 10,000. Find each department's overhead based on sales.

Solution

Verified
Answered 1 year ago
Answered 1 year ago
Step 1
1 of 3

Use the information given in order to find the overhead of each department.

Departments Sales
11 5200$5200\$
22 4700$4700\$
33 6520$6520\$
44 4870$4870\$
55 2010$2010\$
Total 23300$23300\$
Total sales 2300$2300\$.

Create an account to view solutions

By signing up, you accept Quizlet's Terms of Service and Privacy Policy
Continue with GoogleContinue with Facebook

Create an account to view solutions

By signing up, you accept Quizlet's Terms of Service and Privacy Policy
Continue with GoogleContinue with Facebook

More related questions

1/4

1/7