From the given data, compute the following Record the amounts withheld for group and health insurance and calculate the net pay for each employee Record the amount to be withheld for health insurance Each employee contributes $1 65 each week toward the cost of health insurance Record the net pay for each employee The net pay for each employee is obtained by subtracting the total amount of all deductions from the total earnings Each worker is to be paid by check Assign check numbers commencing with No 313 Foot all money columns of the payroll register, and prove the accuracy of the column totals Time Card No Employee Name Hourly Wage or Salary 11 Fran M Carson $ 17 50 per hour 12 William A Wilson 17 25 per hour 13 Harry T Utley 18 10 per hour 21 Lawrence R Fife 17 90 per hour 22 Lucy K Smith 19 75 per hour 31 Gretchen R Fay 515 per week 32 Glenda B Robey 2,700 per month 33 Thomas K Schork 3,350 per month 51 Barbara T Hardy 2,510 per month 99 Carson C Kipley 52,000 per year Ms Glenda B Robey prepares the time clerk's report for each pay period Her report for the first week of operations is given below Continuing payroll problem A, KIPLEY COMPANY, INC PAYROLL REGISTER FOR PERIOD ENDING January 8, 20 MARITAL STATUS NO OF W H ALLOW REGULAR EARNINGS OVERTIME EARNINGS HOURS WORKED RATE PER HOUR HOURS WORKED RATE PER HOUR TOTAL EMPLOYEE AMOUNT AMOUNT EARNINGS 11 Carson, Fran M S 1 40 $17 50 700 00 $0 00 700 00 12 Wilson, William A S 0 40 $17 25 690 00 8 $25 88 207 00 897 00 13 Utley, Harry T M 2 37 5 $18 10 678 75 $0 00 678 75 21 Fife, Lawrence R M 4 40 $17 90 716 00 6 $26 85 161 10 877 10 22 Smith, Lucy K S 2 40 $19 75 790 00 $0 00 790 00 31 Fay, Gretchen R M 3 40 $12 88 515 20 1 25 $19 32 24 15 539 50 32 Robey, Glenda B M 6 40 $15 58 623 20 $0 00 623 20 33 Schork, Thomas K S 1 40 $19 33 773 20 $0 00 773 20 51 Hardy, Barbara T M 5 40 $14 48 579 20 4 $21 72 86 88 666 08 99 Kipley, Carson C M 7 40 $25 00 1,000 00 $0 00 1,000 00 Totals 7,065 55 479 13 7,544 68

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Nov 27, 2018

From the given data, compute the following: Record the amounts withheld for group and health insurance and calculate the net pay for each employee. Record

From the given data, compute the following:

Record the amounts withheld for group and health insurance and calculate the net pay for each employee.

Record the amount to be withheld for health insurance. Each employee contributes $1.65 each week toward the cost of health insurance.

Record the net pay for each employee. The net pay for each employee is obtained by subtracting the total amount of all deductions from the total earnings. Each worker is to be paid by check. Assign check numbers commencing with No. 313. Foot all money columns of the payroll register, and prove the accuracy of the column totals.

Time Card No.	Employee Name	Hourly Wage or Salary
11	Fran M. Carson	$ 17.50 per hour
12	William A. Wilson	17.25 per hour
13	Harry T. Utley	18.10 per hour
21	Lawrence R. Fife	17.90 per hour
22	Lucy K. Smith	19.75 per hour
31	Gretchen R. Fay	515 per week
32	Glenda B. Robey	2,700 per month
33	Thomas K. Schork	3,350 per month
51	Barbara T. Hardy	2,510 per month
99	Carson C. Kipley	52,000 per year

Ms. Glenda B. Robey prepares the time clerk's report for each pay period. Her report for the first week of operations is given below.

Continuing payroll problem-A, KIPLEY COMPANY, INC.

PAYROLL REGISTER
FOR PERIOD ENDING	January 8, 20 - -

	MARITAL STATUS	NO. OF W/H ALLOW.	REGULAR EARNINGS			OVERTIME EARNINGS
			HOURS WORKED	RATE PER HOUR		HOURS WORKED	RATE PER HOUR
									TOTAL
EMPLOYEE					AMOUNT			AMOUNT	EARNINGS
11 Carson, Fran M.	S	1	40	$17.50	700.00		$0.00		700.00
12 Wilson, William A.	S	0	40	$17.25	690.00	8	$25.88	207.00	897.00
13 Utley, Harry T.	M	2	37.5	$18.10	678.75		$0.00		678.75
21 Fife, Lawrence R.	M	4	40	$17.90	716.00	6	$26.85	161.10	877.10
22 Smith, Lucy K.	S	2	40	$19.75	790.00		$0.00		790.00
31 Fay, Gretchen R.	M	3	40	$12.88	515.20	1.25	$19.32	24.15	539.50
32 Robey, Glenda B.	M	6	40	$15.58	623.20		$0.00		623.20
33 Schork, Thomas K.	S	1	40	$19.33	773.20		$0.00		773.20
51 Hardy, Barbara T.	M	5	40	$14.48	579.20	4	$21.72	86.88	666.08
99 Kipley, Carson C.	M	7	40	$25.00	1,000.00		$0.00		1,000.00
Totals					7,065.55			479.13	7,544.68	*