| Hourly Employees |
| Employee Number | Last Name | First Name | Department | Hourly Pay Rate | Customer Service Training Completed | Performance Index | Unexcused Absenses | Accrued Vacation | Vision Insurance | Dental Insurance | Medical Insurance |
| 140 | Hooper | Jamalia | Human Resources | $25 | Y | 79 | 0 | 12 | Y | Y | N |
| 251 | Buck | William | Human Resources | $10 | Y | 100 | 1 | 19 | N | N | Y |
| 184 | Patel | Bernard | Legal Department | $25 | N | 81 | 2 | 1 | Y | Y | N |
| 298 | Webster | Desirae | Advertising | $20 | Y | 89 | 0 | 18 | N | Y | Y |
| 257 | Herman | Cara | Customer Service | $15 | N | 99 | 3 | 6 | N | Y | N |
| 223 | Rivas | Hu | Customer Relations | $15 | N | 75 | 2 | 20 | N | N | Y |
| 281 | Hutchinson | Wynne | Media Relations | $15 | Y | 94 | 0 | 4 | N | N | N |
| 110 | Marshall | Eleanor | Sales and Marketing | $10 | Y | 94 | 1 | 1 | N | Y | Y |
| 286 | Chapman | Ryan | Payroll | $15 | N | 89 | 2 | 3 | Y | Y | Y |
| 121 | Anthony | Rooney | Media Relations | $10 | N | 87 | 1 | 4 | N | Y | N |
| 287 | Cruz | Jamalia | Sales and Marketing | $15 | Y | 99 | 2 | 0 | N | Y | N |
| 282 | Cook | Lilah | Advertising | $25 | N | 95 | 0 | 13 | Y | N | N |
| 231 | Flores | Ciaran | Advertising | $10 | Y | 77 | 1 | 8 | Y | Y | N |
| 173 | Mcleod | Liberty | Research and Development | $25 | Y | 89 | 3 | 0 | Y | Y | N |
| 100 | Wilder | Alisa | Legal Department | $15 | N | 82 | 2 | 2 | N | N | Y |
| 294 | Conley | Hanae | Sales and Marketing | $10 | N | 76 | 0 | 12 | Y | Y | Y |
| 118 | Cooper | Risa | Quality Assurance | $25 | Y | 99 | 0 | 5 | Y | N | N |
| 178 | Mccarthy | Kasper | Advertising | $15 | N | 84 | 0 | 11 | N | Y | N |
| 247 | Bates | Cadman | Payroll | $15 | Y | 89 | 3 | 6 | N | N | N |
| 264 | Schmidt | Breanna | Accounting | $15 | N | 78 | 1 | 1 | N | N | Y |
| 253 | Cabrera | Flavia | Accounting | $15 | Y | 75 | 2 | 20 | Y | Y | N |
| 237 | Reid | Juliet | Media Relations | $20 | N | 78 | 0 | 8 | N | Y | N |
| 132 | Santana | Amena | Quality Assurance | $10 | N | 84 | 2 | 0 | Y | Y | Y |
| 286 | Mosley | Amela | Payroll | $10 | N | 90 | 3 | 3 | N | N | Y |
| 112 | Carey | Brody | Quality Assurance | $15 | Y | 76 | 2 | 12 | N | N | Y |
| 177 | Cortez | Doris | Accounting | $10 | Y | 78 | 1 | 14 | N | N | N |
| 141 | Carver | Ciara | Customer Relations | $15 | Y | 83 | 3 | 2 | N | Y | Y |
| 179 | Gilliam | Ignacia | Sales and Marketing | $10 | Y | 78 | 2 | 1 | N | Y | N |
| 101 | Clay | Azalia | Research and Development | $25 | N | 90 | 2 | 5 | Y | Y | N |
| 255 | Barrera | Hasad | Human Resources | $25 | N | 80 | 0 | 6 | N | Y | Y |
| 287 | Price | Orli | Sales and Marketing | $25 | Y | 79 | 1 | 1 | Y | Y | Y |
| 122 | Hinton | Delilah | Payroll | $15 | N | 93 | 2 | 15 | N | N | N |
| 136 | Woodward | Porter | Accounting | $10 | Y | 88 | 3 | 12 | N | N | Y |
| 193 | Donovan | Kristen | Quality Assurance | $25 | N | 87 | 0 | 6 | N | Y | Y |
| 264 | Velez | Rigel | Accounting | $25 | Y | 77 | 2 | 2 | Y | Y | Y |
| 182 | Atkins | Justin | Tech Support | $25 | N | 94 | 2 | 11 | Y | Y | N |
| 145 | Salazar | Blythe | Sales and Marketing | $15 | N | 94 | 1 | 18 | N | N | Y |
| 248 | Thompson | Leo | Tech Support | $10 | N | 76 | 1 | 14 | Y | Y | Y |
| 216 | Fischer | Aurora | Tech Support | $25 | Y | 80 | 0 | 2 | Y | N | Y |
| 285 | Byrd | Jackson | Media Relations | $25 | Y | 95 | 2 | 9 | Y | Y | N |
| 270 | Morrison | Haley | Tech Support | $25 | Y | 92 | 0 | 5 | Y | Y | Y |
| 220 | Warner | Nerea | Tech Support | $25 | N | 82 | 0 | 14 | Y | N | Y |
| 252 | Williamson | Quinn | Payroll | $20 | N | 96 | 0 | 18 | N | N | N |
| 287 | Morgan | Jolene | Accounting | $20 | Y | 87 | 0 | 1 | N | Y | Y |
| 156 | Holden | MacKenzie | Quality Assurance | $10 | N | 98 | 1 | 16 | Y | N | Y |
| 169 | Molina | Zelda | Sales and Marketing | $15 | Y | 80 | 1 | 11 | Y | Y | N |
| 125 | Weber | Ross | Advertising | $10 | Y | 91 | 0 | 12 | Y | Y | N |
| 283 | Avila | Raja | Tech Support | $25 | Y | 97 | 3 | 18 | Y | Y | N |
| 114 | Conley | Rhona | Research and Development | $15 | N | 92 | 2 | 10 | N | Y | N |
| 137 | Pierce | Avye | Advertising | $15 | N | 85 | 2 | 6 | N | Y | N |
| 219 | Houston | Charissa | Customer Relations | $15 | Y | 100 | 1 | 11 | N | Y | Y |
| 217 | Armstrong | Darrel | Advertising | $10 | N | 81 | 2 | 14 | N | Y | N |
| 139 | Ferrell | Ronan | Research and Development | $10 | Y | 96 | 0 | 3 | N | Y | N |
| 253 | Burnett | Cameran | Payroll | $25 | N | 82 | 2 | 0 | N | N | Y |
| 156 | Head | Susan | Media Relations | $15 | N | 97 | 3 | 13 | N | N | Y |
| 267 | Gonzales | Scarlet | Research and Development | $20 | Y | 78 | 2 | 3 | Y | N | N |
| 268 | Oliver | Thaddeus | Research and Development | $20 | Y | 88 | 2 | 5 | Y | Y | N |
| 128 | Horton | Dai | Research and Development | $25 | N | 87 | 0 | 9 | N | Y | N |
| 156 | Workman | Donna | Sales and Marketing | $15 | N | 83 | 2 | 3 | N | Y | N |
| 224 | Flynn | Gail | Accounting | $20 | N | 99 | 3 | 11 | Y | Y | Y |
| 170 | Patterson | Hakeem | Advertising | $20 | Y | 90 | 1 | 2 | N | Y | Y |
| 192 | Baxter | Gage | Advertising | $10 | N | 90 | 3 | 20 | Y | Y | Y |
| 173 | Ingram | Orli | Customer Relations | $20 | Y | 81 | 3 | 14 | Y | Y | Y |
| 143 | Irwin | Ryder | Media Relations | $15 | N | 84 | 0 | 15 | Y | Y | N |
| 290 | Murphy | Reagan | Sales and Marketing | $20 | N | 98 | 3 | 5 | N | N | N |
| 117 | Hurley | Steven | Research and Development | $20 | Y | 96 | 0 | 6 | Y | N | Y |
| 185 | Barlow | Zenia | Customer Relations | $25 | Y | 85 | 2 | 13 | Y | N | Y |
| 225 | Becker | Amy | Advertising | $15 | N | 77 | 3 | 6 | Y | Y | N |
| 284 | Welch | Merrill | Accounting | $10 | Y | 88 | 2 | 9 | N | N | N |
| 242 | Lowe | Ferdinand | Payroll | $10 | N | 99 | 3 | 18 | Y | N | N |
| 235 | Leblanc | Tanner | Tech Support | $25 | Y | 78 | 1 | 10 | Y | Y | N |
| 129 | Joyce | John | Legal Department | $25 | N | 86 | 0 | 9 | N | Y | N |
| 209 | Browning | Tamara | Human Resources | $10 | Y | 91 | 1 | 12 | Y | Y | N |
| 250 | Bates | Yael | Human Resources | $20 | N | 100 | 1 | 13 | N | Y | Y |
| 178 | Rodriquez | Meredith | Advertising | $25 | Y | 96 | 3 | 17 | N | Y | N |
| 207 | Bowman | Jemima | Human Resources | $15 | N | 80 | 2 | 7 | N | N | Y |
| 105 | Norris | Brennan | Research and Development | $20 | Y | 95 | 2 | 18 | N | N | Y |
| 162 | Collier | Sydney | Quality Assurance | $10 | Y | 81 | 2 | 1 | N | Y | N |
| 148 | Rowland | Igor | Accounting | $15 | Y | 84 | 1 | 14 | N | Y | N |
| 182 | Mann | Arthur | Quality Assurance | $15 | N | 100 | 2 | 9 | N | N | Y |
| 136 | Howard | Noel | Media Relations | $20 | Y | 83 | 0 | 3 | N | Y | Y |
| 203 | Tanner | Isaiah | Quality Assurance | $15 | N | 82 | 1 | 17 | N | N | Y |
| 281 | Mckay | Elaine | Advertising | $10 | Y | 96 | 0 | 1 | Y | Y | N |
| 170 | Fleming | Maggy | Tech Support | $10 | N | 97 | 1 | 12 | Y | Y | N |
| 217 | Dorsey | Miranda | Accounting | $20 | N | 90 | 0 | 4 | Y | Y | Y |
| 282 | Zimmerman | Allegra | Sales and Marketing | $10 | Y | 88 | 0 | 17 | N | N | N |
| 132 | Hammond | Ray | Sales and Marketing | $25 | Y | 86 | 0 | 12 | Y | Y | N |
| 198 | Cain | Odysseus | Customer Service | $25 | Y | 76 | 2 | 8 | Y | N | Y |
| 300 | Wood | Noah | Accounting | $15 | N | 83 | 3 | 11 | N | Y | Y |
| 212 | Britt | Lucius | Customer Service | $10 | Y | 83 | 2 | 17 | N | N | Y |
| 129 | Murphy | Shea | Accounting | $15 | Y | 77 | 2 | 19 | N | Y | Y |
| 172 | Holden | Fleur | Customer Relations | $15 | Y | 100 | 1 | 19 | Y | N | N |
| 274 | Horn | Xyla | Quality Assurance | $20 | Y | 94 | 1 | 6 | Y | Y | N |
| 230 | Mendoza | Iona | Quality Assurance | $20 | Y | 80 | 2 | 13 | N | N | Y |
| 295 | Bradshaw | Ira | Research and Development | $15 | Y | 95 | 2 | 3 | N | N | Y |
| 232 | Merrill | Darrel | Tech Support | $15 | Y | 95 | 2 | 16 | N | N | Y |
| 280 | Clarke | Dennis | Research and Development | $15 | N | 84 | 0 | 9 | Y | Y | Y |
| 127 | Montgomery | Branden | Sales and Marketing | $15 | Y | 86 | 0 | 15 | N | N | N |
| 120 | Ingram | Fuller | Legal Department | $20 | Y | 93 | 3 | 2 | Y | N | N |
| 108 | Duke | Declan | Quality Assurance | $10 | N | 95 | 0 | 12 | Y | Y | Y |
| Bonus if customer service training is completed |
| $ 250 |
| Performance Bonus Lookup Table |
| Performance Index | Amount |
| 0 | 0 |
| 70 | $ 200 |
| 80 | $ 300 |
| 90 | $ 400 |
| 100 | $ 500 |
| Benefits Expenses |
| This company pays for 100% of vision and dental, and 70% of medical |
| Insurance | Premium paid for by company |
| Dental | $ 200 |
| Vision | $ 250 |
| Medical | $ 12,000 |
| Open Positions |
| Department | Open Positions |
| Media Relations | 5 |
| Sales and Marketing | 3 |
| Payroll | 3 |
| Advertising | 2 |
| Research and Development | 7 |
| Legal Department | 5 |
| Quality Assurance | 2 |
| Accounting | 3 |
| Customer Relations | 1 |
M2341asdf
HumanResourcesDataset-1.xlsx
