The Corporate Finance team used to spend days building static forecasts and reports for board-level planning conferences. Our team consolidated divisional and planning data, retro-fitted consolidation on existing cash burn, CAPEX planning, depreciation, CAPEX allocation group KPIs, present outcomes in attractive and useful formats. With Anaplan, decision-making at Bayer is agile and confident in the face of changing business conditions.

Challenges:

• Defining hierarchies, enabling planning at multiple hierarchies – aggregation and disaggregation of data wrt hierarchies.
• The transactional system had a different hierarchy, planning hierarchy had to be different. Translation from the transactional hierarchy at the department/account level to the planning hierarchy.

User Painpoints:

• Multiple Legal Entities with Siloed data systems
• Manual reporting and efforts in Excel for all financial reports and analyses
• Consolidated P&L for each product can be calculated only twice a year, so responding immediately to changes in market conditions and market needs is impossible.

Use Cases:

• Finance Consolidation
• Cash burn analysis

Results at a Glance:

• Created a consolidation model in Anaplan. Retro-fitted consolidation on existing cash-burn, CAPEX planning, depreciation, CAPEX allocation, and planning dashboards.
• Automated translation of hierarchies and enabled top-down and bottom-up level planning and analysis.

Benefits Delivered:

• Single Consolidated Dashboard for all financial reports and statements at the company level with slice-dice capability at an entity, department, and account level. Seamless integration into Tableau for visualizations
• Insights into cash-burn at multi-level (org., accounts, and department)

Impact Generated:

• Transformed manual processes of analysis and reporting which took 2 weeks to Anaplan-based reporting in just 2 days.
• Improved Usability and flexibility on Anaplan. Transformed the excel-based planning and Anaplan