Prioritization Funnel

Metadata

• Name: prioritization-funnel
• Description: Structured opportunity filtering and prioritization
• Triggers: prioritization, resource allocation, opportunity filtering, project ranking

Instructions

Apply a multi-stage filtering process to prioritize opportunities or projects.

Framework

The Funnel Process

ALL OPPORTUNITIES (20-50 options)
          │
    STAGE 1: DEFINITION
    ↓ Apply 4 criteria filters
    (Narrow to 20-30)
          │
    STAGE 2: RAPID APPRAISAL
    ↓ Quick evaluation on key dimensions
    (Narrow to 5-15)
          │
    STAGE 3: FINANCIAL MODELLING
    ↓ Assess quantitative impact
    (Narrow to 3-7)
          │
    STAGE 4: DECISION MAKING
    ↓ Strategic evaluation
    (Select top 1-3)

Stage 1: Definition Filters

Criterion	Threshold	Pass Rate
Strategic Fit	Must align	60% pass
Market Size	Must exceed threshold	50% pass
Required Investment	Within budget	40% pass
Time Horizon	Meets window	70% pass
Resource Availability	Feasible	50% pass

Result: [Opportunities passed to Stage 2]

Stage 2: Rapid Appraisal

Dimension	Weight	Scale (1-5)	Description
Strategic Alignment	30%	[High/Med/Low]	Fit with goals
Market Potential	25%	[H/M/L]	Growth opportunity
Profitability Impact	20%	[H/M/L]	NPV or margin
Implementation Ease	15%	[Easy/Med/Hard]	Feasibility
Risk Level	10%	[H/M/L]	Project risk
Score	[Calculated total]

Result: [Opportunities passed to Stage 3]

Stage 3: Financial Modeling

Opportunity	NPV	IRR	Payback	Sensitivity
[Opportunity A]	$X M	Y%	Z years	Analysis
[Opportunity B]	$X M	Y%	Z years	Analysis

Result: [Opportunities ranked for final decision]

Stage 4: Final Selection

Rank	Opportunity	Total Score	Key Differentiator
1	[Opportunity Name]	[Score]	[Why #1?]
2	[Opportunity Name]	[Score]	[Why #2?]
3	[Opportunity Name]	[Score]	[Why #3?]

---

Selected Opportunities

Priority 1: [Opportunity Name]

• Action: [Description]
• Owner: [Who's responsible]
• Timeline: [Start - completion]
• Budget: [Allocation]

Priority 2: [Opportunity Name]

• Action: [Description]
• Owner: [Who's responsible]
• Timeline: [Start - completion]
• Budget: [Allocation]

Priority 3: [Opportunity Name]

• Action: [Description]
• Owner: [Who's responsible]
• Timeline: [Start - completion]
• Budget: [Allocation]

---

Resource Allocation

| Priority | Allocated Capital | % of Budget | Personnel | Timeline | |----------|-----------------|-----------------|------------------| | 1 | $X M | Y% | [Team lead] | Q1-Q2 | | 2 | $Y M | Z% | [Team lead] | Q2-Q3 | | 3 | $Z M | W% | [Team lead] | Q3-Q4 | | Hold | $V M | V% | - | - |

Governance

Decision Authority: [Who has final approval] Approval Process: [Stage gate process] Review Timeline: [When to review priorities]

---

Monitoring

Metric	Target	Actual	Variance	Action
# of opportunities in funnel	20	18	🔴 -10	Reassess funnel
Average NPV of top 3	$X M	$Y M	🟢 +10%	Continue investment
Resource utilization	90%	75%	🟡 -15%	Optimize capacity

---

Funnel Metrics

Stage	Input	Pass Rate	Cycle Time
Definition	50 options	60%	1 week
Appraisal	30 options	50%	2 days
Financial Modeling	15 options	33%	1 week
Selection	7 options	100%	Decision made

---

Strategic Implications

Portfolio Balance:

• [Analysis of opportunity mix]

Resource Constraints:

• [Budget constraint analysis]
• [Capacity constraint analysis]
• [Timeline constraint analysis]

Risk Factors:

• [Over-prioritizing quick wins]
• [Under-prioritizing strategic opportunities]

Tips

• Be transparent about scoring - make criteria explicit
• Use quantitative thresholds where possible
• Balance qualitative and quantitative factors
• Don't rush Stage 2 - financial modeling matters
• Consider resource constraints realistically
• Review funnel regularly - opportunities and conditions change
• Document decision rationale for accountability
• Use weighted scoring to reflect strategic priorities

References

• Various project management and portfolio management sources
• McKinsey, BCG project management frameworks
• PMI prioritization methods
• Stage-gate process best practices