Employee Earnings Record

Marys Luxury Travel uses a weekly federal income tax withholding table. Refer to Figure 8-4 in the text. The payroll data for each employee for the week ended March 22, 20, are given. 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. 1622	Rate	Total Earnings Jan. 1Mar. 15
Bacon, Andrea	4	M	45	$12.00	$5,500.00
Cole, Andrew	1	S	40	12.00	5,900.00
Hicks, Melvin	3	M	44	10.50	5,040.00
Leung, Cara	1	S	35	11.00	5,090.50
Melling, Melissa	2	M	40	13.00	4,743.50

Social Security tax is withheld from the first $128,400 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 $17 withheld and Cole and Hicks have $6 withheld for health insurance. Bacon and Leung have $22 withheld to be invested in the travel agencys credit union. Cole has $38.50 withheld and Hicks has $19.25 withheld under a savings bond purchase plan.

Marys Luxury Travels 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. (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		fill in the blank 1	fill in the blank 2	fill in the blank 3	fill in the blank 4	fill in the blank 5	fill in the blank 6	fill in the blank 7	fill in the blank 8	fill in the blank 9	fill in the blank 10	fill in the blank 11	Credit unionSavings bond	fill in the blank 13	fill in the blank 14	fill in the blank 15	fill in the blank 16
3/29
Gender		Department		Occupation		Social Security No.		Marital Status	Allowances	Pay Rate	Date of Birth	Date Hired	Name/Address				Emp. No.
M		Ticket Sales		Manager		544-67-1283		S	1	$12.00	5/8/86	6/1/--	Andrew Cole				62
													28 Quarry Drive,
													Vernon, CT, 06066