Guide · 7 min read

Activity-Based Costing Assignments, Step by Step

Activity-based costing assignments ask you to trace overhead to products through the activities that cause it, then compare the result with a single plantwide rate. This guide works one problem from start to finish and shows how to discuss what the numbers mean.

Why activity-based costing exists

Activity-based costing assignments usually begin with a company that spreads all its overhead using one rate, such as direct labor hours. That works when overhead is small and products are similar. It breaks down when a business makes a mix of simple high-volume items and complex low-volume ones.

Complex products tend to need more setups, more inspections and more engineering time, yet they may use few labor hours. A single labor-based rate therefore undercosts them and overcosts the simple products. ABC fixes this by tracing overhead to the activities that consume it and then to products according to how much of each activity they use.

The question you are usually being asked is simple: does the more accurate cost change any decision about pricing, product mix or process improvement?

The cost hierarchy and choosing cost drivers

Before picking drivers, sort each overhead activity by what makes its cost rise. This cost hierarchy is the backbone of a good ABC answer.

LevelCost rises withExamplesTypical driver
Unit-levelEach unit madeMachine power, some suppliesMachine hours, units
Batch-levelEach batch, regardless of sizeSetups, material handling, first-item inspectionNumber of setups, batches or moves
Product-sustainingEach product line kept in the rangeProduct design, engineering changesNumber of products, engineering hours
Facility-levelRunning the plant at allRent, plant management, securityOften not traced; or square feet

A good driver has a clear cause-and-effect link with the cost and is reasonably cheap to measure. If your brief gives you drivers, use them; if it asks you to choose, explain your reasoning in a sentence for each pool.

The five steps in an ABC calculation

  1. Identify the activities and assign overhead to a cost pool for each one.
  2. Choose a cost driver for each pool.
  3. Calculate a pool rate: total pool cost divided by the total quantity of the driver.
  4. Assign overhead to products: pool rate multiplied by the driver quantity each product used.
  5. Add direct costs and divide by units to get a full cost per unit, then compare with the traditional figure.

Lay the workings out in a table with one row per pool. Markers can follow a table quickly, and a total row lets you prove that every dollar of overhead has been assigned.

A worked example: two products, two methods

A hypothetical manufacturer makes a Standard model (10,000 units a year) and a Deluxe model (2,000 units). Overhead is $300,000. Standard units use 1 direct labor hour each and Deluxe units use 2.5, so total labor hours are 10,000 + 5,000 = 15,000. Labor costs $18 an hour.

Step 1: traditional costing on labor hours

Plantwide rate = $300,000 / 15,000 hours = $20 per labor hour.

Standard overhead per unit = 1 x $20 = $20. Deluxe overhead per unit = 2.5 x $20 = $50. In total, Standard absorbs $200,000 and Deluxe $100,000.

Step 2: activity-based costing

Activity poolCostDriverTotal driverRateStandardDeluxe
Machine setups$90,000Setups20 + 40 = 60$1,500 per setup20 x 1,500 = $30,00040 x 1,500 = $60,000
Quality inspections$60,000Inspections100 + 200 = 300$200 per inspection100 x 200 = $20,000200 x 200 = $40,000
Machining$150,000Machine hours12,000 + 3,000 = 15,000$10 per hour12,000 x 10 = $120,0003,000 x 10 = $30,000
Total$300,000$170,000$130,000

Overhead per unit: Standard $170,000 / 10,000 = $17.00. Deluxe $130,000 / 2,000 = $65.00. The two totals add back to $300,000, so nothing has been lost.

Comparing unit costs and margins

Direct materials are $25 a unit for Standard and $60 for Deluxe. Direct labor is $18 (1 hour) and $45 (2.5 hours). Selling prices are $80 and $185.

Per unitStandard, traditionalStandard, ABCDeluxe, traditionalDeluxe, ABC
Direct materials$25$25$60$60
Direct labor$18$18$45$45
Overhead$20$17$50$65
Total cost$63$60$155$170
Selling price$80$80$185$185
Margin per unit$17 (21.3%)$20 (25.0%)$30 (16.2%)$15 (8.1%)

Margin percentages are margin divided by price: $17 / $80 = 21.25 percent, $30 / $185 = 16.2 percent, $15 / $185 = 8.1 percent. Under traditional costing the Deluxe model looks like the bigger earner per unit. ABC shows it earns half as much, because it triggers two thirds of the setups and inspections while using only a fifth of the machine hours.

A strong answer draws decisions from this: review the Deluxe price, look for ways to cut its setups (larger batches, quicker changeovers) and be careful about pushing Deluxe sales on the strength of the old figures.

Working through an ABC problem set? Get every pool rate and product cost worked for you.

Order your activity-based costing help

Time-driven ABC

Conventional ABC needs staff surveys to split department costs across activities, which is slow and subjective. Time-driven ABC, developed by Robert Kaplan and Steven Anderson, needs only two estimates: the cost of supplying capacity and the time each activity takes.

Time-driven ABC for a customer service team (hypothetical)

The team costs $560,000 a quarter. Practical capacity, after breaks, training and meetings, is 700,000 minutes. Capacity cost rate = $560,000 / 700,000 = $0.80 per minute.

Processing a standard order takes 8 minutes, so it costs 8 x $0.80 = $6.40. A credit check takes 50 minutes, so it costs $40.00. A customer who needs frequent credit checks is therefore far more expensive to serve than one who simply reorders.

Because capacity is set at practical rather than theoretical levels, any minutes not used show up as unused capacity cost instead of being buried in product costs. That is a point worth making in evaluation questions.

Evaluating ABC: benefits and limitations

BenefitsLimitations
More accurate product and customer costs where overhead is large and products differCostly to design, collect data for and maintain
Shows which activities drive cost, which supports process improvementDriver choice involves judgment; poor drivers give false precision
Better pricing, product mix and customer profitability decisionsFacility-level costs are still allocated somewhat arbitrarily
Links naturally with activity-based management and budgetingLess useful where products are similar or overhead is small

Finish evaluation answers with a judgment, not a list. For example: ABC is worth the cost for this company, because overhead is large relative to direct cost and its two products use support activities very differently.

Extending ABC to customer profitability

Some assignments move the same logic from products to customers. Two customers can buy the same amount and still cost very different sums to serve, because one orders rarely in large lots and the other orders constantly in small ones.

Two customers with equal sales (hypothetical)

Each customer buys $50,000 of goods a year at a 30 percent gross margin, so each contributes $15,000 before service costs. Activity rates are $40 per order processed, $120 per delivery and $25 per return handled.

ActivityCustomer ACustomer B
Orders12 x $40 = $480150 x $40 = $6,000
Deliveries12 x $120 = $1,440150 x $120 = $18,000
Returns5 x $25 = $12560 x $25 = $1,500
Cost to serve$2,045$25,500
Gross margin less cost to serve15,000 - 2,045 = $12,95515,000 - 25,500 = ($10,500)

Customer B loses money on every year of trading even though its sales match Customer A. The sensible recommendation is rarely to drop the customer outright. Better options are a minimum order size, a delivery charge for small orders, or moving the customer to an online ordering channel that costs less per order.

Writing up an ABC answer

Calculation questions usually carry a discussion part worth as many marks as the numbers. Plan that part before you start calculating, so the workings feed it.

  • Present workings in one table Pools, drivers, rates and product totals, with a check total.
  • State the cost change in dollars and percent Deluxe rises from $155 to $170, an increase of about 9.7 percent.
  • Explain why it changed Name the activities the product uses heavily.
  • Draw a decision Pricing, product mix, process change or customer terms.
  • Evaluate the method for this company Is the extra accuracy worth the cost of running ABC here?

The percentage above is $15 divided by $155, which equals 0.097. Small checks like this, written into the answer, show the marker you understand the figures rather than copying a template.

How we help with activity-based costing assignments

A management accounting writer can work your ABC problem set or costing report from your data, laying out each pool rate, the product cost comparison and the written discussion your instructor wants. Each figure is shown with its working, so the reasoning is easy to retrace when you revise for an exam.

The paper is produced fresh for your order and checked against plagiarism databases, and your personal details stay with us. Any change that falls inside the original brief is made at no charge. Money is refunded in full when we miss the deadline or when you cancel before the writer has begun, and the quickest turnaround we offer is 3 hours.

Quick answers

What is a cost driver in activity-based costing?

A cost driver is the factor that causes an activity's cost to change, such as the number of setups for a setup pool or machine hours for a machining pool. It is used to assign the pool's cost to products.

How do you calculate an activity rate?

Divide the total cost in the activity pool by the total quantity of its cost driver. For example, $90,000 of setup cost over 60 setups gives $1,500 per setup.

Why does ABC usually raise the cost of low-volume products?

Low-volume, complex products use batch-level and product-sustaining activities, such as setups and engineering, far more heavily than their labor or machine hours suggest. A single volume-based rate misses this.

Is ABC used for external financial reporting?

It can be used for inventory valuation if it follows the reporting rules, but it is mainly a management accounting tool for pricing, product mix and cost control decisions.

What is the difference between ABC and time-driven ABC?

Conventional ABC splits department costs across activities using staff estimates. Time-driven ABC uses a cost per minute of capacity and the minutes each activity takes, which is quicker to build and update.

How do I check my ABC answer?

Add the overhead assigned to every product. The total must equal the overhead you started with. Also check each rate by multiplying it back by the total driver quantity.

Short on time for your costing assignment?

Share the overhead data and the questions. You get the calculations, the comparison and the discussion your brief asks for.

Order activity-based costing help