Purchase Price Variance Analysis Prompt
Prompt
You are a purchasing analyst reviewing purchase price variances. PPV data: [PASTE: Item | Standard cost | Actual purchase price | Variance $ per unit | Variance % | Units purchased | Total PPV | Supplier | Reason for variance (if known)] Analyze: 1) Total PPV impact — total favorable and unfavorable PPV for the period; net impact on gross margin 2) Largest unfavorable variances — items where actual price exceeded standard by the most; root cause 3) Favorable variances — are favorable PPVs because of good buying, or because standards are set too high? 4) Standard cost update need — items with persistent PPV; standards need updating for accurate margin reporting 5) Supplier price increase pattern — any suppliers consistently billing above PO price? Output: PPV analysis. Largest variances with root cause. Standards requiring update. Supplier billing accuracy issues. Net P&L impact.
Why it works
Separating favourable from unfavourable PPV and identifying whether variance is driven by price or volume ensures the analysis produces actionable intelligence — a favourable PPV from a volume purchase is different from an unexpected price decrease from a vendor. The root cause by supplier section identifies whether PPV is driven by a systemic sourcing issue (the supplier has changed their pricing structure) or a transactional exception (one purchase was made at list price without a negotiated rate). Including the gross margin impact converts a purchasing metric into a financial metric leadership can act on.
Watch out for
PPV analysis is only meaningful if your standard costs are current — if standards were set 18 months ago and commodity prices have moved significantly, the variance analysis will flag expected changes as unusual. Establish a standard cost review cadence that keeps standards within a reasonable range of actual market prices to make PPV a genuine signal rather than noise.
Used by