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 bv

Budaeted Direct Lahor Ho$$rc &

Budgeted Overhead Costs by Activity

Cost Driver & Budgeted Usage by Activity

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 ind supervision.

$\backslash$table$[[$Activity cost pool,$\backslash$table$[[$Budgeted$],[$Cost$]],\backslash$table$[[$Budgeted$],[$Activity Usa$]],,$ty Rate$],[$Maintenance$,,100,000,MH,$per MH$],[$Supervision$,,125,000,$DLH$,$per DLH$]]$