How much does the company spend on salaries, overtime, and bonuses overall?

Which departments have the highest employee expenses in total, and which departments have the highest average employee pay?

How long have employees been with the company on average, and how does that vary by department?

How does performance vary across employees and departments?

Do salaries seem to be tied to performance, experience, or length of employment? What about bonuses?

How much money does the company need to save in order to reduce its costs by 10 percent?

  
 

 

Transcribed Image Text:

EMPLOYEE IDIDATE OF HIRE 485607 393786 355232 420444 380553 427151 547926 417193 509063 435359 512184 438389 443122 397561 555048 453271 464630 519760 442969 580205 432466 462316 416859 328530 580230 557912 DEPARTMENT 8/6/1987 Account Planning 8/7/1987 Account Planning 8/8/1987 Account Planning 8/9/1987 Account Planning 8/10/1987 Account Planning 8/11/1987 Account Planning 8/12/1987 Account Planning 8/13/1987 Account Planning 8/14/1987 Account Service 8/15/1987 Account Service 8/16/1987 Account Service 8/17/1987 Account Service 8/15/1997 Account Service 8/16/1997 Account Service 8/17/1997 Account Service 8/18/1997 Account Service 8/19/1997 Account Service 8/20/1997 Account Service 8/21/1997 Account Service 8/22/1997 Finance & Accounts 8/23/1997 Finance & Accounts 8/24/1997 Finance & Accounts 8/25/1997 Finance & Accounts 8/26/1997 HR & Facilities 8/27/1997 HR & Facilities 8/28/1997 HR & Facilities PERFORMANCE SCORE (1-4) 1 3 3 3 3 Essential Employee 3 3 3 1 Needs motivation. Issues with ma 2 2 3 3 3 3 3 3 3 3 1 3 3 3 1 3 MANAGER COMMENTARY 3 SALARY BONUS OVERTIN $48,200.00 $2,000.00 $48,200.00 $2,000.00 $48,200.00 $2,000.00 $48,200.00 $2,000.00 $48,200.00 $2,000.00 $48,200.00 $2,000.00 $48,200.00 $2,000.00 $48,200.00 $2,000.00 $42,000.00 $2,000.00 $42,000.00 $2,000.00 $45,000.00 $2,000.00 $42,000.00 $2,000.00 $42,000.00 $2,000.00 $0.00 $42,000.00 $2,000.00 $42,000.00 $2,000.00 $42,000.00 $2,000.00 $0.00 $45,000.00 $2,000.00 $0.00 $45,000.00 $2,000.00 $0.00 $45,000.00 $2,000.00 $0.00 $57,000.00 $2,000.00 $0.00 $57,000.00 $2,000.00 $0.00 $57,000.00 $2,000.00 $0.00 $57,000.00 $2,000.00 $0.00 $61,000.00 $2,000.00 $0.00 $61,000.00 $2,000.00 $0.00 $61,000.00 $2,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 EMPLOYEE IDIDATE OF HIRE 485607 393786 355232 420444 380553 427151 547926 417193 509063 435359 512184 438389 443122 397561 555048 453271 464630 519760 442969 580205 432466 462316 416859 328530 580230 557912 DEPARTMENT 8/6/1987 Account Planning 8/7/1987 Account Planning 8/8/1987 Account Planning 8/9/1987 Account Planning 8/10/1987 Account Planning 8/11/1987 Account Planning 8/12/1987 Account Planning 8/13/1987 Account Planning 8/14/1987 Account Service 8/15/1987 Account Service 8/16/1987 Account Service 8/17/1987 Account Service 8/15/1997 Account Service 8/16/1997 Account Service 8/17/1997 Account Service 8/18/1997 Account Service 8/19/1997 Account Service 8/20/1997 Account Service 8/21/1997 Account Service 8/22/1997 Finance & Accounts 8/23/1997 Finance & Accounts 8/24/1997 Finance & Accounts 8/25/1997 Finance & Accounts 8/26/1997 HR & Facilities 8/27/1997 HR & Facilities 8/28/1997 HR & Facilities PERFORMANCE SCORE (1-4) 1 3 3 3 3 Essential Employee 3 3 3 1 Needs motivation. Issues with ma 2 2 3 3 3 3 3 3 3 3 1 3 3 3 1 3 MANAGER COMMENTARY 3 SALARY BONUS OVERTIN $48,200.00 $2,000.00 $48,200.00 $2,000.00 $48,200.00 $2,000.00 $48,200.00 $2,000.00 $48,200.00 $2,000.00 $48,200.00 $2,000.00 $48,200.00 $2,000.00 $48,200.00 $2,000.00 $42,000.00 $2,000.00 $42,000.00 $2,000.00 $45,000.00 $2,000.00 $42,000.00 $2,000.00 $42,000.00 $2,000.00 $0.00 $42,000.00 $2,000.00 $42,000.00 $2,000.00 $42,000.00 $2,000.00 $0.00 $45,000.00 $2,000.00 $0.00 $45,000.00 $2,000.00 $0.00 $45,000.00 $2,000.00 $0.00 $57,000.00 $2,000.00 $0.00 $57,000.00 $2,000.00 $0.00 $57,000.00 $2,000.00 $0.00 $57,000.00 $2,000.00 $0.00 $61,000.00 $2,000.00 $0.00 $61,000.00 $2,000.00 $0.00 $61,000.00 $2,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Answer rating: 100% (QA)

Based on the provided images of the data we can attempt to answer these questions based on the visible entries The images depicted show a partial dataset for employees including their employee ID date ... View the full answer