"Excel just wasn’t designed to do some of the heavy lifting that companies need to do in finance.” So says Paul Hammerman, a business applications analyst at Forrester Research Inc. Despite that generally accepted fact, spreadsheets continue to be widely used as the default tool of choice for managing the finances of construction projects large and small. Most individuals that find themselves in this situation however, would enthusiastically agree that the use of spreadsheets for this level of complexity requires a ridiculous amount of meaningless effort for very little return. Far too much effort is put into getting the data into the spreadsheet – and all the formulas straightened out – that little time is actually spent analyzing that data.
Time-phasing the project budget is as core to project controls on construction projects as pasta is to Italian food. Or hockey is to a Canadian winter. Time-phasing is so central to project controls, that in 4castplus there are five different time-phasing plans that can be setup on a single project. Actually, there are 10 – but in this article we’re mostly going to talk about one really important one.
One of the most important functions of project controls and cost engineering, is the ability to accurately forecast remaining costs-to-complete on a construction project. With the new Resource Forecasting tools in 4castplus, project controls professionals can now achieve ultimate accuracy and take full control of how projects are forecasted.
Several decades ago, organizations used to manage all their finances using big paper-based ledgers, where they’d spend much of their day “doing the books”. These large ledger books worked for hundreds of years, however it would be a challenge to find any modern company today that runs their business on paper-based accounting methods.
The recent announcement by the Alberta government to invest $1B in grants and loan guarantees to partially upgrade its bitumen, is great news for the Alberta energy industry. As a landlocked province with no access to tidewater for access to diverse markets, and no pipeline to transport its bitumen, Alberta is not getting full value for its products. It’s the government’s hope and expectation that this will incentivize a further $5B in private investment to build and improve the local upgrader infrastructure.
It’s not uncommon for organizations to consider the idea of using their ERP as a one-stop-solution for all their technology needs – even when it comes to managing the many-layered complexities of cost management on major projects. It’s an appealing idea: everything in one place, under the tight control and scrutiny of the finance department. The challenge with this of course, is that the target users of an ERP are in the finance department, not those who are managing the day-to-day operations of a large construction project.
Construction projects have many moving parts and a colossal amount of data to carefully manage in order to keep the project running to plan. Not only that, but there are numerous different types of users that need to work collaboratively in real-time. Such as: Project managers, project controls, engineers, field staff at the jobsite, subcontractors, project owners and others, that all need to work together, sharing data and workflows, to seamlessly bring a project to a successful conclusion.
More and more companies are demanding greater visibility into construction project performance. Simply put, companies want to know that funds are being well spent and that their projects are going to run to plan. As a result, increased demands are being made on project controllers to deliver timely and accurate cost and revenue forecasts to help shape business decisions. But hey, you know all about this, don’t you?