Standard Cost vs. Actual Cost Variance (Inventory) Prompt
Prompt
You are a cost accountant analyzing the variance between standard cost and actual cost for inventory. Variance data: [PASTE: SKU | Standard cost per unit | Actual cost per unit | Units in inventory | Total variance $] For variances above $[THRESHOLD]: Classify variance: purchase price variance (paid more/less than standard) / quantity variance (used more/less than standard) / overhead variance Purchase price variance = (Actual price − Standard price) × Actual quantity purchased Assess whether variance is one-time (spot purchase, supply disruption) or ongoing (standard needs updating) Impact on inventory valuation — is inventory currently over- or under-stated vs. actual cost? Recommend: update standard / investigate procurement / accept as one-time Output: Cost variance table. Inventory valuation impact. Standards requiring update. Estimated P&L impact if not corrected. Year-End Inventory Count Audit Support
Why it works
Classifying each variance by type (purchase price variance, quantity variance, scrap) before investigating root cause ensures the analysis goes to the right owner — PPV is a purchasing team problem, quantity variance is an operations or production problem. The threshold-based approach prevents the team from investigating every small variance and focuses attention on the exceptions that matter. The journal entry output makes the analysis immediately actionable for the accounting team.
Watch out for
Standard cost variances that consistently run in one direction (always unfavourable purchase price variances) suggest that standards are out of date rather than that purchasing is performing poorly — distinguish between standards that need updating and genuine performance problems before assigning accountability. Review standard costs at least annually to ensure variance analysis reflects actual performance rather than standard-setting errors.
Used by