Overview
Many organizations — from growing SMBs to enterprise PMO teams — face the same challenge every budget cycle: more projects than money. The AI Project Portfolio Advisor helps decision-makers cut through competing priorities by calculating objective scores for every project and producing a funded vs. deferred split that maximizes portfolio value within budget constraints.
How It Works
- Set up your organization — Enter your company name, total budget, discount rate (cost of capital), and average fully-loaded employee hourly rate. These inputs anchor all financial calculations.
- Add projects — Define each project with a name, category (Revenue, Cost Reduction, Employee Productivity, Customer Value, Compliance, or Strategic), estimated cost, project lifespan, and time-to-value. Each category then prompts for the benefit inputs that make sense for it — for example, revenue projects ask for annual revenue increase, while compliance projects ask for the cost of non-compliance.
- Run the analysis — The tool scores every project using a composite formula, models three scenarios, and allocates the budget — compliance projects first, then discretionary by rank.
- Review results — See a ranked list with funded vs. deferred status, scenario NPV and ROI figures for each project, a score breakdown, and an AI-generated narrative with key drivers, quick wins, risks, and sequencing recommendations.
Scoring Formula
Each project receives a composite score weighted across three dimensions:
| Dimension | Weight | How It's Calculated |
|---|---|---|
| Financial | 40% | NPV normalized across the full portfolio (min-max scaling) |
| Strategic | 35% | Average of five qualitative ratings (1–5 scale) |
| Feasibility | 25% | Resource availability + inverse implementation complexity |
Scenario Analysis
Three scenarios are modeled for every project and for the portfolio total:
| Scenario | Benefit Multiplier | Cost Multiplier |
|---|---|---|
| Best Case | ×1.25 | ×0.90 |
| Base Case | ×1.00 | ×1.00 |
| Worst Case | ×0.65 | ×1.25 |
NPV is calculated using discounted cash flows over the project lifespan, with year-1 benefits discounted proportionally by time-to-value.
Budget Allocation Logic
- Compliance projects are mandatory — funded regardless of rank (regulatory risk cannot be deferred).
- Remaining budget allocated to discretionary projects — sorted by composite score, greedy fill until the budget is exhausted.
- Deferred projects — identified with their deferral reason and a recommendation for when to revisit.
Project Categories
- Revenue — Initiatives that directly increase top-line revenue
- Cost Reduction — Automation and efficiency projects that reduce operating expenses
- Employee Productivity — Tools and platforms that improve workforce output and reduce turnover
- Customer Value — Investments that improve retention, NPS, or customer lifetime value
- Compliance — Regulatory and risk-mitigation projects (always prioritized)
- Strategic — Long-term positioning investments without near-term financial return
Use Cases
- Annual IT and capital budget prioritization for PMO teams
- Executive alignment on discretionary spend allocation
- Board-level portfolio review presentations
- SMB strategic planning with limited resources
- Investment prioritization for private equity portfolio companies
From Demo to Production
This demo shows how NPV-based scoring and AI narrative can rank a portfolio of projects in seconds. A production deployment takes it further by integrating with your PPM and ERP systems, tracking actual vs. projected benefits over time, and supporting rolling re-prioritization as budgets and business conditions change.
Real-World Challenges
| Challenge | Why It's Hard | How to Solve It |
|---|---|---|
| Benefit estimation bias | Project sponsors systematically inflate projected benefits to secure funding — the model is only as good as its inputs | Require independent validation of benefit estimates; track historical accuracy by sponsor and apply calibration factors |
| Project interdependencies | The model treats projects as independent, but in reality Project B may only deliver value if Project A ships first | Map dependencies explicitly; model them as constraints in the allocation algorithm; flag dependency chains in the narrative |
| Political dynamics | Executive pet projects and mandated initiatives override objective scoring — the tool recommends one thing, leadership does another | Separate "must-do" projects (like compliance) from scored discretionary projects; make the cost of political overrides visible |
| Mid-cycle re-prioritization | Budgets get cut mid-year, new urgent projects appear, and the original portfolio plan becomes stale | Run the model quarterly (or on-demand); support incremental re-scoring with sunk-cost adjustments |
| Post-funding benefit tracking | Most organizations never circle back to check whether funded projects delivered their projected benefits | Integrate with ERP/finance for actuals; generate automated benefit-realization reports at project milestones |
Cost Estimates
| Line Item | Small (PMO Team) | Mid-Market (Division) | Enterprise (Multi-BU) |
|---|---|---|---|
| AI API (GPT-4o-mini) | $20–60/mo | $60–200/mo | $200–800/mo |
| PPM tool integration (Clarity, Planview, ServiceNow SPM) | $100–400/mo | $400–1,500/mo | $1,500–5,000/mo |
| Financial model maintenance (labor) | $100–200/mo | $200–500/mo | $500–1,500/mo |
| Hosting & infrastructure | $0–20/mo | $20–100/mo | $100–500/mo |
| Total monthly | $150–600 | $600–2,500 | $2,500–8,000 |
ROI Definition
- Primary metric: Portfolio value optimization — target 10–20% improvement in total portfolio NPV through better capital allocation
- Secondary metrics: Time saved on portfolio review cycles, reduction in deferred-project churn, improvement in benefit realization rates
- Break-even timeline: 1–2 quarters (the tool pays for itself with a single better-allocated project)
- Example: An organization with a $5M annual project budget achieving 15% better allocation through objective scoring = $750K in additional realized value per year vs. ~$10K–30K/year in tool costs.
Technology Stack
- AI Model: OpenAI GPT-4o-mini (executive narrative, risk analysis, and sequencing recommendations)
- Financial Engine: NPV/DCF calculations in TypeScript with three-scenario modeling (best/base/worst case)
- Frontend: React client component with multi-step form, project input wizard, and ranked portfolio view
- Backend: Next.js API route (serverless)
- Scoring: Composite weighted score across Financial (40%), Strategic (35%), and Feasibility (25%) dimensions
Want This for Your Business?
A production deployment connects to your PPM tools (Clarity, Planview, ServiceNow SPM) and ERP for actuals, supports rolling re-prioritization on any cadence, and tracks benefit realization against projections over time. The scoring model is calibrated to your organization's strategic weights and risk tolerance. A full deployment typically takes 3–4 weeks and starts at $5,000.
Financial projections are illustrative estimates based on inputs you provide. All outputs should be reviewed by a qualified finance professional before use in binding decisions. This demo uses GPT-4o-mini for narrative generation.