Chapter 10, Problem 9R

Click the Chart sheet tab. On the screen is a chart of the four payroll taxes that a company might incur in total during the year. The four taxes are federal unemployment, state unemployment, Social Security, and Medicare. By the behaviors shown on the chart, identify below which of the four taxes each represents.

Series 1 _____

Series 2 _____

Series 3 _____

Series 4 _____

When the assignment is complete, close the file without saving it again.

TICKLERS (optional)

Worksheet. A new employee was hired during November and was mistakenly omitted from the payroll register. The employee’s last name is Zuckerman, and his gross pay for November is $1,300. Add the new employee to the PR5 worksheet and include all standard withholding rates in computing net pay. Federal income tax withheld is $101. He is a union member. Preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as PRT.

Chart. Using the PR4 file, prepare a 3-D pie chart to show the percentage of an employee’s gross pay that is withheld for taxes, Social Security, and so on, and how much is left over as net pay. Use Smith as your example. Complete the Chart Tickler Data Table and use it as a basis for preparing the chart. Enter your name somewhere on the chart. Save the file again as PR4. Print the chart.