Question #6 #7 and #8 please

STUDENT NAME P10 ? PAYROLL REGISTER (PR) LEARNING OBJECTIVES Prepare and use a payroll register including Social Security and Medicare Use -IF and ROUND to design the Social Security tax Record journal entries for payroll, employer's tax liability, and payment of Identify behavior patterns among payroll taxes over time. and union dues formulas. payroll taxes. .Alter the worksheet to include an additional employee of an employee's gross pay that is withheld for to Create a chart showing the percentage and other such deductions, and how much is left over as net pay. PROBLEM DATA Reno Graphics has five employees, and they are paid at the end of each month. P November are as follows: Cumulative Gross Pay at October 31 Gross Pay for Federal Income Employee November Tax Withheld Jones Miller Smith Williams $9,000 1,530 1,210 12,000 $1,948 137 89 2,788 661 15,570 6,550 120,000 55,000 Zlotorzynski4,200 Other information (using 2011 rates) is as follows: a social security taxes are 4.2% of monthly gross pay up to a cumulative total pay of $106,800 for2011. Employers must pay 62% of monthly gross pay up to acumulative total payo! $106,800 for each employee. b, Medicare taxes are 1.45% on monthly gross pay with no upper limit. c. A $25 monthly deduction is made for union dues for all union members. d. Unemployment taxes are paid on monthly gross pay up to the first $7,000 earned by employee each year. State and federal rates are 2.7% and .8%, respectively. REQUIREMENT