Skip to content

Activity-Based Costing: When It's Worth the Effort

By Newtown Analytics · · 8 min read

For finance, fp&a & accounting managers

Activity-based costing assigns overhead to products, customers and channels according to the activities they actually cause, instead of spreading it evenly by volume, labor hours or revenue. The difference matters when products or customers consume overhead in different proportions: a low-volume, complex product can cause far more setups, inspections, orders and handling than a high-volume simple one, and a traditional allocation hides this. This guide explains the method, works an example in which traditional costing shows a product earning a profit and activity-based costing shows it losing money, covers when the method is worth the effort, and describes a simpler version that many teams can adopt. It belongs to unit economics and budgeting and forecasting, builds on operating leverage and cost-volume-profit analysis, and leads to cost allocation methods and overhead rate.

The problem with traditional allocation

Traditional costing pools all overhead and spreads it using one base, such as direct labor hours or machine hours. That works when every product uses overhead in proportion to the base. It fails when they do not. Overhead is mostly caused by activities such as setting up machines, inspecting batches, moving materials, processing orders and handling customer requests, and these activities relate to the number of batches, orders and special requirements, not to the number of units. High-volume products are overcharged, and low-volume, complex products are undercharged. Pricing and mix decisions made on that basis are wrong.

The steps

  1. Identify the major activities that consume overhead resources.
  2. Assign overhead costs to activity pools, using payroll, space and equipment data.
  3. Choose a cost driver for each activity: the measure that best explains how much of the activity is consumed.
  4. Calculate a rate per driver unit: pool cost divided by total driver quantity.
  5. Assign costs to products, customers or channels by multiplying the rate by the quantity of the driver each consumes.
  6. Review and act on the results, including pricing, range and process decisions.

A worked example

A hypothetical manufacturer has $600,000 of annual overhead and two products. Product A is a simple, high-volume item with 90,000 units. Product B is a complex, low-volume item with 10,000 units. Direct labor hours are split 80 percent to A and 20 percent to B.

Traditional allocation by direct labor hours

  • A receives 0.80 × 600,000 = $480,000, or 480,000 / 90,000 = $5.33 per unit
  • B receives 0.20 × 600,000 = $120,000, or 120,000 / 10,000 = $12.00 per unit

Activity-based allocation

The overhead is broken into four pools with their drivers:

ActivityPool costDriverTotal driver unitsRate
Machine setups$200,000Number of setups100$2,000 per setup
Quality inspections$150,000Number of inspections1,500$100 per inspection
Material handling$100,000Number of moves4,000$25 per move
Order processing$150,000Number of orders3,000$50 per order
Total$600,000

Consumption by product:

ActivityProduct AProduct B
Setups2080
Inspections3001,200
Moves8003,200
Orders6002,400

Costs assigned:

ActivityProduct AProduct B
Setups (× $2,000)$40,000$160,000
Inspections (× $100)$30,000$120,000
Moves (× $25)$20,000$80,000
Orders (× $50)$30,000$120,000
Total overhead$120,000$480,000
Per unit$1.33$48.00

Check: setups 20 + 80 = 100; inspections 300 + 1,200 = 1,500; moves 800 + 3,200 = 4,000; orders 600 + 2,400 = 3,000. A: 40 + 30 + 20 + 30 = 120 (thousands); B: 160 + 120 + 80 + 120 = 480; total 600,000. Per unit: 120,000 / 90,000 = 1.33; 480,000 / 10,000 = 48.00.

The effect on profit

Product A sells at $15 with direct costs of $8. Product B sells at $45 with direct costs of $20.

Product AProduct B
Price$15.00$45.00
Direct costs$8.00$20.00
Overhead, traditional$5.33$12.00
Profit per unit, traditional$1.67$13.00
Overhead, ABC$1.33$48.00
Profit per unit, ABC$5.67-$23.00

Traditional costing says Product B earns $13 per unit (a 29 percent margin) and is the star. Activity-based costing says B loses $23 per unit, or $230,000 across 10,000 units, while A earns a respectable $5.67 per unit. A manager using the traditional numbers would push B and might raise A's price or drop it. The ABC view points the other way: raise B's price, simplify or standardize it, set minimum batch sizes, or stop selling it.

What ABC does and does not tell you

The $48 overhead per unit for B includes costs that may not disappear if B is dropped. The setups, inspections and handling for B can only be avoided if the resources are reduced, for example by redeploying or eliminating the people and equipment that perform them. ABC shows the cost caused by the activity; it does not show the saving you will realize. Combine it with an assessment of which resources can actually be removed. See product margin analysis.

When ABC is worth the effort

ConditionWhy ABC helps
Overhead is a large share of total costAllocation errors matter more
Products or customers differ in complexity, batch size or support needsOne-base allocation is distorted
Pricing or range decisions are being made on margins that look suspiciousABC tests them
Profit rankings under traditional costing do not match intuition from the floorIntuition may be picking up the cost of complexity
Competitors seem to win the high-volume business and leave you the complex businessA sign you may be underpricing complexity

ABC is probably not worth the full effort when overhead is small relative to direct costs, products are alike, or the decisions it would inform are not on the table.

A simpler approach: time-driven ABC

Full ABC requires surveys of how people spend their time, and many projects fail on that. Time-driven ABC simplifies it. For each resource department, calculate a capacity cost rate (cost divided by practical capacity in minutes or hours), then estimate the time each activity or transaction takes using a standard time equation.

Example: an order-processing team costs $150,000 a year and has practical capacity of 150,000 minutes (about 10 people, at 15,000 minutes each). The rate is $1.00 per minute. A standard order takes 10 minutes ($10), a special-label order adds 6 minutes ($6), and an export order adds 15 minutes ($15). A customer who places 200 export orders with special labels costs 200 × (10 + 6 + 15) = 200 × 31 = $6,200 to process, against $2,000 for 200 standard orders. This approach uses data from the ERP and short interviews, not surveys, and it is easier to update.

Common implementation problems

  • Too many activities. Start with five to ten.
  • Poor driver data. Use drivers that can be counted from existing systems.
  • Treating the result as a verdict. It is a model, and the assumptions need review.
  • No action. Decide in advance what pricing, process or range decisions the analysis will inform.
  • Ignoring unused capacity. Assigning the cost of idle capacity to products makes them look worse. Show idle capacity separately.
  • One-time projects. ABC is useful only when maintained.

Many ABC drivers are operational: the number of SKUs, changeovers, shipments and special orders. Reducing complexity lowers overhead. Product companies that rationalize SKUs, standardize packaging and plan production in longer runs often see overhead fall. See demand planning and inventory optimization.

Common mistakes

  • Using ABC to justify decisions already made.
  • Over-engineering the model.
  • Mistaking cost assignment for cost saving.
  • Failing to refresh drivers and rates.
  • Leaving out customers and channels and focusing only on products.
  • Using ABC for external reporting when accounting rules require other methods.

Turning the results into action

The ABC result is the start of the work, not the end. For Product B, the full cost under ABC is $20 of direct cost plus $48 of overhead, or $68 per unit. To break even at the current volume, the price must be $68. To earn a 15 percent margin on price, it would need to be 68 / 0.85 = $80. The current price of $45 is far below either. Possible actions include raising the price (perhaps with a minimum order size), cutting the number of setups by running larger batches, simplifying the specification, or exiting the product.

Take the batching option. If B's 80 setups were halved to 40 by producing in larger runs, the setup cost falls by 40 × $2,000 = $80,000, so overhead per unit falls by 80,000 / 10,000 = $8, from $48 to $40. The loss per unit shrinks from $23 to $15. It is not enough on its own, but combined with a price rise of $10 to $55, the unit result would be 55 - 20 - 40 = -$5, and with further reductions in inspections and handling the product could reach break-even. Each lever can be sized with the activity rates, which is the real value of the model.

Selecting good cost drivers

A good driver is one that explains the consumption of the activity, can be counted from existing systems and is not easily gamed. Number of setups is a better driver for setup cost than machine hours. Number of purchase orders is better than purchase value for procurement cost. Number of customer calls is better than revenue for customer service. Check the choice by asking whether doubling the driver would roughly double the resource needed. If it would not, find a better one. Validate rates with the people who do the work, since they often know where the model departs from reality.

FAQs

What is activity-based costing?

A costing method that assigns overhead to products or customers according to the activities they consume, using cost drivers such as setups, orders or inspections.

How is ABC different from traditional costing?

Traditional costing spreads overhead using one volume-based measure. ABC uses several activity-based drivers, so complex, low-volume items bear more cost.

When should a company use ABC?

When overhead is large, products or customers differ in complexity and decisions on price or range depend on accurate margins.

Does ABC save money?

No, it identifies where costs are caused. Savings arise from decisions made with that information.

What is time-driven ABC?

A simpler form that calculates a cost per minute of capacity for each resource and estimates the time each transaction takes.

This article is for general information. It is not accounting, tax, legal or investment advice, and examples use illustrative numbers rather than client data. Confirm decisions that carry financial or legal consequences with a qualified professional.

Better forecasts. Healthier inventory. More working capital.

Newtown Analytics advises growing consumer-product companies on demand planning and inventory optimization.