Project Overhead Allocation: The Base You Pick Changes Every Margin You See

Overhead can’t be traced, only fairly assigned. Pick a base that mirrors how work consumes support — or every margin you report is a guess. The method, not the number, is the real decision.

Indirect costs are the quiet liars of project accounting. Rent, management salaries, IT, quality control, and support staff serve the whole business, so no single task can claim them — but every project has to carry a share anyway. That share is what turns a decent-looking gross profit into a marginal one. The problem is that the share is a fiction of your choosing: pick one allocation base and a project looks profitable; pick another and it doesn’t. This guide explains the allocation methods, the overhead-rate math behind them, and how to pick a base that reflects how your projects actually consume support — plus an Excel worksheet to run the numbers.

What Overhead Allocation Is

Overhead is the set of indirect costs that can’t be traced to a single project — the rent, supervision, finance, and back-office that keep the work possible. Allocation is the process of distributing those costs across the projects (or products) that benefit from them.

It matters because, for external reporting, absorption costing generally requires overhead to be assigned to project cost, and because every profitability number you publish depends on how that assignment is done. There’s no “correct” allocation — only methods that mirror economic reality more or less closely.

Why the Method Outranks the Number

Most teams fight about thenumberwhen the real decision was thebase. A revenue-based allocation — assigning overhead in proportion to each project’s revenue — is the most common default and the most distorting, because it rewards whatever sells most regardless of how much support it actually needs. A simple product with 70% of revenue can eat more overhead than it deserves, while a complex, support-hungry project is undercharged and looks more profitable than it is.

The goal isn’t a perfect split. It’s an allocation base thatmoves with the work the way the overhead really does. That single choice determines which projects you think are winning.

Choosing an Allocation Base

The base is the driver you use to spread overhead. Common options and when they fit:

Base	Use it when
Direct labor hours	Overhead scales with people time; simple and standard
Machine hours	Overhead is mainly depreciation and maintenance (capital-intensive)
Units produced	Products are homogeneous
Material cost	Support cost varies with what you buy
Revenue	Easy default, but distorts — avoid unless nothing else tracks
Activity drivers (ABC)	Support is driven by setups, inspections, or handling, not volume

The best base is the one whose size tracks the support a project consumes. If a project’s overhead is mostly inspection effort, allocating by direct labor hours charges it wrong.

The Overhead-Rate Math

Allocation runs through a predetermined overhead rate:

Predetermined rate = Total estimated overhead ÷ Total estimated allocation base

Then each project receivesrate × the base it consumed. A shop with $100,000 of estimated overhead and 10,000 expected direct labor hours runs a rate of $10 per hour; a project using 500 hours gets $5,000 of overhead.

The same logic scales down: a furniture project sharing $30,000 of monthly overhead over 9,000 direct labor hours gets a $3.33/hour rate — a labor-heavy table line absorbs $33.30 per unit, a simpler chair line just $6.67.

Applied vs. Actual: The Underapplied Trap

The rate you apply is an estimate, set before the period. Actual overhead rarely matches it exactly, producing a reconciling difference:

• Overapplied overhead— you charged more than you spent.
• Underapplied overhead— you charged less than you spent, which overstates gross profit and flatters margins until corrected.

A method that chronically under-applies makes projects look healthier than they are. Reconciling applied against actual each period keeps the story honest.

From Single-Rate to ABC

The simpler end of the spectrum charges everything on one base — ideal when direct labor is a large share of cost and rises in step with overhead. As technology and complexity grow, one driver no longer tracks the support being consumed, and multiple drivers earn their keep.

Activity-based costing (ABC)groups overhead into cost pools and charges each project by the activities it actually triggers — setups, inspections, material handling — instead of by volume alone. Its five stages:

1. Identify the cost-driving activities.
2. Group overhead into cost pools around those activities.
3. Pick a cost driver for each pool.
4. Compute a rate per driver.
5. Allocate each pool to projects by their use of that driver.

ABC is notably more precise — independent research puts the accuracy gain in the 15–25% range — and it changes which projects look profitable. But it costs effort to run. The right method matches sophistication to the complexity of your cost structure: a single-rate base if labor dominates, ABC when multiple activities really drive support.

Worked Example Through Both Lenses

A small project shop sharing $30,000 of monthly overhead:

Project	DL hours	Single-rate (3.33/hr)
Build A (labor-heavy)	500	$1,665
Build B (setup-heavy)	200	$666

Under single-rate, Build B looks cheap. But if Build B triggers most of the setups and inspections, an ABC view that charges setup and inspection pools to it assigns it far more — and the “simple” project stops looking profitable. That flip is exactly why method choice changes strategic conclusions.

Build an Allocation Worksheet in Excel

• Overhead sheet— list every indirect cost and its driver (supervision → hours, rent → square footage).
• Cost-pool grouping— collect costs into pools that share a driver.
• Driver totals— capture each project’s consumption of every driver.
• Rate formulas—pool total ÷ total driverfor each pool, thenrate × project driver use.
• Reconciliation row— compare applied to actual overhead each month and flag underapplied drift.

Where Allocation Goes Wrong

• Defaulting to revenue.It’s simple and baked into every system, and it systematically misstates who’s actually profitable.
• One rate, every project.A single global driver hides big differences in how projects consume support.
• Ignoring underapplied overhead.Letting applied drift below actual flatters margins until reconciliation hurts.
• Over-engineering.Rolling out full ABC on a simple, labor-heavy shop adds cost without changing answers.
• Never revisiting.An allocation base frozen for years stops matching the business as it changes.

Frequently Asked Questions

What’s the difference between direct and indirect (overhead) costs?Direct costs trace to a single project; overhead is indirect and must be shared across the projects that benefit from it.

Which allocation base should I use?The one whose size tracks how your projects actually consume support — direct labor hours if people drive overhead, machine hours if equipment does, activity drivers if setups and inspections do.

What is a predetermined overhead rate?Total estimated overhead ÷ total estimated base, applied to each project asrate × base consumed. It’s a forecast, so it needs reconciling to actuals.

What does underapplied overhead mean?You applied less overhead than you actually incurred, so gross profit and margins look better than they are until the difference is booked.

Is ABC always better?Only when multiple activities genuinely drive support. If direct labor dominates, a single-rate base is simpler and just as accurate — and far cheaper to run.

Make the Base Fit the Work

Overhead allocation doesn’t make projects profitable; it decides which ones you believe to be. Pick a base that moves with the support each job really consumes, reconcile applied to actual every period, and escalate to activity-based detail only where complexity pays for it. Get the method right, and the margins stop lying.

Keep the monthly overhead reconciliation on amonthly budget plannerrhythm, and let anexpense trackercarry the support costs so the pools you allocate rest on recorded facts. More free tools live atUse Office Toolkit.