Data from the Project Dashboard

The purpose of the Dashboard is to give project managers a real-time overview of their project data such as costs, budgets and progress percentages.

This article aims to introduce Global indicators and to detail the calculations behind these elements of the Dashboard.

Introduction to Global Indicator

The Global indicator section allows you to manually update the different indicators and add explanatory comments if needed in order to share a quick visual of project progress with collaborators.

To update an indicator, you need to:

1. Click on the Update button.

2. Select the status for each indicator that needs to be modified
3. Add a comment (if needed).
   • If a comment already exists for an indicator, replacing it will save the old comment in comment history.
4. Click Save to save your changes.

To view the comments for each indicator, click on the icon .

You will also be able to see the history of previous statuses and comments, including the date and time of the update, and the name of the person who made each update.

Description of Financial items

Initial Budget 

• Displays the pre-tax dollar value of the first version of the budget.
  • This budget may have an Archived status (meaning it was replaced by a new budget)
• If no version is Archived, Aidi displays the current approved version.
• If there are several components, the sum of the budgets corresponding to these criteria is displayed.

Approved Budget

• Pre-tax dollar value of the approved budget.
• If there are multiple components, the approved budgets are added together.

Committed

• Approved purchase orders, change orders and operating expenses, in dollars, before taxes.

Invoiced

• Sum of all invoices with status Accepted, before taxes.

Trend

• Reflects the pre-tax dollar value presented in the Cost summary.
• These are committed amounts + upcoming amounts.
• Future amounts are unapproved directives and ODCs, unapproved purchase orders, budget lines not yet committed, risks listed in the cost summary.

Budget Gap

• Difference between Approved Budget and Trend (Approved Budget - Trend).
• A negative amount is shown in red as a projected cost overrun.

Total Projected Costs

• Projected costs are entered manually in the Cost Summary to by-pass or extrapolate the tendency automatically calculated by Aidi. This feature is only available to cistomers subscribing to the Advanced or Enterprise plans of the Aidi platform.

✏️Note: Any negative amount will be displayed in red.

Description of Advancement items

Advancement (pmt request/committed)

• Overall percentage progress of approved Payment requests.
  • This percentage is calculated as follows: cumulative total amount of Payment requests divided by (Approved purchase order amounts + approved Change orders amounts + Operating expenses)

Date Advancement

• Calculation based on project start and end dates.
  • These dates are defined in the project scheduler at the task level in order to allow a percentage of progress more representative of the reality of your projects.

• The percentage displayed is the difference between the Start Date and End Date of the project, compared to today's date. 

  • Example: the difference between the start date and end date = 10 days and the curent date is 3 days after the start date, the Date advancement % = 30%.

✏️ Note: If no task has been created in the scheduler, the start date and end date of the project equal by default the date of creation of the project.

Invoiced

• The percentage of the total amount of all invoices divided by the total amount of all commitments (Purchase orders + approved Change orders).

Contingency Use

• Percentage of total amount of all approved Change orders divided by the sum of all budget lines marked as Contingency.