please complete Net pay in excel

format (included format example )

along with General entries for salary

please help if you can Thank you !!

PAYROLL FINAL PROBLEM 1.) Employee Name: Rollo Lawson Marital Status: Single 3.) Employee Name: Jaclie Brown Marital Status Married FIT: $150 FIT: $133 Annual Salary: $50,000 Annual Salary: $52,000 Payroll Schedule: Bi-Weekly Payroll Schedule: Bi-Weekly 2.) Employee Name: George Jefferson Marital Status: Married 4.) Employee Name: Thelma Evans Marital Status: Single FIT: $257 FIT: $148 Annual Salary: $65,000 Annual Salary $50,000 Payroll Schedule: Semi-Monthly Payroll Schedule: Semi-Monthly Hourly Employees Emplovee J. Lewis R Bell C. Duncan A Anderson Hours Hourly Rate 45 $13.00 42 15.00 40 18.00 48 15.00 Federal Income Tax $30 35 38 33 Additional Data: The state of Missouri has 69 tax rate. The city of St. Louis has a 1% tax rate. INSTRUCTIONS for Salary emplovees- 1.) Calculate Net Pay (excel working paperi-salary tab in green show cross footing of amounts) Prepare journal entries for salary only, INSTRUCTIONS: for Hourly emplovees. 1.) Calculate Net Pay (excel working paper-hourly tab in yellow show cross footing of amounts) Additional Information for hourly employees only Hourly employees are paid time and a half for hour's work that surpasses 40 hours PAYROLL CALCULATIONS R. Lawson G. Jefferson J. Brown T. Evans TOTAL ANNUAL SALARY NUMBER OF PAY PERIODS 30 11 GROSS PAY 12 13 FICA OASDI 14 15 FICA/HI 16 17 FEDERAL INCOME TAX 11 19 STATE. TAX OF GROSS PAY 20 21 CITY TAX OF GROSS PAY 22 NET PAY 24 note: cross foot your numbers to make sure they equal. The gross pay less the tax deductions should be equivalent to the total of net pay. 24