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)
Chapter18: The Management Of Accounts Receivable And Inventories
Section: Chapter Questions
Problem 9P
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fed0d058c-e1eb-45a6-955b-51f1949f6cd6%2F928db876-64d2-453a-b99f-fdd636e71f32%2Fx66o5x7_processed.jpeg&w=3840&q=75)
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fed0d058c-e1eb-45a6-955b-51f1949f6cd6%2F928db876-64d2-453a-b99f-fdd636e71f32%2Fl9l6gu_processed.jpeg&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![EBK CONTEMPORARY FINANCIAL MANAGEMENT](https://www.bartleby.com/isbn_cover_images/9781337514835/9781337514835_smallCoverImage.jpg)
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
![College Accounting, Chapters 1-27](https://www.bartleby.com/isbn_cover_images/9781337794756/9781337794756_smallCoverImage.gif)
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
![EBK CONTEMPORARY FINANCIAL MANAGEMENT](https://www.bartleby.com/isbn_cover_images/9781337514835/9781337514835_smallCoverImage.jpg)
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
![College Accounting, Chapters 1-27](https://www.bartleby.com/isbn_cover_images/9781337794756/9781337794756_smallCoverImage.gif)
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
![Intermediate Financial Management (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781337395083/9781337395083_smallCoverImage.gif)
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage