Production Report & Analysis — Master Prompt Guide

Author: Aderemi Ajayi Purpose: Structured AI prompt framework for manufacturing production reporting and analysis Version: 1.0 Date: June 2026

Overview

This document provides a ready-to-use prompt framework for generating comprehensive production reports and analysis using AI. It is aligned with ISO 9001:2015, ISO 14001, and ISO 45001 requirements and incorporates Lean Manufacturing, Six Sigma, and OEE best practices.

Master Prompt Template

You are a world-class manufacturing operations analyst and continuous improvement expert.
Prepare a comprehensive [REPORT TYPE] for the following operation, applying lean manufacturing
principles, Six Sigma thinking, and ISO 9001/45001/14001 best practices.

══ OPERATION DETAILS ══
• Facility:               [Plant / Facility Name]
• Product / Line:         [Product or Production Line]
• Target Production:      [Units / Day or Period]
• Actual Production:      [Units Achieved]
• OEE Target:             [e.g. 85%]
• Defect / Rejection Rate:[e.g. 2.3%]
• Context:                [Any additional background — audits, new equipment, disruptions]

══ ANALYSIS REQUIRED ══
Perform a structured deep-dive covering the following modules:
  1. OEE breakdown (Availability · Performance · Quality)
  2. Downtime Pareto & root cause
  3. Waste & losses (6 Big Losses)
  4. Quality defect analysis (Pareto + 5-Why)
  5. Shift-by-shift performance comparison
  6. Material consumption vs standard
  7. Energy & utilities consumption
  8. Safety near-miss & incident review
  9. Labour productivity & headcount analysis
  10. CAPA status & open actions tracker
  11. Cost of Poor Quality (COPQ) estimate

══ STRUCTURE YOUR RESPONSE AS FOLLOWS ══

1. EXECUTIVE SUMMARY
   – One-paragraph situation summary
   – Key findings (bullet points)
   – Recommended course of action
   – Expected business impact

2. PERFORMANCE DASHBOARD
   – KPI table: Target vs Actual vs Variance vs RAG status
   – OEE waterfall breakdown (Availability / Performance / Quality)
   – Trend direction (improving / declining / stable)

3. ROOT CAUSE ANALYSIS
   – Apply 5-Why and/or Fishbone analysis for top losses
   – Pareto chart of downtime/defect contributors
   – Identify systemic vs one-off issues

4. FINANCIAL IMPACT
   – Estimate cost of production losses
   – Cost of Poor Quality (COPQ) if applicable
   – Potential savings from closing the performance gap

5. ACTION PLAN
   ┌─────────────────────────────────────────────────────┐
   │ Priority │ Action │ Owner │ Timeline │ KPI          │
   ├── Immediate (0–30 days)                             │
   ├── Short-term (1–3 months)                           │
   ├── Medium-term (3–12 months)                         │
   └── Strategic (1+ year)                               │
   (Include RACI where applicable)

6. RISK & COMPLIANCE
   – Risks to monitor (Safety / Quality / Supply / Cost)
   – ISO compliance gaps and CAPA recommendations
   – Escalation triggers

7. SUCCESS METRICS & NEXT STEPS
   – SMART KPIs to track improvement
   – Next review date and reporting cadence

══ OUTPUT FORMAT ══
Deliver as: Executive summary + structured slides (PowerPoint-ready)
Use professional, executive-level language suitable for management review and board
presentation. Include tables, metrics, and RAG (Red/Amber/Green) status indicators
where applicable. End every section with a clear "So what?" insight.

Report Type Variants

Report Type	Best Used For	Frequency
Daily Shift Report	Operational control, shift handover	Daily
Weekly Production Summary	Trend monitoring, team review	Weekly
Monthly Performance Report	Management review, ISO records	Monthly
Downtime & Loss Analysis	Targeted improvement initiatives	As needed
OEE Deep-Dive Analysis	Benchmarking, capital justification	Monthly / Quarterly
Quality & Defect Analysis	Customer complaints, reject spikes	As needed
Line Efficiency Report	Capacity planning, bottleneck analysis	Weekly / Monthly

Analysis Module Reference

OEE Breakdown

Availability = (Planned Time − Downtime) / Planned Time
Performance = (Actual Output × Ideal Cycle Time) / Available Time
Quality = Good Units / Total Units Produced
OEE = Availability × Performance × Quality

6 Big Losses (Lean Manufacturing)

Unplanned downtime (breakdowns)
Planned downtime (changeovers, maintenance)
Small stops and idling
Reduced speed
Startup / yield losses
Production defects and rework

5-Why Root Cause Framework

Problem Statement → Why 1 → Why 2 → Why 3 → Why 4 → Why 5 (Root Cause)

RAG Status Guide

Status	Meaning	Action Required
🟢 Green	On target (≥95% of KPI)	Monitor
🟡 Amber	At risk (85–94% of KPI)	Corrective action within 7 days
🔴 Red	Off target (<85% of KPI)	Immediate escalation

KPI Reference Table

KPI	World Class	Target	Minimum Acceptable
OEE	≥85%	≥75%	≥65%
Availability	≥90%	≥85%	≥80%
Performance	≥95%	≥90%	≥85%
Quality Rate	≥99.9%	≥99%	≥98%
Defect / Rejection Rate	<0.1%	<1%	<2%
MTBF (Mean Time Between Failures)	>480 min	>240 min	>120 min
MTTR (Mean Time to Repair)	<15 min	<30 min	<60 min
Changeover Time (SMED)	<10 min	<30 min	<60 min

CAPA Tracker Template

Ref	Issue	Root Cause	Corrective Action	Owner	Due Date	Status	Verified
CAPA-001						Open
CAPA-002						In Progress

Recommended Reporting Cadence

Daily      → Shift supervisors → Operations manager
Weekly     → Operations manager → Plant manager
Monthly    → Plant manager → MD / Executive team
Quarterly  → Executive team → Board

Tips for Best Results

Always provide actual vs target data — the AI generates sharper insights with real numbers.
Add context — mention upcoming audits, new equipment, or supply issues.
Select only relevant modules — focused prompts produce more actionable outputs.
Specify your audience — board-level vs engineering-level output differs significantly.
Request RAG status — red/amber/green flags make reports scannable for executives.
Ask for financial impact — quantifying losses strengthens the case for investment.

Document prepared for Aderemi Ajayi | Manufacturing Excellence Framework | June 2026