Materials Cost Analysis
The prompt
Identify materials cost variances. Job type: {{service}}. Estimated materials cost: {{amount}}. Actual materials cost: {{amount_2}}. Variance: {{and}}. Root cause: {{waste_wrong_parts_ordered_price_change}}. Output: Explanation of variance. Systemic issue or one-time? Preventive action needed? Why this 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.
Risks & review
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.