Module 1: Foundations and Fundamentals - "Validation and Security" Case Assignment
john_promo
ValidationandSecurity.xlsxSheet1
| Last Name | First Name | SSN | Filing Status | Allowances | Insurance | 401K Contribution | Hourly Rate | Overtime Rate | Total Hours | Gross | 401K | Insurance |
| Harris | Jennifer | 572-51-7954 | Married | 2 | Family | FALSE | $19.50 | 29.25 | 44.0 | 897.00 | - 0 | 175.75 |
| Connor | Leigh | 592-52-7921 | Divorced | 4 | Family | TRUE | $21.30 | 31.95 | 44.0 | 979.80 | 41.64 | 175.75 |
| Smith | Randall | 484-09-7836 | Single | 1 | Single | FALSE | $25.10 | 37.65 | 40.0 | 1,004.00 | - 0 | 67.50 |
| Boggs | Adrienne | 554-35-1309 | Head of Household | 3 | Family | TRUE | $25.30 | 37.95 | 50.0 | 1,391.50 | 59.14 | 175.75 |
| Purdom | Christian | 518-46-4642 | Single | 1 | Single | FALSE | $22.20 | 33.30 | 37.0 | 821.40 | - 0 | 67.50 |
| Cimeno | Caroline | 676-12-7861 | Married | 3 | No | TRUE | $37.80 | 56.70 | 45.0 | 1,795.50 | 76.31 | ERROR:#N/A |
| Jacks | Ashleigh | 476-10-4673 | Single | 1 | Single | TRUE | $31.85 | 47.78 | 40.0 | 1,274.00 | 54.15 | 67.50 |
| Peterson | Nathan | 552-18-4596 | Married | 2 | No | TRUE | $24.19 | 36.29 | 52.0 | 1,403.02 | 59.63 | ERROR:#N/A |
| Richards | Elsie | 584-65-1351 | Divorced | 3 | FAMLY | TRUE | $27.20 | 40.80 | 46.0 | 1,332.80 | 56.64 | ERROR:#N/A |
| Williams | Ali | 560-71-9029 | Married | 4 | Family | FALSE | $24.50 | 36.75 | 38.0 | 931.00 | - 0 | 175.75 |
| Blackwell | Annalyse | 511-12-6630 | Single | 1 | Single | TRUE | $24.35 | 36.53 | 40.0 | 974.00 | 41.40 | 67.50 |
| Assumptions and Tables | ||||||||||||
| Filing Status Options | Overtime Cutoff | Overtime Factor | 401K Options | 401K Rate | Health Plan | Deduction Per Pay | ||||||
| Single Debra Gross: Assume "Divorced" is "Single" unless noted as "Head of Household" | 40 | 1.5 | TRUE | 4.25% | Family | $175.75 | ||||||
| Married | FALSE | Single | $67.50 | |||||||||
| Head of Household | None | $0.00 |
