PRAU5A1P1

jfmysjvfes691981

prau5ap1_template-1.xlsx

Home >Business & Finance homework help >Accounting homework help >PRAU5A1P1

4-5A

Name:
Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear
to the right of an incorrect answer.
4-5A
			HOGAN THRIFT SHOP
PAYROLL REGISTER
FOR PERIOD ENDING	December 19, 20 - -											EE	ER
											OASDI	0.062	0.062		SIT	0.02
	MARITAL STATUS	NO. OF W/H ALLOW.		DEDUCTIONS							HI	0.0145	0.0145		CIT	0.015
				( a )		( b )	( c )	( d )		( e )	OASDI
			TOTAL	FICA						NET	Base	113700
EMPLOYEE NAME			EARNINGS	OASDI	HI	FIT		CIT		PAY	oasdi	hi	fit	sit	cit	net pay
John, Matthew	M	3	2,272.00								6.20	32.94	315.20	45.44	34.08	1838.14
Smith, Jennifer	S	1	275.00								17.05	3.99	16.00	5.50	4.13	228.33
Bullen, Catherine	M	0	250.00								15.50	3.63	10.00	5.00	3.75	212.12
Matthews, Mary	S	3	320.25								19.86	4.64	6.00	6.41	4.80	278.54
Hadt, Bonnie	S	1	450.00								27.90	6.53	42.00	9.00	6.75	357.82
Camp, Sean	S	2	560.50								34.75	8.13	47.00	11.21	8.41	451.00
Wilson, Helen	S	1	475.50								29.48	6.89	45.00	9.51	7.13	377.49
Gleason, Jose	M	3	890.00								55.18	12.91	59.00	17.80	13.35	731.76
Totals			5,493.25			Mark Sears: Enter as a formula totaling column	Mark Sears: Enter as a formula totaling column	Mark Sears: Enter as a formula totaling column		Mark Sears: Enter as a formula totaling column	205.92	79.66	540.20	109.87	82.40	4475.20
Compute the employer's FICA taxes for the pay period ending December 19.
OASDI Taxes					HI Taxes
OASDI taxable earnings					HI taxable earnings						3321.25				$ 5,493.25
OASDI taxes					HI taxes		Mark Sears: Hint: Employer's tax must be calculated separately on total wages, since differences may occur due to rounding of individual employee amounts				205.92 Mark Sears: Hint: Employer's tax must be calculated separately on total wages, since differences may occur due to rounding of individual employee amounts				79.65 Mark Sears: Hint: Employer's tax must be calculated separately on total wages, since differences may occur due to rounding of individual employee amounts
				Ros Hill: Enter as a formula of taxable wages x OASDI rate	Mark Sears: Enter as a formula of taxable earnings x HI rate	Ros Hill: Hint: Must use Percentage Method.	Mark Sears: Enter as a formula of taxable earnings x state tax rate	Mark Sears: Enter as a formula of taxable earnings x city tax rate	Mark Sears: Enter as a formula totaling column							Mark Sears: Enter as a formula of total earnings less the sum of deductions	Mark Sears: Enter as a formula totaling column	Mark Sears: Enter as a formula adding applicable amounts in the Total Earnings column	Mark Sears: Hint: Employer's tax must be calculated separately on total applicable wages, since differences may occur due to rounding of individual employee amounts	Student Work Area	Instructor Comment/Grade Area

4-8A

Name:
Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear
to the right of an incorrect answer.
4-8A
COX SECURITY SYSTEMS
PAYROLL REGISTER
FOR PERIOD ENDING		December 26, 20 - -
																	Oasdi	Hi	fit	sit	cit	Net pay
	MARITAL STATUS	NO. OF W/H ALLOW.		EARNINGS				DEDUCTIONS								EE	0.062	0.0145		0.02	0.01
					( a)	( b )		( a )		( b )	( c )	( d )	( e )			ER	0.062	0.0145
EMPLOYEE NAME				REGULAR	SUPP'L.	TOTAL		FICA					NET
								OASDI	HI	FIT	SIT	CIT	PAY
Hall, Michael	M	5	(M)	5,000.00								Mark Sears: Enter as a formula of taxable earnings x city tax rate			4800.00	9800.00	607.60	142.10	1531.00	196.00	98.00	7225.30
Short, Joy T.	M	2	(M)	2,750.00											2640.00	5390.00	334.18	78.16	800.00	107.80	53.90	4015.96
Abbott, Linda	S	1		520.00											2163.20	2683.20	166.36	38.91	593.80	53.66	26.83	1803.64
Smith, Joseph	M	4		465.00											1934.40	2399.40	148.76	34.79	484.60	47.99	23.99	1659.27
Tols, Sean M.	M	2		380.00											1580.80	1960.80	121.57	28.43	403.20	39.22	19.61	1348.77
Gillespie, Michelle	S	1		350.00											1456.00	1806.00	111.97	26.19	391.00	36.12	18.06	1222.66
Smart, Jennifer	M	2		575.00											2392.00	2967.00	183.95	43.02	625.00	59.34	29.67	2026.02
White, Matthew J.	S	0		425.00											1768.00	2193.00	135.97	31.80	491.00	43.86	21.93	1468.44
Totals				10,465.00				Mark Sears: Enter as a formula totaling column							18734.40	29199.40	1810.36	423.40	5319.60	583.99	291.99	20770.06
Compute the employer's FICA taxes for the pay period ending December 26.
OASDI Taxes							HI Taxes
OASDI taxable earnings								HI taxable earnings							29199.40				29199.40
OASDI taxes				Mark Sears: Hint: Employer's tax must be calculated separately on total applicable wages, since differences may occur due to rounding of individual employee amounts									Mark Sears: Enter as a formula of total earnings less the sum of deductions	Mark Sears: Enter as a formula totaling column	Mark Sears: Enter as a formula totaling column		Mark Sears: Enter as a formula totaling column		Mark Sears: Enter as a formula totaling column				HI taxes	Mark Sears: Hint: Employer's tax must be calculated separately on total applicable wages, since differences may occur due to rounding of individual employee amounts	Mark Sears: Enter as a formula totaling column	Ros Hill: Enter as a formula calculating annual pay x bonus rate	Ros Hill: Enter as a formula totaling regular and supplemental pay	Mark Sears: Enter as a formula of taxable earnings x OASDI rate	Mark Sears: Enter as a formula of taxable earnings x HI rate	Mark Sears: Enter as a formula totaling column	Mark Sears: Enter as a formula of taxable earnings x state tax rate	Mark Sears: Enter as a formula totaling column	1810.36	423.39
(M) indicates monthly pay.
Student Work Area								Instructor Comment/Grade Area

4-10A

Name:
Content/Instructions:
	Mattola Company is giving each of its employees a holiday bonus of $100 on Dec 20th (a nonpayday). The company wants each employee's check to be $100. The supplemental tax percent is used.
	a. What will be the gross amount of each bonus if each employee pays a state income tax of 2.8% (besides the other payroll taxes)? Please demonstrate the process used to achieve your answer.
	Answer a:
	b. What would the net amount of each bonus check be if the company did not gross up the bonus? Please demonstrate the proces used to achieve your answer.
	Answer b: