COMPANY
The Department’s Key focus is on operational transport functions and strategic transport planning and policy across the range of public and commercial transport systems that service the State. It’s role is to connect people with goods and services through an intricate system of roads, railways, airports, ports and waterways and educate and regulate to keep them safe within those networks.
Challenges and Business Objectives
- A proposed solution was required to produce a 5 year Budget. The current Years’ Budget was required to be captured at a detail level, with remaining years being produced at a higher level.
- Budgeting and Planning was entirely Excel based, with all the issues typically associated with spreadsheet-based solutions. Considerable manual effort was involved in reconciling activities throughout the process.
- The development of mappings were required to interface with Department of Treasury and Finance chart of accounts.
SOLUTION
- Hyperion Planning was used as the core component to capture Budget inputs from users and centrally consolidate and calculate numbers to produce a final budget. The system provides a mechanism to quickly iterate and easily track changes arising from adjustments initiated by Treasury (SIMS system) and internal budget transfers.
- Outcomes produced to be accessible to the Oracle BI Apps database for reporting purposes.
SOLUTION BENEFITS
- Historical data sourced electronically from Oracle EBS
- Base budget data captured from users
- A journaling mechanism was developed to capture budget movements and changes
- A labour module which calculates outcomes by position and associated average costs per position was developed.
- Automated electronic upload of completed Budget data back into Oracle EBS
- Developed an interface to source data from the client as well as provide final budgets and revisions back to the client's Accounting system (SIMS)
ASK US A QUESTION
Government / Budgeting & Forecasting