please calculate net pay :Hourly (will include example )

in excel

please helo I have less than 3 hours

PAYROLL FINAL PROBLEM 1.) Employee Name: Rollo Lawson Marital Status: Simple FIT: $150 3.) Employee Name: Jackie Brown Marital Status Married FIT. $133 Anndal Salary: $50,000 Annual Salary: $52,600 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 550,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 15.00 Federal Income Tax $30 35 38 33 Additional Data: The state of Missouri has 6% tax rate. The city of St. Louis has a 1% tax rate. INSTRUCTIONS: for Salary emplovees- 1.) Calculate Net Pay (excel working papers-salary tab in green show cross footing of amounts) Prepare joumal entries for salary only. INSTRUCTIONS: for Hourly emplovees. 1.) Calculate Net Pay (excel working papers-hourly red in yellow sbor cross Booning of amounts) Additional Information for hourly employees only Hourly employees are paid time and a half for hour's work that surpasses 40 hours X Times New Roman Comments 16 AA Number Paste BI- A- A 249 ===== -- $ 96 ) Conditional Forma l Forming Table - D- w Streda Choband Any Font Agent . Del A 11 . HOURLY EMPLOYEES EARNINGS DEDUCTIONS Federa Regular Overtime Overtime ca Fica Tocome Pay Rate Pay Gross Pay Taxes Oasdi) Taxes Employee Name Total Hours Tas Total Deductions Nel Pay 10 coram Calon HOURLY SAL