Normal Capacity and Unabsorbed Overhead Calculator (ASC 330)
Allocates fixed production overhead on normal capacity rather than actual output, expenses the unallocated remainder, and shows exactly how much stock value and reported profit the intuitive method would have manufactured out of a slow quarter. Built for manufacturing controllers and audit-facing finance teams who have to defend a unit cost when the plant ran below plan.
Download This Calculator
Get the Excel spreadsheet behind this calculator to use offline, customize it with your own overhead pool, capacity range and cost build-up, and publish it as a web tool using Sheetflow.
The Rate the Standard Requires
Allocates on normal capacity — $13.3333 a unit at the defaults — not the $18.75 that spreading over 128,000 actual units tempts you into, a 41% overstatement the standard prohibits. The unallocated $693,333 is expensed in the period.
Priced in Stock, Profit and Margin
Shows what the wrong method defers into the balance sheet — $195,000 of overstated closing stock and the same $195,000 of unearned pre-tax profit, 1.92 margin points, $154,050 after tax — with the deferral equal to the stock-build share of unallocated overhead.
All Three Capacity Regimes
Caps the rate below the normal range and expenses the remainder; lowers it above the range so inventory is never measured above cost. Matches IAS 2 §13, and costs the "just build more" reflex at $2.27 of cash per $1 of charge deferred.
Frequently Asked Questions
Why can't I spread fixed overhead over the units I actually made?
Because the standard forbids it, and it forbids it precisely in the quarter when you most want to.
ASC 330-10-30-3 requires fixed production overhead to be allocated on normal capacity — the production expected over a number of periods under normal circumstances, after allowing for planned maintenance. Not theoretical capacity, and not this period's actual output. Then 330-10-30-6 is explicit: the amount of fixed overhead allocated to each unit of production shall not be increased as a consequence of abnormally low production or idle plant. Whatever is left over falls under 330-10-30-7 — unallocated overheads shall be recognized as an expense in the period in which they are incurred.
The calculator's defaults put a $2,400,000 fixed overhead pool against 180,000 units of normal capacity — $13.3333 a unit. The plant made 128,000, which is 71.1% utilisation and below the 160,000 lower bound of the normal range.
Spreading the pool over 128,000 units gives $18.75 instead. That's $5.4167 of extra overhead loaded into every unit, a 41% overstatement of the overhead component, and it is exactly the move the standard prohibits.
Under ASC 330 you absorb $1,706,667 into production and expense $693,333 immediately.
The framing that makes this click: the $693,333 isn't a costing residual, it's the cost of capacity you paid for and didn't use. It belongs to the period that wasted it, not to the units that happened to get made.
What does the wrong method actually do to the accounts?
It converts a period expense into an asset, and the size of the effect depends on how much stock you built.
Overhead attached to units that were sold reaches the income statement either way — the method only changes the label. The damage is the overhead attached to units still sitting in stock at period end, because that cost gets deferred into next period instead of hitting this one.
At the defaults, closing finished goods are 36,000 units, 28.125% of production. So the deferral is 28.125% of the $693,333:
| ASC 330 | Spread over actual | Difference | |
|---|---|---|---|
| Fixed overhead per unit | $13.3333 | $18.7500 | $5.4167 |
| Full unit cost | $62.5833 | $68.0000 | $5.4167 |
| Closing stock value | $2,253,000 | $2,448,000 | $195,000 |
| Gross margin | $2,704,200 | $2,899,200 | $195,000 |
| Gross margin percentage | 26.57% | 28.49% | 1.92 points |
$195,000 of stock that isn't worth what it says, and $195,000 of profit that wasn't earned — $154,050 after tax at 21%.
Two sanity checks the calculator runs so you can see the model closes. Every dollar of the pool lands somewhere: $693,333 expensed, $1,226,667 in cost of sales, $480,000 in closing stock, summing to exactly $2,400,000. And the profit effect equals the unallocated overhead times the deferred share — $693,333 × 28.125% = $195,000.
Note what that second identity implies. A plant that sells everything it makes shows no difference at all. The misstatement only appears when you build stock, which is exactly what happens when demand falls faster than you cut production.
What counts as "normal capacity" and who decides?
Normal capacity is a range, not a number, and that is where the judgement — and the audit exposure — lives.
The standard says normal capacity refers to a range of production levels, that some variation period to period is expected and establishes that range, and that the range will vary by business and industry. Within the range, 330-10-30-6 permits using the actual level because it approximates normal. Below it, you are in abnormally low territory and the rule bites.
The calculator makes you state the range explicitly — 160,000 to 200,000 against a 180,000 normal level in the defaults — because an unstated range is an undocumented judgement.
Factors the standard names as causing abnormally low production: significantly reduced demand, labour and materials shortages, and unplanned facility or equipment downtime. Planned maintenance is not one of them; it's already baked into normal capacity.
This is not a theoretical exposure. The SEC has written to registrants asking them to review ASC 330-10-30-1 through 30-8, state the impact of applying it, and quantify the overhead capitalised versus the overhead expensed. One filer's response set out a normal capacity range of 2.0 to 2.5 million tons and explained that actual production fell inside it, so full absorption applied.
If you cannot produce that paragraph about your own plant, you have a documentation problem rather than an accounting one.
Does the rule work the other way in a strong quarter?
Yes, and this half is widely missed.
ASC 330-10-30-6 also states that in periods of abnormally high production, the fixed overhead allocated to each unit shall be decreased so that inventories are not measured above cost. You absorb the pool, no more — you cannot keep charging the normal rate and capitalise more overhead than you actually incurred.
Run the defaults through all three regimes:
| Production | Regime | Rate applied | Unallocated |
|---|---|---|---|
| 128,000 | Abnormally low | $13.3333 | $693,333 |
| 175,000 | Within the normal range | $13.7143 | $0 |
| 215,000 | Abnormally high | $11.1628 | $0 |
The asymmetry is the point. Below the range the rate is capped at the normal-capacity figure and the remainder is expensed. Above the range the rate falls so total absorption can't exceed the pool. In both directions the standard is preventing inventory from carrying cost it didn't cause.
IFRS reaches the same place. IAS 2 paragraph 13 requires fixed production overheads to be allocated on normal capacity, with unallocated overhead from idle plant or abnormally low production expensed rather than capitalised. Dual reporters do not need two models here.
Can't I just produce more and make the charge go away?
Arithmetically yes. Economically it is usually a bad trade, and the calculator prices it rather than leaving it as a moral argument.
Producing 32,000 more units would lift output to the bottom of the normal range and eliminate the entire $693,333 charge. Those units cost $42.50 of prime cost and $6.75 of variable overhead each — $1,576,000 of cash to defer $693,333 of expense.
That's $2.27 of cash spent for every $1 of charge deferred — and deferred is the right word, because the cost comes back through cost of sales when the stock eventually sells, or through a write-down if it doesn't.
This incentive is well known, which is why the rule exists. Building to absorb overhead is the specific behaviour ASC 330 limits, and an auditor seeing production rise while orders fall will ask about it directly. There's also a lower-of-cost-or-net-realisable-value test waiting at the end of it.
Three honest scope limits.
- One product, one pool. The model runs a single fixed overhead pool over a single unit of output. A plant with several cost centres or a wide product mix needs the test applied per pool, and the answer will differ by pool.
- FIFO assumed. Opening stock is charged out first at its own carried cost. Under LIFO or weighted average the current-period absorption rate blends differently and the deferred share changes.
- Allocation only, not measurement. This computes what attaches to inventory. It does not run the subsequent lower-of-cost-or-NRV test under ASC 330-10-35, and in a quarter weak enough to produce unabsorbed overhead, that test is often the one that matters more.
Transform Your Excel Models into Web Tools
Turn your complex Excel calculations into online calculators, web forms, and APIs. No coding required — upload your spreadsheet and publish your calculations instantly.
Calculations are for estimation and planning purposes. Users should verify important results for their specific situations. No signup required. Calculations performed securely.