Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Thoni Manufacturing has gathered information from materials requisition sheets and labor time sheets for several jobs worked on during the last month and needs to
Thoni Manufacturing has gathered information from materials requisition sheets and labor time sheets for several jobs worked on during the last month and needs to calculate the job costs. Click here to view the Excel dataset. What is the total amount of direct materials added to work in process during the month? You will find the data in the materials tab of the data worksheet. (Round answer to 2 decimal places, eg. 1,524.54.) Total amount of direct materials $ e Textbook and Media What is the total amount of direct labor added to work in process during the month? You will find the data in the labor tab of the data worksheet. You will need to use the VLOOKUP function to find employee wage rates in the wage rate tab of the worksheet. Remember that time data is expressed in hours and minutes, while the wage rate is expressed on an hourly basis. You will need to convert minutes worked to their decimal equivalent before making the direct labor calculation. You may find the HOUR and MINUTE functions helpful for this calculation (HOUR(cell reference) + MINUTE(cell reference))/60. (Round answer to 2 decimal places, e.g. 1,524.54.) Total amount of direct labor $ e Textbook and Media Thoni Manufacturing uses direct labor hours to apply manufacturing overhead. The predetermined overhead rate is $200/DLH. What is the total amount of manufacturing overhead applied to work in process during the month? (Round answer to 2 decimal places, e.g. 1,524.54.) Total amount of manufacturing overhead applied $ samdi Thoni Manufacturing has gathered information from materials requisition sheets and labor time sheets for several jobs worked on during the last month and needs to calculate the job costs. Click here to view the Excel dataset. What is the total amount of direct materials added to work in process during the month? You will find the data in the materials tab of the data worksheet. (Round answer to 2 decimal places, eg. 1,524.54.) Total amount of direct materials $ e Textbook and Media What is the total amount of direct labor added to work in process during the month? You will find the data in the labor tab of the data worksheet. You will need to use the VLOOKUP function to find employee wage rates in the wage rate tab of the worksheet. Remember that time data is expressed in hours and minutes, while the wage rate is expressed on an hourly basis. You will need to convert minutes worked to their decimal equivalent before making the direct labor calculation. You may find the HOUR and MINUTE functions helpful for this calculation (HOUR(cell reference) + MINUTE(cell reference))/60. (Round answer to 2 decimal places, e.g. 1,524.54.) Total amount of direct labor $ e Textbook and Media Thoni Manufacturing uses direct labor hours to apply manufacturing overhead. The predetermined overhead rate is $200/DLH. What is the total amount of manufacturing overhead applied to work in process during the month? (Round answer to 2 decimal places, e.g. 1,524.54.) Total amount of manufacturing overhead applied $ samdi
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started