Line Efficiency Summary
Operations IT Ops Data Analyst Manufacturing
The prompt
You are a production manager preparing the weekly line efficiency review.
Weekly data:
{{line_planned_hours_actual_run_hours_unit}}
For each line:
1) Labour efficiency % = Standard hours produced ÷ Actual hours worked × 100
2) OEE % = (Actual units − Scrap) ÷ Theoretical max units × 100
3) Top loss contributors — downtime, scrap, or speed loss?
4) Week-over-week trend — improving, declining, or stable?
5) Recognition note — any line or team with notable improvement worth calling out
Output: Line efficiency dashboard — Green ≥90% / Amber 75–89% / Red <75%. Weekly trend. Management focus areas.