Summary of "Arrival-Departure Ratio (ADR) & Capacity Planning" Prompt

  This prompt provides a comprehensive framework for analyzing work flow health and planning capacity using the Arrival-Departure Ratio (ADR) metric in Planview Viz.

What It Does

  This prompt guides you through a four-part analysis and planning exercise:

Part 1: Historical Performance Analysis

• Calculates how much work is arriving versus being completed each month (the ADR ratio)
• Breaks down the analysis separately for Features and Defects
• Identifies trends showing whether your team is keeping up with incoming work or falling behind
• Assesses the predictability and health of your delivery system

Part 2: Future Capacity Planning

• Recommends how much team capacity should be reserved for defect work going forward
• Analyzes patterns in resolved defects to identify root causes
• Suggests technical debt initiatives to prevent recurring issues
• Helps you proactively allocate resources rather than reactively responding to problems

Part 3: Dashboard Design

• Creates specifications for a weekly tracking dashboard to monitor ADR in real-time
• Includes visual alerts when work is arriving faster than it's being completed (ADR > 1.1)
• Tracks Work in Progress (WIP) trends
• Provides exportable formats for sharing with stakeholders

Part 4: Executive Communication

• Structures findings into a leadership-ready presentation
• Translates technical metrics into business implications
• Presents evidence-based recommendations with clear rationale

Who Should Use This

  This prompt is ideal for:

• Portfolio/Program Managers monitoring delivery health
• Engineering Leaders planning capacity allocation
• Product Managers balancing feature work with quality improvements
• Directors/VPs needing executive visibility into flow metrics

#########################################################

#########################################################

Analysis Request: Arrival-Departure Ratio (ADR) & Capacity Planning

Part 1: Historical ADR Analysis (October 2025 - February 2026) ← change timeframe as needed
Analyze the <XYZ> Value Stream for the period October 2025 through February 2026:

Calculate Arrival-Departure Ratio (ADR) month-over-month:
ADR = (New work arriving) / (Work completed)
Break out separately for Features and Defects
Present as a table with monthly values
Predictability & Health Assessment:
Interpret what the ADR indicates about system predictability
Assess the health implications of the observed ratios
Identify trends or patterns in the data
Use objective, data-driven language



Part 2: Forward-Looking Capacity Recommendations (March - December 2026)
Based on the historical ADR analysis:

Defect Capacity Reservation:
Recommend what percentage of capacity should be reserved for defect work monthly for the remainder of 2026
Provide rationale based on the historical ADR patterns
Technical Debt Recommendations:
Review defects resolved in 2026 (January - May)
Identify patterns or root causes
Recommend specific technical debt initiatives to address systemic issues



Part 3: Dashboard Design Specification
Design a weekly ADR tracking dashboard with the following components:

Metrics displayed:
Features: arrival rate, departure rate, ADR
Defects: arrival rate, departure rate, ADR
WIP (Work in Progress) trends over time
Alert mechanism: Visual indicator when ADR exceeds 1.1 for proactive capacity management

Format requirements: Exportable and shareable (specify format: PDF, Excel, PowerPoint, or image)
Part 4: Executive Presentation Outline
Create a presentation deck outline for leadership review including:

Executive Overview (1-2 slides)
Key findings from ADR analysis
Health and predictability assessment
Capacity recommendations
Technical debt priorities
Dashboard overview and usage guidance
Tone: Objective, evidence-based, avoiding hyperbolic language