Answered step by step
Verified Expert Solution
Question
1 Approved Answer
485607 A B 1 EMPLOYEE ID DATE OF HIRE 2 E H DEPARTMENT PERFORMANCE SCORE (1-4) MANAGER COMMENTARY SALARY 3 393786 4 355232 5
485607 A B 1 EMPLOYEE ID DATE OF HIRE 2 E H DEPARTMENT PERFORMANCE SCORE (1-4) MANAGER COMMENTARY SALARY 3 393786 4 355232 5 420444 6 380553 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 1 BONUS OVERTIN $48,200.00 $2,000.00 $0.00 3 $48,200.00 $2,000.00 $0.00 3 $48,200.00 $2,000.00 $0.00 3 $48,200.00 $2,000.00 $0.00 3 Essential Employee $48,200.00 $2,000.00 $0.00 7 427151 8 547926 9 417193 10 509063 11 435359 12 512184 13 438389 14 443122 15 397561 16 555048 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 3 $48,200.00 $2,000.00 $0.00 3 $48,200.00 $2,000.00 $0.00 3 1 Needs motivation. Issues with ma $48,200.00 $42,000.00 $2,000.00 $0.00 $2,000.00 $0.00 2 $42,000.00 $2,000.00 $0.00 2 $45,000.00 $2,000.00 $0.00 3 $42,000.00 $2,000.00 $0.00 3 $42,000.00 $2,000.00 $0.00 3 $42,000.00 $2,000.00 $0.00 3 $42,000.00 $2,000.00 $0.00 17 453271 8/18/1997 Account Service 3 $42,000.00 $2,000.00 $0.00 18 464630 8/19/1997 Account Service 3 $45,000.00 $2,000.00 $0.00 19 519760 8/20/1997 Account Service 3 $45,000.00 $2,000.00 $0.00 20 442969 8/21/1997 Account Service 3 $45,000.00 $2,000.00 $0.00 21 580205 8/22/1997 Finance & Accounts 1 $57,000.00 $2,000.00 $0.00 22 432466 8/23/1997 Finance & Accounts 3 $57,000.00 $2,000.00 $0.00 K A B 23 462316 24 416859 C 8/24/1997 Finance & Accounts 8/25/1997 Finance & Accounts D E 3 F $57,000.00 G H $2,000.00 $0.00 3 $57,000.00 $2,000.00 $0.00 25 328530 8/26/1997 HR & Facilities 1 $61,000.00 $2,000.00 $0.00 26 580230 8/27/1997 HR & Facilities 3 $61,000.00 $2,000.00 $0.00 27 557912 8/28/1997 HR & Facilities 28 470345 8/29/1997 HR & Facilities 29 506073 8/30/1997 IT 30 440265 8/31/1997 IT 3 4 3 Essential Employee 3 $61,000.00 $2,000.00 $0.00 $61,000.00 $2,000.00 $0.00 $75,000.00 $2,000.00 $5,000.00 $75,000.00 $2,000.00 $5,000.00 31 468069 9/1/1997 IT 32 374957 33 513536 9/2/1997 IT 9/3/1997 Logistics 3 4 $75,000.00 $2,000.00 $5,000.00 $75,000.00 $2,000.00 $5,000.00 3 $62,000.00 $2,000.00 $0.00 34 460143 9/7/1987 Logistics 3 $62,000.00 $2,000.00 $0.00 35 589832 36 423817 37 513076 38 390362 9/8/1987 Logistics 9/9/1987 Logistics 9/10/1987 Management 9/11/1987 Management 3 Essential Employee $62,000.00 $2,000.00 $0.00 4 Above performance. $62,000.00 $2,000.00 $0.00 2 $370,834.00 $0.00 $0.00 3 $247,324.00 $0.00 $0.00 39 378723 40 444407 9/12/1987 Management 9/13/1987 Management 3 $237,385.00 $0.00 $0.00 4 $245,048.00 $0.00 $0.00 41 328698 9/14/1987 Manufacturing 1 Essential Employee $46,000.00 $2,000.00 $0.00 42 364811 9/15/1987 Manufacturing 2 $42,000.00 $2,000.00 $0.00 43 446576 9/16/1987 Manufacturing 3 $48,000.00 $2,000.00 $0.00 A B 44 374689 45 575866 46 336426 47 604892 48 397725 49 564463 9/17/1987 Manufacturing 9/18/1987 Manufacturing 9/19/1987 Manufacturing 9/20/1987 Manufacturing 9/21/1987 Manufacturing 9/22/1987 Manufacturing 3 3 3 3 Great job. E F G H $48,000.00 $2,000.00 $0.00 $48,000.00 $2,000.00 $0.00 3 $48,000.00 $2,000.00 $0.00 50 424162 9/23/1987 Manufacturing 3 3 $48,000.00 $2,000.00 $42,000.00 $42,000.00 $2,000.00 $2,700.00 $0.00 $2,000.00 $2,700.00 $42,000.00 $2,000.00 $2,700.00 51 385138 52 502794 53 568130 54 605566 55 328667 9/24/1987 Manufacturing 9/25/1987 Manufacturing 9/26/1987 Manufacturing 9/27/1987 Manufacturing 9/28/1987 Manufacturing 3 $42,000.00 $2,000.00 $2,700.00 3 $42,000.00 $2,000.00 $0.00 3 Essential Employee $42,000.00 $2,000.00 $0.00 3 $46,000.00 $2,000.00 $0.00 3 $46,000.00 $2,000.00 $0.00 56 467513 57 436000 9/29/1987 Manufacturing 9/30/1987 Manufacturing 3 $46,000.00 $2,000.00 $0.00 58 454819 9/29/1992 Manufacturing 3 3 $46,000.00 $2,000.00 $0.00 $46,000.00 $2,000.00 $0.00 59 545925 9/30/1992 Manufacturing 4 Never late. Hardworking employe $48,000.00 $2,000.00 $0.00 60 340158 61 612983 10/1/1992 Manufacturing 10/2/1992 Research 4 $42,000.00 $2,000.00 $2,700.00 3 Trying hard. $55,000.00 $2,000.00 $0.00 62 456221 10/3/1992 Research 3 $55,000.00 $2,000.00 $0.00 63 457949 10/4/1992 Research 3 $55,000.00 $2,000.00 $0.00 64 592862 10/5/1992 Research 3 Essential Employee $55,000.00 $2,000.00 $0.00 A C D E 65 492087 10/6/1992 Sales 2 F $55,000.00 G $2,000.00 H $0.00 66 350488 10/7/1992 Sales 67 490196 10/8/1992 Sales 2 3 $77,000.00 $2,000.00 $0.00 $55,000.00 $2,000.00 $1,100.00 68 561413 10/9/1992 Sales 3 Team leader. $55,000.00 $2,000.00 $1,100.00 69 383332 10/10/1992 Sales 3 $55,000.00 $2,000.00 $1,100.00 70 321027 10/11/1992 Sales 3 $55,000.00 $2,000.00 $0.00 71 598755 10/14/1987 Sales 3 $55,000.00 $2,000.00 $0.00 72 326815 10/15/1987 Sales 3 $77,000.00 $2,000.00 $0.00 73 483908 10/16/1987 Sales 4 Essential Employee $55,000.00 $2,000.00 $1,100.00 74 374331 75 576190 76 535048 77 478733 78 510395 10/17/1987 Web Development 10/18/1987 Web Development 10/19/1987 Web Development 10/20/1987 Web Development 10/21/1987 Web Development 3 $75,000.00 $2,000.00 $0.00 3 $75,000.00 $2,000.00 $0.00 3 $75,000.00 $2,000.00 $0.00 3 $75,000.00 $2,000.00 $0.00 3 $75,000.00 $2,000.00 $0.00 79
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started