BiGA gleans valuable strategic insights using Greentrees tree analysis
One of Australia’s largest construction and allied industries apprentice training and education organisations turned to Greentree for a ‘best fit’ accounting system...
John Shenfield, chief financial officer at BIGA, explains that whilst the privately funded not-for-profit organisation trains and places apprentices with building and construction industry clients, it does not undertake its own building projects.
Having inherited Job Pack, a vertical construction industry package, Shenfield says the organisation struggled to get the information it needed from a system geared up for construction jobs.
Basically, the business has two distinct areas; employment and training.
The employment part of the business needs to collect, store, manage and maintain information about apprentices working on construction jobs and hired out to client companies.
The training part of the business needs to collect, store, manage and maintain information about the academic learning and qualifications of individuals, who may also be BIGA apprentices.
Being a not-for-profit meant that budgetary constraints and the inherent complexity of specialist systems, pretty much dictated how much of the system Shenfield could replace.
His wish list would have included most of Greentree’s financial suite but the beauty of its modular environment, meant he could purchase only what he needed.
Pulling together data from disparate systems
Since most of the systems BIGA uses are reasonably complex and by and large do what they are supposed to do, the decision was made to replace General Ledger since it was the most cost effective and easily understood.
Greentree’s Open Database Connectivity handles the extraction of data from multiple proprietary sub-systems whilst Excel handles financial reporting.
Of course, none of this works unless something tells all these systems what to do and how to do it and this is when Greentree’s flexibility for customisation and local support becomes strategic.
Customisation, back-up and support
Working closely with the local Greentree partner, Shenfield says they came up with a customised interface to get data in and out of proprietary BIGA subsystems and in and out of Greentree.
After a few teething problems the system is working well and Shenfield states that without the help, expertise, pre & post-implementation support of the Greentree partner, the whole project would have fallen over.
Also of strategic significance, is Greentree’s tree analysis and Shenfield enthusiastically explains why this has stand-out value for him.
Tracking profit streams is vital
Having managed profit-driven businesses prior to BIGA, Shenfield is intimately aware of the need to track and monitor profit streams and cash flows and this is where Greentree’s tree analysis really comes into its own.
He says that although BIGA is a not-for-profit organisation, it’s absolutely imperative that revenue covers operational and administrative costs.
Shenfield explains how he can create logical groups of data for analysis like for example, “which carpentry apprentices are working on a particular client’s site at which location and what’s the charge-out rate?”
The data can be used as parameters for reporting the financial impact on BIGA’s profits of say, relocating apprentices to other locations or allocating additional apprentices to any given client’s site. This is invaluable for ensuring BIGA accurately reports its financial position to management and stakeholders and continues as a financially viable entity.
An “easy-on-the-eye” solution
Shenfield reports that users find Greentree to be intuitive, logical and easy-on-the-eye, which are attributes that cannot be underestimated.
Greentree’s attention to the design and development of a visually appealing user interface ensures user uptake is quick and painless.
Greentree has helped BIGA pull together a number of disparate systems in order to extract, group and analyse strategic data.
Tree analysis leverages the familiarity of Excel to produce sophisticated reporting that informs management decision making and this has all been achieved within a tight budget.
A sound ongoing working relationship with the Greentree business partner holds it all together for the future.
For more information
Graham Hill
Greentree
Phone: 1800 000 737
Email: graham.hill@greentree.com
www.greentree.com
8/6/30_ex
At a Glance
BIGA trains and educates construction and allied industry apprentices but doesn’t actually undertake construction jobs. However, the system they were using was geared for this so they basically needed a ‘best fit’ system that enabled the collection and updating of apprentice and student records. They also needed to analyse business data from multiple disparate systems and create reports that informed management and external stakeholders.
Solution
Greentree’s fully integrated and scalable – business management system
Result
BIGA make extensive use of Greentree’s ODBC, Excel Reporting and tree analysis. These tools enable management to extract and analyse data from multiple disparate and proprietary systems for strategic insights. Specifically, management can examine in-depth, the strategic impact of various scenarios on revenue, profits and cash flows. Excel Reporting enables BIGA to meet its internal and external reporting requirements.
Further Reading
To read more about this solution provider visit their online exhbit in the ERP Pavilion
