"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.
It’s typically not until the end of the day at the construction site that the field personnel sit down to collect and enter all the time and expenses for their crews, equipment and other charges for that day. It’s late and they are in a rush to get it done so it’s inevitable that mistakes are made. Things get coded to the wrong place, charges are missed, incorrect rates are used, etc. All these errors are compiled, submitted and ultimately routed to the finance team for processing. And this is where the nightmare begins.
Finance is responsible for ensuring data accuracy in cost tracking before billing clients, paying vendors or routing charges through payroll. It’s not that site foreman can’t be detailed – it’s just that they have a very different spectrum of priorities. What this translates to, is that the finance team is tasked with finding and correcting data entry errors from the jobsite.
Successfully managing construction projects is highly dependent on the quality of the data that’s captured about those projects. Whether you’re using the data to manage costs, bill your clients, pay your subcontractors, determine progress – or all that and more – the quality of that data is crucial to the success of the project. Current, Accurate and Complete – these are the key cornerstones of quality information. What’s more, getting quality data right from the start – i.e. from when it’s first entered into the system – saves organizations tremendous time, money and effort in executing on projects. Not only that, it reduces the chances and effects of any potential claims, disputes, safety issues and delays. Mistakes and omissions bleed energy and money from your organization. The result is not just costly, it’s often embarrassing – and you are particularly vulnerable if you have any manual “double-entry” of data from system to system.
Project controls professionals can spend endless hours discussing, debating and tweaking the required codes for their project and for good reason; there are so many layers to consider in designing the ‘right’ cost coding system.
Find the Right Cost Coding System for You