Uniting Church in Australia
Uniting Church in Australia (UCA) is a non-profit organization and the third largest Christian denomination in Australia with 2,800 congregations, 51 presbyteries and 6 synods. There are over 50 locations connected to the network with approximately 1000 client devices that are supported by a central Help Desk. Over the last 5 years, the IT department has grown to support 2500 staff (from 150 staff). In 2011, UCA selected Kepion as their solution provider for their financial budgeting allocations needs. Kepion partnered with Bizdata to implement and support the solution for UCA.
Uniting Church in Australia has recently grown tremendously in the last 5 years from 5 to 20 internal clients. It became progressively difficult to calculate forecast income and recoverable costs, identify direct and shared charges, conduct what-if analysis and ensure the budget was prepared for both financial and calendar years. As the client base grew, the business rules became more complex and more time consuming to manage on Excel spreadsheets.
"The administrative complexity has grown as a result of growing the customer portfolio" says Pier Fasnacht, Director of Information Technology Services. "I realized this is my problem, for I was doing it all on spreadsheets. It served the purpose for a few years but the rules became so complex I realized I need to get smarter." Revisions of the budget would take 2 days of effort per quarter, any pricing changes would take up to a week to reflect on the spreadsheets. "Preparing the budget seemed to go on for a long time, probably a month of elapsed time, around 10 days of my time." says Pier.
There are aspects of Kepion that are very simple. Loading in the budget, to expenditures, to classification of the number of devices is all very easy within Kepion.Pier Fasnacht, Director of Information Technology Services
Kepion provided UCA with the capabilities to quickly build planning and reporting applications to reduce the reliance on spreadsheets. UCA IT was able to handle all their complex business rules and budgeting requirements. Kepion allows UCA to conduct "what-if" analysis, which allows users to change parameters and see what the effects are, which was particularly important given their dual charging model of direct and shared.
With Kepion, UCA IT was able to provide variable driven allocations across the entire client base from a simple form-driven matrix held within the model. This development enabled UCA to easily change allocation rules, without having to deal with the underlying logic.
"There are aspects of Kepion that are very simple. Loading in the budget, to expenditures, to classification of the number of devices is all very easy within Kepion. Now within Kepion, we can do new pricing for a client by just changing a few parameters. It would show me the new pricing for a client, along with favorable variances based off existing clients. This used to take 10 days before, but now with Kepion, it can all be done within a single day."
Simplifying the Process
With Kepion, UCA was able to automate their process for calculations, consolidations and budget balances between departments.
"Before, if our users wanted to refresh the spreadsheet data, they would have to reapply all the logic and recalculate all the rules at cost pool level and consolidate. Then the spreadsheets needed to be manually balanced to budget." says Pier "Now with Kepion, it recalculates everything for us automatically and ensures that our bottom-line will balance. If it doesn't balance, we would immediately know what the root cause is."
... For me, the key benefit of Kepion is the flexibility of being able to rapidly calculate charges and apply variations.Pier Fasnacht, Director of Information Technology Services
UCA has been using Kepion Modeler to create business intelligence applications for both their planning and reporting needs. With Kepion, UCA IT was able to leverage and make quick modifications to applications in order to adapt to changing requirements. "For me, the key benefit of Kepion is the flexibility of being able to rapidly calculate charges and apply variations.
For example, if I wanted to modify the number of devices, which drives the costs, and see what the impact will be based on different assumptions, it can all be easily done within Kepion," says Pier.
Kepion has helped UCA improve in their overall efficiencies for planning and budgeting processes across all their line-of-businesses. With Kepion, UCA IT has been able to handle on-going complexities of their user requirements. The ability to reuse existing models for different business scenarios, and unique scaling capabilities has shown UCA that Kepion is a viable long-term solution within the organization. "Kepion allows us to actually refine the allocation month by month to reflect major steps that is expected in the future," says Pier. "Kepion is a sophisticated tool that easily manages a complex business environment."
The UCA is a non-profit organization and is the third largest Christian denomination in Australia with has 2,800 congregations, 51 presbyteries and 6 synods.
UCA needed a solution to manage their budget allocation model across all their internal clients. IT needed a easy-to-manage solution to handle complex rule calculations and form entries.
UCA was able to simplify their budgeting process with automated functionalities within Kepion, thus increasing their overall efficiencies by 10x folds.
- Flexibility: Handle complex charge calculations
- Reusability: Leveraging existing models
- Scalability: Adding new clients, devices, etc with ease
- Usability: Ease of conducting "what-if" analysis
Take a look at Kepion today
Interested in seeing what Kepion could do for your business? Click below to schedule a personalized demo.Get Demo