2. Change the total fixed manufacturing overhead cost for the Milling Department in the area back...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
2. Change the total fixed manufacturing overhead cost for the Milling Department in the area back to $390,000, keeping all of the other data the same as in the original example. Consider a new job, Job 408, with the following characteristics: A. B 1 Chapter 2: Applying Excel 2 3 Cost summary for Job 408 Department 4 Milling Assembly 5 Machine-hours 80 4. 6 Direct labor-hours 20 7 Direct materials cost $ 810 $ 240 8 Direct labor cost $ 140 $ 360 In your worksheet, enter this new data in the cells for Job 407. What is the new selling price for Job 408? (Round your final answer to 2 decimal places.) Answer is complete but not entirely correct. Selling price for Job 408 $ 5,425.00 Dickson Company: An Example Using Multiple Predetermined Overhead Rates Step 1: Calculate the estimated total manufacturing overhead cost for each department. Milling Department Overhead Cost (Y): Assembly Department Overhead Cost (Y): $390,000 + ($2.00 per MH x 60,000 MHs) = $390,000 + $120,000 = $510,000 = $500,000 + ($3.75 per DLH x 80,000 DLHS) = $500,000 + $300,000 = $800,000 Step 2: Calculate the predetermined overhead rate in each department. Milling Department Overhead Rate: Assembly Department Overhead Rate: $510,000 60,000 machine-hours = $8.50 per machine-hour $800,000 80,000 direct labor-hours = $10.00 per direct labor-hour %3D Step 3: Calculate the amount of overhead applied from both departments to Job 407. Milling Department: Overhead Applied to Job 407 Assembly Department: Overhead Applied to Job 407 = $8.50 per MH x 90 MHs = $765 = $10.00 per DLH x 20 DLH. = $200 Step 4: Calculate the total job cost for Job 407. Milling Assembly $370 $280 Total $1,170 Direct materials $800 Direct labor $ 70 350 Manufacturing overhead applied $765 $200 965 Total cost of Job 407 $2,485 Step 5: Calculate the selling price for Job 407. Total cost of Job 407 $2,485.00 Markup ($2,485 x 75%) 1,863.75 Selling price of Job 407 $4,348.75 3. Without changing the data for the job from requirement 2 above, what is the selling price for Job 408 if the total number of machine- hours in the Assembly Department increases from 3,000 machine-hours to 4,000 machine-hours? (Round your final answer to 2 decimal places.) Selling price for Job 408 4. Restore the total number of machine-hours in the Assembly Department to 3,000 machine-hours. And keep the job data the same as it was in Requirement 2. What is the selling price for Job 408 if the total number of direct labor-hours in the Assembly Department decreases from 80,000 direct labor-hours to 50,000 direct labor-hours? (Round your final answer to 2 decimal places.) Selling price for Job 408 2. Change the total fixed manufacturing overhead cost for the Milling Department in the area back to $390,000, keeping all of the other data the same as in the original example. Consider a new job, Job 408, with the following characteristics: A. B 1 Chapter 2: Applying Excel 2 3 Cost summary for Job 408 Department 4 Milling Assembly 5 Machine-hours 80 4. 6 Direct labor-hours 20 7 Direct materials cost $ 810 $ 240 8 Direct labor cost $ 140 $ 360 In your worksheet, enter this new data in the cells for Job 407. What is the new selling price for Job 408? (Round your final answer to 2 decimal places.) Answer is complete but not entirely correct. Selling price for Job 408 $ 5,425.00 Dickson Company: An Example Using Multiple Predetermined Overhead Rates Step 1: Calculate the estimated total manufacturing overhead cost for each department. Milling Department Overhead Cost (Y): Assembly Department Overhead Cost (Y): $390,000 + ($2.00 per MH x 60,000 MHs) = $390,000 + $120,000 = $510,000 = $500,000 + ($3.75 per DLH x 80,000 DLHS) = $500,000 + $300,000 = $800,000 Step 2: Calculate the predetermined overhead rate in each department. Milling Department Overhead Rate: Assembly Department Overhead Rate: $510,000 60,000 machine-hours = $8.50 per machine-hour $800,000 80,000 direct labor-hours = $10.00 per direct labor-hour %3D Step 3: Calculate the amount of overhead applied from both departments to Job 407. Milling Department: Overhead Applied to Job 407 Assembly Department: Overhead Applied to Job 407 = $8.50 per MH x 90 MHs = $765 = $10.00 per DLH x 20 DLH. = $200 Step 4: Calculate the total job cost for Job 407. Milling Assembly $370 $280 Total $1,170 Direct materials $800 Direct labor $ 70 350 Manufacturing overhead applied $765 $200 965 Total cost of Job 407 $2,485 Step 5: Calculate the selling price for Job 407. Total cost of Job 407 $2,485.00 Markup ($2,485 x 75%) 1,863.75 Selling price of Job 407 $4,348.75 3. Without changing the data for the job from requirement 2 above, what is the selling price for Job 408 if the total number of machine- hours in the Assembly Department increases from 3,000 machine-hours to 4,000 machine-hours? (Round your final answer to 2 decimal places.) Selling price for Job 408 4. Restore the total number of machine-hours in the Assembly Department to 3,000 machine-hours. And keep the job data the same as it was in Requirement 2. What is the selling price for Job 408 if the total number of direct labor-hours in the Assembly Department decreases from 80,000 direct labor-hours to 50,000 direct labor-hours? (Round your final answer to 2 decimal places.) Selling price for Job 408
Expert Answer:
Answer rating: 100% (QA)
2 Particulars Milling Department Assembly Department Total Fixed Manufacturing Cost 390000 800000 To... View the full answer
Related Book For
Cost management a strategic approach
ISBN: 978-0073526942
5th edition
Authors: Edward J. Blocher, David E. Stout, Gary Cokins
Posted Date:
Students also viewed these accounting questions
-
Sena Corporation issued 10,000,000TL of 15%, 4-year bonds dated March 1, 2021, with annual interest payments on Feb. 28. The bonds were issued on March 1, 2021, at par. Sena's year-end is December...
-
Step 1 Calculate the cash flow forecast as of June 2017 Hint you may want to use the spreadsheet template you received with your cash flow forecasting homework problems Step 2 Do you foresee any cash...
-
Problem 23-7A Your answer is partially correct. Try again. Rogen Corporation manufactures a single product. The standard cost per unit of product is shown below. Direct materials-3 pound plastic at...
-
Write a program that takes an integer command-line argument n and creates an n-by-n boolean array a[][] such that a[i][j] is true if i and j are relatively prime (have no common factors), and false...
-
Carbon disulfide (CS2) boils at 46.30 oC and has a density of 1.261 g/mL.
-
Why is the lettering on the front of some vehicles "backward"? JUMA
-
Suppose the wealth that is to be received at a time \(T\) in the future has the form where \(a\) is a constant and \(x\) is a random variable. The value of the variable \(h\) can be selected by the...
-
The following costs result from the production and sale of 480,000 CD sets manufactured by Trace Company for the year ended December 31, 2011. The CD sets sell for $4.50 each. The company has a 25%...
-
Consider a 10 year bond with face value $1000. Pays 6% coupon semi annual and has a yeild to maruryity of 7%. How much would the approximate percentagechange in the price of bond if interest rate in...
-
Part of developing a long-term R&D strategy is to locate facilities in countries that are widely known to be competitive. Your company seeks to develop R&D facilities in Asia to counter recent...
-
Exercise 2-37 (Algo) Basic Concepts (LO 2-1, 2, 6) Lillibridge & Friends, Incorporated provides you with the following data for its single product: Sales price per unit Fixed costs (per quarter):...
-
s Alyeska Services Company, a division of a major oil company, provides various services to the operators of the North Slope oil field in Alaska. Data concerning the most recent year appear below:...
-
Bandar Industries manufactures sporting equipment. One of the company's products is a football helmet that requires special plastic. During the quarter ending June 30, the company manufactured 3,700...
-
ces Juniper Design, provides design services to residential developers. Last year, the company had net operating income of $460,000 on sales of $1,700,000. The company's average operating assets were...
-
Tan Corporation of Japan has two regional divisions with headquarters in Osaka and Yokohama. Selected data on the two divisions follow: Osaka Division $ 10,600,000 Sales Net operating income $...
-
A company incurs $1210000 of overhead each year in three departments, Processing, Packaging, and Testing. The company performs 1000 processing transactions, 200000 packaging transactions, and 1900...
-
List the possible rational zeros. m(x)=9x-20x-7x-6
-
Determine whether the lines are parallel, perpendicular, or neither. 2x + 3y = -12, 2y - 3x = 8
-
How is cost estimation used in activity-based costing?
-
Stratford Corporation is a diversified company whose products are marketed both domestically and internationally. Its major product lines are pharmaceutical products, sports equipment, and household...
-
What is partial productivity? Total productivity?
-
Define internal combustion engine and explain how it is different from external combustion engines?
-
In an air standard Otto cycle, the pressure and temperature at the start of compression stroke are 1 bar and \(30^{\circ} \mathrm{C}\), respectively. The temperature at the end of compression is...
-
In I.C. engines, power developed inside the cylinder is known as: (a) Brake horse power (b) Indicated horse power (c) Pumping power (d) None of the above
Study smarter with the SolutionInn App