Kipley Company is a small manufacturing firm located in Pittsburgh, Pennsylvania. The company has a workforce of both hourly and salaried employees. Each employee is paid for hours actually worked during each week, with the time worked being recorded in quarter-hour increments. The standard workweek consists of 40 hours, with all employees being paid time and one-half for any hours worked beyond the 40 regular hours.

Requirement:

Record the regular hours and the overtime hours worked for each employee, using the time clerk's report as your reference.

Complete the Regular Earnings columns (Rate per Hour and Amount) for hourly employees. For only hourly employees that worked overtime, complete the Overtime Earnings columns (Rate per Hour and Amount).
For salaried workers, complete the Regular Earnings column and show the hourly overtime rate and earnings only if overtime was worked.

Record the Total Earnings for each employee by adding the Regular Earnings and the Overtime Earnings.

Payroll Register

This is the first task to completing Kipley Company's payroll register. Complete the steps outlined below:

Record the regular hours and the overtime hours worked for each employee, using the time clerk's report as your reference.

Complete the Regular Earnings columns (Rate per Hour and Amount) for hourly employees. For only hourly employees that worked overtime, complete the Overtime Earnings columns (Rate per Hour and Amount).
For salaried workers, complete the Regular Earnings column and show the hourly overtime rate and earnings only if overtime was worked.

Record the Total Earnings for each employee by adding the Regular Earnings and the Overtime Earnings.

If an amount box does not require an entry, leave it blank or enter "0". If required, round your intermediate calculations to the nearest cent and use the rounded amounts in subsequent computations. Round fraction values to the nearest two decimal places, e.g. 1 1/2 to 1.50.

KIPLEY COMPANY, INC.
Employee Payroll Register
For Period Ending January 8, 20 --

Regular Earnings Overtime Earnings

Time Card
No.
Name Filing
Status
No. W/H Allow.
Hours Worked
Rate per Hour
Amount
Hours Worked
Rate per Hour
Amount
Total Earnings

11 Carson, F. S N/A fill in the blank ca57b8fb4067fd2_1 $fill in the blank ca57b8fb4067fd2_2 $fill in the blank ca57b8fb4067fd2_3 fill in the blank ca57b8fb4067fd2_4 $fill in the blank ca57b8fb4067fd2_5 $fill in the blank ca57b8fb4067fd2_6 $fill in the blank ca57b8fb4067fd2_7

12 Wilson, W. S N/A fill in the blank ca57b8fb4067fd2_8 fill in the blank ca57b8fb4067fd2_9 fill in the blank ca57b8fb4067fd2_10 fill in the blank ca57b8fb4067fd2_11 fill in the blank ca57b8fb4067fd2_12 fill in the blank ca57b8fb4067fd2_13 fill in the blank ca57b8fb4067fd2_14

13 Utley, H. MFJ N/A fill in the blank ca57b8fb4067fd2_15 fill in the blank ca57b8fb4067fd2_16 fill in the blank ca57b8fb4067fd2_17 fill in the blank ca57b8fb4067fd2_18 fill in the blank ca57b8fb4067fd2_19 fill in the blank ca57b8fb4067fd2_20 fill in the blank ca57b8fb4067fd2_21

21 Fife, L. MFJ N/A fill in the blank ca57b8fb4067fd2_22 fill in the blank ca57b8fb4067fd2_23 fill in the blank ca57b8fb4067fd2_24 fill in the blank ca57b8fb4067fd2_25 fill in the blank ca57b8fb4067fd2_26 fill in the blank ca57b8fb4067fd2_27 fill in the blank ca57b8fb4067fd2_28

22 Smith, L. S N/A fill in the blank ca57b8fb4067fd2_29 fill in the blank ca57b8fb4067fd2_30 fill in the blank ca57b8fb4067fd2_31 fill in the blank ca57b8fb4067fd2_32 fill in the blank ca57b8fb4067fd2_33 fill in the blank ca57b8fb4067fd2_34 fill in the blank ca57b8fb4067fd2_35

31 Fay, G. MFJ N/A fill in the blank ca57b8fb4067fd2_36 ……… fill in the blank ca57b8fb4067fd2_37 fill in the blank ca57b8fb4067fd2_38 fill in the blank ca57b8fb4067fd2_39 fill in the blank ca57b8fb4067fd2_40 fill in the blank ca57b8fb4067fd2_41

32 Robey, G. MFJ N/A fill in the blank ca57b8fb4067fd2_42 ……… fill in the blank ca57b8fb4067fd2_43 fill in the blank ca57b8fb4067fd2_44 fill in the blank ca57b8fb4067fd2_45 fill in the blank ca57b8fb4067fd2_46 fill in the blank ca57b8fb4067fd2_47

33 Schork, T. S N/A fill in the blank ca57b8fb4067fd2_48 ……… fill in the blank ca57b8fb4067fd2_49 fill in the blank ca57b8fb4067fd2_50 fill in the blank ca57b8fb4067fd2_51 fill in the blank ca57b8fb4067fd2_52 fill in the blank ca57b8fb4067fd2_53

51 Hardy, B. MFJ N/A fill in the blank ca57b8fb4067fd2_54 ……… fill in the blank ca57b8fb4067fd2_55 fill in the blank ca57b8fb4067fd2_56 fill in the blank ca57b8fb4067fd2_57 fill in the blank ca57b8fb4067fd2_58 fill in the blank ca57b8fb4067fd2_59

99 Kipley, C. MFJ N/A fill in the blank ca57b8fb4067fd2_60 ……… fill in the blank ca57b8fb4067fd2_61 fill in the blank ca57b8fb4067fd2_62 fill in the blank ca57b8fb4067fd2_63 fill in the blank ca57b8fb4067fd2_64 fill in the blank ca57b8fb4067fd2_65

Totals $fill in the blank ca57b8fb4067fd2_66 ……… ……… $fill in the blank ca57b8fb4067fd2_67 $fill in the blank ca57b8fb4067fd2_68

Transcribed Image Text:TIME CLERK'S REPORT NO. 1 For Period Ending January 8, 20-- Time Record Time Time Employee Worked* Lost M W F S 11 Fran M. Carson 8 8 8. 8 8 40 12 William A. Wilson 8 8. 8 8 48 13 Harry T. Utley 8 52 8. 8. 8 372 22 hrs. tardy 21 Lawrence R. Fife 10 10 8 8 10 46 22 Lucy K. Smith 8 8 8. 8. 8 40 31 Gretchen R. Fay 8 8. 8. 8. 8 14 414 32 Glenda B. Robey 8. 8 8 8 8 40 33 Thomas K. Schork 8 8 8 8 8 40 51 Barbara T. Hardy 8 8. 8. 8. 8. 4 44 99 Carson C. Kipley 8 8 8 8 8 40
Transcribed Image Text:Kipley's Hourly Wage/Salary Report is provided below, listing each employee's assigned time card number as well as their individual hourly rate or salary. 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

Question

Kipley Company is a small manufacturing firm located in Pittsburgh, Pennsylvania. The company has a workforce of both hourly and salaried employees. Each employee is paid for hours actually worked during each week, with the time worked being recorded in quarter-hour increments. The standard workweek consists of 40 hours, with all employees being paid time and one-half for any hours worked beyond the 40 regular hours.

Requirement:

Record the regular hours and the overtime hours worked for each employee, using the time clerk's report as your reference.
Complete the Regular Earnings columns (Rate per Hour and Amount) for hourly employees. For only hourly employees that worked overtime, complete the Overtime Earnings columns (Rate per Hour and Amount).
For salaried workers, complete the Regular Earnings column and show the hourly overtime rate and earnings only if overtime was worked.
Record the Total Earnings for each employee by adding the Regular Earnings and the Overtime Earnings.

Payroll Register

This is the first task to completing Kipley Company's payroll register. Complete the steps outlined below:

Record the regular hours and the overtime hours worked for each employee, using the time clerk's report as your reference.
Complete the Regular Earnings columns (Rate per Hour and Amount) for hourly employees. For only hourly employees that worked overtime, complete the Overtime Earnings columns (Rate per Hour and Amount).
For salaried workers, complete the Regular Earnings column and show the hourly overtime rate and earnings only if overtime was worked.
Record the Total Earnings for each employee by adding the Regular Earnings and the Overtime Earnings.

If an amount box does not require an entry, leave it blank or enter "0". If required, round your intermediate calculations to the nearest cent and use the rounded amounts in subsequent computations. Round fraction values to the nearest two decimal places, e.g. 1 1/2 to 1.50.

Time Card No.	Name	Filing Status	No. W/H Allow.	Hours Worked	Rate per Hour	Amount	Hours Worked	Rate per Hour	Amount	Total Earnings
KIPLEY COMPANY, INC. Employee Payroll Register For Period Ending January 8, 20 --
				Regular Earnings	Overtime Earnings
11	Carson, F.	S	N/A	fill in the blank ca57b8fb4067fd2_1	$fill in the blank ca57b8fb4067fd2_2	$fill in the blank ca57b8fb4067fd2_3	fill in the blank ca57b8fb4067fd2_4	$fill in the blank ca57b8fb4067fd2_5	$fill in the blank ca57b8fb4067fd2_6	$fill in the blank ca57b8fb4067fd2_7
12	Wilson, W.	S	N/A	fill in the blank ca57b8fb4067fd2_8	fill in the blank ca57b8fb4067fd2_9	fill in the blank ca57b8fb4067fd2_10	fill in the blank ca57b8fb4067fd2_11	fill in the blank ca57b8fb4067fd2_12	fill in the blank ca57b8fb4067fd2_13	fill in the blank ca57b8fb4067fd2_14
13	Utley, H.	MFJ	N/A	fill in the blank ca57b8fb4067fd2_15	fill in the blank ca57b8fb4067fd2_16	fill in the blank ca57b8fb4067fd2_17	fill in the blank ca57b8fb4067fd2_18	fill in the blank ca57b8fb4067fd2_19	fill in the blank ca57b8fb4067fd2_20	fill in the blank ca57b8fb4067fd2_21
21	Fife, L.	MFJ	N/A	fill in the blank ca57b8fb4067fd2_22	fill in the blank ca57b8fb4067fd2_23	fill in the blank ca57b8fb4067fd2_24	fill in the blank ca57b8fb4067fd2_25	fill in the blank ca57b8fb4067fd2_26	fill in the blank ca57b8fb4067fd2_27	fill in the blank ca57b8fb4067fd2_28
22	Smith, L.	S	N/A	fill in the blank ca57b8fb4067fd2_29	fill in the blank ca57b8fb4067fd2_30	fill in the blank ca57b8fb4067fd2_31	fill in the blank ca57b8fb4067fd2_32	fill in the blank ca57b8fb4067fd2_33	fill in the blank ca57b8fb4067fd2_34	fill in the blank ca57b8fb4067fd2_35
31	Fay, G.	MFJ	N/A	fill in the blank ca57b8fb4067fd2_36	………	fill in the blank ca57b8fb4067fd2_37	fill in the blank ca57b8fb4067fd2_38	fill in the blank ca57b8fb4067fd2_39	fill in the blank ca57b8fb4067fd2_40	fill in the blank ca57b8fb4067fd2_41
32	Robey, G.	MFJ	N/A	fill in the blank ca57b8fb4067fd2_42	………	fill in the blank ca57b8fb4067fd2_43	fill in the blank ca57b8fb4067fd2_44	fill in the blank ca57b8fb4067fd2_45	fill in the blank ca57b8fb4067fd2_46	fill in the blank ca57b8fb4067fd2_47
33	Schork, T.	S	N/A	fill in the blank ca57b8fb4067fd2_48	………	fill in the blank ca57b8fb4067fd2_49	fill in the blank ca57b8fb4067fd2_50	fill in the blank ca57b8fb4067fd2_51	fill in the blank ca57b8fb4067fd2_52	fill in the blank ca57b8fb4067fd2_53
51	Hardy, B.	MFJ	N/A	fill in the blank ca57b8fb4067fd2_54	………	fill in the blank ca57b8fb4067fd2_55	fill in the blank ca57b8fb4067fd2_56	fill in the blank ca57b8fb4067fd2_57	fill in the blank ca57b8fb4067fd2_58	fill in the blank ca57b8fb4067fd2_59
99	Kipley, C.	MFJ	N/A	fill in the blank ca57b8fb4067fd2_60	………	fill in the blank ca57b8fb4067fd2_61	fill in the blank ca57b8fb4067fd2_62	fill in the blank ca57b8fb4067fd2_63	fill in the blank ca57b8fb4067fd2_64	fill in the blank ca57b8fb4067fd2_65
Totals	$fill in the blank ca57b8fb4067fd2_66	………	………	$fill in the blank ca57b8fb4067fd2_67	$fill in the blank ca57b8fb4067fd2_68

TIME CLERK'S REPORT NO. 1
For Period Ending January 8, 20--
Time Record
Time
Time
Employee
Worked*
Lost
M
W
F
S
11
Fran M. Carson
8
8
8.
8
8
40
12
William A. Wilson
8
8.
8
8
48
13
Harry T. Utley
8
52
8.
8.
8
372
22 hrs. tardy
21
Lawrence R. Fife
10
10
8
8
10
46
22
Lucy K. Smith
8
8
8.
8.
8
40
31
Gretchen R. Fay
8
8.
8.
8.
8
14
414
32
Glenda B. Robey
8.
8
8
8
8
40
33
Thomas K. Schork
8
8
8
8
8
40
51
Barbara T. Hardy
8
8.
8.
8.
8.
4
44
99
Carson C. Kipley
8
8
8
8
8
40

Kipley's Hourly Wage/Salary Report is provided below, listing each employee's assigned time card number as well as their individual hourly
rate or salary.
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

Accepted Answer

Salary per week of salaried employee
= salary mer month /4
salary per hour of salaried employee
=…