UniPhi Blog

UniPhi 13 is coming!

Mark Heath, 31 May 2017


The UniPhi platform is fast approaching its 12th anniversary. And as is the case every year, we are continuing on with the development of enhancements and brand new features. Over the course of the next few weeks I'll be producing a series of blogs which will detail exactly what you can expect in the forthcoming release of UniPhi 13 due out in July 2017.

The two major features are enhanced BI reporting with Tableau, PowerBI or other tools of choice and a tweak to the interface. (Hint! We've gone square!)


BI Tools providing rich reporting capability

BI Tools enabling cut and dice analysis

Some other new features are:

Redesigned My Work Summary tab. We have completed a redesign of the my work summary so that you can now see all of the work that you have allocated to you.

Issue Custom Fields can be added to the Issues tab. This allows you to filter for any specific type of issues according to your organisations requirements

Ability to link issues to milestones, and link milestones to lifecycle phases. As issue or action dates change, your lifecycle dates are dynamically updated, and your milestone forecast data are also adjusted.

Progress Claims multi contract selection. When creating a progress claim, UniPhi now allows you to select all contracts within a project that relate to a single supplier.

Provisional Sums. Allows you to specify a deliverable as being a provisional sum, and then managing the committed value as it becomes known.

 

Share this:

Cost Management Series III - Cash flow

Mark Heath, 11 May 2017

Feedback from cost management firms is that there is a dearth of software to support the cash flow forecasting requirements for developers and consultants. One of the reasons for this is the complexity in generating an algorithm that can handle with accuracy the permutations of projects that are run in the construction industry. One of our clients has 12 construction industry sectors (e.g. Health, Education, Commercial, Leisure etc). Across all sectors there are over 30 project types or sub sectors (e.g. oil and gas, solar for energy sector, defence and justice for government, Office short, medium and tall plus fitout for commercial etc) and against 30 project types there are literally hundreds of asset types (Halls, libraries, pools, stadia etc etc). Then you need to consider the work types for these projects (i.e. new build, refurb, extension etc). And finally size and complexity all need to be considered.

How can a software developer generate an accurate profile of how an estimate will be spent over time? Many project managers build up work breakdown structures with both effort and material allocated. This is then sequenced and durations determined for each piece of work. Then via the Gantt profile, scheduling software can spit out a cash profile.  However, this is an enormous amount of work to complete for an investment that may only be at feasibility stage or even right up to detailed design. What if there was a better way?

We believe that a simpler way is to leverage the past to predict the future. As projects are completed, an actual earned profile is developed for that project. Categorising that project with a selection for each of the meta data described below means that we can use this information on any future projects that match the meta data classification. So over time, your consultancy, development company or construction company can use past projects to predict the spend profile of future ones.

Read our blog post on the release of this cash flow algorithm here:

http://uniphi.com.au/blog/view.aspx/uniphi-12-s-curve-phasing-algorithm-based-off-benchmark-past-621551636789556201

Or watch a demonstration of it in use on YouTube below:



Now this database of old projects can be an inhibitor to the success of such an algorithm, however, the expectation is that most organisations have strategic plans that result in them focused on only a small subset of the sectors, project types and asset types listed above. Therefore, it does not take long for cost data to exist in their key strategic niche to. Cost consultancies could look to sell actual phasing profiles of past jobs to companies in niche areas of work (so long as that company has UniPhi to take advantage of the data!). With a small amount of strategic activity, even a startup construction company or developer could obtain rich benchmark data for very little when compared to the risk of poor cash flow forecasting leading to funding issues and other financial stresses.

 

Share this:

Cost Management Series II - Managing change

Mark Heath, 26 Apr 2017

UniPhi's version 12 release saw the demise of the lonely change request system. This system was created in UniPhi's second release back in 2005. Since then, the documents, costs,  issues and risks modules have evolved to a point where all the functions contained in change requests were better managed via these other modules.

How is this so? Well, we realised that managing change is significantly more than document the description and reason why change occurred and then analysing the impacts. If you want manage change rather than react to it then it needs to be incorporated into the day to day management process of which, the first element is capturing the risk of change. By better identifying the risks of (or opportunities for) change to your project, you can then create specific tasks in UniPhi to mitigate the chances of the risk occurring and preparing for if it does.

Risk register across a portfolio of projects
As projects evolve, these risks sadly sometimes eventuate and other issues crop up that weren't identified in the risk analysis. By triggering contingency plans or logging, managing and if necessary escalating issues in a transparent and collaborative fashion through a web based tool that pulls in emails and allows for commentary with file sharing, these changes can be effectively closed out without impacting on budgets or delivery dates.


Of course, some issues morph into events that do requiring further funds and/or delay delivery of the project outputs (we won't even touch benefits as who manages these anyway). When this occurs, new budgets can be created in UniPhi's cost module, time delays via the project schedule function and then presented to management in accordance with the relevant delegation of authority via the the documents system. Once approved, this then becomes the new baseline to compare commitments and forecasts to complete.




And that is the interactive, evolutionary way we support managing change.

 

Share this:

Cost Management Series I - Adding Value to the Value Management Conversation

Mark Heath, 15 Sep 2016

Value management
Value management is a methodology mainly used in the construction industry to do what most commercial organisations would call benefits management. However, in my experience, much of the value management discussion conducted in workshops or in after workshop documentation doesn't really focus on the real final benefits of the building being designed. Most discussions look at precursor factors to value like number of desks per sqm, number of meeting rooms, green star and the like. This is mainly because these things are easy to value.

Best Practice
This is where the cost consultant can come into their own. By knowing the key benchmarks and by being able to quickly analyse where the variance occurs and how much things vary for every quantum or rate change then at worst they can input into the investment side of the debate. For example, a cost consultant being able to quickly advise that removing 10 workstations and adding two multi-media meeting rooms will cost an extra $50,000.

Key to this best practice is the development of volume and rate variances. Each time a cost plan is updated, the cost consultant needs to be able to quickly identify the volume change, the rate change and the monetary impact of those changes and this needs to be done on a functional and elemental level. Again, an example of a change in design and type of windows leads to an increase in costs of $2m but this is driven by a $3m increase in the price of the windows offset by a $1m saving in scope. Now it might be that this design reduces heating and cooling requirements that leads to a 4 star Green Star rating but the reduction in size and number leads to reduced natural lighting. The investor may then review the value in keeping the original design but just change the quality of windows as it is only a $1m saving for a reduction in potential comfort of the space.

A sample view of this type of data can be seen in the screenshot below:

Variance analysis at the elemental level - download image for original size.

Variance analysis displayed graphically

Equally, it is essential that the cost consultant has the knowledge and time to complete extensive sense checks on these value management estimates as they're often time constrained, are not completed from first principles and can rely on benchmark data to create.

Software can provide significant value to this by automating the calculation of volume and rate variances including the monetary valuation of these changes (not merely the quantum) and by auto calculating the sense checks that verify the veracity of the estimate. As per previous blogs, benchmarking, leveraging the data captured on previous projects and using this to validate the estimate is essential.

Future disruption
As can be seen here, the variance analysis needs to be centred around whether the extra benefit is worth the extra investment, not just what the design parameter changes cost. There needs to be a higher level conversation that matches the goals of the investor. For example, in a fit out example, what's the staff profile and growth prospects of the business? What is their hot desk policy? How are they expecting this new fit out to change staff retention rates and what is the $ value saved in terms of re-training and knowledge loss? As a cost modelling expert, it should be possible for consultants to extend their capabilities into the benefit side of the equation and use their modelling skills to provide input into the value management conversation.

Again, software can help here by quickly aggregating the bottom level benefit drivers into the overall $ value assessment and linking the net benefit/deficit of a change in one design over another. Perhaps the future will see the Cost Manager become the Value Manager when benefits are factored into their cost modelling!  

 

Share this:

UniPhi 12 - Upgraded cash flow phasing

Mark Heath, 04 Jul 2016

Key to the successful deployment at a recent client of ours was the upgrading of our cash flow capabilities. We have already referenced some of these including the only known software product on the market that can phase cash flows based off the earned value profile of a collection of similar projects. However, there is much more just in time for our 12 release including:

  • More user friendly navigation of cash flow forecasts with more filters and an excel grid look and feel
  • Linking the start of one cost or revenue codes phasing based off the end of another
  • Linking the phasing of a cost or revenue code to the start and/or finish date of a lifecycle phase
  • Applying a non-benchmarked "S" curve algorithm
  • Productivity adjustments for auto phasing
  • Ability to shift the start date of a project which already has a cash flow

We will now go through each new feature one by one:

When entering the phasing screen the default start month is either the first month that already has a value or the start date of the project. You are then presented with a 12 month period and Previous/Next navigation options. You can jump to a date in the future by selecting the start date.
The real key is the presentation of all data on one screen (including children projects within the parent and contracts phasing in the same screen). Filtering then allows the user to remove the noise including a levels filter to display the relevant level of codes/contract deliverables that you wish to phase against and focusing on either forecasts or budget. Of course there's still the "All" view that shows budget versus actual and variance for analysis purposes.

The new cash flow phasing screen with contracts displayed against their relevant code.






















The key to the next two features is to streamline the adjustment of cash flow phasing as things change. An example of this is the fact that settlement of units sold during construction phase will always occur after a certain period (e.g. 2 weeks) that the certificate of occupancy is obtained. There are two ways to link these two events in UniPhi, 1) link the construction cost code to the revenue code or 2) link the construction lifecycle phase to the revenue code. In both events, changing the end date of construction will automatically push out the start date for sales settlements.

Linking dates for automated cash flow phasing
Added to the automated phasing methods are our unique "Benchmark" method and a standard construction 'S' Curve algorithm. These methods can be chosen per cost code or for the project as a whole with the relationship maintained for any changes to dates and durations. Also included is the simple "adjust start" function which allows you to shift the phasing profile forward or backwards in time to allow for changes to planning decisions and internal approvals (as are wont to occur).

Finally, the 'S' curve algorithm's can be adjusted via a simple productivity percentage applied to financial months that are typical of down time in your industry or geographic location. As an example, you might apply a 50% reduction adjustment for December January in Australia to allow for the fact that the construction industry shuts down for four weeks over the Christmas and New Year period.





 

Share this:
Next Page >