Continuing Payroll Problem, 2A: Chapter 2
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:
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:
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.
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 |
Continuing Payroll Problem, 2A: Chapter 2 Kipley Company is a small manufacturing firm located in Pittsburgh,...
Continuing Payroll Problem, 2B: Chapter 2 Olney Company, Inc. is a small manufacturing firm located in Newtown, 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...
Continuing Payroll Problem, 2B: Chapter 2 Olney Company, Inc. is a small manufacturing firm located in Allentown, 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...
Help on this problem would be immensely appreciated.
Instructions Continuing Payroll Problem: Chapter 3 As you learned in the previous chapter, Kipley Company is a small manufacturing firm located in Pittsburgh, Pennsylvania. The company has a workforce of both hourly and salaried employees. In the last chapter, gross wages were computed for each employee. Adjacent to their name, each employee's gross wages are shown in the Payroll Register. The next task is computing the FICA withholding for each employee and...
may someone help me to find the Net Pay at the second page
please!!
. Excel Project #8: Kipley Company Payroll Register: Download the Excel file below these instructions and save it as Excel8_lyour initials). • Follow the directions for each column, to enter the information in the Payroll Register, using formulas when appropriate Regular Earnings: Employee Hours Worked Rate per Hour Amount Carson, F. 40 17.50 Use a formula to calculate Wilson, W. 40 17 25 Use a formula...
You have almost completed the Kipley Company's Employee Payroll Register for the pay period ending January 8, 20--. In this last task, the following steps will be completed. Requirements: Record the deduction for group insurance. Record the health insurance deduction. Record the check number assigned to each employee. Compute and record the net pay for each employee. Total the input columns on the Employee Payroll register. On Employer Register, enter total gross earnings. Prepare the journal entries as of January...
Calculate Payroll K. Mello Company has three employees-a consultant, a computer programmer, and an administrator. The following payroll information is available for each employee: Consultant Computer Programmer Administrator Regular earnings rate $2,710 per week $34 per hour $50 per hour Overtime earnings rate Not applicable 2 times hourly rate 1.5 times hourly rate Federal income tax withheld $910 $252 $500 For hourly employees, overtime is paid for hours worked in excess of 40 hours per week. For the current pay...
OEX71-10 Calculate payroll Obj. 2 Breakin Away Company has three employees-a consultant, a computer programmer, and an administrator. The following payroll information is available for each employee: Show Consultantc $4,000 per week Not applicable Computer Pregrammer Regular earnings rate Overtime earnings rate Number of withholding allowances $60 per hour 1.5 times hourly rate 550 per hour 2 times hourly rate or hourly employees overtime is paid for hours worked in excess of 40 hours per week. For the current pay...
Calculate Payroll computer programmer, and an administrator. The following payroll information is available for each K. Mello Company has three employees-a consultant, employee Administrator Consultant Computer Programmer $3,110 per week Regular earnings rate $36 per hour $44 per hour Overtime earnings rate 1.5 times hourly rate Not applicable 2 times hourly rate Federal income tax withheld $930 $244 $510 For hourly employees, overtime is paid for hours worked in excess of 40 hours per week. For the current pay period,...
Calculate Payroll K. Mello Company has three employees-a consultant, a computer programmer, and an administrator. The following payroll information is available for each employee: Consultant Computer Programmer Administrator Regular earnings rate $36 per hour $3,010 per week Not applicable $48 per hour 1.5 times hourly rate Overtime earnings rate 2 times hourly rate Federal income tax withheld $930 $246 $505 For hourly employees, overtime is paid for hours worked in excess of 40 hours per week. For the current pay...
Calculate Payroll K. Mello Company has three employees-a consultant, a computer programmer, and an administrator. The following payroll information is available for each employee: Consultant Computer Programmer Administrator Regular earnings rate $3,010 per week $36 per hour $50 per hour Overtime earnings rate Not applicable 2 times hourly rate 1.5 times hourly rate Federal income tax withheld $910 $258 $515 For hourly employees, overtime is paid for hours worked in excess of 40 hours per week. For the current pay...