40 722 670 780 single married married single 0 1 2 1

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 41 hours, and Liptak and Stern each worked 36 hours. Chapter 12 Problems 308-337_CH12_868829.indd 330 9/15/05 11:46:37 AM Problems CHAPTER 12 SPREADSHEET SMART GUIDE Instructions On the forms provided in your working papers: 1. Prepare a payroll register for the week ending October 9. The date of payment is also October 9. List employees in alphabetical order by last name. Use the tables on page 317 to determine the federal income tax withholding. The rate for the state income tax is 2%. Compute social security tax at 6.2% and Medicare tax at 1.45%. Union members pay weekly dues of $4.50. Both Gail Job and Bruce Stern had $6.75 deducted for health and hospital insurance. 2. Total the amount columns. Subtract total deductions from total earnings. Does the result equal the sum of the Net Pay column? If not, find and correct any error(s) on the payroll register. Analyze Step–by–Step Instructions: Problem 12–6 1. Select the spreadsheet template for Problem 12–6. 2. Enter your name and the date in the spaces provided on the template. 3. Complete the spreadsheet using the instructions in your working papers. 4. Print the spreadsheet and proof your work. 5. Complete the Analyze activity. 6. Save your work and exit the spreadsheet program. Identify the employee who had the highest amount withheld for federal income tax for the week. Problem 12–7 Preparing Payroll Checks and Employee’s Earnings Records The payroll register for Kits & Pups Grooming is presented here and also appears in your working papers. PAYROLL REGISTER 3 4 TOTAL HOURS 2 NAME Hurd, Mildred Montego, José Pilly, Amanda Steams, Margaret ALLOW. 1 162 157 151 163 MAR. STATUS EMPLOYEE NUMBER PAY PERIOD ENDING October 17 RATE S S M S 0 1 2 0 38 39 36 41 7.60 7.90 8.10 7.60 20 -- DATE OF PAYMENT October 17, 20-- EARNINGS REGULAR 288 308 291 304 80 10 60 00 OVERTIME 11 40 DEDUCTIONS TOTAL 288 308 291 315 80 10 60 40 SOC. SEC. MEDICARE TAX TAX 17 19 18 19 91 10 08 55 4 4 4 4 19 47 23 57 FED. INC. TAX 35 00 30 00 10 00 40 00 STATE INC. TAX 7 7 7 7 22 70 29 89 HOSP. INS. 5 10 7 6...
View Full Document

This note was uploaded on 01/16/2014 for the course BUSINESS Accounting taught by Professor Dr.stevenhall during the Fall '13 term at Del Mar College.

Ask a homework question - tutors are online