Step 1: Calculate the estimated total manufacturing overhead cost for each department. Milling Department Overhead Cost...
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. Milling Department Overhead Cost (Y)= $390,000+ ($2.00 per MH x 60,000 MHs) $390,000+ $120,000 = $510,000 Assembly Department Overhead Cost (Y) = $500,000+ ($3.75 per DLH 80,000 DLHs) = $500,000+ $300,000 = $800,000 Step 2: Calculate the predetermined overhead rate in each department. 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. Ope C36 Format Painter Clipboard Edit fx A Hist 1 Chapter 2: Applying Excel 2 3 Data 4 Markup on job cost 5 6 7 Font 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 18 Direct materials 19 Direct labor cost Alignment B C D E 75% Department Milling Assembly 60,000 8,000 $390,000 3,000 80,000 $500,000 $2.00 $3.75 Department Milling Assembly 90 4 5 $800 20 $370 $70 $280 20 21 Enter a formula into each of the cells marked with a ? below 22 23 Step 1: Calculate the estimated total manufacturing overhead cost for each department 24 Milling Assembly 25 Total fixed manufacturing overhead cost Milling Direct materials $ 800 Direct labor $ 70 Assembly $ 370 $ 280 Total 26 Variable manufacturing overhead per machine-hour or direct labor-hour $390,000 $2.00 $500,000 $3.75 $ 1,170 27 Total machine-hours or direct labor-hours 90 4 350 28 Total variable manufacturing overhead ? ? Manufacturing overhead applied $ 765 $ 200 965 29 Total manufacturing overhead $510,000 $800,000 30 Total cost of Job 407 Step 5: Calculate the selling price for Job 407.. $ 2,485 31 Step 2: Calculate the predetermined overhead rate in each department 32 Milling Assembly 33 Total manufacturing overhead ? ? 34 Total machine-hours or direct labor-hours ? ? Total cost of Job 407 $ 2,485.00 Markup ($2,485 x 75%) 1.863.75 Selling price of Job 407 $ 4.348.75 35 Predetermined overhead rate per machine-hour or direct labor-hour $8.50 $10.00 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 2 ? 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 44 45 Direct materials 46 Direct labor cost 47 Manufacturing overhead applied 48 Total cost of Job 407 49 50 Step 5: Calculate the selling price for Job 407 51 Total cost of Job 407 52 Markup 53 Selling price of Job 407 54 55 Milling Assembly Total ? ? ? ? ? ? ? ? ? ? 2 ? ? Numbe Step 1: Calculate the estimated total manufacturing overhead cost for each department. Milling Department Overhead Cost (Y)= $390,000+ ($2.00 per MH x 60,000 MHs) $390,000+ $120,000 = $510,000 Assembly Department Overhead Cost (Y) = $500,000+ ($3.75 per DLH 80,000 DLHs) = $500,000+ $300,000 = $800,000 Step 2: Calculate the predetermined overhead rate in each department. 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. Ope C36 Format Painter Clipboard Edit fx A Hist 1 Chapter 2: Applying Excel 2 3 Data 4 Markup on job cost 5 6 7 Font 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 18 Direct materials 19 Direct labor cost Alignment B C D E 75% Department Milling Assembly 60,000 8,000 $390,000 3,000 80,000 $500,000 $2.00 $3.75 Department Milling Assembly 90 4 5 $800 20 $370 $70 $280 20 21 Enter a formula into each of the cells marked with a ? below 22 23 Step 1: Calculate the estimated total manufacturing overhead cost for each department 24 Milling Assembly 25 Total fixed manufacturing overhead cost Milling Direct materials $ 800 Direct labor $ 70 Assembly $ 370 $ 280 Total 26 Variable manufacturing overhead per machine-hour or direct labor-hour $390,000 $2.00 $500,000 $3.75 $ 1,170 27 Total machine-hours or direct labor-hours 90 4 350 28 Total variable manufacturing overhead ? ? Manufacturing overhead applied $ 765 $ 200 965 29 Total manufacturing overhead $510,000 $800,000 30 Total cost of Job 407 Step 5: Calculate the selling price for Job 407.. $ 2,485 31 Step 2: Calculate the predetermined overhead rate in each department 32 Milling Assembly 33 Total manufacturing overhead ? ? 34 Total machine-hours or direct labor-hours ? ? Total cost of Job 407 $ 2,485.00 Markup ($2,485 x 75%) 1.863.75 Selling price of Job 407 $ 4.348.75 35 Predetermined overhead rate per machine-hour or direct labor-hour $8.50 $10.00 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 2 ? 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 44 45 Direct materials 46 Direct labor cost 47 Manufacturing overhead applied 48 Total cost of Job 407 49 50 Step 5: Calculate the selling price for Job 407 51 Total cost of Job 407 52 Markup 53 Selling price of Job 407 54 55 Milling Assembly Total ? ? ? ? ? ? ? ? ? ? 2 ? ? Numbe
Expert Answer:
Related Book For
Managerial Accounting
ISBN: 9781260247787
17th Edition
Authors: Ray Garrison, Eric Noreen, Peter Brewer
Posted Date:
Students also viewed these accounting questions
-
The average total dollar purchase at a convenience store is less than that at a supermarket. Despite smaller-ticket purchases, convenience stores can still be profitable because of the size of...
-
What global and international considerations should be made when conducting business?
-
The CIO of a major company is studying the use of the company's email service for non-business communications, which is against company policy. The CIO wants to estimate the proportion of email...
-
What will be the sum of third proportional to 18 and 54 and fourth proportional to 12, 18 and LCM of 12 and 18? 1. 162 2. 216 3. 612 4. 256 526 5.
-
Solve Problem using Gauss-Jordan elimination. 4x1 - 2x2 + 2x3 = 5 -6x1 + 3x2 - 3x3 = -2 10x1 - 5x2 + 9x3 = 4
-
Ivan's Diner received the following bills for December 2018 utilities: - Electricity: \(\$ 850\) on December 29, 2018 - Telephone: \(\$ 475\) on January 5, 2019 Both bills were paid on January 10,...
-
What could you suggest to Graham to improve the decision-making process in his organization? Graham ruled with an iron will. He felt that the only way to motivate his employees was by giving them...
-
Addison Corporation has ten million shares of common stock issued and outstanding. On June 1 the board of directors voted a 60 cents per share cash dividend to stockholders of record as of June 14,...
-
(1 point) A fence is to be built to enclose a rectangular area of 250 square feet. The fence along three sides is to be made of material that costs 3 dollars per foot, and the material for the fourth...
-
Walmart makes significant investments in operating capacity, primarily via investments in property, plant, and equipment, but also via investments in wholly and partially owned subsidiaries. Walmart...
-
Youre late for work because you overslept, but your boss hatesover-sleepers. He does love entertaining stories, so create themost outlandish excuse as to why you were late. Write a minimum ofone page.
-
If the price of oil falls, should the consortium of foreign oil companies try to renegotiate the contract with the Kazakh government? With an estimated 13 billion barrels of oilmaking it the fifth...
-
Review the stereotypes of people from different cultures in the chapters International Aspects section. Are those stereotypes shared by other students in your class? If students from other countries...
-
The Hudson Jewelers case study can be found in Appendix C. Chapter 18 Case Questions for Discussion: 1.Write a short paper (maximum of two pages) on how the four principles of lean operating systems...
-
On June 1, Meadow Company sold merchandise with a list price of \(\$ 40,000\). For each of the sales terms below, determine the proper amount of cash received: Credit Terms Date Paid 1234 1. 2/10,...
-
Tell me about a challenging cultural team experience you have had and how you handled it.31
-
You are the junior accountant at CBW Bank. You have been asked to assist with the 30 June 2021 tax work: As part of the bank manager's contract she was provided with a BMW luxury motor vehicle for...
-
Prepare a stock card using the following information A company is registered for GST which it pays quarterly, assume GST was last paid on the 30th of June 2019. It uses weighted average cost...
-
The dot.com business has raised many issues about accounting practices, some of which are of great concern to both the SEC and the FASB. Important ones relate to the valuation and classification of...
-
Graph 19 Identify each type of graph in the given figure: tree graph, star graph, starlike graph, line graph, lobster graph, caterpillar graph, and/or forest graph. B C Graph 19 d d a D b h 9 Graph 20
-
Three spanning trees of Graph \(A\), which include both edges be and \(d e\). Use the figure shown to draw three possible spanning trees that fit the given description. b C d e f Graph A m n P Graph K
Study smarter with the SolutionInn App