How to visualize your real-time costs with software

March 22, 2018

real-time-costs

Probably everyone who has ever managed a project agrees that during project execution you want real time information about the status of your project. This can be quite a challenge since often large amounts of data need to be processed and limited time is available to generate your reports. Still, it is possible to extract and visualize the status and performance using project controls software tools. Let’s look at some examples.

 

Organize cost data with breakdown structure reports

You will very likely encounter long lists of budget items, commitments, actuals and other cost data that needs to be processed during execution. To ease this job, you can use breakdown structures to structure cost data. Below is an example of a breakdown structure report using a Cost Breakdown Structure (CBS):

Cost Breakdown Structure table

 

Visualize cost trends with charts and graphs

By creating breakdown structure reports at each control moment in your project, say every 2 weeks, you get a picture of how the project evolves over time. This can be visualised in a graph:

Project progress graph

We are looking at the revised baseline cost, commitments and earned value (cost of work performed). Each dot you see represents the total cost from a breakdown report. This is now comparable with the planned spending from the revised baseline. What’s especially powerful is showing this graph for specific parts of the project, by filtering parts of the breakdown report. For example, by only plotting the civil parts of the CBS, a more detailed indication of the progress from this discipline is obtained.

 

Track perfromance with key KPIs and dashboards

From the breakdown report you can also take differences and ratios between accounts. For example, taking the ratio of the revised baseline cost and the actual cost, you obtain the Cost Performance Index (CPI). By displaying it as a dashboard with colour coding, you can visualise this to get an early warning tool:

Dashboard with colour coding 1Dashboard with colour coding 2

Many more indicators or metrics are possible if the project controls software allows you to define them. Using filters can isolate specific parts of the project instead of looking at the overall total.

 

Forecast costs with cash flow curves

The traditional cash flow of the project should be available for extraction as well, comparing spending to incoming payments. An example is shown in this graph:

Cash flow visualization

From the report date onwards, the cash flow is forecasted using the planned and actual status of the project to get a real-time indication of your working capital the next months.

It is very well possible to extract real-time information with project controls software. The example images above were all created using Cleopatra Enterprise. Bringing your cost engineering department to the next level starts with a tool that suits your needs.

Something to add to this article? Contact us.

Related resources

When managing a project, having a complete overview of what is happening everywhere is the key to success. Therefore, having the right tools to handle all the relevant information of the project will be a great asset. The amount of data that a cost manager works with in a regular…

When managing a project, having a complete overview of what is happening everywhere is the key to success.…

Read blog article

Keeping a project under “control” can be very challenging. Here’s a list of the 5 greatest benefits of using a project controls software with advanced technologies.

Keeping a project under “control” can be very challenging. Here’s a list of the 5 greatest benefits of…

Read blog article