Project KPIs

Project header KPIs explanation and formulas

Corrie Hermans-Webster avatar
Written by Corrie Hermans-Webster
Updated over a week ago

In this article, you will find more information about the KPIs in the header of your projects. When you hover over the "i" icon, you will find several different KPIs. You can read an explanation for each one of them below.

"Hours tracked" hover

Exceedance activities
This counter displays the total exceedance for all individual time activities. We show this because the total spent/budget ratio can still be "positive" even though an exceedance or overspend can occur on the individual activity level.

Example:
Activity 1
Budget 2500
Spent 1500

Activity 2
Budget 500
Spent 1000

The total spent is 2500, which is below the project budget of 3000. We can most likely already conclude that this project will be over budget. We spent 500 too much on activity 2, so the activity exceedance is 500. (Activity 2, spent 1000 - budget 500 = 500)

Initial budget
Users can set an "initial budget" for each activity. This is a memo field to keep track of the budget which was initially set when approving the estimate for the project. 

It can happen that the budget for activities change during the course of a project. To be able to stick to the initial budget when changing  budgets you can use this field. 

Example:
Activity 1
Budget 2500
Initial budget 1500

Activity 2
Budget 500
Initial budget 1000

Total "Budget" for both activities is 3000 (2500 + 500). The initial budget is 2500 (1500 + 1000) this means that the margin for this project decreased with 500. 

"Expenses tracked" hover

Exceedance activities
This counter displays the total of the exceedance for all individual expense activities. We do so because the total spent/budget ratio can still be "positive" though an exceedance or overspent can occur on individual activity level. Exceedance for expense activities does take POs into account. Rodeo automatically check if either the PO or spent amount is the highest to take into account.

Example:
Expense activity 1
Budget 1000
Spent 1500
PO 2000

Exceedance is 1000. (PO 2000 - budget 1000)

Expense activity 2
Budget 1000
Spent 1500
PO 1000

Exceedance is 500. (Spent 1500 - budget 1000)

Initial budget
This KPI works the exactly the same way for "Tracked time" as for "Expenses tracked". Please read the explanation above at "Hours tracked" hover.

Remaining PO amount
This is the amount for which you could still expect expense invoices. The remaining PO amount is the total amount for all open POs on the project minus the expenses related to this project's POs. 

Example:
PO amount 4500
Expenses tracked 2000

The remaining PO amount in this case is 2500.

"Total invoiced" hover (project is not "closed")

Budgeted margin
This KPI indicates the margin left when the all project expenses are tracked based on the set values for the budget. 

Example:
Expense activity 1
Budget 5000
Selling for 6000

Time activity 1
Budget 3000

Budgeted margin is 4000 (6000 + 3000 - 5000)

Overdue invoices
The total amount of invoices which have an overdue payment date and are (of course) not yet paid.

Approved estimates
The total amount of all approved estimates for this project. You can compare this value with the projects selling price and the amount invoiced to keep track of the projects financial status.

Total invoiced
Total amount invoiced for this project, displayed to clarify the calculation for the project's margin.

Expense budget
Total expense budget for the project, displayed to clarify the calculation for the project's margin.

Exceedance
Total of "Exceedance activities" for tracked time and expenses, displayed to clarify the calculation for the project's margin.

Actual margin
Actual margin = "Total invoiced" -  "Expense budget" - "Exceedance". The "Actual margin" indicates the current margin to cover agency costs. This is already invoiced to your customer - the expected amount of expenses - total exceedance.

"Total invoiced" hover (project is "closed")

Rodeo displays a different formula and KPIs for projects with the status "Closed". 

Total invoiced
Total amount invoiced for this project, displayed to clarify the calculation for the project's margin.

Expenses tracked
Total amount of all tracked expenses for the project. 

Remaining PO amount
This is the amount for which you could still expect expense invoices. The remaining PO amount is the total amount for all open POs in the project minus the expenses related to this project's POs

Realized margin
Realized margin = "Total invoiced" -  "Expenses tracked" - "Remaining PO amount". The "Realized margin" indicates the final margin to cover agency costs. Invoiced to your customer - tracked amount of expenses - expected amount still to be paid to suppliers.

Did this answer your question?