TAB "EMPLOYEES 1. Clean up the Employee Name in tab "EMPLOYEES to be incompliance with the format "Doe, John 2. Break the Employee Name into First Name (John) and Last Name (Doel-please note that no middle names or initials should be included in either column 3. Create employee email address with format: First Name Last Name@xyz.com 4. Highlight employees having hour rate more than $60 TAS "PAYROLL" 5. Calculate Gross Earnings 6. Calculate Deduction amount (Deduction amount HCSP Retirement 4010)+ Health Insurance+Dental Insurance Parking). Remember that employees might not have all of those deduction types 7. Calculate Withholding amount. (Withholding amount State WH Federal WH+ Social Security Tax Medicare tax) Please put totals in for the columns in requirements 5-7 (use of the SUM function is recommended). Your totals can appear at the top or bottom of the columns and should match the check figures provided. Employee 10 0000258 300002671 40000793) 0004018 0004054 700004125 00004321 00004544 10 0004973 13 00001071 1300005482 14 0005745 1500006356 14 000040 1700006765 18000002 1900007239 20 00007793 2100004032 22 0000194 23 0000531 24 00008951 25 00009512 36 00009923 370010325 2800030753 29 0001299 3000 PENERA FISHMANA FAULKNER DANILAly COPULA COM CARROLL COLV POPP MCADAMLempins GOLDMAN NELSONA KANE D ROMAN HEDEL HUSEDaan arvi HENOLMAYIL DEMATTOL, alan 310010959 32 00011242 33 00011404 GARSHEL 00013058 TAAR 00012036 0013410 37 3749 ANDERSON BLXdent Addre 4AL 3 4 T v n HE 1929 $340 $37.56 04 F F F Y N 0 1 r 129 29 20040 1019973 $36.25 $29.24 34041 29 50042910 12 SLOSING 0044230 T 10 29 536.99 F 1 T Employee ID 200348914 Pay End Date Holiday G 300348816 1/31/19 Vacation Sick 0 Regular Gross H Deduction 400348665 1/31/19 80 Tax Withholding M Net 6 1/31/19 74 500348638 3 600348629 1/31/19 77 0 1 79 700347899 1/31/19 0 80 1/31/19 800347693 15 65 1/31/19 900347559 24 56 1/31/19 10 00347507 0 80 1/31/19 11 00347105 80 1/31/19 0 12 00346952 80 1/31/19 0 13 00346943 80 1/31/19 0 14 00346783 80 1/31/19 10 70 15 00346694 1/31/19 0 16 00346248 80 1/31/19 0 80 17 00345757 1/31/19 11 69 18 003456861 1/31/19 0 BO 19 00345089 1/31/19 14 66 20 00343845 1/31/19 7 73 21 00343312 1/31/19 0 BO 22 00343116 1/31/19 0 80 23 00342903 1/31/19 B 72 24 00342297 1/31/19 241 56 25 00341904 1/31/19 0 80 26 00341859 1/31/19 5 75 27 00341261 1/31/19 80 28 00341243 1/31/19 0 80 29 00341020 1/31/19 9 71 30 00339997 1/31/19 11 69 31 00339336 1/31/19 0 80 32 00338952 1/31/19 19 61 33 00338337 1/31/19 2 78 34 00338302 1/31/19 0 80 30 35 00337748 1/31/19 0 80 3600335474 1/31/19 10. 70 37 00324976 1/31/19 0 1 79 38 00324324 1/31/19 0 80 39 00323851 1/31/19 14 66 40 00323664 1/31/19 0 80 41 00323272 1/31/19 5 75 63 42 00322960 1/31/19 17 80 43 00322809 1/31/19 80 44 00322692 1/31/19 0 80 45 00322237 1/31/19 0 46 00322157 1/31/19 80 80 47 00321924 1/31/19 48 00321890 1/31/19 6 74 49 00321844 1/31/19 9 00 68 77 50 00321604 1/31/19 3 $1 00320614 1/31/19 25 55 52 00320419 1/31/19 80 5300319670 1/31/19 80 0 1 Deduction Rate 2 3 Health Care Saving Plan (HCSP) 4 Retirement 5 Health Insurance (F-Family) 6 Health Insurance (S-Single) 7 Dental Insurance (F-Family) 8 Dental Insurance (S-Single) 9 Parking 10 11 Tax Withholding Rate 12 State 13 Federal 14 Social Security Tax 15 Medicare Tax 16 2% of Gross amount 5% of Gross amount $80 per pay period $10 per pay period $25 per pay period $5 per pay period $35 per pay period 10% of (Gross-Deduction) 20% of (Gross-Deduction) 4.20% of (Gross-HCSP-Health Insurance-Dental Insurance) 1.45% of (Gross-HCSP Health Insurance-Dental Insurance) H