Budget Management System - 30+ Cost Centres
Air New Zealand Engineering Services is a major supplier of aircraft, airmotive and component maintenance, repair and overhaul services with customers in New Zealand, Australia, Asia, the Americas and Europe.
The Finance team needed a system that could capture the results of different scenario planning models and facilitate comparison between the different scenarios.
They needed to be able to change an assumption, model a scenario and quickly report on the impact of that change across the planning horizon.
And they had a number of Profit Centres that contributed to the group performance. Finally, as a 'nice to have' they needed to be able to use the same data to upload into their ERP system thereby avoiding duplication of effort.
The solution was custom-designed using VBA code on a Microsoft Access platform incorporating multi-user functionality.
The design took into consideration standard internal control procedures and checks to validate the integrity of the data being managed and programming code to translate plan dates to the appropriate financial period.
A dynamic reporting program enabled the reports to split results into 11 columns of a combination of months, quarters and years dependent upon a starting date nominated by the user.
Custom coding eliminated the downtime associated with most of the repetitive administrative tasks associated with the process allowing the team to focus on the review of the assumptions and analysis of the trends.
The data was programmatically summarised into an extract that met the input requirements of their ERP system, SAP Financials.