This calculator gives estimates for education and planning. It is not investment, tax or legal advice; for decisions about your own situation, talk to a qualified financial professional.
Activity-based costing assigns overhead to a product according to the activities it uses. The activity-based costing calculator takes three cost pools, their total driver volumes and the driver amounts the product uses, and gives the rate per activity, the overhead assigned to the product, the overhead per unit and the difference from a traditional machine-hour rate.
How the calculation works
- For each activity, divide its cost pool by its total driver volume to get a rate: for example, setup cost ÷ number of setups.
- Assign overhead to the product by multiplying each rate by the amount of the driver the product uses, and add the activities up.
- Divide the total by the number of units for the overhead per unit.
- Compare with the traditional method, which spreads all overhead on a single base, here machine hours: total overhead ÷ total machine hours × the product’s hours.
Example
A plant has pools of $60,000 for 200 setups ($300 each), $45,000 for 300 inspections ($150 each) and $150,000 for 10,000 machine hours ($15 each). A product uses 12 setups, 20 inspections and 400 hours. Its activity-based overhead is 3,600 + 3,000 + 6,000 = $12,600, or $12.60 a unit for 1,000 units. The traditional rate of $25.50 per machine hour gives only $10,200, so it under-costs the product by $2,400.
Why it matters
If overhead is spread on one base, prices and product decisions can be wrong: complex products look cheaper than they are and simple ones look dearer. Activity-based costing shows who really uses the resources, which supports better pricing and product choices.
Good to know
The calculator handles one product and three activities, with the third as the base for the traditional comparison. It uses the whole cost pool and driver volume, assuming the capacity is fully used. Unused capacity should be separated from the pool, and costs that have no clear driver are better left outside the system.
Related tools
The COGS calculator finds the cost of goods sold, the break-even calculator uses costs to find the volume needed and the material variance calculator splits material costs into price and usage.