Kipley Company is a small manufacturing firm located in Pitt

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.

Wages are paid every Friday, with one week\'s pay being held back by the company. Assume that the first payday for Kipley Company is January 14 for the workweek ending January 8 (Saturday).

You are being asked to complete Kipley\'s Payroll Register for the pay period ending January 8, 20--. Ms. Glenda B. Robey prepares the Time Clerk\'s Report for each pay period. This along with the Hourly Wage / Salary Report is provided.

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.

Hourly Wage / Salary Report

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 Clerk\'s Report

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.

Note: All employees, except for Carson Kipley, are paid for hours worked beyond 40 at one and one-half times their regular hourly rate of pay.

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.	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

Solution

Payroll Report for Kipley Company

(in $)

Regular Earnings

Total

Overtime Earnings

Total

Weekly pay

Time Card Number

Employee

Rate

Hours

Rate

Hours

11

Frank M. Carson

17.5

40

700

26.25

0

700

12

William A. Wilson

17.25

40

690

25.875

8

207

897

13

Harry t. Utley

18.1

37.5

678.75

27.15

0

678.75

21

Lawrence R. Fife

17.9

40

716

26.85

6

161.1

877.1

22

Lucy K. Smith

19.75

40

790

29.625

0

790

31

Gretchen R. Fay

12.87

40

514.8

19.305

1.25

24.13

538.93125

32

Glenda B. Robey

16.88

40

675.2

25.32

0

675.2

33

Thomas k. Schork

20.94

40

837.6

31.41

0

837.6

51

Barbara T. Hardy

15.69

40

627.6

23.535

4

94.14

721.74

99

Carson C. Kipley

25

40

1000

0

0

1000

26.25=17.25*1.5

Payroll Report for Kipley Company		(in $)
		Regular Earnings	Total	Overtime Earnings	Total	Weekly pay
Time Card Number	Employee	Rate	Hours		Rate	Hours
11	Frank M. Carson	17.5	40	700	26.25		0	700
12	William A. Wilson	17.25	40	690	25.875	8	207	897
13	Harry t. Utley	18.1	37.5	678.75	27.15		0	678.75
21	Lawrence R. Fife	17.9	40	716	26.85	6	161.1	877.1
22	Lucy K. Smith	19.75	40	790	29.625		0	790
31	Gretchen R. Fay	12.87	40	514.8	19.305	1.25	24.13	538.93125
32	Glenda B. Robey	16.88	40	675.2	25.32		0	675.2
33	Thomas k. Schork	20.94	40	837.6	31.41		0	837.6
51	Barbara T. Hardy	15.69	40	627.6	23.535	4	94.14	721.74
99	Carson C. Kipley	25	40	1000	0		0	1000