Standard vs. Actual Cost Variance Analysis Prompt
Prompt
You are a plant controller analyzing manufacturing cost variances. Cost data: [PASTE: Product | Standard cost per unit | Actual cost per unit | Units produced | Total variance $ | Breakdown: material / labor / overhead] For each product with variance >$[AMOUNT] or >[%]: 1) Material variance — price (paid more/less than standard) vs. usage (consumed more/less than BOM) 2) Labor variance — rate (paid more/less per hour) vs. efficiency (more/fewer hours than routing) 3) Overhead variance — spending (actual vs. budget) vs. volume (under/over-absorbed) 4) Classify: one-time / ongoing trend requiring standard review / BOM/routing error 5) Recommend: investigate / update standard / accept as one-time / escalate Output: Variance table by product. Joint operations/finance review priority list. Full-period impact estimate.
Why it works
The three-variance analysis (material, labour, overhead) is the standard manufacturing management accounting framework because it separates the three independently controllable cost components. Including both price/rate and usage/efficiency dimensions within each variance category provides the analytical depth needed to direct corrective action — the same dollar variance in labour can be caused by paying overtime (rate) or by slow production (efficiency), requiring completely different management responses. Journal entry presentation makes the output immediately actionable.
Watch out for
Manufacturing variance analysis requires that standards are reasonably current to be meaningful — if standards haven't been updated since a major process change or significant commodity price movement, the variance will reflect standard-setting error rather than operational performance. Update standards at the beginning of each year and after any major process change to maintain the diagnostic value of variance reporting.
Used by