Answered step by step
Verified Expert Solution
Question
1 Approved Answer
! Required information d [The following information applies to the questions displayed below.] Celestial Artistry Company is developing departmental overhead rates based on direct-labor
! Required information d [The following information applies to the questions displayed below.] Celestial Artistry Company is developing departmental overhead rates based on direct-labor hours for its two production departments, Etching and Finishing. The Etching Department employs 20 people and the Finishing Department employs 80 people. Each person in these two departments works 2,000 hours per year. The production-related overhead costs for the Etching Department are budgeted at $200,000, and the Finishing Department costs are budgeted at $320,000. Two service departments, Maintenance and Computing, directly support the two production departments. These service departments have budgeted costs of $48,000 and $250,000, respectively. The production departments' overhead rates cannot be determined until the service departments' costs are allocated. The following schedule reflects the use of the Maintenance Department's and Computing Department's output by the various departments. Service Department Maintenance Maintenance (maintenance hours) 0 Using Department Computing 1,000 Etching Finishing 1,000 8,000 Computing (minutes) 240,000 840,000 120,000 2. Use the step-down method to allocate service department costs. Allocate the Computing Department's costs first. Calculate the overhead rates per direct-labor hour for the Etching Department and the Finishing Department. (Do not round intermediate calculations. Round "Overhead rate per hour" to 3 decimal places and other answers to the nearest dollar amount.) Production Departments Etching Finishing Service Departments Computing Maintenance Costs prior to allocation $ 250,000 $ Allocation of Computing Department costs $ 250,000 Allocation of Maintenance Department costs Total service department cost allocated Overhead costs traceable to production departments Total overhead cost $ 48,000 50,000 98,000 $ 175,000 $ 42,667 10,889 31,250 $ 185,889 $ 73,917 200,000 320,000 $ 385,889 $ 393,917 Direct-labor hours (DLH) 40,000 160,000 Overhead rate per hour $ 9.647 2.462 **Red text indicates no response was expected in a cell or a formula-based calculation is incorrect; no points deducted.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started