Homework Help is Here – Start Your Trial Now!
Business
Accounting
Show the solution in excel Required: - Schedule of labor hours and schedule of labor costs (Factory payroll distribution sheet)

Show the solution in excel Required: - Schedule of labor hours and schedule of labor costs (Factory payroll distribution sheet)

FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
See similar textbooks
icon
Related questions
Question
Show the solution in excel Required: - Schedule of labor hours and schedule of labor costs (Factory payroll distribution sheet)
NN Company operates on a 6-day week, with time and one-quarter for all hours over eight during the regular days. The time cards for the week ending November 30 showed: Rate/hr P120 No. Name Mon Tues Wed Thurs Fri Sat 001 Jake 8. 8 8 8 8 8 002 Tibs 8 8 8 6 7 4 80 003 Ramon 8 8 8 8 4 70 004 Teddy 8. 8 8. 8 4 70 005 Art 9. 8 9 70 006 Rene Aga 9 8 8 9. 4 80 007 9 8 8 4 4 80
Transcribed Image Text:NN Company operates on a 6-day week, with time and one-quarter for all hours over eight during the regular days. The time cards for the week ending November 30 showed: Rate/hr P120 No. Name Mon Tues Wed Thurs Fri Sat 001 Jake 8. 8 8 8 8 8 002 Tibs 8 8 8 6 7 4 80 003 Ramon 8 8 8 8 4 70 004 Teddy 8. 8 8. 8 4 70 005 Art 9. 8 9 70 006 Rene Aga 9 8 8 9. 4 80 007 9 8 8 4 4 80
An analysis of the job time tickets and payroll records showed: No. Job No. Mon Tues Wed Thurs Fri Sat 001 Supervisor 701 8 8 8 8. 002 7 6 - 702 2 2 7 4 003 701 4 702 8. 4 004 702 4 2 4 703 8 7 005 703 6 7 4 8 7 704 2 2 2 006 704 4 7 6. 4 4 4 705 4 2 4 007 704 8 4 3 2 4 4 705 Previous earnings in June (November 1 – 24) No. 001 19,210.00 002 16,204.00 003 12,814.00 004 12,706.00 005 12,528.00 006 16,102.00 007 14,538.00 AT
Transcribed Image Text:An analysis of the job time tickets and payroll records showed: No. Job No. Mon Tues Wed Thurs Fri Sat 001 Supervisor 701 8 8 8 8. 002 7 6 - 702 2 2 7 4 003 701 4 702 8. 4 004 702 4 2 4 703 8 7 005 703 6 7 4 8 7 704 2 2 2 006 704 4 7 6. 4 4 4 705 4 2 4 007 704 8 4 3 2 4 4 705 Previous earnings in June (November 1 – 24) No. 001 19,210.00 002 16,204.00 003 12,814.00 004 12,706.00 005 12,528.00 006 16,102.00 007 14,538.00 AT
Expert 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:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS