Lesson 3.5 40 min
Allocating overhead
Predetermined rates, normal capacity, under- and over-applied overhead, and using more than one cost pool.
Overhead allocation decides how much of the shared cost of running a business each job, product or customer carries. Done badly, it makes some work look more profitable than it is and other work look worse, and prices drift in the wrong direction.
The predetermined rate
Overhead is applied with a rate set before the year begins:
Predetermined overhead rate = Budgeted overhead ÷ Budgeted activity
Using a budgeted rate, instead of waiting for actual costs, means jobs can be costed and quoted as they happen, and that a job done in a quiet month isn't charged more than the same job done in a busy one.
Choose the activity base with care. It should be the thing that drives the overhead. Labour hours suit a business whose overhead grows with the hours its people work. Machine hours suit a workshop. Number of jobs or calls suits costs that arise once per job, such as dispatching and invoicing.
Normal capacity and idle time
What should the denominator be: the hours the business could work, the hours it expects to work, or the hours it actually works? IAS 2, the IFRS standard for inventories, requires fixed production overhead to be allocated on the basis of normal capacity, the output expected on average over several periods under normal circumstances. Overhead that is not absorbed because output was low is expensed in the period instead of loaded onto the units produced.
Hartley doesn't hold inventory, so IAS 2 doesn't govern its job costing. The reasoning still applies to pricing: if the rate is set on a year of unusually low activity, each job carries an unusually high share of overhead, quotes rise, more work is lost, and activity falls further.
Hartley treats the unbilled time of its salaried plumbers as overhead. That choice keeps the cost of a billable hour honest: if a third of paid hours go unbilled, someone has to pay for them, and the only source is the billed hours.
Under- and over-applied overhead
At year end, overhead applied to jobs (actual activity times the predetermined rate) rarely equals overhead actually incurred.
Under-applied overhead = Actual overhead − Applied overhead
If the difference is small, close it to cost of goods sold or cost of services. If it is large, investigate. It usually means activity was below plan, spending was above plan, or the activity base doesn't drive the costs.
More than one pool
A single plant-wide rate is easy but treats every hour as consuming overhead in the same way. If a large part of overhead arises per job instead of per hour, short jobs will be under-costed and long jobs over-costed. Splitting overhead into two or more pools, each with its own driver, fixes this. Activity-based costing extends the idea to many pools. For a small business, two or three well-chosen pools capture most of the benefit.
Worked case
Hartley's overhead rate
Hartley Plumbing has 3 salaried plumbers, each paid for 2,000 hours a year at $38 an hour. It bills labour at $125 an hour. Materials cost it $40 per billable hour on average and are billed to customers at cost plus 30%. Running the vans costs $7 per billable hour in fuel and wear, on top of their fixed leases. The plan for the year is 3,600 billable hours.
Hartley's overhead pool is its non-wage fixed costs plus the wages for unbilled time. Paid hours are 6,000; the plan bills 3,600, leaving 2,400 idle hours.
| $ | |
|---|---|
| Office administrator | 48,000 |
| Shop and yard rent | 24,000 |
| Van leases | 18,000 |
| Insurance | 4,800 |
| Software | 4,800 |
| Paid plumber hours not billed, 2,400 × $38 | 91,200 |
| Overhead pool | 190,800 |
| Planned billable hours | 3,600 |
| Overhead rate per billable hour | 53 |
The predetermined rate is $190,800 ÷ 3,600 = $53 per billable hour. The full cost of a billable hour then builds up like this:
| $ | |
|---|---|
| Plumber wage | 38 |
| Overhead | 53 |
| Fuel and van wear | 7 |
| Materials at cost | 40 |
| Full cost | 138 |
| Revenue per hour | 177 |
| Profit per hour | 39 |
At year end, actual billable hours came in at 3,400. Fewer billed hours meant more idle wages, so actual overhead was higher than planned while applied overhead was lower.
| $ | |
|---|---|
| Overhead applied, 3,400 × $53 | 180,200 |
| Non-wage overhead, as budgeted | 99,600 |
| Idle plumber wages, 2,600 × $38 | 98,800 |
| Actual overhead | 198,400 |
| Under-applied overhead | 18,200 |
The $18,200 is expensed in the year. If Hartley expected 3,400 hours to be the normal level, it should reset the rate for next year; if 3,600 is still the normal level, it should leave the rate and work on bookings.
A second look at the pool shows that dispatch, invoicing and the vans (the office administrator at $48,000 and the van leases at $18,000) arise per call more than per hour. Hartley handles about 1,200 calls a year, averaging 3 hours each. Splitting the pool:
| Single rate | Two pools | |
|---|---|---|
| Dispatch pool: administrator and vans | 66,000 | |
| Rate per call | 55.00 | |
| Remaining pool | 124,800 | |
| Rate per billable hour | 53.00 | 34.67 |
| Drain call, 1.5 hours | 79.50 | 107.00 |
| Water heater, 6 hours | 318.00 | 263.00 |
Under two pools, a 1.5-hour drain call carries $107.00 of overhead, up from $79.50 under one rate. The 6-hour water heater job carries $263, down from $318. Short calls were being under-costed and long jobs over-costed, which argues for a minimum call-out charge.
Template
Overhead rate and two-pool allocation
Build an overhead pool, set a predetermined rate on planned activity, check under- or over-applied overhead at year end, and compare a single rate with a two-pool allocation for any job length. Hartley's figures are loaded.
The full working file, 3-5-overhead-allocation.xlsx, is in the Accounting and Finance Toolkit, Part 1. The lesson above teaches the method and shows the worked numbers, so you can build it yourself in any spreadsheet.
Exercises
Work these, then open the answers
If Hartley had set its rate on the actual 3,400 hours instead of the planned 3,600, what would the rate have been?
Answer
Actual overhead of $198,400 ÷ 3,400 hours = $58.35 per hour. Every job would have carried about $5 more per hour, and quotes based on it would have risen.
Billable hours come in at 3,800. Is overhead under- or over-applied, and by how much?
Answer
Idle hours = 6,000 − 3,800 = 2,200, so actual overhead = 99,600 + (2,200 × 38) = 183,200. Applied = 3,800 × 53 = 201,400. Over-applied by 18,200.
Using the two-pool rates, work out the overhead a 1-hour call carries.
Answer
$55 + $34.67 = $89.67, against $53 under the single rate.
Check
4 questions
Sources
Sources
- IAS 2 Inventories, IFRS Foundation
- Principles of Accounting, Volume 2: Managerial Accounting, OpenStax, Rice University