• Who we are
  • What We Do
    • By Department
      • Finance
      • Sales Planning
      • Supply Chain
    • Technology
      • Anaplan
      • Jedox
      • Board
  • Our Work
  • Contact Us

Success Stories

Financial Consolidation for a leading Bio-Pharma Company in USA

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

Reach out to us

Get to know more about us.

AttributeX is a leading global professional services company, providing a broad range of services in Connected Planning, Performance Management, RPA and Advanced Analytics, with seasoned experts across all of these services. We combine unmatched experience and specialized capabilities across all the business functions – Supply Chain, Sales & Marketing, Finance and HCM.

Useful Links

  • Who we are
  • Supply Chain
  • Our Work
  • Contact Us

USA

11040 Bollinger Canyon Road
STE E 455 San Ramon, CA
94582

India

Nanakramguda Rd,
Manikonda, Hyderabad,
Telangana 500032.

Email:
info@attributex.com

© Copyright AttributeX. All Rights Reserved
Designed & Developed by creatit.co.in