Question

Chrom Company 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 & Machine Hours by Department Department Finishing Total: $8,000,000 150,000 h... 125,000 h... 100,000 h... 75,000 hrs Assembly Assembly 50,000 hrs Assembly 25,000 hrs Finishing Finishing Direct Labor Hours Machine Hours Budgeted Overhead Costs by Activity Cost Driver & Budgeted Usage by Activity Supervision Total: $8,000,000 Maintenance Supervision Maintenance Note: Total overhead costs by department and total overhead costs by activity are equal. The costs are presented in two different ways here. View on Tableau Public Share Tableau DA 17-3 (Static): Mini-Case, Computing overhead activity rates using ABC Using activity based costing and data from the lower half of the dashboard, compute overhead activity rates for both maintenance and supervision. Activity cost pool Budgeted Cost Budgeted Activity Usage Activity Rate Maintenance 100,000 MH per MH Supervision 125,000 DLH per DLH

          Chrom Company 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 &
Machine Hours by Department
Department
Finishing
Total:
$8,000,000
150,000 h...
125,000 h...
100,000 h...
75,000 hrs
Assembly
Assembly
50,000 hrs
Assembly
25,000 hrs
Finishing
Finishing
Direct Labor Hours Machine Hours
Budgeted Overhead Costs by
Activity
Cost Driver & Budgeted Usage
by Activity
Supervision
Total:
$8,000,000
Maintenance
Supervision
Maintenance
Note: Total overhead costs by department and total overhead costs by activity are
equal. The costs are presented in two different ways here.
View on Tableau Public
Share
Tableau DA 17-3 (Static): Mini-Case, Computing overhead activity rates using ABC
Using activity based costing and data from the lower half of the dashboard, compute overhead activity rates for both maintenance
and supervision.
Activity cost pool
Budgeted
Cost
Budgeted
Activity Usage
Activity Rate
Maintenance
100,000 MH
per MH
Supervision
125,000 DLH
per DLH

Chrom Company 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
Machine Hours by Department
Department
Finishing
Total:
8,000,000
150,000 h...
125,000 h...
100,000 h...
75,000 hrs
Assembly
Assembly
50,000 hrs
Assembly
25,000 hrs
Finishing
Finishing
Direct Labor Hours Machine Hours
Budgeted Overhead Costs by
Activity
Cost Driver Budgeted Usage
by Activity
Supervision
Total:8,000,000
Maintenance
Supervision
Maintenance
Note: Total overhead costs by department and total overhead costs by activity are
equal. The costs are presented in two different ways here.
View on Tableau Public
Share
Tableau DA 17-3 (Static): Mini-Case, Computing overhead activity rates using ABC
Using activity based costing and data from the lower half of the dashboard, compute overhead activity rates for both maintenance
and supervision.
Activity cost pool
Budgeted
Cost
Budgeted
Activity Usage
Activity Rate
Maintenance
100,000 MH
per MH
Supervision
125,000 DLH
per DLH

Added by Victor Manuel O.

Question

Please give Ace some feedback