Payroll Register and Payroll Journal Entry

Mary Losch operates a travel agency called Marys Luxury Travel. She has five employees, all of whom are paid on a weekly basis. The travel agency uses a payroll register, individual employee earnings records, and a general journal.

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	44	$14.00	$6,300.00
Cole, Andrew	1	S	40	15.00	6,150.00
Hicks, Melvin	3	M	44	13.50	5,805.00
Leung, Cara	1	S	36	14.00	5,600.00
Melling, Melissa	2	M	40	14.50	5,945.00

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 $15 withheld and Cole and Hicks have $10 withheld for health insurance. Bacon and Leung have $20 withheld to be invested in the travel agencys credit union. Cole has $38.75 withheld and Hicks has $18.75 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.

Required:

Question Content Area

1. Prepare a payroll register for Marys Luxury Travel for the week ended March 22, 20--. (In the Taxable Earnings/Unemployment Compensation column, enter the same amounts as in the Social Security column.) Total the amount columns.

If required, round your answers to the nearest cent.

			Payroll Register for Period Ended											March 22		20--
			Earnings				Taxable Earnings		Deductions
Name	No. of Allow.	Marit. Status	Regular	Overtime	Total	Cumulative Total	Unemploy. Comp.	Social Security	Federal Income Tax	Social Security Tax	Medicare Tax	City Tax	Health Insurance	Other		Total	Net Pay	Ck. No.
Bacon, Andrea	4	M	fill in the blank b52f24fb206dfc7_1	fill in the blank b52f24fb206dfc7_2	fill in the blank b52f24fb206dfc7_3	fill in the blank b52f24fb206dfc7_4	fill in the blank b52f24fb206dfc7_5	fill in the blank b52f24fb206dfc7_6	fill in the blank b52f24fb206dfc7_7	fill in the blank b52f24fb206dfc7_8	fill in the blank b52f24fb206dfc7_9	fill in the blank b52f24fb206dfc7_10	fill in the blank b52f24fb206dfc7_11	BondsCredit UnionCredit Union	fill in the blank b52f24fb206dfc7_13	fill in the blank b52f24fb206dfc7_14	fill in the blank b52f24fb206dfc7_15	fill in the blank b52f24fb206dfc7_16
Cole, Andrew	1	S	fill in the blank b52f24fb206dfc7_17		fill in the blank b52f24fb206dfc7_18	fill in the blank b52f24fb206dfc7_19	fill in the blank b52f24fb206dfc7_20	fill in the blank b52f24fb206dfc7_21	fill in the blank b52f24fb206dfc7_22	fill in the blank b52f24fb206dfc7_23	fill in the blank b52f24fb206dfc7_24	fill in the blank b52f24fb206dfc7_25	fill in the blank b52f24fb206dfc7_26	BondsCredit UnionBonds	fill in the blank b52f24fb206dfc7_28	fill in the blank b52f24fb206dfc7_29	fill in the blank b52f24fb206dfc7_30	fill in the blank b52f24fb206dfc7_31
Hicks, Melvin	3	M	fill in the blank b52f24fb206dfc7_32	fill in the blank b52f24fb206dfc7_33	fill in the blank b52f24fb206dfc7_34	fill in the blank b52f24fb206dfc7_35	fill in the blank b52f24fb206dfc7_36	fill in the blank b52f24fb206dfc7_37	fill in the blank b52f24fb206dfc7_38	fill in the blank b52f24fb206dfc7_39	fill in the blank b52f24fb206dfc7_40	fill in the blank b52f24fb206dfc7_41	fill in the blank b52f24fb206dfc7_42	BondsCredit UnionBonds	fill in the blank b52f24fb206dfc7_44	fill in the blank b52f24fb206dfc7_45	fill in the blank b52f24fb206dfc7_46	fill in the blank b52f24fb206dfc7_47
Leung, Cara	1	S	fill in the blank b52f24fb206dfc7_48		fill in the blank b52f24fb206dfc7_49	fill in the blank b52f24fb206dfc7_50	fill in the blank b52f24fb206dfc7_51	fill in the blank b52f24fb206dfc7_52	fill in the blank b52f24fb206dfc7_53	fill in the blank b52f24fb206dfc7_54	fill in the blank b52f24fb206dfc7_55	fill in the blank b52f24fb206dfc7_56	fill in the blank b52f24fb206dfc7_57	BondsCredit UnionCredit Union	fill in the blank b52f24fb206dfc7_59	fill in the blank b52f24fb206dfc7_60	fill in the blank b52f24fb206dfc7_61	fill in the blank b52f24fb206dfc7_62
Melling, Melissa	2	M	fill in the blank b52f24fb206dfc7_63		fill in the blank b52f24fb206dfc7_64	fill in the blank b52f24fb206dfc7_65	fill in the blank b52f24fb206dfc7_66	fill in the blank b52f24fb206dfc7_67	fill in the blank b52f24fb206dfc7_68	fill in the blank b52f24fb206dfc7_69	fill in the blank b52f24fb206dfc7_70	fill in the blank b52f24fb206dfc7_71				fill in the blank b52f24fb206dfc7_72	fill in the blank b52f24fb206dfc7_73	fill in the blank b52f24fb206dfc7_74
			fill in the blank b52f24fb206dfc7_75	fill in the blank b52f24fb206dfc7_76	fill in the blank b52f24fb206dfc7_77	fill in the blank b52f24fb206dfc7_78	fill in the blank b52f24fb206dfc7_79	fill in the blank b52f24fb206dfc7_80	fill in the blank b52f24fb206dfc7_81	fill in the blank b52f24fb206dfc7_82	fill in the blank b52f24fb206dfc7_83	fill in the blank b52f24fb206dfc7_84	fill in the blank b52f24fb206dfc7_85		fill in the blank b52f24fb206dfc7_86	fill in the blank b52f24fb206dfc7_87	fill in the blank b52f24fb206dfc7_88

Feedback Area

Feedback

Question Content Area

2. Assuming that the wages for the week ended March 22 were paid on March 24, prepare the journal entry for the payment of the payroll.

Page: 1

ROW NUMBER	DATE	ACCOUNT TITLE	DOC. NO.	POST. REF.	DEBIT	CREDIT	ROW NUMBER
1	20-- Mar. 24	CashCredit Union PayableEmployee Federal Income Tax PayableMedicare Tax PayableSocial Security Tax PayableWages and Salaries ExpenseWages and Salaries Expense	blank	blank	Wages and Salaries Expense	Wages and Salaries Expense	1
2	blank	City Tax ExpenseEmployee Federal Income Tax PayableHealth Insurance Premiums ExpenseMedicare Tax ExpenseSocial Security Tax ExpenseWages and Salaries PayableEmployee Federal Income Tax Payable	blank	blank	Employee Federal Income Tax Payable	Employee Federal Income Tax Payable	2
3	blank	Credit Union ExpenseEmployee Income Tax ExpenseHealth Insurance Premiums ExpenseSocial Security Tax PayableU.S. Savings Bonds ExpenseWages and Salaries PayableSocial Security Tax Payable	blank	blank	Social Security Tax Payable	Social Security Tax Payable	3
4	blank	City Tax ExpenseEmployee Income Tax ExpenseHealth Insurance Premiums ExpenseMedicare Tax PayableU.S. Savings Bonds ExpenseWages and Salaries PayableMedicare Tax Payable	blank	blank	Medicare Tax Payable	Medicare Tax Payable	4
5	blank	City Tax PayableCredit Union ExpenseHealth Insurance Premiums ExpenseMedicare Tax ExpenseSocial Security Tax ExpenseWages and Salaries PayableCity Tax Payable	blank	blank	City Tax Payable	City Tax Payable	5
6	blank	Credit Union ExpenseEmployee Income Tax ExpenseHealth Insurance Premiums PayableMedicare Tax ExpenseU.S. Savings Bonds ExpenseWages and Salaries PayableHealth Insurance Premiums Payable	blank	blank	Health Insurance Premiums Payable	Health Insurance Premiums Payable	6
7	blank	City Tax ExpenseCredit Union PayableMedicare Tax ExpenseSocial Security Tax ExpenseU.S. Savings Bonds ExpenseWages and Salaries PayableCredit Union Payable	blank	blank	Credit Union Payable	Credit Union Payable	7
8	blank	City Tax ExpenseEmployee Income Tax ExpenseHealth Insurance Premiums ExpenseSocial Security Tax ExpenseU.S. Savings Bonds PayableWages and Salaries PayableU.S. Savings Bonds Payable	blank	blank	U.S. Savings Bonds Payable	U.S. Savings Bonds Payable	8
9	blank	CashCredit Union ExpenseEmployee Income Tax ExpenseMedicare Tax ExpenseSocial Security Tax ExpenseWages and Salaries ExpenseCash	blank	blank	Cash	Cash	9
10	blank	Payroll for week ended March 22	blank	blank	blank	blank	10