About the Activity-Based Costing Calculator
This activity-based costing (ABC) calculator assigns manufacturing overhead to two products using up to four activity cost pools — such as machine setups, machining, inspections and purchasing — and the cost driver each one consumes. It works out an activity rate for every pool, the overhead each product absorbs, and the full unit cost including direct materials and direct labor. Alongside, it shows the unit costs you would get with a traditional single plantwide rate based on direct labor hours.
It is designed for cost accountants, finance teams setting prices, small manufacturers and students working ABC textbook problems. The side-by-side comparison makes the classic ABC insight visible: low-volume, complex products that need many setups and inspections are usually undercosted by a volume-based rate, while high-volume standard products are overcosted.
Rename the pools in your head to match your own activities — the math is identical for any driver. Leave a pool at zero cost if you need fewer than four. Overhead is treated as fully assigned to the two products, and the traditional comparison spreads the same total overhead using direct labor hours.
With the default inputs, the product a — abc cost per unit is $190.00. Change any value above to recalculate instantly.
How to use the activity-based costing calculator
- 1Enter units, direct materials, direct labor cost and labor hours per unit for both products.
- 2For each activity pool, enter the overhead cost in the pool.
- 3Enter how much of each pool’s driver Product A and Product B consumed.
- 4Set any unused pool cost to zero.
- 5Compare ABC unit costs with traditional unit costs and review the allocation table.
Formula and method
Activity-based costing first groups overhead into activity cost pools, then divides each pool by the total quantity of its cost driver to get an activity rate (for example $1,000 per setup). Each product is charged its rate times the driver quantity it consumed, and the sum across pools divided by units produced gives overhead per unit. Adding direct materials and direct labor gives the full ABC unit cost.
The traditional comparison uses one plantwide rate: total overhead ÷ total direct labor hours, applied to each product’s labor hours per unit. Because setups, inspections and orders are often driven by batches and complexity rather than labor hours, the two methods can differ sharply for low-volume products.
- Pool cost
- Overhead cost gathered in one activity cost pool
- Driver
- Measure of activity consumption (setups, machine hours, inspections, orders)
- DM, DL
- Direct materials and direct labor cost per unit
- Plantwide rate
- Total overhead ÷ total direct labor hours
Worked examples
Deluxe vs standard product
Activity rates are $60,000 ÷ 60 = $1,000 per setup, $200,000 ÷ 20,000 = $10 per machine hour, $40,000 ÷ 200 = $200 per inspection and $30,000 ÷ 300 = $100 per order. Product A absorbs $40,000 + $30,000 + $30,000 + $10,000 = $110,000, or $110 per unit, for an ABC cost of $190. A plantwide rate of $330,000 ÷ 11,500 hours = $28.70 per hour would cost it at only $123.04 — undercosting it by about $67.
Two pools only
Setups cost $1,000 each and machining $10 per hour. A uses 25 setups and 5,000 machine hours ($75,000); B uses 25 setups and 10,000 hours ($125,000). Per unit that is $15 for A and $25 for B. A plantwide rate of $200,000 ÷ 10,000 labor hours = $20 per unit would overcost A by $5 and undercost B by $5.
Frequently asked questions
What is activity-based costing?+
Activity-based costing assigns overhead to products based on the activities they actually consume — setups, inspections, machine time, purchase orders — instead of a single volume measure such as labor hours. It gives more accurate product costs when overhead is driven by complexity and batches.
How do you calculate an activity rate?+
Divide the cost in an activity pool by the total quantity of its cost driver. For example, $60,000 of setup cost and 60 setups gives $1,000 per setup. Each product is then charged the rate times the number of setups it required.
Why does ABC give different costs than traditional costing?+
Traditional costing spreads overhead in proportion to labor or machine hours, so high-volume products absorb most of it. ABC recognizes that low-volume or complex products cause a disproportionate share of setups, inspections and orders, so it usually shifts overhead toward them.
What are common cost drivers?+
Typical drivers include number of setups or batches, machine hours, number of inspections, purchase orders, material moves, engineering change orders, customer orders and square footage. Choose the measure that best explains why the pool’s cost rises.
When is activity-based costing worth the effort?+
ABC is most useful when overhead is a large share of total cost, products differ in volume and complexity, and pricing or product-mix decisions depend on accurate costs. For a single simple product, a plantwide rate is usually adequate.
Results are estimates for educational purposes and are not financial advice. Rates, fees and terms vary — confirm with your lender or a licensed advisor before making decisions.