Because the growing requirements could no longer be met with planning in Excel, Getränke Hoffmann opted for a professional solution for planning, forecasting and reporting. The HICO Group experts implemented this solution quickly and successfully.
Why should you take part?
Find out more about the selection process for the right solution and how the use of Jedox has enabled company-wide corporate performance management to be mapped on a shared database in the online seminar by Constanze Perlberg, Senior Controller at Getränke Hoffmann. Instead of Excel-based top-down planning, the team now benefits from bottom-up planning with input reports and a high level of acceptance from the departments involved. In addition to tangible benefits in day-to-day business, such as faster and more flexible analyses, company-wide planning has become a reliable management tool.
The solution from Getränke Hoffmann at a glance:
- Simple integration of SAP, Snowflake and other upstream systems
- P&L planning as a central element of the application
- Detailed sales planning with daily sales of the stores
- Personnel planning of FTEs, additions and departures, capacities, store openings and closures
- Complex group cost allocation with multi-level contribution margins
- Use of AIssisted™ Planning for forecasting P&L developmen
The BI experts of HICO Group designed and implemented this installation
With the support of Jedox partner HICO-Group, the team at Getränke Hoffmann implemented a powerful Bl architecture and set up an integrated business planning system. The main data source is the organization’s SAP system, which also receives the cash register data from the stores and merchandise management, among other things. In a data warehouse based on a Snowflake platform, the data from various SAP accounting areas flows together and is provided in high-performance data models for planning and analysis. Jedox financial models for the P&L, balance sheet and cash flow as well as the HR planning model were used to set up the solution. The HICO Group consultants used this as the basis for developing a comprehensive company-specific planning model.
Agenda Installations-Workshop
- 18/06/2024
- 10:45 am – 11:45 am
- Presented by Constanze Perlberg, Controlling Getränke Hoffmann und Stefan Spielvogel, Lead Consultant Planning HICO-Group
