RBS

"The system has been a major success in the bank greatly reducing cycle time, providing greater analytical capability and replacing the historic multi spreadsheet."   Adrian Goldsmith, Head of Planning Transformation and Cost Management

 

Challenges

  • Many stakeholders of the planning process led to a non coordinated spreadsheet driven  planning process
  • No driver based planning
  • Large planning cycle times
  • Comparative data in multiple systems on different charts of accounts

What We Did

  • Consolidated all divisional/group planning processes into Hyperion Planning with a consistent chart of accounts
  • Built data mapping process to transfer data from different chart of accounts
  • Build driver based models within Hyperion Planning that models
                  • 100% of Retail banking Revenues
                  • 90% of Retail banking assets and liabilities
                  • All key staff cost lines
                  • Corporate banking revenues
                  • Wealth management revenues
  • Built Stress scenario modelling capability integrating both operational and  strategic planning
  • Incorporated regulatory planning requirements (Firm Data Submission Framework) into the planning system

Results

  • Single planning submission process reducing cycle time and reconciliation effort
  • Systemising multiple offline excel submissions for use by regulators (PRA), treasury and GFP&A
  • Instant what if capability on key revenue lines, multiple key drivers can be flexed to produce plans enhancing analytical  reporting capability
  • Centralised planning reporting ensuring no duplication of figures across the bank

Contact us for more information