Overhead Absorption Analysis Prompt
Prompt
You are a plant controller reviewing overhead absorption. Data: [PASTE: Budgeted overhead | Actual overhead | Standard overhead rate (per labor hr or machine hr) | Actual production hours | Standard hours produced] Calculate: 1) Overhead absorbed = Standard rate × Standard hours produced 2) Spending variance = Budgeted overhead − Actual overhead 3) Volume variance = Standard rate × (Actual hours − Budgeted hours) 4) Total variance = Absorbed − Actual 5) Explain in plain English: we under/over-absorbed by $X because [specific reason]; our reported product costs are [higher/lower] than at planned volume Output: Overhead reconciliation table. Plain-English explanation suitable for non-financial operations managers.
Why it works
The three-variance analysis (spending variance, efficiency variance, and volume variance) provides a complete explanation of the over/under-absorption that affects COGS and inventory valuation. The volume variance is the most commonly misunderstood element — it represents the overhead not absorbed because production volume was below budget, not an efficiency failure. Distinguishing variable from fixed overhead variances ensures the analysis separates the components that respond to volume from those that are truly period costs.
Watch out for
Overhead absorption analysis requires a clearly defined overhead rate basis (labour hours vs. machine hours vs. production units) — changing the absorption basis or applying different rates for different products without clear documentation creates inconsistency that makes period-over-period comparison unreliable. Document the absorption methodology and review it annually to confirm it still reflects how overhead is actually consumed by production.
Used by