Driving Project Costing Improvement

Businesses whose main activity is project delivery, be it construction, engineering or manufacturing are often missing opportunities to drive improvement. This article explores how ‘closing the loop’ on project delivery can highlight the areas where businesses can improve and become more competitive.

Projects of a significant size tend to follow the same basic structure across sectors such as construction, engineering and manufacturing. Terminology varies, but in the most basic form the steps are: costing, pricing, decision (win/lose) and delivery with actual costs.

Some projects can be highly complex of course, incorporating lots of moving parts and interdependency. One small failure can quickly snowball. This may be common, but to accept it as the norm is a failure to embrace improvement. A business must build a mechanism to learn from individual failures to improve as an organisation.

“You must learn from the mistakes of others. You can’t possibly live long enough to make them all yourself.” Samuel Levenson

Top Level View

At the top level, a project has six outcomes in this context which may be described on two axes. The vertical won/lost axis and the costing axis which is original estimated costs versus the actual delivery cost.

For the boxes along the bottom row, you will not know the actual cost of delivery as the contract was lost, so it is hypothetical. This makes it even more important to be confident that costings are accurate, as not knowing why contracts are lost are a big hurdle to improving competitiveness.

Consider each in turn:

  1. This will be a common scenario – the project cost estimates are too high, the price in-turn was too high, and the contract is lost. When you consider the amount of effort to get to this point in terms of sales, marketing, estimating and compiling documentation, it is a travesty to lose due to poor costing data. This represents an enormous amount of waste and has an impact on growth.
  2. The contract is won, but it was under-costed. It may not be apparent until late in delivery, as budgets run out. In some cases, it you may not know about it at all, for example, poorly structured cost allocations (e.g. booking to overhead codes), can hide the poorly performing projects. Even if the business overall is profitable, it could do better if this problem is identified and corrected. Individual projects could be operating at a reduced margin, or even worse, a loss. There are exceptions, for example you may deliver a project at low margin for strategic reasons, to ‘catch the bigger fish’.
  3. The costing and price were exactly where it should have been, but you lose the contract. It is worth understanding why of course, maybe other factors fell short. But if it were just cost, maybe your competition fell into the trap of box 2, in which case in the long run, this could still be a win.
  4. The project was over costed, but it was still won. This situation may look like a major win, in the short-term, it undoubtedly is. However, you ran the risk of losing the project (box 1). There is also risk to the long-term relationship with a client, and reputation. On the flipside, you may have discovered the market can support higher prices for some projects, in which case this learning point can be fed into future pricing – pushing up margins.
  5. Under-costed the project but lost it anyway. On the face of it, you have probably dodged a bullet in this scenario. But there are still points to learn, why did you not win despite underpricing?
  6. This is the desired outcome of course. Estimated costs and actual costs were aligned. Margins are protected, relationships and reputations remain positive. But it is not all ‘high five’ just yet. There may still be room for improvement. Although the project as a whole came in on cost, what about the constituent parts? You may find some were under costed (box 2) and some were over costed (box 4). Still room to improve even in a successful project. This is where granularity of data becomes important.

“It’s much easier to double your business by doubling your conversion rate than by doubling your traffic.” Bryan Eisenberg

Cost Structures

To get the proper visibility it is important to set up a solid cost structure. The main aim is to reduce the reliance on overhead codes and allocate direct costs properly. Ideally you need to book as much as you can to direct project codes to get a true reflection of project costs. For example, if all internally managed transport function is booked to an overhead code, the cost is skewed as overheads are distributed by sales value (or similar) and not actual use. By booking the vehicle and its mileage to a project, then amortising the costs accordingly you will get a more accurate picture of the project costs.

There may be a concern that this adds to workload. In the short-term it will a little. But as more projects are handled this way you will be able to create templates from successful project elements, which form the building blocks for future projects.

The granular data structure means the data can be used as an improvement tool. Where there is deviation between estimate and actual costs, you can drill down into the data to find out why. You can also compare projects at different levels to gain insight and true business intelligence.

By closing the costing loop, improvement cycles are created, and this will improve competitiveness as costing processes become more refined. But there is more…

Image of closed loop project costing

Earned Value Management

Collecting the data at the end of a project allows the closure of the loop for the whole project, but there is great advantage to collecting the cost data as the project is running. Live (or near to) data collection. Ideally the data should be collated in a centralised database (in the cloud if your teams are mobile) because this presents a fantastic opportunity.

Rather than just reviewing on project completion, project performance can be monitored continually. A loop within a loop. To achieve this there is one element missing.

Take an example. Say one element of a project is estimated to cost £100,000 (labour, materials, asset use, etc) and should take 6 weeks. You are three weeks in, and you have spent £50,000. Superficially it looks like it is on track. But progress may not be in line with spend and time. Only when you capture ‘earned value’ will you know. If this project element has earned value of 25%, then you are 100% over-spent and 1.5 weeks behind. Good to know sooner rather than later, as a snowball effect could impact the whole project and early detection will give a greater chance of recovery.

Earned value is quite simple and common. The trick is to break it down to suitable elements. Break it down too far and it becomes onerous to manage, not far enough and you do not get the intelligence value.

If the work breakdown structure (WBS) is linked to costs and earned value, further benefit can be derived. Add payment stages and supplier terms and you can create a cashflow forecast.

The open-loop process from above is now developed into a closed-loop improvement driven process. This process will improve cost accuracy, protect margins and support growth.

Image of closed loop project costing with monitoring

Outline Plan

The benefits of closed loop project management can be enormous. But how would you go about it? Every business is different of course, but here are the main steps:

  1. Review and challenge the cost structures. Design a cost structure that will be future proof and allow as much cost as a possible to be allocated as direct rather than overhead.
  2. Reflect the new structure in accounting software and build a database system to hold the project data that connects to the accounting software. The project data will include WBS, earned values, timescales, cost profiles, payment stages and supplier terms. You may want to start with the basics first and refine the system later.
  3. Build a cost estimates front end. Many businesses make the mistake of trying to do this with spreadsheets. Fine to test as a prototype, but in the long run you need a centralised database system to manage this. If the data is fragmented across dozens of spreadsheets, it will be impossible to leverage the benefits.
  4. Add the pricing structures, overhead recoveries, approval and quoting steps into the system.
  5. Once this is in place, the quoting process can be automated. This will save a lot of time and mistakes. Crucial if your clients expect quick answers.
  6. Build a review process for those bids that are lost. Capture lessons learned where possible and refine the costing models to suit.
  7. During delivery of projects that are won; capture actual expenditure, timesheets, earned values, etc. Build the monitoring review cycles so deviation can be managed.
  8. On project completion, review the actuals against the original estimates and refine the process and cost models to ensure a more competitive approach next time. There is always room to be more competitive.

“An organization’s ability to learn, and translate that learning into action rapidly, is the ultimate competitive advantage.” Jack Welch

Finally

Whilst building a process like this, it is easy to get bogged down in too much detail. My top tip for this: Design the framework first, to ensure anything you do does not preclude future developments. Then build simple versions of the process within the framework allowing you to add detail and refinements later. In other words – start simple.

A brief note on reporting. You can categorise reporting into two camps; one is the repetitive reports that you need to see on a regular basis. They tend to be the same and are there to highlight exceptions, e.g. KPIs, status reports etc. These can be automated.

The other type of report is those used to solve problems. They tend to be more flexible. They are an exploration of the data to understand cause and potential solutions to problems. You cannot really automate these in the same way, but it is important to base them on a single version of the truth. This is where Excel and Power BI are their most useful.

Closing the loop on project delivery will drive improvement and competitive advantage but it is a tough journey.

“The most valuable commodity I know of is information.” Gordon Gekko

Tel: 01482 762 102
Email: enquiries@vensis.co.uk