Homework Help is Here – Start Your Trial Now!
Business
Accounting
Decker Screw Manufacturing Company produces special screws made to customer specifications. During June, the following data pertained to these costs: Department Number 1 2 1 1 2 Department Number 1 2 1 2 1 Department Number 1 2 Summary of Direct Materials Requisitions Job Requisition Number Number Quantity 2906 4,850 2907 170 2908 2906 2908 B9766 B9767 B9768 B9769 B9770 1,120 4,730 29 Cost per Unit $ 1.30 22.00 9.00 1.31 48.00 Summary of Direct Labor Time Tickets Job Ticket Cost per Number Number Hours 2906 1056-1168 1,114 2907 2121-2130 2908 1169-1189 2908 2131-1239 2906 1190-1239 148 163 44 822 Unit $ 6.50 9.00 6.50 9.00 6.50 Summary of Factory Overhead Application Rates Basis of Application Rates $3 per direct labor hour 150% of direct labor cost Decker had no beginning Work-in-Process Inventory for June. Of the jobs begun in June, Job 2906 was completed and sold on account for $30,000, Job 2907 was completed but not sold, and Job 2908 was still in process. Required:

Decker Screw Manufacturing Company produces special screws made to customer specifications. During June, the following data pertained to these costs: Department Number 1 2 1 1 2 Department Number 1 2 1 2 1 Department Number 1 2 Summary of Direct Materials Requisitions Job Requisition Number Number Quantity 2906 4,850 2907 170 2908 2906 2908 B9766 B9767 B9768 B9769 B9770 1,120 4,730 29 Cost per Unit $ 1.30 22.00 9.00 1.31 48.00 Summary of Direct Labor Time Tickets Job Ticket Cost per Number Number Hours 2906 1056-1168 1,114 2907 2121-2130 2908 1169-1189 2908 2131-1239 2906 1190-1239 148 163 44 822 Unit $ 6.50 9.00 6.50 9.00 6.50 Summary of Factory Overhead Application Rates Basis of Application Rates $3 per direct labor hour 150% of direct labor cost Decker had no beginning Work-in-Process Inventory for June. Of the jobs begun in June, Job 2906 was completed and sold on account for $30,000, Job 2907 was completed but not sold, and Job 2908 was still in process. Required:

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

kk.

Subject :- Accounting 

 

Required: 1. Calculate the direct materials, direct labor, factory overhead, and total costs for each job started in June. 2. Perform the same calculations as in requirement 1, but assume that the direct labor rate per hour increased by 10% in Department 1 and 25% in Department 2. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Perform the same calculations as in requirement 1, but assume that the direct labor rate per hour increased by 10% in Department 1 and 25% in Department 2. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Direct materials Direct labor Factory overhead Total job cost $ $ Job 2906 13,023.30 x $ 13,956.80 x 5,856.00 x 32,836.10 $ Job 2907 4,620.00 $ 1,755.00 X 2,632.50 x 9,007.50 $ Job 2908 12,384.00 $ 1,807.65 x 663.00 x 14,854.65 $ Total 30,027.30 17,519.45 9,151.50 56,698.25
Transcribed Image Text:Required: 1. Calculate the direct materials, direct labor, factory overhead, and total costs for each job started in June. 2. Perform the same calculations as in requirement 1, but assume that the direct labor rate per hour increased by 10% in Department 1 and 25% in Department 2. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Perform the same calculations as in requirement 1, but assume that the direct labor rate per hour increased by 10% in Department 1 and 25% in Department 2. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Direct materials Direct labor Factory overhead Total job cost $ $ Job 2906 13,023.30 x $ 13,956.80 x 5,856.00 x 32,836.10 $ Job 2907 4,620.00 $ 1,755.00 X 2,632.50 x 9,007.50 $ Job 2908 12,384.00 $ 1,807.65 x 663.00 x 14,854.65 $ Total 30,027.30 17,519.45 9,151.50 56,698.25
! Required information Use the data below to create Pivot Table(s) in Excel. You will use the pivot table(s) to fill out your answers in the requirements (worksheets) in Part 2. Submit your Excel File containing the Pivot Tables in Part 3. Decker Screw Manufacturing Company produces special screws made to customer specifications. During June, the following data pertained to these costs: Department Number 1 2 1 1 2 Department Number 1 2 - NTN 1 2 1 Department Number 1 2 Summary of Direct Materials. Requisitions Job Requisition Number Number Quantity 2906 B9766 4,850 2907 B9767 170 2908 B9768 1,120 2906 B9769 4,730 2908 B9770 29 Cost per Unit $ 1.30 22.00 9.00 1.31 48.00 Summary of Direct Labor Time Tickets Job Ticket Number Number Cost per Unit $ 6.50 9.00 Hours 2906 1056-1168 1,114 2907 2121-2130 2908 1169-1189 2908 2131-1239 2906 1190-1239 6.50 9.00 6.50 148 163 44 822 Summary of Factory Overhead Application Rates Basis of Application Rates $3 per direct labor hour 150% of direct labor cost Decker had no beginning Work-in-Process Inventory for June. Of the jobs begun in June, Job 2906 was completed and sold on account for $30,000, Job 2907 was completed but not sold, and Job 2908 was still in process. Required:
Transcribed Image Text:! Required information Use the data below to create Pivot Table(s) in Excel. You will use the pivot table(s) to fill out your answers in the requirements (worksheets) in Part 2. Submit your Excel File containing the Pivot Tables in Part 3. Decker Screw Manufacturing Company produces special screws made to customer specifications. During June, the following data pertained to these costs: Department Number 1 2 1 1 2 Department Number 1 2 - NTN 1 2 1 Department Number 1 2 Summary of Direct Materials. Requisitions Job Requisition Number Number Quantity 2906 B9766 4,850 2907 B9767 170 2908 B9768 1,120 2906 B9769 4,730 2908 B9770 29 Cost per Unit $ 1.30 22.00 9.00 1.31 48.00 Summary of Direct Labor Time Tickets Job Ticket Number Number Cost per Unit $ 6.50 9.00 Hours 2906 1056-1168 1,114 2907 2121-2130 2908 1169-1189 2908 2131-1239 2906 1190-1239 6.50 9.00 6.50 148 163 44 822 Summary of Factory Overhead Application Rates Basis of Application Rates $3 per direct labor hour 150% of direct labor cost Decker had no beginning Work-in-Process Inventory for June. Of the jobs begun in June, Job 2906 was completed and sold on account for $30,000, Job 2907 was completed but not sold, and Job 2908 was still in process. Required:
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Cost Sheet
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
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