Tableau DA 4-3: Mini-Case, Computing and assigning costs using ABC LOP3 wants to assign overhead costs to its two different models to better understand the profitability of each model. The Tableau Dashboard provides data for our analysis Estimated Overhead Costs by Estimated Direct Labor Hours & Machine Hours by Department Estimated Overhead Costs by Estimated Direct Labor Hours & Department Machine Hours by Department 150,000 hrs 125,000 hrs 100,000 hrs Finishing o lo 75,000 hrs Assembly Assembly Department Finishing: $3,000,000 Assembly 25,000 hrs Finishing Direct Labor Hours Machine Hours Estimated Overhead Costs by Estimated Direct Labor Hours & Machine Hours by Department 150,000 hrs 125,000 hrs 100,000 hrs Finishing T. 75,000 hrs Assembly Total: $8,000,000 Assembly Department Assembly: $5,000,000 Finishing Estimated Overhead Costs by Department Estimated Direct Labor Hours & Machine Hours by Department 150,000 hrs 125,000 hrs Finishing 100,000 hrs O DE Total: 75,000 hrs $8,000,000 Assem Direct Labor Hours Assembly: 100,000 hours 50,000 hrs 25,000 hrs Finishing Finishing Direct Labor Hours Machine Hours Estimated Overhead Costs by Department Estimated Direct Labor Hours & Machine Hours by Department 125,000 hrs Finishing 100,000 hrs Total: $8,000,000 Assembly Assembly 50,000 hrs Assembly 25,000 hrs Finishing Finishing Direct Labor H Direct Labor Hours Finishing: 25.000 hours Estimated Overhead Costs by Activity Cost Driver & Expected to Estimated Overhead Costs by Department Estimated Direct Labor Hours & Machine Hours by Department 150,000 hrs 125,000 hrs 100,000 hrs 75,000 hrs Total: $8,000,000 Asselbly 50,000 hrs Assembly Machine Hours Assembly: 70,000 hours 25,000 hrs Finishing Finishing Direct Labor Hours Machine Hours Estimated Overhead Costs by Department Estimated Direct Labor Hours & Machine Hours by Department 150,000 hrs 125,000 hrs 100,000 hrs Finishing 75,000 hrs Assembly Total: $8,000,000 Assembly 50,000 hrs 25,000 hrs Machine Hours Direct Labor Hou Finishing: 30,000 hours Direct Labor Hours Machine Hours Estimated Overhead Costs by Activity Cost Driver & Expected Usage by Activity Supervision Supervision Maintenance Activity Cost Pool Supervision: $2,000,000 Maintenance Note: Total overhead costs by department and total overhead costs by activity are equal. The costs are presented in two different ways here. + ableau Direct Labor Hours Machine Hours Estimated Overhead Costs by Activity Cost Driver & Expected Usage by Activity Supervision Supervision GEN Activity Cost Pool Maintenance: $6,000,000 $8,000,000 Maintenance Note: Total overhead costs by department and total overhead costs by activity are equal. The costs are presented in two different ways here. Direct Labor Hours Machine Hours Estimated Overhead Costs by Activity Cost Driver & Expected Usage by Activity Supervision Maintenance Supervision -0. Total: $8,000,000 Activity Supervision: 125,000 direct labor hours Maintenance Note: Total overhead costs by department and total overhead costs by activity are equal. The costs are presented in two different ways hern Direct Labor Hours Machine Hours Estimated Overhead Costs by Activity Cost Driver & Expected Usage by Activity Supervision Supervision Maintenance O Total: $8,000,000 Activity Maintenance: 100,000 machine hours Note: Total overhead costs by department and total overhead cncto equal. The ante ... Tableau DA 4.3: Mini-Case, Assigning overhead costs and making decisions 2. The company's XL model requires 2 direct labor hours and 1 machine hour. The RD model requires 3 direct labor hours and 3 machine hours. (a) Compute the overhead cost per unit of each model using ABC. (b) Alternatively, compute the overhead cost per unit of each model using a single plantwide overhead rate based on direct labor hours 3. The company gives a bonus to production managers based on their ability to lower the cost of their assigned model. a. Which overhead cost allocation method would the XL production manager prefer? b. Which overhead cost allocation method would the RD production manager prefer? Complete this question by entering your answers in the tabs below. Required 2A Required 2B Required 3 Compute the overhead cost per unit of each model using ABC. Activity Activity Rate Activity Driver incurred Overhead Assigned Activity Driver incurred Overhead Der MH DLH DUH Supervision Overhead Cost Per Unit Required 28 > Tableau DA 4-3: Mini-Case, Assigning overhead costs and making decisions 2. The company's XL model requires 2 direct labor hours and 1 machine hour. The RD model requires 3 direct labor hours and 3 machine hours. (a) Compute the overhead cost per unit of each model using ABC. (b) Alternatively, compute the overhead cost per unit of each model using a single plantwide overhead rate based on direct labor hours. 3. The company gives a bonus to production managers based on their ability to lower the cost of their assigned model. a. Which overhead cost allocation method would the XL production manager prefer? Complete this question by entering your answers in the tabs below. Required 2A Required Alternatively, compute the overhead cost per unit of each model using a single plantwide overhead rate based on direct labor Model Activity Driver Plantwide OH Rate OH Cost Per Unit RD DLHT Tableau DA 4-3: Mini-Case, Assigning overhead costs and making decisions 2. The company's XL model requires 2 direct labor hours and 1 machine hour. The RD model requires 3 direct labor hours and 3 (a) Compute the overhead cost per unit of each model using ABC. (b) Alternatively, compute the overhead cost per unit of each model using a single plantwide overhead rate based on direct labor hours. 3. The company gives a bonus to production managers based on their ability to lower the cost of their assigned model. b. Which overhead cost allocation method would the RD production manager prefer? Complete this question by entering your answers in the tabs below. Required 2A Required 28 Rezuired 3 a. Which overhead cost allocation method would the XL production manager prefer? b. Which overhead cost allocation method would the RD production manager prefer? a. Which overhead cost allocation method would the XL production manager prefer? b. Which overhead cost allocation method would the RD production manager prefer?