Edition: Business, Enterprise
User-level: Project Manager and above
Overview
Every project in Project Portfolio shows a Project Health rating: On Track, Monitor or Attention. This article explains how that rating is calculated, so you can understand why a project has the status it does and what to look at to improve it.
Project Health is a financial health check. It is based on WIP, profit, recovery, budget and outstanding invoices. It does not look at schedule, dates or resourcing.
How the rating works
Each financial measure is scored as 0 (green), 0.5 (amber) or 1 (red). Scores are combined into a single number between 0 and 1, and that number is turned into a status using the same thresholds at every level (measure, stage and project):
Score | Project Health |
0.40 or above | ATTENTION |
0.27 to 0.39 | MONITOR |
Below 0.27 | ON TRACK |
Project Health is calculated for projects with a status of Proposal, Active or Pending Invoice. Stages marked Unsuccessful are ignored.
Step 1: Stage health
Each stage is scored on four measures:
Measure | Weight | Attention (red) | Monitor (amber) | Not used for |
WIP | 0.3 | More than 75% of the stage's WIP is aged | More than 50% of WIP is aged | No Billing stages |
Profit | 0.3 | Profit is below 0 and the stage can't recover | Profit is below 0 but the stage can still recover | No Billing stages |
Recovery | 0.3 | Below 75% | Below 85% | No Billing stages |
Budget | 0.6 | Charge is more than 110% of budget | Charge is more than 100% of budget | No Billing and Hourly (rates) stages, or where both budget and agreed fee are 0 |
How each measure is checked
WIP – aged WIP divided by total WIP. Aged WIP is WIP more than 30 days old. A stage with no WIP is green.
Profit – if profit is 0 or above, this is green. If profit is negative, it is amber when there is still fee left to bill and costs haven't exceeded the agreed fee. Otherwise it is red.
Recovery – revenue invoiced (ex-tax) as a percentage of the charge value invoiced or written off. Below 100% means discounts or write-offs.
Budget – the stage's total charge compared with its budget. If no budget is set, the agreed fee is used instead.
The stage score
The four measures are combined using their weights. Budget carries the most weight (0.6), so going over budget has the biggest effect on a stage.
If a measure doesn't apply to a stage, it is left out and the remaining measures are rebalanced. For example, an Hourly stage is scored on WIP, Profit and Recovery only. A stage where no measures apply is green.
Step 2: Project health
Project Health is not a simple average of the stage ratings. It combines three scores.
Stage roll-up
The average of the stage scores, weighted by each stage's agreed fee, so larger stages count for more.
Only billable stages that are Active, Pending Invoice or Complete are included.
Project financials
The same four measures (WIP, Profit, Recovery, Budget) with the same weights and thresholds, but calculated on the project totals. Stage figures are added together first, then scored.
This means a loss on one stage can be offset by profit on others.
Debtors
Looks at the project's outstanding invoices by due date:
RED if any invoice is more than 45 days past due.
AMBER if any invoice is more than 30 days past due.
Otherwise green.
Measure | How it is calculated for the project |
WIP | Total aged WIP ÷ total WIP across billable stages. Red above 75%, amber above 50%. |
Profit | Total profit across billable stages. If below 0, amber when there is still fee left to bill and total costs haven't exceeded the total agreed fee. Otherwise red. |
Recovery | Total revenue invoiced (ex-tax) ÷ total charge invoiced or written off. Red below 75%, amber below 85%. |
Budget | Total charge ÷ total budget, excluding No Billing and Hourly stages. Stages with no budget use their agreed fee. Red above 110%, amber above 100%. |
Step 3: Combining the scores
Stage roll-up and project financials
The stage roll-up and project financial scores are compared. Where the project financials show a bigger problem than the stages, the project financial score is used. Otherwise the stage roll-up is used.
Stage roll-up | Project financials | Score used |
Red | Red | Project financials |
Red | Amber | Stage roll-up |
Amber | Red | Project financials |
Green | Amber or Red | Project financials |
Amber | Green | Stage roll-up, capped at the bottom of Monitor (0.27) |
Any other combination |
| Stage roll-up |
Adding debtors
Debtors are then added with a smaller weight (0.2, compared with 1.0 for the financial score):
Final score = (combined score + 0.2 × debtors score) ÷ 1.2
The final score is turned into On Track, Monitor or Attention using the thresholds above. Because debtors carry less weight, they nudge the result rather than decide it:
A project that is otherwise healthy but has invoices more than 45 days overdue stays On Track.
A project that is already borderline can be tipped into Attention by overdue invoices.
A project with some stage issues but healthy overall financials and no overdue invoices can show On Track.
Terms used in this article
Term | What it means |
Agreed fee | The fee agreed for the stage. Used to weight stages in the roll-up and as the budget when no budget is set. |
Standard cost | The stage's budget cost: the total cost of all transactions on the stage, whatever their status. This is the rate less the target profit, as shown to project managers. It is not actual staff cost. |
Profit | Revenue invoiced (ex-tax) minus standard cost. |
Residual | The fee still left to bill on the stage. If there is residual fee, a loss-making stage is rated Monitor rather than Attention, because there is still room to recover. |
Revenue (ex-tax) | Revenue invoiced for the stage, excluding tax. |
Charge invoiced | The value of transactions that have been invoiced or written off. |
Recovery % | Revenue (ex-tax) ÷ charge invoiced × 100. Below 100% means discounts or write-offs. |
Total charge | The original value of the stage's transactions at the rate entered, whatever their status. Used for the Budget measure. |
WIP | Work in progress: transactions with a status of WIP or Invoice Draft. |
Aged WIP | WIP with a transaction date more than 30 days ago. |
Debtor ageing | How far past its due date an outstanding invoice is (more than 30 or more than 45 days). |
Note: Aged WIP and debtor ageing use fixed 30 and 45 day periods. They don't use your organisation's Aged WIP or Aged Debtors settings in Configuration.
FAQs
Why is my project On Track when one of its stages is in Attention?
Project Health weights stages by agreed fee and also looks at project totals. A small stage in Attention can be outweighed by larger healthy stages, and a loss on one stage can be offset by profit on others.
Why don't overdue invoices turn my project red?
Debtors carry a smaller weight than the financial measures. Overdue invoices can tip a borderline project into Attention, but won't on their own turn an otherwise healthy project red.
Does Project Health include schedule or resourcing?
No. It is based on financial data only.
