• 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, e.g. 1,524.54.)

Total amount of direct materials$____________

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$________________

Data sheets and questions have been posted on course hero.. but the answers are not obvious. NEED answers to fill the boxes.

THE LINK BELOW HAS THE EXCEL DATA SHEETS AVAILABLE AS I CANNOT LINK THEM.

https://www.coursehero.com/u/file/72303962/Copy-of-Using-Excel-Job-Order-Costingxlsx/?justUnlocked=1#question

assessment.education.wiley.com C + Is\\ Chapter 4 HW: Sutterfield, Baylee B. W NWP Assessment Player UI Application - Chapter 4 HW Question 5 of 6 View Policies Current Attempt in Progress 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, e.g. 1,524.54.) Total amount of direct materials 674467.99 to eTextbook 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 the6 Chapter 4 HW Question 5 of6 - / 5 '= iassessmenteducation.wiley.com C {} + W NWP Assessment Player Ul Application What is the total amount of direct labor added to work in process during the month? You will nd the data in the labor tab of the data worksheet. You will need to use the VLOOKUP function to nd 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 nd the HOUR and MINUTE functions helpful for this calculation (HOUR(cell reference) + MINUTE(ce|| reference))/60. (Round answer to 2 decimal places, e.g. 1,524.54.) Total amount of direct labor $ eTextbook 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 $