Skip to main content

Project Health (RAG) Calculation Guide

Learn how Synergy calculates the Project Health (RAG) Scores.

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.

  1. 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.

  2. 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.

  3. 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.

Did this answer your question?