Metric calculations

How the core project metrics are calculated.

This page explains how the metrics on the financial forecast chart, the resource forecast chart, the financial section of the project overview page, and the resource totals on the project schedule are calculated.

Financial forecast chart

The financial forecast values use the following calculations:

• Actual income: $\text{actual hours} \times \text{rate}$
• Schedule variance: $(\text{planned hours}_\text{baseline} - \text{actual hours}) \times \text{rate}$
• In progress: $\text{planned hours}_\text{baseline} \times \text{rate}$
• Lead: $\text{forecast hours} \times \text{rate}$
• Pipeline, medium probability: $\text{forecast hours} \times \text{rate}$
• Pipeline, high probability: $\text{forecast hours} \times \text{rate}$

Project overview financials

The cards on the project overview page use the following calculations:

• Invoiced value: The sum of what the invoices billed, priced from the rates frozen onto each invoice.
• Gross profit: $\text{invoiced value} - (\text{actual income} + \text{expenses})$
• Compliance to plan: $(\text{actual hours} \div \text{forecast hours}) \times 100$

Project schedule value totals

The totals behind the value columns on the project schedule are calculated from two different rates.

Forecast, actual, and baseline value are live figures, so each is the hours on the row multiplied by the rate currently set for that resource on the schedule:

• Forecast value: $\text{forecast hours} \times \text{rate}$
• Actual value: $\text{actual hours} \times \text{rate}$
• Baseline value: $\text{planned hours}_\text{baseline} \times \text{rate}$

Invoiced value, shown behind the INV column, is what the invoices actually billed. Each invoice stores the rate that applied when it was prepared, and the total is calculated from those stored rates rather than from the current rate on the schedule.