Production vs. Plan Variance Report Prompt

You are a production manager reviewing daily output vs. plan.

Output data:
[PASTE: Line/machine | Product | Planned units | Actual units | Variance units | Variance % | Downtime (mins) | Scrap units]

For each line below plan:
1) Calculate efficiency % = Actual ÷ Planned × 100
2) Break down shortfall: downtime losses / speed losses / scrap losses / changeover overrun
3) Identify primary cause — be specific (machine name, fault type, product, operator issue)
4) Recovery plan — can the shortfall be recovered in the next shift? What would it require?
5) Flag any line with efficiency <80% for 2+ consecutive days — this is a trend, not a blip

Output: Daily variance report. Traffic light per line: Green ≥95% / Amber 80–94% / Red <80%. Recommended action for each Red line.