Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

image text in transcribed

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

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

Step: 3

blur-text-image

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

Montgomerys Auditing Classic Reprint Series

Authors: Robert Hiester Montgomery

1st Edition

1390439356, 978-1390439359

More Books

Students also viewed these Accounting questions

Question

Please make it fast 4 6 1 .

Answered: 1 week ago

Question

Define Administration?

Answered: 1 week ago