Downtime Pareto Analysis
Operations IT Ops Data Analyst Manufacturing
The prompt
You are a reliability engineer analyzing downtime data for root cause prioritization.
Downtime data (last 90 days):
{{machine_date_duration_mins_reason_code_d}}
Perform Pareto analysis:
1) Total downtime by machine — rank highest to lowest
2) Total downtime by reason code — top 5 causes by total minutes lost
3) Frequency vs. duration — are the longest events also the most frequent?
4) Pattern analysis — do failures cluster on certain shifts, days, or after specific setups?
5) Apply 5-Why to the top downtime cause — trace from symptom to root cause
Output: Pareto analysis + 5-Why for top cause. Priority action list: immediate / 30-day / 90-day. Which machine to tackle first and why.