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 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 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 TIME CLERK'S REPORT NO 1 For Period Ending January 8, 20 Employee Time Record Time Worked Time Lost M T W T F S 11 Fran M Carson 8 8 8 8 8 40 12 William A Wilson 8 8 8 8 8 8 48 13 Harry T Utley 8 5 8 8 8 37 2 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 1 41 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 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 Marital Status No W H Allow Hours Worked Rate per Hour Amount Hours Worked Rate per Hour Amount Total Earnings 11 Carson, F S 1 $ $ $ $ $ 12 Wilson, W S 0 13 Utley, H M 2 21 Fife, L M 4 22 Smith, L S 2 31 Fay, G M 3 32 Robey, G M 6 33 Schork, T S 1 51 Hardy, B M 5 99 Kipley, C M 7 Totals $ $ $

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 08, 2024

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

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

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.

TIME CLERK'S REPORT NO. 1

For Period Ending January 8, 20--

Employee

Time Record

Time Worked*

Time Lost

Fran M. Carson

William A. Wilson

Harry T. Utley

2 hrs. tardy

Lawrence R. Fife

Lucy K. Smith

Gretchen R. Fay

Glenda B. Robey

Thomas K. Schork

Barbara T. Hardy

Carson C. Kipley

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.

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	Marital 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	1		$	$		$	$	$
12	Wilson, W.	S	0
13	Utley, H.	M	2
21	Fife, L.	M	4
22	Smith, L.	S	2
31	Fay, G.	M	3
32	Robey, G.	M	6
33	Schork, T.	S	1
51	Hardy, B.	M	5
99	Kipley, C.	M	7
Totals						$			$	$