Labor Hours Variance Analysis Prompt
Prompt
You are an operations analyst reviewing labor hours variance vs. plan. Data: [PASTE: Week | Function | Planned hours | Actual hours | Variance hours | Volume processed | Planned productivity rate | Actual productivity rate] For each function with >10% variance: 1) Volume variance — was actual volume higher or lower than planned? How many hours does that explain? 2) Productivity variance — at actual volume, did the team achieve planned productivity per unit? 3) Overtime usage — what % of actual hours were overtime? Was it planned or reactive? 4) Root cause of productivity gap (if any): equipment downtime / errors/rework / training issues / understaffing 5) Corrective action — what changes next week to close the productivity gap? Output: Labor hours variance table. Volume vs. productivity decomposition. Corrective actions by function.
Used by
Data Analysts