Return to Case Studies

Context
Financial modelling and systems analysis are structured approaches that can assist organisations to make critical business and project decisions. In particular, these approaches can provide individuals with an easy to use, decision modelling tool for the analysis of complex problems and for dealing with large amounts of information, reliably and efficiently.

Financial modelling and systems analysis have been used to inform complex decision making in the following areas:

  • Budgeting and forecasting
  • Investment planning
  • Financial statement projections
  • Cost-benefit analysis
  • Cost allocation models
  • management reporting
  • scenario planning
  • corporate planning
  • consolidations, mergers and acquisitions
  • business development, marketing and other corporate models
  • project evaluations
  • production planning and bill of materials processing systems

Financial modelling and systems analysis provide an interdisciplinary approach – bringing together analytical tools, design methods and evaluation techniques.

 

Modelling Approach
Evans & Peck, in partnership with Trueblue Systems, has demonstrated that the use of Code Blue in financial modelling and systems analysis offers distinct advantages over traditional tools.

Code Blue blends the power of a language with the simplicity of a spreadsheet to enable the dynamic construction of systems, and uses a modelling approach rather than the standard database and reporting focus of traditional packages.

Spreadsheets encounter serious difficulties when used on complex problems, and they can can quickly become error-ridden and unworkable. By using Code Blue, the degree of complexity and difficulty in solving problems is minimised. As well, the structured approach used by Code Blue can eliminate costly human errors - resulting in significant savings and greater management of risk by organisations.

 
 

Key Benefits
The key benefits of using Code Blue include:

  • Fast development time, resulting in significant cost savings
  • Solutions customised to individual needs
  • Easy formulation of models
  • Can be managed and maintained by anyone in the organisation
  • Audits can be undertaken by people not familiar with the software
  • Reduced error rate
  • Long model life-times (due to the structured approach)
  • Teams of modellers can work together on large projects
  • Simple integration with existing databases
  • Sharing of data between systems
  • Ability to import graphics, images, audio, video and reports from other systems
  • Control of intellectual property as systems are owned by organisations
  • Built in facilities provide what if scenarios, risk ( Monte Carlo ), goal seeking, pivot tables, macros, excel worksheet generation, optimisation and sensitivity
  • Compact model size
  • Real time scenario generation
  • Automatic data exchange

The ongoing development of Code Blue means clients are able to respond quickly to changes in their industry and working environment, and gain a distinct advantage over competitors.

Experience
Code Blue has been chosen as a cost effective and powerful financial modelling tool by leading Australian organisations including Wesfarmers, the Australian Rail Group, Western Power, Plan B, Australian Fast Foods and Cedar Woods Properties.

The diverse applicability of Code Blue is demonstrated by the many industry sectors in which it has been used, including:

  • Transport – (Australian Rail Group)
  • Justice – (Department of Justice WA )
  • Infrastructure – (Western Power)
  • Retail – Australian Fast Foods
  • Property Development – (Cedar Woods)
  • Financial Services – (Plan B)

Contact info@decisionmodelling.com for further information.

 

Key Modelling Technique: Financial Modelling and Systems Analysis
Modelling Software Used: Code Blue