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