Tableau DA 17-2: Exercise, Computing departmental overhead rates LO P2 Chrom Comany manufactures two models, the...

Transcribed Image Text:

Tableau DA 17-2: Exercise, Computing departmental overhead rates LO P2 Chrom Comany manufactures two models, the XL and RD. It also has two departments, assembly and finishing. The company wants to assign budgeted overhead costs to its two different models to better understand the profitability of each model. The Tableau Dashboard provides data for our analysis. Budgeted Overhead Costs by Budgeted Direct Labor Hours & Department Machine Hours by Department Finishing, 150,000 h... 125,000 h... Department Finishing: $3,000,000 100,000 h... 75,000 hrs Assembly Total: Assembly $8,000,000 50,000 hrs Assembly 25,000 hrs. Finishing Finishing Direct Labor Hours Machine Hours Department Machine Hours by Department 150,000 h... 125,000 h... 100,000 h... Finishing 75,000 hrs Total: $8,000,000 Assembly Assembly 50,000 hrs Assembly 25,000 hrs Finishing Direct Labor Hour Finishing Machine Hours Finishing: 30,000 hours Budgeted Overhead Costs by Activity Cost Driver & Budgeted Usage by Activity Supervision Maintenance Budgeted Overhead Costs by Cost Driver & Budgeted Usage Activity by Activity Supervision Maintenance Supervision Activity Cost Pool Supervision: $2,000,000 Total: $8,000,000 Maintenance Budgeted Overhead Costs by Cost Driver & Budgeted Usage Activity by Activity Supervision Maintenance Supervision Total: $8,000,000 Maintenance Activity Supervision: 125,000 direct labor hours Budgeted Overhead Costs by Activity Cost Driver & Budgeted Usage by Activity Supervision Total: $8,000,000 Supervision Maintenance Maintenance Activity Maintenance: 100,000 machine hours Note: Total overhead costs by denartment and total overhead conto bu 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 1. Using data from the upper half of the dashboard, compute the company's assembly department overhead rate using direct labor hours. 2. Using data from the upper half of the dashboard, compute the company's finishing department overhead rate using machine hours. 1. Departmental overhead rate (Assembly) 2. Departmental overhead rate (Finishing) Tableau DA 17-2: Exercise, Computing departmental overhead rates LO P2 Chrom Comany manufactures two models, the XL and RD. It also has two departments, assembly and finishing. The company wants to assign budgeted overhead costs to its two different models to better understand the profitability of each model. The Tableau Dashboard provides data for our analysis. Budgeted Overhead Costs by Budgeted Direct Labor Hours & Department Machine Hours by Department Finishing, 150,000 h... 125,000 h... Department Finishing: $3,000,000 100,000 h... 75,000 hrs Assembly Total: Assembly $8,000,000 50,000 hrs Assembly 25,000 hrs. Finishing Finishing Direct Labor Hours Machine Hours Department Machine Hours by Department 150,000 h... 125,000 h... 100,000 h... Finishing 75,000 hrs Total: $8,000,000 Assembly Assembly 50,000 hrs Assembly 25,000 hrs Finishing Direct Labor Hour Finishing Machine Hours Finishing: 30,000 hours Budgeted Overhead Costs by Activity Cost Driver & Budgeted Usage by Activity Supervision Maintenance Budgeted Overhead Costs by Cost Driver & Budgeted Usage Activity by Activity Supervision Maintenance Supervision Activity Cost Pool Supervision: $2,000,000 Total: $8,000,000 Maintenance Budgeted Overhead Costs by Cost Driver & Budgeted Usage Activity by Activity Supervision Maintenance Supervision Total: $8,000,000 Maintenance Activity Supervision: 125,000 direct labor hours Budgeted Overhead Costs by Activity Cost Driver & Budgeted Usage by Activity Supervision Total: $8,000,000 Supervision Maintenance Maintenance Activity Maintenance: 100,000 machine hours Note: Total overhead costs by denartment and total overhead conto bu 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 1. Using data from the upper half of the dashboard, compute the company's assembly department overhead rate using direct labor hours. 2. Using data from the upper half of the dashboard, compute the company's finishing department overhead rate using machine hours. 1. Departmental overhead rate (Assembly) 2. Departmental overhead rate (Finishing)