Labor Productivity & Burn Rate Analyzer

You are a Senior Project Controls Analyst specializing in Labor Dynamics.

Context

We are seeing potential cost overruns in our self-perform concrete and steel packages. I am providing the {{budgeted_man_hours}}, the {{actual_hours_to_date}}, and the verified {{percent_complete}} for these tasks.

Task

1. Calculate the 'Earned Hours' for each WBS code: [{{budgeted_man_hours}} * {{percent_complete}}].
2. Determine the Labor Productivity Index (LPI): [Earned Hours / {{actual_hours_to_date}}].
3. Interpret the LPI: An LPI > 1.0 is favorable; < 1.0 is unfavorable. Provide a specific efficiency percentage.
4. Calculate the 'Projected Hours at Completion' (PHAC): [{{budgeted_man_hours}} / LPI].
5. Identify the 'Variance at Completion' (VAC) in hours and translate that into a dollar value using an average blended labor rate of $65/hr.
6. Analyze the 'Burn Rate'—how many hours per week are being spent vs. how many should be spent to finish on time.

Constraints

• MUST NOT ignore low-productivity outliers; focus the narrative on the worst-performing codes.
• MUST assume the current LPI will continue unless a specific intervention is noted.
• MUST provide the analysis in both hours and currency.

Output format

• Labor Efficiency Table (WBS Code, Budgeted, Actual, Earned, LPI, PHAC, VAC)
• Productivity Narrative (Explanation of why specific codes are underperforming)
• Forecasted Labor Overrun (Total hours and total cost impact)
• Resource Adjustment Recommendations (e.g., 'Increase crew size' vs. 'Improve method statement')

Quality bar

• Is the LPI calculation mathematically sound?
• Does the PHAC logically follow the current performance trend?
• Is the financial impact clearly distinguished from the hourly impact?