In: Accounting
| Your company wants to do a comparison between the current traditional costing system and the newly developed ABC system. 200 units were completed during the month. Associated costs for the month are: Direct material, $21,500; Average direct labor cost, $15/hour; Direct labor hours, 215; Overhead allocation is 175% of direct labor costs. | ||||||||
| Complete the cost comparsion between ABC and Traditional Costing for the order. Calculate the Activity Costs per Unit. | ||||||||
| Activity | Cost Driver | Activity Amount | Activity Rate | |||||
| Design | Design Hours | 25 hours | $60 | per hour | ||||
| Setup | Number of Setups | 6 setups | $40 | per setup | ||||
| Production | Equipment Hours | 45 hours | $125 | per hour | ||||
| Assembly | Direct Labor Hours | 20 hours | $40 | per hour | ||||
| Shipping/Packaging | Direct Labor Hours | 30 hours | $25 | per hour | ||||
| Calculations: | Fill-in the labels and calculations in the table below | |||||||
| Traditional Costing: | ||||||||
| Total Cost | Overhead Allocation Rate | |||||||
| ABC Costing | ||||||||
| Total Activity Costs for Job | ||||||||
| Activity Costs per Unit | ||||||||
| ABC Total Costs | ||||||||
| Total Activity Costs | ||||||||
| Total Cost (ABC) | Overhead Allocation Rate | |||||||
| In 1 -2 paragraphs below, analyze the difference between ABC & Traditional Costing. What potential benefit does this reflect of ABC? | ||||||||
| Traditional costing: | |||||||||||||||
| Cost of Job: | |||||||||||||||
| Direct material | 21500 | ||||||||||||||
| Direct labour (215 hours @15) | 3225 | ||||||||||||||
| OH ($3225*175%) | 5644 | ||||||||||||||
| Total cost | 30369 | ||||||||||||||
| ABC Costing: | |||||||||||||||
| Activity cost | Activity | Activity rate | OH | ||||||||||||
| Incurred | |||||||||||||||
| Design | 25 | 60 | 1500 | ||||||||||||
| Setup | 6 | 40 | 240 | ||||||||||||
| Production | 45 | 125 | 5625 | ||||||||||||
| Assembly | 20 | 40 | 800 | ||||||||||||
| Sshipping | 30 | 25 | 750 | ||||||||||||
| Total Activity cost | 8915 | ||||||||||||||
| Divide: Number of units | 200 | ||||||||||||||
| Activity cost per unit | 44.575 | ||||||||||||||
| TOTAL Cost under ABC | |||||||||||||||
| Direct material | 21500 | ||||||||||||||
| Direct labour (215 hours @15) | 3225 | ||||||||||||||
| Activtity cost | 8915 | ||||||||||||||
| Total cost under ABC | 33640 | ||||||||||||||
| As analyse from traditional and Activity bassed costing, the traditional costing allocate all the indirect cost with common base irrespective of whether that cost is based on that basis. | |||||||||||||||
| However, Under ABC analysis, the processes are converted in to activities and separate allocation base is determined for each activity. | |||||||||||||||
| Then the job done is charged on the basis of each activity consumed. | |||||||||||||||
| This is very systematic and accurate method of allocation of cost. | |||||||||||||||