Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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)

image text in transcribedimage text in transcribed 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: 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: 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. Calculate the direct materials, direct labor, factory overhead, and total costs for each job started in June. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Complete this question by entering your answers in the tabs below. 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.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Wiley CIA Exam Review Test Bank Part 1 Essentials Of Internal Auditing

Authors: S. Rao Vallabhaneni

1st Edition

1119987237, 978-1119987239

More Books

Students also viewed these Accounting questions

Question

2. Are my sources up to date?

Answered: 1 week ago