Skip to content
Omnikalc

Activity-based costing calculator: what overhead does a product really cause?

Enter three activity cost pools, their driver volumes and the product's use of each to get the cost per activity, the product's overhead and a comparison with machine-hour costing.

Updated on
Your inputs
$

Value out of range

Value out of range

Value out of range

$

Value out of range

Value out of range

Value out of range

$

Value out of range

Value out of range

Value out of range

Value out of range

Results

Overhead assigned to the product (activity-based)

$12,600

Cost per setup
$300.00
Cost per inspection
$150.00
Cost per machine hour
$15.00
Overhead per unit (activity-based)
$12.600
Overhead assigned by the traditional method (machine hours)
$10,200
Difference: activity-based minus traditional
$2,400
The traditional method under-costs this product

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.

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.

Frequently asked questions

What is activity-based costing?

It is a method that assigns overhead to products according to the activities they cause, such as setups, inspections or orders, rather than spreading it on one base like labor hours. Each activity has a cost pool and a driver, and products pay for the amount of each activity they use.

Why can traditional costing mislead?

A single base such as machine hours assumes that all overhead is driven by it. In reality, low-volume or complex products often need many setups and inspections for few machine hours, so they cause more overhead than the single base shows. Their cost is understated and high-volume products overstated.

How do I choose cost drivers?

Pick a measure that changes with the activity's cost and that you can count, such as setups, purchase orders, inspections or machine hours. The link between the driver and the cost should be clear. Too many activities make the system costly to maintain, so most firms use a handful.

When is activity-based costing worth the effort?

When overhead is a large share of cost, the products differ a lot in volume or complexity, and decisions on pricing, product range or customers depend on accurate costs. For simple operations with few products, a plantwide rate may be enough.

Was this calculator helpful?

Thanks for your feedback!

Results are estimates provided for information purposes. They do not replace professional advice.