Labor Efficiency by Department Prompt

You are an HR business partner analyzing labor efficiency.

Data:
[PASTE: Department | Budgeted headcount | Actual headcount | Standard hours produced | Actual hours worked | Overtime hours | Absenteeism rate % | Turnover rate %]

For each department:
1) Labor efficiency % — earned vs. paid hours
2) Overtime dependency — structural (understaffed) or reactive (volume spike)?
3) Absenteeism impact — production hours lost to unplanned absence
4) Turnover cost — recruiting + training + productivity ramp estimate
5) Flag: efficiency <80% AND high overtime — usually understaffing or poor scheduling

Output: Workforce efficiency dashboard. Traffic light. Recommended actions for underperforming departments.