Support for the financial management of a business unit within a multinational company

BU Management

Context

  • An innovative and rapidly growing business unit within a multinational corporation, facing significant changes in its organisational structure and management approach, and in particular a lack of tools for managing production costs

Objectives

  • Provide analytical and technical support to the Finance and Business teams
  • Automate and continuously improve financial and sales reporting
  • Create and continuously improve the Power BI Finance and Sell-out dashboards
  • Support the preparation and implementation of the COGS budget

Deliverables achieved

  • Fully automated BI dashboards for Finance & Sales
  • Automated monthly reports
  • Template for calculating standard production costs, including a detailed analysis and breakdown by type
  • Structured analysis of variances between actual and standard costs

Key success factors

  • Excellent knowledge of the company and the sector
  • Close relationships with clients thanks to the on-site presence of H4 consultants
  • Proficiency in tools (Power Pivot, Power Query, Power BI) and financial modelling

Tools used

  • Power BI / Power Query / Power Pivot
  • Tagetik

Our other customer cases

AI-driven automation of the monthly Business Review presentation for a subsidiary of a major group | Automation of tasks and processes using AI | Mid-cap and large group
AI-driven automation of analytical code cleaning during the month-end closing process for a medium-sized enterprise | Automation of tasks and processes using AI | Mid-cap and large group
Performance assessment and operational turnaround of an investment. Operational restructuring and special situations | Assessment of
stress factors and identification of levers for recovery | Funds
Support for a court-ordered sale, corporate restructuring and the sale of an SME. Operational restructuring and special circumstances | Design and implementation of a recovery plan | Start-ups and SMEs
Support with the restructuring and sale of an SME. Operational restructuring and special situations | Design and implementation of the recovery plan | Funds
Analysing the profitability of an investment. Modelling and performance analysis | Profitability analyses | Fund