Homework Help is Here – Start Your Trial Now!
Business
Accounting
Time Card No. Employee Name Hourty Wage or Salary Rob A. Mangino 11 $ 18.50 per hour Inga C. Flores Carson S. Palmetto 12 10.25 per hour 13 17.80 per hour 21 Randy F. Waters 20.70 per hour 22 Cathy T. Kroll 23.80 per hour 31 Carmen V. Ruppert 800 per week 32 William M. Scot 780 per week 33 Sarah A Wickman 3,500 per month 51 Lucas T. Foley 4,500 per month 90 Marshal W. Oiney 78,000 per year Ms. Carmen V. Ruppert prepares the time clerk's report for each pay period. Her report for the first week of operations is given on the following page. Using the payroll register for Olney Company, which is reproduced on a fold-out at the back of the book (PR-1), proceed as follows: 1. Enter each employee's time card number and name in the appropriate columns. 2. Record the regular hours and the overtime hours worked for each employee, using the time clerk's report as your reference. 3. Complete the Regular Earnings columns (Rate per Hour and Amount) and the Overtime Earnings columns (Rate per Hour and Time Record Time Time Employee Worked Lost 11 ROB A.MANGINO 40 12 INGA C.FLORES 8. 10 50 13 CARSON S.PALMETTO 5 8 38 1 hYs. tardy 21 RANDY F.W RS 10 10 47 22 CATHY T.KROLL 8. 31 CARMEN V.RUPPERT 41 32 WILLIAM M.SCOTT 40 33 SARAH A.WICKMAN 51 LUCAS T.POLBY 99 MARSHAL W.OLNEY 40

Time Card No. Employee Name Hourty Wage or Salary Rob A. Mangino 11 $ 18.50 per hour Inga C. Flores Carson S. Palmetto 12 10.25 per hour 13 17.80 per hour 21 Randy F. Waters 20.70 per hour 22 Cathy T. Kroll 23.80 per hour 31 Carmen V. Ruppert 800 per week 32 William M. Scot 780 per week 33 Sarah A Wickman 3,500 per month 51 Lucas T. Foley 4,500 per month 90 Marshal W. Oiney 78,000 per year Ms. Carmen V. Ruppert prepares the time clerk's report for each pay period. Her report for the first week of operations is given on the following page. Using the payroll register for Olney Company, which is reproduced on a fold-out at the back of the book (PR-1), proceed as follows: 1. Enter each employee's time card number and name in the appropriate columns. 2. Record the regular hours and the overtime hours worked for each employee, using the time clerk's report as your reference. 3. Complete the Regular Earnings columns (Rate per Hour and Amount) and the Overtime Earnings columns (Rate per Hour and Time Record Time Time Employee Worked Lost 11 ROB A.MANGINO 40 12 INGA C.FLORES 8. 10 50 13 CARSON S.PALMETTO 5 8 38 1 hYs. tardy 21 RANDY F.W RS 10 10 47 22 CATHY T.KROLL 8. 31 CARMEN V.RUPPERT 41 32 WILLIAM M.SCOTT 40 33 SARAH A.WICKMAN 51 LUCAS T.POLBY 99 MARSHAL W.OLNEY 40

Financial Accounting
Financial Accounting
15th Edition
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Carl Warren, James M. Reeve, Jonathan Duchac
Chapter11: Current Liabilities And Payroll
Section: Chapter Questions
Problem 4PA
See similar textbooks
icon
Related questions
Question

Payroll Accounting Class (2301-900)

Cengage - eBook Bieg/Toland's Payroll Accounting (2021, 31th Edition)

Chapter 2 - Computing Wages and Salaries

Chapter 2 - Continuing Problem 2B (Onley Company, Excel)

 

I need help finishing the Total Amount (last fourcells) for Regular Earnings and I need all four columns for OT Earnings

I will need the formula for the Amount and Total Earnings columns (example: =40*19.5)

below I have attached the homework assignment and the information given

Time Card No. Employee Name Hourly Wage or Salary $ 18.50 per hour 11 Rob A. Mangino 12 Inga C. Flores 19.25 per hour 13 Carson S. Palmetto 17.80 per hour 21 Randy F. Waters 20.70 per hour 22 Cathy T. Kroll 23.80 per hour 31 Carmen V. Ruppert 800 per week 32 William M. Scott 780 per week 33 Sarah A Wickman 3,500 per month 51 Lucas T. Foley 4,500 per month 99 Marshal W. Olney 78,000 per year Ms. Carmen V. Ruppert prepares the time clerk's report for each pay period. Her report for the first week of operations is given on the following page. Using the payroll register for Olney Company, which is reproduced on a fold-out at the back of the book (PR-1), proceed as follows: 1. Enter each employee's time card number and name in the appropriate columns. 2. Record the regular hours and the overtime hours worked for each employee, using the time clerk's report as your reference. 3. Complete the Regular Earnings columns (Rate per Hour and Amount) and the Overtime Earnings columns (Rate per Hour and Time Record Time Time Employee M. T W Worked Lost 11 ROB A.MANGINO 8. 40 - 12 INGA C.FLORES 10 50 13 CARSON S.PALMETTO 8. 6. 38 15 hrs. tordy 21 RANDY F.WATERS 10 10 11 47 22 CATHY T.KROLL 40 31 CARMEN V.RUPPERT 8. 41 32 WILLIAM M.SCOTT 8. 8. 8. 40 33 SARAH A HICKMAN 8. 40 51 LUCAS T.POLEY 8. 45 99 MARSHAL W.OLNEY 40 F.
Transcribed Image Text:Time Card No. Employee Name Hourly Wage or Salary $ 18.50 per hour 11 Rob A. Mangino 12 Inga C. Flores 19.25 per hour 13 Carson S. Palmetto 17.80 per hour 21 Randy F. Waters 20.70 per hour 22 Cathy T. Kroll 23.80 per hour 31 Carmen V. Ruppert 800 per week 32 William M. Scott 780 per week 33 Sarah A Wickman 3,500 per month 51 Lucas T. Foley 4,500 per month 99 Marshal W. Olney 78,000 per year Ms. Carmen V. Ruppert prepares the time clerk's report for each pay period. Her report for the first week of operations is given on the following page. Using the payroll register for Olney Company, which is reproduced on a fold-out at the back of the book (PR-1), proceed as follows: 1. Enter each employee's time card number and name in the appropriate columns. 2. Record the regular hours and the overtime hours worked for each employee, using the time clerk's report as your reference. 3. Complete the Regular Earnings columns (Rate per Hour and Amount) and the Overtime Earnings columns (Rate per Hour and Time Record Time Time Employee M. T W Worked Lost 11 ROB A.MANGINO 8. 40 - 12 INGA C.FLORES 10 50 13 CARSON S.PALMETTO 8. 6. 38 15 hrs. tordy 21 RANDY F.WATERS 10 10 11 47 22 CATHY T.KROLL 40 31 CARMEN V.RUPPERT 8. 41 32 WILLIAM M.SCOTT 8. 8. 8. 40 33 SARAH A HICKMAN 8. 40 51 LUCAS T.POLEY 8. 45 99 MARSHAL W.OLNEY 40 F.
10 11 FOR PERIOD ENDING 12 13 14 15 January 8, 20 -- REGULAR EARNINGS OVERTIME EARNINGS RATE PER HOUR TOTAL RATE PER HOUR 16 17 11 Mangino, R. EMPLOYEE AMOUNT AMOUNT EARNINGS 1 40 $ 18.50 740.00 18 12 Flores, L 19 13 Palmetto, C. 40 19.25 770.00 M 38.5 17.80 685.30 20 21 Waters, R. 40 20.70 828.00 21 22 Kroll, C. 22 31 Ruppert, C. 23 32 Scott, W. 2 40 23.80 952.00 M 3 40 800.00 M 4. 40 780.00 24 33 Wickman, S. 25 51 Foley, L. 26 99 Olney, M. 1. 40 M 5. 45 M 7. 40 27 Totals 29. STATUS 232|3 ALLOW. HA0 1O ON. WORKE HOURS
Transcribed Image Text:10 11 FOR PERIOD ENDING 12 13 14 15 January 8, 20 -- REGULAR EARNINGS OVERTIME EARNINGS RATE PER HOUR TOTAL RATE PER HOUR 16 17 11 Mangino, R. EMPLOYEE AMOUNT AMOUNT EARNINGS 1 40 $ 18.50 740.00 18 12 Flores, L 19 13 Palmetto, C. 40 19.25 770.00 M 38.5 17.80 685.30 20 21 Waters, R. 40 20.70 828.00 21 22 Kroll, C. 22 31 Ruppert, C. 23 32 Scott, W. 2 40 23.80 952.00 M 3 40 800.00 M 4. 40 780.00 24 33 Wickman, S. 25 51 Foley, L. 26 99 Olney, M. 1. 40 M 5. 45 M 7. 40 27 Totals 29. STATUS 232|3 ALLOW. HA0 1O ON. WORKE HOURS
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
College Accounting, Chapters 1-27
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
Century 21 Accounting Multicolumn Journal
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
Century 21 Accounting General Journal
Century 21 Accounting General Journal
Accounting
ISBN:
9781337680059
Author:
Gilbertson
Publisher:
Cengage
College Accounting (Book Only): A Career Approach
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781337280570
Author:
Scott, Cathy J.
Publisher:
South-Western College Pub
SEE MORE TEXTBOOKS