Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Explain what you can determine about the company's employees from the spreadsheet. What story does the data tell you? Your response should be 100-200 words.
Explain what you can determine about the company's employees from the spreadsheet. What story does the data tell you? Your response should be 100-200 words.
| EMPLOYEE ID | DATE OF HIRE | DEPARTMENT | PERFORMANCE SCORE (1-4) | MANAGER COMMENTARY | SALARY | BONUS | OVERTIME |
| 485607 | 8/6/1987 | Account Planning | 1 | $48,200.00 | $2,000.00 | $0.00 | |
| 393786 | 8/7/1987 | Account Planning | 3 | $48,200.00 | $2,000.00 | $0.00 | |
| 355232 | 8/8/1987 | Account Planning | 3 | $48,200.00 | $2,000.00 | $0.00 | |
| 420444 | 8/9/1987 | Account Planning | 3 | $48,200.00 | $2,000.00 | $0.00 | |
| 380553 | 8/10/1987 | Account Planning | 3 | Essential Employee | $48,200.00 | $2,000.00 | $0.00 |
| 427151 | 8/11/1987 | Account Planning | 3 | $48,200.00 | $2,000.00 | $0.00 | |
| 547926 | 8/12/1987 | Account Planning | 3 | $48,200.00 | $2,000.00 | $0.00 | |
| 417193 | 8/13/1987 | Account Planning | 3 | $48,200.00 | $2,000.00 | $0.00 | |
| 509063 | 8/14/1987 | Account Service | 1 | Needs motivation. Issues with manager. | $42,000.00 | $2,000.00 | $0.00 |
| 435359 | 8/15/1987 | Account Service | 2 | $42,000.00 | $2,000.00 | $0.00 | |
| 512184 | 8/16/1987 | Account Service | 2 | $45,000.00 | $2,000.00 | $0.00 | |
| 438389 | 8/17/1987 | Account Service | 3 | $42,000.00 | $2,000.00 | $0.00 | |
| 443122 | 8/15/1997 | Account Service | 3 | $42,000.00 | $2,000.00 | $0.00 | |
| 397561 | 8/16/1997 | Account Service | 3 | $42,000.00 | $2,000.00 | $0.00 | |
| 555048 | 8/17/1997 | Account Service | 3 | $42,000.00 | $2,000.00 | $0.00 | |
| 453271 | 8/18/1997 | Account Service | 3 | $42,000.00 | $2,000.00 | $0.00 | |
| 464630 | 8/19/1997 | Account Service | 3 | $45,000.00 | $2,000.00 | $0.00 | |
| 519760 | 8/20/1997 | Account Service | 3 | $45,000.00 | $2,000.00 | $0.00 | |
| 442969 | 8/21/1997 | Account Service | 3 | $45,000.00 | $2,000.00 | $0.00 | |
| 580205 | 8/22/1997 | Finance & Accounts | 1 | $57,000.00 | $2,000.00 | $0.00 | |
| 432466 | 8/23/1997 | Finance & Accounts | 3 | $57,000.00 | $2,000.00 | $0.00 | |
| 462316 | 8/24/1997 | Finance & Accounts | 3 | $57,000.00 | $2,000.00 | $0.00 | |
| 416859 | 8/25/1997 | Finance & Accounts | 3 | $57,000.00 | $2,000.00 | $0.00 | |
| 328530 | 8/26/1997 | HR & Facilities | 1 | $61,000.00 | $2,000.00 | $0.00 | |
| 580230 | 8/27/1997 | HR & Facilities | 3 | $61,000.00 | $2,000.00 | $0.00 | |
| 557912 | 8/28/1997 | HR & Facilities | 3 | $61,000.00 | $2,000.00 | $0.00 | |
| 470345 | 8/29/1997 | HR & Facilities | 4 | $61,000.00 | $2,000.00 | $0.00 | |
| 506073 | 8/30/1997 | IT | 3 | Essential Employee | $75,000.00 | $2,000.00 | $5,000.00 |
| 440265 | 8/31/1997 | IT | 3 | $75,000.00 | $2,000.00 | $5,000.00 | |
| 468069 | 9/1/1997 | IT | 3 | $75,000.00 | $2,000.00 | $5,000.00 | |
| 374957 | 9/2/1997 | IT | 4 | $75,000.00 | $2,000.00 | $5,000.00 | |
| 513536 | 9/3/1997 | Logistics | 3 | $62,000.00 | $2,000.00 | $0.00 | |
| 460143 | 9/7/1987 | Logistics | 3 | $62,000.00 | $2,000.00 | $0.00 | |
| 589832 | 9/8/1987 | Logistics | 3 | Essential Employee | $62,000.00 | $2,000.00 | $0.00 |
| 423817 | 9/9/1987 | Logistics | 4 | Above performance. | $62,000.00 | $2,000.00 | $0.00 |
| 513076 | 9/10/1987 | Management | 2 | $370,834.00 | $0.00 | $0.00 | |
| 390362 | 9/11/1987 | Management | 3 | $247,324.00 | $0.00 | $0.00 | |
| 378723 | 9/12/1987 | Management | 3 | $237,385.00 | $0.00 | $0.00 | |
| 444407 | 9/13/1987 | Management | 4 | $245,048.00 | $0.00 | $0.00 | |
| 328698 | 9/14/1987 | Manufacturing | 1 | Essential Employee | $46,000.00 | $2,000.00 | $0.00 |
| 364811 | 9/15/1987 | Manufacturing | 2 | $42,000.00 | $2,000.00 | $0.00 | |
| 446576 | 9/16/1987 | Manufacturing | 3 | $48,000.00 | $2,000.00 | $0.00 | |
| 374689 | 9/17/1987 | Manufacturing | 3 | $48,000.00 | $2,000.00 | $0.00 | |
| 575866 | 9/18/1987 | Manufacturing | 3 | $48,000.00 | $2,000.00 | $0.00 | |
| 336426 | 9/19/1987 | Manufacturing | 3 | $48,000.00 | $2,000.00 | $0.00 | |
| 604892 | 9/20/1987 | Manufacturing | 3 | $48,000.00 | $2,000.00 | $0.00 | |
| 397725 | 9/21/1987 | Manufacturing | 3 | Great job. | $42,000.00 | $2,000.00 | $2,700.00 |
| 564463 | 9/22/1987 | Manufacturing | 3 | $42,000.00 | $2,000.00 | $2,700.00 | |
| 424162 | 9/23/1987 | Manufacturing | 3 | $42,000.00 | $2,000.00 | $2,700.00 | |
| 385138 | 9/24/1987 | Manufacturing | 3 | $42,000.00 | $2,000.00 | $2,700.00 | |
| 502794 | 9/25/1987 | Manufacturing | 3 | $42,000.00 | $2,000.00 | $0.00 | |
| 568130 | 9/26/1987 | Manufacturing | 3 | Essential Employee | $42,000.00 | $2,000.00 | $0.00 |
| 605566 | 9/27/1987 | Manufacturing | 3 | $46,000.00 | $2,000.00 | $0.00 | |
| 328667 | 9/28/1987 | Manufacturing | 3 | $46,000.00 | $2,000.00 | $0.00 | |
| 467513 | 9/29/1987 | Manufacturing | 3 | $46,000.00 | $2,000.00 | $0.00 | |
| 436000 | 9/30/1987 | Manufacturing | 3 | $46,000.00 | $2,000.00 | $0.00 | |
| 454819 | 9/29/1992 | Manufacturing | 3 | $46,000.00 | $2,000.00 | $0.00 | |
| 545925 | 9/30/1992 | Manufacturing | 4 | Never late. Hardworking employee. | $48,000.00 | $2,000.00 | $0.00 |
| 340158 | 10/1/1992 | Manufacturing | 4 | $42,000.00 | $2,000.00 | $2,700.00 | |
| 612983 | 10/2/1992 | Research | 3 | Trying hard. | $55,000.00 | $2,000.00 | $0.00 |
| 456221 | 10/3/1992 | Research | 3 | $55,000.00 | $2,000.00 | $0.00 | |
| 457949 | 10/4/1992 | Research | 3 | $55,000.00 | $2,000.00 | $0.00 | |
| 592862 | 10/5/1992 | Research | 3 | Essential Employee | $55,000.00 | $2,000.00 | $0.00 |
| 492087 | 10/6/1992 | Sales | 2 | $55,000.00 | $2,000.00 | $0.00 | |
| 350488 | 10/7/1992 | Sales | 2 | $77,000.00 | $2,000.00 | $0.00 | |
| 490196 | 10/8/1992 | Sales | 3 | $55,000.00 | $2,000.00 | $1,100.00 | |
| 561413 | 10/9/1992 | Sales | 3 | Team leader. | $55,000.00 | $2,000.00 | $1,100.00 |
| 383332 | 10/10/1992 | Sales | 3 | $55,000.00 | $2,000.00 | $1,100.00 | |
| 321027 | 10/11/1992 | Sales | 3 | $55,000.00 | $2,000.00 | $0.00 | |
| 598755 | 10/14/1987 | Sales | 3 | $55,000.00 | $2,000.00 | $0.00 | |
| 326815 | 10/15/1987 | Sales | 3 | $77,000.00 | $2,000.00 | $0.00 | |
| 483908 | 10/16/1987 | Sales | 4 | Essential Employee | $55,000.00 | $2,000.00 | $1,100.00 |
| 374331 | 10/17/1987 | Web Development | 3 | $75,000.00 | $2,000.00 | $0.00 | |
| 576190 | 10/18/1987 | Web Development | 3 | $75,000.00 | $2,000.00 | $0.00 | |
| 535048 | 10/19/1987 | Web Development | 3 | $75,000.00 | $2,000.00 | $0.00 | |
| 478733 | 10/20/1987 | Web Development | 3 | $75,000.00 | $2,000.00 | $0.00 | |
| 510395 | 10/21/1987 | Web Development | 3 | $75,000.00 | $2,000.00 | $0.00 |
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
Managing Information Technology
Authors: Carol Brown, Daniel DeHayes, Jeffrey Hoffer, Wainright Marti
7th Edition
132146320, 978-0132146326
