chapter 8 assignment 5
Employee Earnings Record
Mary’s Luxury Travel uses table for weekly federal income tax withholding. Refer to Figure 8-4 in the text. The payroll data for each employee for the week ended March 22, 20—, are given below. Employees are paid 1½ times the regular rate for working over 40 hours a week.
Name |
No. of Allowances |
Marital Status |
Total Hours Worked Mar. 16–22 |
Rate |
Total Earnings Jan. 1–Mar. 15 |
| Bacon, Andrea | 4 | M | 45 | $12 | $5,480 |
| Cole, Andrew | 1 | S | 40 | 12 | 5,760 |
| Hicks, Melvin | 3 | M | 44 | 10.50 | 4,960 |
| Leung, Cara | 1 | S | 36 | 11 | 5,125.50 |
| Melling, Melissa | 2 | M | 40 | 10.50 | 4,720.50 |
Social Security tax is withheld from the first $118,500 of earnings at the rate of 6.2%. Medicare tax is withheld at the rate of 1.45%, and city earnings tax at the rate of 1%, both applied to gross pay. Bacon and Leung have $15 withheld and Cole and Hicks have $5 withheld for health insurance. Bacon and Leung have $20 withheld to be invested in the travel agency’s credit union. Cole has $38.75 withheld and Hicks has $18.75 withheld under a savings bond purchase plan.
Mary’s Luxury Travel’s payroll is met by drawing checks on its regular bank account. The checks were issued in sequence, beginning with Check No. 423.
Andrew Cole, employee number 62, is employed as a manager in the ticket sales department. He was born on May 8, 1986, and was hired on June 1 of last year. His Social Security number is 544-67-1283. He lives at 28 Quarry Drive, Vernon, CT, 06066.
Required:
For the week ended March 22, complete an employee earnings record for Andrew Cole. If required, round your answers to two decimal places. If an amount box does not require an entry, leave it blank. (Insert earnings data only for the week of March 22.)
| Employee Earnings Record for Period Ended | March 22 | 20– | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Earnings | Taxable Earnings | Deductions | |||||||||||||||
| 20 — Period Ended |
Regular |
Overtime |
Total |
Cumulative Total |
Unemploy. Comp. |
Social Security |
Federal Income Tax | Social Security Tax | Medicare Tax |
City Tax |
Health Insurance |
Other |
Total |
CK. NO. |
Amount |
||
| 3/8 | |||||||||||||||||
| 3/15 | |||||||||||||||||
| 3/22 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 3/29 | |||||||||||||||||
| Gender | Department | Occupation | |||||||||||||||
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!
NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
