# 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.

- Topic: Finance & Accounting
- Framework: Few-Shot
- Level: Standard
- Tags: Finance, Analyze, Explain & Teach, Fill-in Template
- Source: https://www.thinkwithprompt.com/prompts/explain-manufacturing-cost-variances-in-my-monthly-results

## Prompt

```text
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.
```

## What to fill in

- MONTH
- NEEDS EXPLANATION

Free to copy and use. From ThinkWithPrompt (https://www.thinkwithprompt.com/), a library of 2,663 curated AI prompts.