Driver Analysis Example [best]: Cost

| Activity | Description | |----------|-------------| | Machine operation | Running saws, planers, CNC routers | | Setup | Preparing machines for different products | | Quality inspection | Checking dimensions and finish | | Material handling | Moving lumber and parts to workstations | For each activity, we determine what causes resource consumption:

= $600,000 / 1,200 setups = $500 per setup cost driver analysis example

| Activity Driver | Standard Chairs | Custom Tables | Total | |----------------|----------------|---------------|-------| | Machine hours | 40,000 | 10,000 | 50,000 | | Number of setups | 200 | 1,000 | 1,200 | | Number of inspections | 500 | 2,000 | 2,500 | | Number of moves | 5,000 | 10,000 | 15,000 | 000 / 1

= $300,000 / 15,000 moves = $20 per move Step 5: Trace Costs to Products Using Actual Driver Consumption Now we collect data on how many driver units each product line consumes annually. 000 | 10

| Activity | Activity Cost Driver | Total Driver Quantity (Annual) | |----------|----------------------|-------------------------------| | Machine operation | Machine hours | 50,000 hours | | Setup | Number of setups | 1,200 setups | | Quality inspection | Number of inspections | 2,500 inspections | | Material handling | Number of material moves | 15,000 moves | We compute the rate per unit of activity cost driver.

= $500,000 / 2,500 inspections = $200 per inspection

| Product | Traditional Overhead | ABC Overhead | Difference | |---------|---------------------|--------------|------------| | Standard chairs | 80,000 × $24 = $1,920,000 | $1,100,000 | Overcosted by $820,000 | | Custom tables | 20,000 × $24 = $480,000 | $1,300,000 | Undercosted by $820,000 |