Explain manufacturing cost variances in my monthly results
A breakdown of standard cost variances (material, labor, overhead absorption) into what drove them, with commentary operations and finance both accept.
The prompt
Help me analyze and explain manufacturing variances against standard cost.
Period: [MONTH]
Variance data: [PASTE totals or by product/line: material price variance, material usage variance, labor rate, labor efficiency, overhead spending, overhead volume/absorption, scrap, purchase price variance]
Standards and actuals: [standard vs. actual material prices, quantities, labor hours, rates, production volume vs. budgeted volume]
What happened operationally: [e.g. "supplier price increase on resin", "new line ramp-up", "overtime for a rush order", "machine down 3 days"]
Costing method: [standard costing / actual costing; how overhead is absorbed, e.g. per machine hour]
Steps:
1. Check the math: confirm each variance with the standard formula (price variance = (actual price - standard price) x actual quantity; usage = (actual quantity - standard quantity allowed) x standard price; similar for labor and overhead). Flag anything that doesn't reconcile.
2. Separate real performance from accounting effects: volume-driven under-absorption, outdated standards, inventory revaluation, and timing.
3. Link each significant variance to the operational cause I gave, and list ones with no explanation as [NEEDS EXPLANATION].
4. Say which variances are likely to repeat next month and which are one-offs.
5. Flag standards that look stale and should be updated.
Return:
- A variance table: Variance | Amount | Favorable/unfavorable | Driver | Recurring? | Owner.
- A 200-word commentary for the monthly report.
- 3 questions to ask the plant manager.
Do not invent causes or numbers. This is analysis support; the final figures should be checked by my finance team.
Highlighted [brackets] are blanks to replace with your own details.
Fill in the blanks and use this promptMore Finance & Accounting prompts
What to fill in
- MONTH
- NEEDS EXPLANATION
How this prompt is built
This prompt follows the Few-Shot structure (Few-shot prompting). A few-shot prompt includes one or more worked examples of the input and the output you want, so the model can copy the pattern instead of guessing it.
Related prompts
- Explain budget vs. actual variancesAnalyzes variances and writes the commentary management needs.
- Analyze financial statementsReads a P&L, balance sheet, and cash flow statement and summarizes performance, health, and risks.
- Find cost savings and improve profitabilityCost and profitability analysis with practical, prioritized savings options.
- Compare startup investor term sheets and what I'm giving upA side-by-side comparison of equity term sheets in plain English, showing dilution, control, and downside economics.