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 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. 3x1 - 9x2 + 12x3 = 6 -2x1 + 6x2 - 8x3 = -4
-
What is the unit of work in the MKS system of units? What is the unit of torque in the MKS system of units? Can work and torque have the same units? N.m What is the torque of a 20 N perpendicular...
-
Describe the difference between concrete and abstract classes and give an example for each.
-
1. Wages and prices will increase when actual output exceeds potential. __________(True/False) 2. The short run in macroeconomics is the time period over which __________do not adjust to economic...
-
Question 1 of 42\ Use the following T-Account for "Income Taxes Payable," a liability for income tax that a company owes to the government, to solve for how much the company paid in cash taxes over...
-
7) A petty cash fund was originally established with a check for $100. On August 31, which is the period end, the petty cash fund included the following: Petty Cash Receipts: Postage Office Supplies...
-
The total number of points scored in Super Bowl football games and the changes in the Dow Jones Industrial stock index in the years following those games Exercises 916, list pairs of variables. For...
-
Normalize this form: Purchase Order (Customer copy) Order: 345 To: Jack Trout Swillbuckets Club West Yorkshire 8/12/2002 From: Cooper's Brewery 15 Brewery St Fillem Product No Name Quantity Price 10...
-
A proton \(\mathrm{p}_{1}\) moving in the Earth reference frame collides with a proton \(p_{2}\) that is at rest in that reference frame. The collision creates a particle that has mass \(m\) and an...
-
The Iorentz. Cup spaceship race is won by the pilot who can travel \(1.00 \times 10^{9} \mathrm{~m}\) in the shortest time interval. The rules state that the start and finish lines must be \(10^{9}...
-
The weights and costs of 50 different bags of apples. Exercises 916, list pairs of variables. For each pair, state whether you believe the two variables are correlated. If you believe they are...
-
Exercise F-1 Future value and present value To determine the appropriate discount factor(s) using tables, click here to view Tables I, II, III, or IV in the appendix. Alternatively, if you calculate...
-
Flicker, Inc., a closely held corporation, acquired a passive activity this year. Gross income from operations of the activity was $160,000. Operating expenses, not including depreciation, were...
-
Calculate: (a) \(f=a /(b c)\), where \(a=2.34\mathrm{~mm}^{2}, b=54.26\mathrm{~m}\), and \(c=0.14\mu \mathrm{m}\); (b) \(g=k t^{3}\), where \(k=1.208\times 10^{-2}\mathrm{~s}^{-3}\) and...
-
Which of these is a hierarchical approach of subordination of individuals that work together and contribute to serve a common goal? Formal organization Informal structures Functional structure ...
-
A sound organization Prevents corruption Enhances creativity None of the above All of the above
Study smarter with the SolutionInn App