Tabellab
Business & Operations Intermediate

Project Portfolio Prioritisation: Scoring, NPV, Resource Constraints & Capacity

Score proposals against strategy, calculate NPV, IRR, PI and payback, build a weighted priority rank, select projects within a capital budget, check team capacity in FTE-months, handle mandatory work and dependencies, chart the value-vs-cost curve and re-prioritise every quarter: 8 hands-on labs.

8 lessons 8 labs 2 h Certificate

The first lesson is free โ€” no account needed.

About this course

A project portfolio prioritisation course that decides which of ten proposals one fictional group, Corvane, should fund, in a spreadsheet, for PMO leads, portfolio and programme managers, strategy and finance analysts and PMP or MBA students. You score the proposals against three strategic objectives and tier them, calculate NPV, IRR, profitability index and payback at a 10% hurdle rate, combine strategy, NPV and delivery risk on one 0โ€“5 scale into a weighted priority rank, select projects by profitability index within a $2.1m capital budget, check four teams' capacity in FTE-months and flag overloads, fund mandatory compliance work first and catch a dependency that missed the cut, draw a value-vs-cost curve in the style of an efficient frontier, and re-rank running projects at a quarterly review with a dashboard chart. Fictional company and illustrative figures. The first lab is free.

Lessons

  1. Project Inventory & Strategic Alignment ScoresLab14 minFree
  2. Financial Metrics: NPV, IRR, Profitability Index & PaybackLab16 min Pro
  3. Weighted Prioritisation: Combining Strategy, NPV and Risk into One RankLab15 min Pro
  4. Budget-Constrained Selection: Ranking by Profitability IndexLab15 min Pro
  5. Resource Capacity vs Demand: FTE-Months by TeamLab14 min Pro
  6. Mandatory Projects & Dependencies: Funding Rules That Reality ImposesLab16 min Pro
  7. The Value-vs-Cost Curve: An Efficient-Frontier-Style ChartLab14 min Pro
  8. Portfolio Dashboard & Quarterly Re-PrioritisationLab15 min Pro