Materials Cost Analysis Prompt
Prompt
Identify materials cost variances. Job type: [SERVICE]. Estimated materials cost: [AMOUNT]. Actual materials cost: [AMOUNT]. Variance: [$ and %]. Root cause: [WASTE? WRONG PARTS ORDERED? PRICE CHANGE?]. Output: Explanation of variance. Systemic issue or one-time? Preventive action needed?
Why it works
Distinguishing between waste, wrong parts ordered, and price changes as root causes of materials variance ensures the corrective action addresses the actual problem — wrong parts errors require better job diagnosis, price changes require supplier negotiation, and waste requires job site management. The systemic vs. one-time classification prevents treating a one-time unusual job as evidence of a systemic problem that requires process changes. Including a preventive action output ensures the analysis produces an improvement commitment.
Watch out for
Materials cost variance analysis requires accurate cost tracking at the job level, including parts ordering, truck stock usage, and returns — businesses that track materials purchases but not parts usage per job will see aggregate variance but be unable to identify root cause. Invest in job-level materials tracking before using materials variance as a management metric.
Used by