a
Case Study Government Workday Adaptive Planning SAP Integration

Revolutionising the Data Capability
of a Government Department

Client
Australian Government Department
Industry
Government
Location
Australia
Solution
Planning and Reporting with Workday Adaptive Planning, integrated with SAP

The Requirement

Data models in Excel, with sources that were not integrated, meant manual updates whenever data changed and left little time to analyse it.

The Solution

A centralised, multi-user planning and reporting system integrated with SAP source systems, with complex models for every key organisational area.

The Impact

Monthly reports refresh at the click of a button, and planning is now continuous, controlled and auditable, with more accurate rolling forecasts.

01 · Client Overview

About The Department

This Government department relies heavily on data to support its members and provide public services, but its data management system was prone to human error.

Planning was limited to large scale budget and forecast cycles, as repetitive and mundane tasks took the department’s staff away from more regular, high-value work.

02 · The Requirement

The Requirement

  • The department’s data models were based in Excel, which created issues with version control
  • Sharing files over email and network share drives created security concerns and potential for file corruption
  • Data sources for the models were not integrated, meaning manual updates and re-importing whenever source data changed
  • Significant time was spent creating the data, which left little time to analyse it

“Reporting using systems that require the compilation of data from multiple sources that are not integrated is frustrating and challenging for financial close teams. Financial systems are always active with changing values, and the review process is constant. Updates and adjustments to systems that use offline reporting mechanisms such as Excel are a real headache, particularly during pivotal reporting cycles.”

Tony ButlerManaging Director, Decision Inc. Australia
03 · The Solution

One System for Planning and Reporting

Decision Inc. Australia first showed the department how a centralised, multi-user system for Planning and Reporting could revolutionise its processes and drive time and cost saving efficiencies. The goal: a system integrated with SAP source systems, providing a seamless reporting framework that could be run on demand.

Reporting Base

A solid financial reporting base that automates the periodic reporting of historical actuals.

SAP Integration

Chart of Accounts and Cost Centre structures, with a data integration process that can be scheduled or run on demand.

Reporting Hierarchies

Customised reporting structures and hierarchies for every management reporting view the department needs.

Complex planning models were created to manage the key organisational areas:

  • Global Budget Allocations
  • Workforce Management (graded salaried personnel and FTE)
  • Members’ Salary and Allowances (Officeholders and Charters)
  • Electorate management entitlements
  • Revenue planning (Treasury, Catering and Recoveries)
  • Capital Assets management
  • Allocations
  • Operating Expenses
  • Forecasting model and Sensitivity Analysis

Planning is done primarily from the bottom up, using a combination of assumption driver-based, historical run-rate and zero-based estimates. The detail is balanced and validated by a top-down system of budget allocation, so planners can see which areas are under or over budget at any time. A unique global allocations framework lets budget be allocated and re-allocated across the organisation at any stage of the budget process.

“The forecast model provided them with the ability to take a high-level view of the detail budget as a starting point and apply separate assumptions and adjustments on the fly.”

Tony ButlerManaging Director, Decision Inc. Australia
04 · The Benefits

Planning and Reporting, Streamlined

Planning and reporting cycles have been dramatically streamlined.

Monthly Reports
Formatted graphical reports refreshed at the click of a button
Planning
Continuous, multi-user planning with strong controls and authorisation
Audit Trails
A clear view of every change and adjustment
Forecasting
A multi-version system for more accurate rolling forecasts

New plans can easily be created from old ones and updated, producing more accurate rolling forecasts that allow for informed decision making.