Chapter $13$ XL

STUDENT NAME

P$10$ PAYROLL REGISTER $($PR$)$

LEARNING OBJECTIVES

Prepare and use a payroll register including Social Security and Medicare withholdings.

Use $=$IF and $=$ROUND to design the Social Security tax and union dues formulas.

Record journal entries for payroll, employer's tax liability, and payment of payroll taxes.

Identify behavior patterns among payroll taxes over time.

Alter the worksheet to include an additional employee.

Create a chart showing the percentage of an employee's gross pay that is withheld for taxes 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. Payroll data for November are as follows:

$\backslash$table$[[,$Gross Pay for,Federal Income,Cumulative Gross Pay at$],[$Employee$,$November,Tax Withheld,October $31],[$Jones$,$$$9,000,$$$1,948,$$$?$