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.

1.) 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

$enter the total amount of direct materials in dollars

2.) 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

$enter the total amount of direct labor in dollars

3.) 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

$enter the total amount of manufacturing overhead applied in dollars