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

Analysing the profitability of an investment. Modelling and performance analysis | Profitability analyses | Fund
Automated business plan modelling. Support for growth operations | Modeling of growth operations | Start-up and SME
Target audit in the context of an acquisition. Audit and internal control | Financial audit | Start-up and SME
Development of an application with a validation workflow for managing annual restatements. Finance transformation | Transformation of the finance function | Mid-cap and large group
Creation of investor reports and monitoring of valuations using Power BI. Development of Power BI dashboards | Modelling and performance analysis | Funds
Carried out a transition assignment between two FP&A directors in a mid-cap company. Financial and operational management | Outsourced FP&A | Mid-cap and large group