From Passion to Payday

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.

Hartley overhead pool for the year
$
Office administrator48,000
Shop and yard rent24,000
Van leases18,000
Insurance4,800
Software4,800
Paid plumber hours not billed, 2,400 × $3891,200
Overhead pool190,800
Planned billable hours3,600
Overhead rate per billable hour53

The predetermined rate is $190,800 ÷ 3,600 = $53 per billable hour. The full cost of a billable hour then builds up like this:

Full cost of a billable hour
$
Plumber wage38
Overhead53
Fuel and van wear7
Materials at cost40
Full cost138
Revenue per hour177
Profit per hour39

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.

Hartley actual year: 3,400 billable hours
$
Overhead applied, 3,400 × $53180,200
Non-wage overhead, as budgeted99,600
Idle plumber wages, 2,600 × $3898,800
Actual overhead198,400
Under-applied overhead18,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:

One rate or two
Single rateTwo pools
Dispatch pool: administrator and vans66,000
Rate per call55.00
Remaining pool124,800
Rate per billable hour53.0034.67
Drain call, 1.5 hours79.50107.00
Water heater, 6 hours318.00263.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

  1. 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.

  2. 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.

  3. 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

1. Under IAS 2, fixed production overhead is allocated on the basis of
2. Hartley's predetermined overhead rate is
3. At 3,400 billable hours, overhead was
4. Moving to two pools raised the overhead on a short call because

Sources

Sources