Project 5 Workforce Composition Solution Key

Project 5 Workforce Composition Solution Key - Workforce...

Info icon This preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Workforce Profile Analysis Section 1: Complete all Columns in Data Set Format for: Number Date Text Currency Currency Number Text Number Number Number Number Number Text mm/dd/yy Year Ending Vested Yr 12/31/2014 10 Emp # Hire Date Role Salary Hrly Rate Yrs of Svc Ed Age Vested Race Gender Status State 1001 03/15/99 CEO $200,210 $96.25 16 19 56 Yes 3 1 2 PA 1002 12/15/99 Design $79,723 $38.33 15 16 45 Yes 3 1 2 PA 1003 09/07/12 Sr Mach $66,750 $32.09 2 12 29 No 1 1 1 IL 1004 06/13/12 Machine $31,924 $15.35 3 12 24 No 3 1 2 NE 1005 10/25/08 Machine $42,687 $20.52 6 14 35 No 3 1 1 PA 1006 08/05/06 Machine $50,307 $24.19 8 14 41 No 3 1 1 IL 1014 06/03/09 IT Staf $87,818 $42.22 6 16 40 No 4 2 1 IL 1015 07/08/13 Invent $31,250 $15.02 1 14 26 No 3 1 2 PA 1016 09/23/08 Machine $42,719 $20.54 6 12 35 No 3 1 2 NE 1018 01/15/11 Acctg/Fin $42,836 $20.59 4 16 32 No 3 2 2 PA 1018 05/03/12 Machine $32,157 $15.46 3 12 24 No 3 2 1 NE 1019 05/21/07 Machine $48,317 $23.23 8 12 38 No 3 1 1 NE 1024 08/17/11 Machine $33,005 $15.87 3 12 26 No 3 1 1 IL 1036 09/25/00 Machine $57,822 $27.80 14 16 51 Yes 2 1 1 NE 1038 08/21/12 IT Staf $65,451 $31.47 2 16 32 No 2 1 1 PA 1043 06/18/09 Gen Shop $26,168 $12.58 6 12 27 No 3 1 1 IL 1048 09/19/13 Shipping $31,655 $15.22 1 12 20 No 1 2 2 IL 1049 02/23/04 IT Staf $88,421 $42.51 11 19 41 Yes 3 1 1 PA 1053 05/31/13 Machine $30,241 $14.54 2 12 20 No 3 1 2 PA 1053 09/08/09 Machine $35,293 $16.97 5 12 30 No 1 1 1 IL 1055 06/15/01 Controller $99,836 $48.00 14 19 45 Yes 3 2 1 PA 1055 06/04/01 Machine $56,663 $27.24 14 16 50 Yes 3 1 1 PA 1055 9/30/2001 Machine $57,385 $27.59 13 16 50 Yes 1 1 1 IL 1056 05/06/07 Machine $48,059 $23.11 8 12 38 No 3 1 1 IL Format cells in columns according to indicated format.
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
1059 02/14/12 Acctg/Fin $46,589 $22.40 3 16 33 No 3 2 1 NE 1061 02/02/09 Machine $39,931 $19.20 6 12 34 No 1 1 1 NE 1062 03/04/13 Acctg/Fin $32,238 $15.50 2 16 28 No 3 1 2 IL 1062 07/08/09 Flr Supr $72,803 $35.00 5 14 35 No 3 1 1 PA 1069 02/03/11 Engineering $79,938 $38.43 4 16 35 No 2 2 1 IL 1070 08/21/09 Machine $35,498 $17.07 5 12 31 No 3 1 1 NE 1071 01/09/05 Engineering $86,238 $41.46 10 19 41 No 3 1 1 NE 1071 08/08/05 Engineering $87,019 $41.84 9 19 51 No 3 1 1 IL 1075 01/14/10 Machine $34,317 $16.50 5 12 28 No 3 2 1 NE 1079 10/15/03 Invent $51,459 $24.74 11 16 31 Yes 3 1 1 PA 1083 08/27/09 Machine $35,396 $17.02 5 12 31 No 3 1 2 PA 1083 4/30/2000 Machine $58,771 $28.26 15 14 52 Yes 3 1 1 IL 1084 03/15/99 Sales $85,671 $41.19 16 19 62 Yes 3 1 1 PA 1088 10/03/11 Sr Flr Mgr $83,974 $40.37 3 16 35 No 1 2 1 NE 1096 03/06/06 Machine $50,502 $24.28 9 12 42 No 3 1 1 NE 1097 08/14/05 Machine $50,571 $24.31 9 12 43 No 1 1 1 PA 1098 01/13/14 Engineering $62,245 $29.93 1 16 25 No 3 1 2 PA 1101 06/08/02 Invent $55,994 $26.92 13 16 31 Yes 1 1 1 NE 1102 04/08/00 IT Staf $88,900 $42.74 15 19 48 Yes 3 1 1 PA 1104 02/01/05 Machine $52,450 $25.22 10 12 44 No 3 1 1 NE 1105 09/06/12 Invent $32,633 $15.69 2 12 28 No 3 1 2 NE 1106 5/9/2002 Machine $55,744 $26.80 13 12 48 Yes 1 1 1 IL 1108 06/15/07 Gen Shop $27,403 $13.17 8 12 29 No 3 1 2 IL 1109 02/22/07 Machine $49,201 $23.65 8 12 39 No 3 1 1 NE 1113 05/02/12 Machine $32,124 $15.44 3 12 24 No 1 2 2 PA 1113 09/08/00 Sr Mach $81,695 $39.28 14 14 50 Yes 1 1 1 PA 1116 12/30/08 Machine $42,235 $20.31 6 12 34 No 3 1 1 IL 1116 04/05/00 Quality $81,526 $39.20 15 16 52 Yes 3 1 1 PA 1117 05/27/09 Gen Shop $26,360 $12.67 6 12 27 No 3 2 1 PA 1117 08/15/12 Machine $31,262 $15.03 2 12 22 No 2 1 2 IL 1128 06/07/10 Flr Supr $74,104 $35.63 5 16 35 No 3 2 1 NE 1130 03/15/99 Machine $59,438 $28.58 16 16 53 Yes 3 1 1 PA 1132 07/10/09 Machine $35,822 $17.22 5 12 32 No 3 1 1 PA 1133 02/12/09 Sales $73,337 $35.26 6 19 58 No 4 1 1 PA 1136 12/14/11 Machine $32,523 $15.64 3 12 24 No 1 1 2 IL
Image of page 2
1138 10/18/10 Gen Shop $24,017 $11.55 4 12 24 No 4 2 1 PA 1138 4/12/2008 Machine $44,204 $21.25 7 12 35 No 4 1 1 PA 1140 07/10/09 Machine $35,934 $17.28 5 12 32 No 2 1 1 IL 1141 06/18/09 Gen Shop $25,999 $12.50 6 12 24 No 3 1 1 IL 1142 06/17/09 Machine $36,901 $17.74 6 12 32 No 1 1 1 PA 1145 02/16/09 Gen Shop $25,131 $12.08 6 12 24 No 2 1 2 IL 1145 11/05/09 Machine $34,680 $16.67 5 12 29 No 1 1 2 NE 1145 09/15/04 Machine $53,327 $25.64 10 12 45 Yes 3 1 1 IL 1150 04/26/13 Machine $30,808 $14.81 2 12 21 No 1 1 2 IL 1153 02/05/12 Sr Mach $66,843 $32.14 3 12 30
Image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern