Spreadsheet: 88800d1288637981-excel-2007-short-practice-quiz-help-my-case-6
Sheet: Original

Employee Data
Assumptions |  |  |  |  |  | Statistics
 | Today's Date |  |  |  |  |  |  |  |  |  | 1. Number of hourly employees in Admiinistration
 |  |  |  |  |  |  |  |  |  |  | 2. Average annual salary for full time employees with at least 10 years of seniority
 |  |  |  |  |  |  |  |  |  |  | 3. Total Employee 401(k) contributions for employees who are hourly workers
 |  |  |  |  |  |  |  |  |  |  | 4. Number of employees in Research who earn between $50,000 and $100,000
 |  |  |  |  |  |  |  |  |  |  | 5. Number of employees who do not pay for parking
 |  |  |  |  |  |  |  |  |  |  | 6. Total parking costs for part time employees who park in a satellite lot
ID | Last Name | Hire Date | Seniority (years) | Gender | Department | Job Status | Parking Plan | Pay Type | Annual Salary | Number of Vacation Days | Employee 401(k) | Parking Cost
1078 | [NAME] | 2007-07-25 00:00:00 |  | F | Administration | Full Time | On-site | Salary | 53000
1076 | Ceres | 2008-05-15 00:00:00 |  | F | Finance | Full Time | Preferred | Salary | 68000
1068 | [NAME] | 2003-04-20 00:00:00 |  | M | Finance | Full Time | Satellite | Salary | 115500
1021 | Layton | 2008-03-20 00:00:00 |  | M | Research | Part Time | Satellite | Hourly | 38792
1059 | Grauer | 2007-06-14 00:00:00 |  | F | Finance | Full Time | Prefrred | Salary | 86500
1040 | Ellman | 2008-07-17 00:00:00 |  | M | Finance | Full Time | Satellite | Salary | 123000
1023 | Early | 2008-01-30 00:00:00 |  | M | Finance | Contract | On-site | Salary | 73000
1062 | Gillespie | 2006-01-25 00:00:00 |  | M | Administration | Full Time | Satellite | Salary | 93000
1092 | Otis | 2008-11-03 00:00:00 |  | F | Finance | Part Time | None | Salary | 106000
1085 | Cifizzari | 2004-07-07 00:00:00 |  | F | Administration | Full Time | On-site | Salary | 138000
1004 | [NAME] | 2002-05-08 00:00:00 |  | F | Research | Contract | None | Salary | 68000
1025 | Lesperance | 2005-03-30 00:00:00 |  | M | Finance | Full Time | On-site | Salary | 163000
1028 | Weisglass | 2009-11-13 00:00:00 |  | F | Research | Full Time | On-site | Hourly | 40851
1087 | Lanahan | 2004-03-30 00:00:00 |  | F | Research | Full Time | None | Hourly | 39000
1084 | Green | 1997-10-14 00:00:00 |  | F | Research | Full Time | Preferred | Hourly | 34299
1050 | Strickland | 2001-01-18 00:00:00 |  | F | Administration | Full Time | Satellite | Hourly | 35880
1063 | Charette | 2008-10-14 00:00:00 |  | M | Research | Contract | On-site | Salary | 78000
1026 | [NAME] | 2008-09-07 00:00:00 |  | F | Administration | Full Time | On-site | Salary | 83000
1047 | Waldron | 2008-10-30 00:00:00 |  | F | Finance | Full Time | Satellite | Salary | 51500
1012 | [NAME] | 2003-10-23 00:00:00 |  | F | Finance | Full Time | None | Hourly | 37752
1008 | Braunstein | 2006-02-12 00:00:00 |  | F | Research | Full Time | On-site | Hourly | 36920
1088 | Overby | 2007-05-14 00:00:00 |  | M | Administration | Contract | None | Salary | 103000
1022 | Kiely | 2008-06-16 00:00:00 |  | F | Finance | Full Time | On-site | Salary | 58000
1058 | Lazarus | 2007-10-24 00:00:00 |  | F | Research | Full Time | Preferred | Hourly | 40560
1044 | Sales | 2008-01-15 00:00:00 |  | M | Finance | Full Time | Satellite | Salary | 78000
1079 | Fletcher | 2010-05-31 00:00:00 |  | F | Finance | Full Time | Satellite | Salary | 78000
1049 | [NAME] | 2007-06-06 00:00:00 |  | F | Research | Full Time | Satellite | Hourly | 42640
1010 | Kinzer | 2008-10-02 00:00:00 |  | F | Research | Contract | On-site | Hourly | 35048
1069 | Bland | 2008-10-30 00:00:00 |  | M | Research | Full Time | Preferred | Hourly | 38792
1043 | [NAME] | 1996-02-18 00:00:00 |  | M | Finance | Full Time | Preferred | Salary | 136000
1038 | Baer | 2004-04-18 00:00:00 |  | M | Finance | Full Time | None | Salary | 78000
1100 | Blane | 1995-07-09 00:00:00 |  | F | Finance | Full Time | On-site | Hourly | 45011
1031 | Moreaux | 2008-10-02 00:00:00 |  | F | Finance | Full Time | Motorcycle | Salary | 48000
1046 | Center | 2003-05-07 00:00:00 |  | F | Research | Full Time | On-site | Hourly | 34840
1016 | [NAME] | 2008-12-04 00:00:00 |  | F | Research | Full Time | Satellite | Hourly | 35880
1070 | Marsden | 2005-03-30 00:00:00 |  | F | Finance | Contract | None | Salary | 79000
1090 | [NAME] | 2004-06-11 00:00:00 |  | F | Research | Full Time | Preferred | Hourly | 46800
1013 | [NAME] | 2001-03-08 00:00:00 |  | F | Administration | Part Time | Satellite | Hourly | 44761
1065 | [NAME] | 2005-02-06 00:00:00 |  | F | Finance | Full Time | On-site | Salary | 56000
1093 | Ellis/Mason | 2008-07-04 00:00:00 |  | M | Administration | Full Time | On-site | Salary | 213000
1083 | [NAME] | 2008-06-12 00:00:00 |  | M | Finance | Full Time | Satellite | Salary | 123000
1086 | [NAME] | 2007-12-05 00:00:00 |  | F | Finance | Full Time | None | Salary | 88000
1001 | McNelly | 2006-08-30 00:00:00 |  | M | Finance | Full Time | On-site | Salary | 143000
1075 | Squire | 2005-08-03 00:00:00 |  | F | Finance | Full Time | Preferred | Salary | 56260
1051 | Perpall | 2007-07-04 00:00:00 |  | F | Finance | Part Time | Satellite | Hourly | 39520
1066 | Yoho | 2010-04-24 00:00:00 |  | F | Finance | Contract | On-site | Hourly | 48048
1060 | Michaud | 2009-12-15 00:00:00 |  | F | Finance | Part Time | None | Salary | 58000
1039 | Valente | 2008-11-27 00:00:00 |  | F | Finance | Part Time | Satellite | Hourly | 49004
1081 | Stoneburner | 1996-12-04 00:00:00 |  | F | Research | Full Time | On-site | Hourly | 35880
1061 | [NAME] | 2009-03-16 00:00:00 |  | F | Finance | Full Time | None | Hourly | 45011
1032 | [NAME] | 2000-05-11 00:00:00 |  | M | Administration | Full Time | On-site | Salary | 50244
1067 | Barbiarz | 2003-04-30 00:00:00 |  | F | Finance | Part Time | Preferred | Hourly | 46508
1089 | Craven | 2008-12-25 00:00:00 |  | M | Finance | Full Time | On-site | Salary | 135500
1018 | Crook | 2003-06-29 00:00:00 |  | M | Finance | Full Time | On-site | Salary | 213000
1095 | Aguiar | 2008-07-24 00:00:00 |  | M | Finance | Full Time | On-site | Salary | 98000
1029 | Diller | 2000-10-01 00:00:00 |  | M | Administration | Full Time | On-site | Salary | 88000
1037 | [NAME] | 2008-06-12 00:00:00 |  | M | Finance | Full Time | Preferred | Salary | 54000
1024 | [NAME] | 2003-05-28 00:00:00 |  | F | Finance | Full Time | Preferred | Hourly | 42120
1007 | Joncas | 2008-06-12 00:00:00 |  | M | Administration | Full Time | Satellite | Salary | 93000
1098 | [NAME] | 2004-02-07 00:00:00 |  | F | Finance | Full Time | Satellite | Hourly | 41496
1082 | Hecht | 2008-06-19 00:00:00 |  | M | Finance | Full Time | On-site | Salary | 128000
1064 | Recio | 2007-01-01 00:00:00 |  | F | Finance | Full Time | Motorcycle | Salary | 98000
1002 | [NAME] | 2002-02-08 00:00:00 |  | M | Administration | Full Time | On-site | Salary | 138000
1033 | Fischer | 2008-10-07 00:00:00 |  | M | Finance | Contract | Satellite | Salary | 98000
1072 | Randall | 2007-08-09 00:00:00 |  | F | Finance | Contract | On-site | Salary | 63000
1005 | [NAME] | 1999-08-15 00:00:00 |  | M | Research | Full Time | Preferred | Hourly | 38792
1094 | Gette | 2008-10-09 00:00:00 |  | F | Research | Full Time | On-site | Hourly | 34299
1048 | Quackenbush | 2009-11-07 00:00:00 |  | M | Finance | Full Time | On-site | Salary | 53000
1045 | Del Cerro | 2003-04-09 00:00:00 |  | M | Finance | Full Time | On-site | Salary | 78000
1019 | [NAME] | 2009-10-22 00:00:00 |  | M | Administration | Full Time | None | Salary | 108000
1096 | Matos | 1997-07-21 00:00:00 |  | F | Finance | Full Time | On-site | Salary | 65000
1003 | Santiago | 1997-10-16 00:00:00 |  | F | Research | Part Time | Preferred | Hourly | 35880
1036 | Heaney | 2008-03-06 00:00:00 |  | F | Finance | Full Time | On-site | Hourly | 52000
1009 | [NAME] | 2001-08-02 00:00:00 |  | M | Finance | Full Time | Satellite | Salary | 60000
1056 | [NAME] | 2002-09-12 00:00:00 |  | M | Finance | Full Time | On-site | Salary | 49000
1015 | Salamin | 2008-04-24 00:00:00 |  | F | Administration | Full Time | Satellite | Hourly | 37752
1041 | Olsen | 2005-05-11 00:00:00 |  | M | Administration | Full Time | None | Salary | 76750
1077 | Pelletier | 2008-06-05 00:00:00 |  | M | Finance | Full Time | Preferred | Salary | 165400
1097 | Baer | 2009-12-18 00:00:00 |  | F | Finance | Contract | Satellite | Salary | 93000
1053 | [NAME] | 2008-09-11 00:00:00 |  | M | Administration | Full Time | Satellite | Salary | 108000
1099 | [NAME] | 2008-07-24 00:00:00 |  | F | Finance | Full Time | On-site | Salary | 55000
1035 | Fitzgerald | 1999-08-19 00:00:00 |  | M | Administration | Part Time | On-site | Salary | 46000
1027 | Connolly | 2000-02-13 00:00:00 |  | F | Administration | Full Time | Preferred | Salary | 73000
1074 | Desjardins | 2003-02-05 00:00:00 |  | M | Administration | Full Time | None | Salary | 188000
1080 | [NAME] | 2008-07-24 00:00:00 |  | M | Administration | Full Time | Preferred | Salary | 123000
1057 | McDonald | 1996-07-07 00:00:00 |  | F | Finance | Full Time | On-site | Salary | 98000
1091 | [NAME] | 2008-02-28 00:00:00 |  | M | Finance | Full Time | Satellite | Salary | 109000
1054 | [NAME] | 2002-01-31 00:00:00 |  | M | Finance | Contract | None | Salary | 67000
1073 | [NAME] | 2004-11-24 00:00:00 |  | F | Finance | Full Time | None | Hourly | 42016
1042 | Lipten | 2006-01-08 00:00:00 |  | M | Finance | Full Time | Preferred | Salary | 98000
1034 | Strong | 2008-05-03 00:00:00 |  | F | Administration | Full Time | None | Hourly | 36920
1017 | [NAME] | 2008-12-18 00:00:00 |  | M | Finance | Full Time | On-site | Salary | 103000
1071 | Stearns | 2008-09-25 00:00:00 |  | M | Administration | Contract | None | Salary | 163000
1030 | Clinger | 2008-07-31 00:00:00 |  | M | Finance | Full Time | Motorcycle | Salary | 93000
1052 | Black | 2006-09-07 00:00:00 |  | F | Research | Full Time | None | Hourly | 34840
1014 | Marrero | 2003-01-08 00:00:00 |  | M | Finance | Full Time | On-site | Salary | 123000
1055 | Mendivil | 2004-06-11 00:00:00 |  | M | Finance | Part Time | Satellite | Hourly | 46280
1006 | Hernandez | 2008-08-28 00:00:00 |  | F | Research | Full Time | Satellite | Hourly | 34840
1011 | Feazel | 2001-01-10 00:00:00 |  | M | Research | Full Time | Preferred | Hourly | 35880
1020 | Tanenbaum | 1997-07-20 00:00:00 |  | M | Finance | Full Time | Preferred | Salary | 113000