Step 1: Calculate the estimated total manufacturing overhead cost for each department. File Home Insert Page...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Step 1: Calculate the estimated total manufacturing overhead cost for each department. File Home Insert Page Layout Formulas Data Review View Automate Help Milling Department Overhead Cost (Y)= $390,000+ ($2.00 per MH x 60,000 MHs) $390,000+ $120,000 X Cut Arial 10 Wrap Text = $510,000 Copy Paste BIU A Merge & Center Assembly Department Overhead Cost (Y) = $500,000+ ($3.75 per DLH 80,000 DLHs) = $500,000+ $300,000 = $800,000 Format Painter Clipboard Font Alignment C28 XVfx ? Step 2: Calculate the predetermined overhead rate in each department. A B D Milling Department Overhead Rate = $510,000/60,000 machine-hours = $8.50 per machine-hour Assembly Department Overhead Rate = $800,000/80,000 direct labor-hours = $10.00 per direct labor-hour Step 3: Calculate the amount of overhead applied from both departments to Job 407. Milling Department: Overhead Applied to Job 407 = $8.50 per MH 90 MHs = $765 Assembly Department: Overhead Applied to Job 407 $10.00 per DLH 20 DLHS = $200 Step 4: Calculate the total job cost for Job 407. 8 Machine-hours 9 Direct labor-hours 10 Total fixed manufacturing overhead cost 11 Variable manufacturing overhead per machine-hour 12 Variable manufacturing overhead per direct labor-hour 13 14 Cost summary for Job 407 15 16 Machine-hours 17 Direct labor-hours 1 Chapter 2: Applying Excel 2 3 Data 4 Markup on job cost 5 6 7 75% Department Milling Assembly 60,000 8,000 3,000 80,000 $390,000 $500,000 $2.00 $3.75 Department Milling Assembly 90 5 4 20 $800 $370 $70 $280 18 Direct materials 19 Direct labor cost Milling Direct materials $ 800 Assembly $ 370 Total $ 1,170 20 21 Enter a formula into each of the cells marked with a ? below Direct labor $ 70 $ 280 350 22 Manufacturing overhead applied $ 765 $ 200 965 $ 2,485 23 Step 1: Calculate the estimated total manufacturing overhead cost for each department 24 25 Total fixed manufacturing overhead cost Total cost of Job 407 Step 5: Calculate the selling price for Job 407. Markup ($2,485 75%) Total cost of Job 407 $ 2,485.00 1,863.75 Selling price of Job 407 $ 4,348.75 26 Variable manufacturing overhead per machine-hour or direct labor-hour 27 Total machine-hours or direct labor-hours 28 Total variable manufacturing overhead Milling Assembly $390,000 $500,000 $2.00 $3.75 90 4 ? ? ? 29 Total manufacturing overhead 30 31 Step 2: Calculate the predetermined overhead rate in each department 32 33 Total manufacturing overhead Milling Assembly ? ? 34 Total machine-hours or direct labor-hours ? 35 Predetermined overhead rate per machine-hour or direct labor-hour ? ? ? 36 37 Step 3: Calculate the amount of overhead applied from both departments to Job 407 38 Milling Assembly 39 Predetermined overhead rate per machine-hour or direct labor-hour ? 40 Machine-hours or direct labor-hours for the job ? ? ? ? ? 41 Manufacturing overhead applied 42 43 Step 4: Calculate the total job cost for Job 407 < > Chapter 2 Form + Step 1: Calculate the estimated total manufacturing overhead cost for each department. File Home Insert Page Layout Formulas Data Review View Automate Help Milling Department Overhead Cost (Y)= $390,000+ ($2.00 per MH x 60,000 MHs) $390,000+ $120,000 X Cut Arial 10 Wrap Text = $510,000 Copy Paste BIU A Merge & Center Assembly Department Overhead Cost (Y) = $500,000+ ($3.75 per DLH 80,000 DLHs) = $500,000+ $300,000 = $800,000 Format Painter Clipboard Font Alignment C28 XVfx ? Step 2: Calculate the predetermined overhead rate in each department. A B D Milling Department Overhead Rate = $510,000/60,000 machine-hours = $8.50 per machine-hour Assembly Department Overhead Rate = $800,000/80,000 direct labor-hours = $10.00 per direct labor-hour Step 3: Calculate the amount of overhead applied from both departments to Job 407. Milling Department: Overhead Applied to Job 407 = $8.50 per MH 90 MHs = $765 Assembly Department: Overhead Applied to Job 407 $10.00 per DLH 20 DLHS = $200 Step 4: Calculate the total job cost for Job 407. 8 Machine-hours 9 Direct labor-hours 10 Total fixed manufacturing overhead cost 11 Variable manufacturing overhead per machine-hour 12 Variable manufacturing overhead per direct labor-hour 13 14 Cost summary for Job 407 15 16 Machine-hours 17 Direct labor-hours 1 Chapter 2: Applying Excel 2 3 Data 4 Markup on job cost 5 6 7 75% Department Milling Assembly 60,000 8,000 3,000 80,000 $390,000 $500,000 $2.00 $3.75 Department Milling Assembly 90 5 4 20 $800 $370 $70 $280 18 Direct materials 19 Direct labor cost Milling Direct materials $ 800 Assembly $ 370 Total $ 1,170 20 21 Enter a formula into each of the cells marked with a ? below Direct labor $ 70 $ 280 350 22 Manufacturing overhead applied $ 765 $ 200 965 $ 2,485 23 Step 1: Calculate the estimated total manufacturing overhead cost for each department 24 25 Total fixed manufacturing overhead cost Total cost of Job 407 Step 5: Calculate the selling price for Job 407. Markup ($2,485 75%) Total cost of Job 407 $ 2,485.00 1,863.75 Selling price of Job 407 $ 4,348.75 26 Variable manufacturing overhead per machine-hour or direct labor-hour 27 Total machine-hours or direct labor-hours 28 Total variable manufacturing overhead Milling Assembly $390,000 $500,000 $2.00 $3.75 90 4 ? ? ? 29 Total manufacturing overhead 30 31 Step 2: Calculate the predetermined overhead rate in each department 32 33 Total manufacturing overhead Milling Assembly ? ? 34 Total machine-hours or direct labor-hours ? 35 Predetermined overhead rate per machine-hour or direct labor-hour ? ? ? 36 37 Step 3: Calculate the amount of overhead applied from both departments to Job 407 38 Milling Assembly 39 Predetermined overhead rate per machine-hour or direct labor-hour ? 40 Machine-hours or direct labor-hours for the job ? ? ? ? ? 41 Manufacturing overhead applied 42 43 Step 4: Calculate the total job cost for Job 407 < > Chapter 2 Form +
Expert Answer:
Related Book For
Managerial Accounting Decision Making and Motivating Performance
ISBN: 978-0137024872
1st edition
Authors: Srikant M. Datar, Madhav V. Rajan
Posted Date:
Students also viewed these accounting questions
-
STAFF PERFORMANCE ANALYSIS POINTS: 30 Description and instructions: For this assignment, you are provided data on HIM staff and a quarterly performance report. You are asked to offer analysis of the...
-
Recognition accuracy that measures the percentage of orders that are taken correctly is 86.8%. Suppose that you place order with the bot and two friends of yours independently place orders with the...
-
Consider the following statements about a system of linear equations with augmented matrix A. In each case either prove the statement or give an example for which it is false. (a) If the system is...
-
In Exercises solve the differential equation. Use a graphing utility to graph three solutions, one of which passes through the given point. dr dt sec t tant + 1' (T, 4)
-
Reconsider the data from Problem 56. What is the capital recovery cost of Model 127B? Data from problem 56 Octavia Bakery is planning to purchase one of two ovens. The expected cash flows for each...
-
Glee Distribution markets CDs of the performing artist Unique. At the beginning of October, Glee had in beginning inventory 2,000 of Uniques CDs with a unit cost of $7. During October, Glee made the...
-
Phelps competed at the Olympics. He won several gold medals and cash prizes, all worth $300,000. In addition, in the year that Phelps competed in the Olympics, he received several commercial...
-
Consider a feedback control system with a PID controller: R + Kp + K S C(s) + KDS + + D 1 S +3.65 +9 P(s) Y where R, D, and Yare reference, disturbance, and output respectively. C(s) and P(s) are...
-
Statement 1: The debt to total assets ratio will go up if an equal amount of assets and liabilities are added to the balance sheet. Statement 2: Under IFRS, subsidiaries in which the parent company...
-
Select all that apply Minority-passive equity investments generally Multiple select question. have changes in fair value accounted for in net income. are accounted for at fair value. are accounted...
-
Discuss a means used by the World Bank or the World Trade Organization that might assist the developing country in removing barriers to contributing to the global economy
-
Herb, an accountant, helps Industrial Company prepare and file a false federal corporate income tax return. Under the Internal Revenue Code, a felony punishable by a fine and imprisonment. no...
-
Explain the important of treating each patient as a guest in the image department? compare programmatic accreditation with the institutional accreditation? describe cognitive, affective, and...
-
Texas Instruments was referred to in the chapter as being an innovator in the calculator industry. But that is only one of its products. Let's see how this large company is doing today. Go to...
-
For the next several days, take notes on your listening performance during at least a half-dozen situations in class, during social activities, and at work, if applicable. Referring to the traits of...
-
Explain how an ABS is structured.
-
Explain how an ABS CDO is structured.
-
Why do you think we would want to draw these two extra lines onto the handwritten account?
Study smarter with the SolutionInn App