Client Profile

The client is amongst the top three private banks in Indonesia with more than 1,000 branches across the country and around 14,000 employees. 

Client Requirements

• Forecast revenue
• Forecast overhead cost by group of COA for LOB, Support Function, Direct Business Support and IT 
• Calculate cost allocation logic methodology 
• Generate actual versus forecast reports and provide necessary variances
• Calculate expense at COA level by cost centre
• Maintain outline forecast structure as per the Bank’s requirement such as cost centre(s), COA, etc. 

Solution Overview

• A forecasting system for the Bank to project revenue, overhead costs and cost allocation using defined drivers as well as to generate actual vs forecasting reports with necessary variances
• Solution uses Hyperion Planning System 9.2.0 (Hyperion Essbase, Planning and Report) 

Technology

Hyperion Planning System 9.2.0

Pricing Model

Fixed 

Project Duration

5 calendar months

Service Excellence. Delivered

• Once the project was completed, the client had a system that enabled capturing of budgeting data across LOB and cost centre within 2 weeks 
• The Financial Controller to operate with a very lean team of around 7 to 9 FTEs 

Key Benefits

• Distributed for data capture across 7 regions and 60 units 
• Management of over 2000 plus cost-centre budgets 
• Actual vs. Budget comparisons