Hello, I am needing some help with this assignment I've posted it before a couple of times but whoever has tried to help me has given me the wrong answers and the math doesn't add up or make sense. If I could receive some actually assistance that would be great as I am very frustrated with this assignment.

Using the attached information file, Calculate (1) the weekly paycheck for each staff person and (2) total cost of payroll for the organization for the week.

Information you will need:

Hourly rate of pay

Pay status (exempt or non-exempt)

Productive and non-productive hours worked

State of Missouri and federal income tax rates based on filing status.

Social Security tax (employer and employee)

Medicare tax (employer and employee)

Pre- and post- tax insurance deductions

W-4 withholding details (e.g., single, head of household, etc)

W-4 holding reductions/increases

401(k) matching max of 3% (half of employee contribution to 6%)

Employer contribution of $80.77 per week to medical insurance

Total cost of payroll Total cost of payroll