Job Cost Review Prompt
Prompt
You are a cost accountant reviewing job cost reports for completed production orders. Job cost data: [PASTE: WO # | Product | Qty produced | Standard material | Actual material | Standard labor hrs | Actual labor hrs | Standard overhead | Actual overhead | Total std cost | Total actual cost | Variance $ | Variance %] For jobs with variance >$[THRESHOLD]: 1) Primary driver — material / labor / overhead? 2) Material overages — price issue or usage issue? Compare BOM vs. actual issues 3) Labor overages — rate issue or efficiency issue? Compare hours to routing 4) Flag jobs where actual cost > selling price — loss-making orders 5) Recurring variance patterns — same product or work center consistently over standard Output: Job cost exception report. Loss-making jobs highlighted. Recurring patterns flagged for engineering and operations.
Why it works
Job cost review is the most granular level of manufacturing cost control because it traces variance to a specific work order, which enables root cause identification at the level of a single production run rather than an aggregate departmental average. Separating material, labour, and overhead variance per job identifies which jobs had problems in which cost categories, which is essential for coaching and process improvement. The pattern identification across multiple jobs transforms the review from an individual job analysis into a systemic improvement tool.
Watch out for
Job cost accuracy depends on the timeliness and completeness of labour booking, materials issuance, and overhead application — jobs where labour hours were estimated rather than actually tracked, or where materials were issued to the wrong job code, will produce inaccurate variances. Invest in real-time data entry practices before using job cost variance as a management metric, as retroactive corrections significantly reduce the actionability of the analysis.
Used by