Articles

Capacity cost rate formula: time-driven ABC worked case

Time-driven activity-based costing needs two numbers: what a minute of capacity costs, and how many minutes each transaction takes.

The capacity cost rate formula is the cost of the capacity a department supplies divided by its practical capacity, usually in minutes. It is the first of the two numbers time-driven activity-based costing needs; the second is the time each transaction takes. On an illustrative customer service team costing $1,700,000 a year with 1,641,600 practical minutes, the rate is $1.0356 a minute. Charged on the minutes actually used, it costs a two-line order at $9.32 and a 25-line order at $45.05, and leaves $201,316 of unused capacity on its own line.

Related reading: Cost Accounting by Julian R. Sterling works its subject on one fully specified case, with free companion workbooks. The figures below are an illustrative case built for this article.Get the DRM-free PDF, $19.99 →or see it on Amazon

The formula

Capacity cost rate = cost of capacity supplied / practical capacity

Practical capacity = people × days × hours × 60 × practical share of theoretical time

Cost of a transaction = capacity cost rate × minutes from its time equation

The numerator is everything it costs to keep the department open: salaries with benefits, supervision, systems and space. The denominator is the time the people can actually work, after breaks, training and meetings, not the hours they are paid for. The practical share is commonly set around 80% for people and 85% for machines; it is a judgement and should be written down as one.

Step 1: the capacity cost rate

Illustrative customer service department, annual
ItemValue
20 representatives at $62,000 loaded$1,240,000
2 supervisors at $95,000$190,000
Systems and telephony$150,000
Occupancy$120,000
Cost of capacity supplied$1,700,000

Theoretical capacity = 20 × 228 days × 7.5 hours × 60 = 2,052,000 minutes

Practical capacity = 2,052,000 × 80% = 1,641,600 minutes

Capacity cost rate = $1,700,000 / 1,641,600 = $1.0356 a minute

In Excel, with the cost in B2 and practical minutes in B3: =B2/B3

Only the representatives supply the capacity; supervisors, systems and space are part of its cost, which is why they sit in the numerator and not the denominator.

Step 2: time equations

Time-driven ABC replaces a list of activities and drivers with one equation per process, which adds time for each feature that makes a transaction longer:

Order minutes = 6 + 3 if new customer + 1.5 per line + 10 if expedited

Inquiry = 9 minutes; return = 20 minutes; credit review = 35 minutes

Volumes for the year: 60,000 orders with 360,000 lines, of which 2,400 from new customers and 3,000 expedited; 42,000 inquiries; 4,500 returns; 1,200 credit reviews.

Step 3: capacity used and unused

Minutes used and cost charged at $1.0356 a minute
ProcessMinutesCost
Process orders937,200$970,541
Answer inquiries378,000$391,447
Process returns90,000$93,202
Credit reviews42,000$43,494
Capacity used1,447,200$1,498,684
Unused capacity194,400$201,316
Capacity supplied1,641,600$1,700,000

The team is 88.2% used. The $201,316 of idle time is not charged to any customer; it is reported as the cost of capacity the company chose to keep, the same principle as in how to calculate the cost of unused capacity.

Step 4: cost to serve two customers

Annual cost to serve, time-driven against an average cost per order of $28.33 ($1,700,000 / 60,000 orders)
CustomerOrdersLinesExpeditedInquiriesReturnsMinutesTime-driven costPer-order cost
A, small frequent orders1202403080152,400$2,485$3,400
B, large planned orders401,00001021,905$1,973$1,133

Customer B also has one credit review. An average cost per order charges A $3,400 and B $1,133; the time equations charge $2,485 and $1,973, because B's orders carry 25 lines each and take 43.5 minutes, against 9.0 for A. Both costs exclude the unused capacity, which is why they add up to less than a full allocation would. The same shift from a single volume driver to the real cause of the work is shown on a factory in activity-based costing per unit.

How sensitive is the rate to the practical share?

Same $1,700,000 and 1,447,200 minutes used
Practical sharePractical minutesCapacity cost rateUnused capacity cost
75%1,539,000$1.1046$101,404
80%1,641,600$1.0356$201,316
85%1,744,200$0.9747$289,474

The practical share moves the rate and the unused line, not the total. A lower share makes every transaction look dearer and hides idle time; a higher one does the opposite. Fix it once per department and change it only when the way the team works changes.

Takeaway

Capacity cost rate = cost of capacity supplied / practical capacity: $1,700,000 / 1,641,600 = $1.0356 a minute here. Multiply by the minutes from each time equation to cost a transaction, and report the $201,316 of unused capacity separately.

Questions readers ask

What is the capacity cost rate formula?

Cost of capacity supplied divided by practical capacity. Here $1,700,000 / 1,641,600 minutes = $1.0356 a minute, where practical capacity is 80% of 2,052,000 theoretical minutes.

How is practical capacity estimated in time-driven ABC?

Start from theoretical time (people × days × hours × 60) and take a share for breaks, training and meetings, commonly around 80% for people. 20 people at 228 days and 7.5 hours give 2,052,000 minutes, and 1,641,600 at 80%.

Is unused capacity charged to products or customers?

No. Charging only the minutes used leaves the idle time on its own line: 194,400 minutes, $201,316, in this case.

Go further

This article applies the method to an illustrative case built for it. Cost Accounting works its own fully specified case chapter by chapter, and every figure it prints is a live formula in the free companion workbooks.

Get the book on Amazon →Free companion files

Also on Amazon UK · Amazon Germany · Amazon France · Amazon Canada

Prefer a PDF? The same book is sold as a DRM-free PDF edition, searchable and printable. Get the PDF edition, $19.99

Not on Amazon: 10 paperbacks by Julian R. Sterling on real estate and housing, printed on demand and shipped worldwide. Browse the bookshop →

Also on this site

Reading guide: business operations: cost, contracts, pricing and supply chain → · All 1908 articles →

If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The workbook stays free either way.