✏️Prompts

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