48th Congress of Controllers: Expert contributions from the Exhibitors 2024

Expert contributions of the Exhibitors 2024

The first business intelligence application in 48 hours: zwissTEX, the Swabian manufacturer of high-tech textiles, has done it. With the help of Bissantz ERP solutions for SAP data, a comprehensive KPI landscape for controlling corporate finances was created - and integrated planning.

zwissTEX was looking for a software solution that transfers the data from SAP modules such as SD, FI, MM and PP into efficient reporting. The solution should map the financial and business goals with meaningful KPIs quickly and with little effort and measure the achievement of goals.

Trusting in Bissantz's performance promise, CEO and CFO Dr. Ulrike Neubauer made the project a top priority: “SAP landscapes can be cumbersome. I was skeptical as to whether something could really be added on top of that so quickly – but Bissantz kept the promise.” The linchpin of the solution is the Bissantz ERP Solutions, a tool for the automated creation of ready-to-use, packaged business intelligence systems. Bissantz delivered the first reporting application in just two days.

Soon analytical applications for the areas of logistics, sales and finance were created: from stock levels and ranges to product groups and bills of materials to contribution margins and profitability calculations. After only six months, the desired KPI landscape had taken on a concrete form - and can also be used on the smartphone with the Bissantz DeltaApp.

One of the first applications: the receivables monitor on the smartphone, with interactive access to perspectives such as debtor, product line, due date/dunning level and even the invoice items.

Parallel to the development of the KPI landscape, Bissantz zwissTEX supported the P&L planning: In the sense of an integrated planning, the cost planning in the nature of expense method was merged with the sales planning on sales objects. The specialist departments plan their cost centers and cost types in SAP, while Sales plans sales and turnover in Bissantz. The sales plan data for customers, articles or sales areas are in turn supplemented with the article calculation from SAP. The integrated planning profit and loss statement in Bissantz results in concrete targets for corporate management - the loop of planning, analysis and reporting is closed.

"From many years of experience, I am well aware of the possibilities and limitations of software in corporate management," explains Neubauer. "I was really surprised that such increases in information quality are possible in such a short time!"

READ THE COMPLETE ARTICLE HERE (PDF DOWNLOAD, GERMAN)

 

One of the first applications: the receivables monitor on the smartphone, with interactive access to perspectives such as debtor, product line, due date/dunning level and even the invoice items.

Parallel to the development of the KPI landscape, Bissantz zwissTEX supported the P&L planning: In the sense of an integrated planning, the cost planning in the nature of expense method was merged with the sales planning on sales objects. The specialist departments plan their cost centers and cost types in SAP, while Sales plans sales and turnover in Bissantz. The sales plan data for customers, articles or sales areas are in turn supplemented with the article calculation from SAP. The integrated planning profit and loss statement in Bissantz results in concrete targets for corporate management - the control loop of planning, analysis and reporting is closed.

"From many years of experience, I am well aware of the possibilities and limitations of software in corporate management," explains Neubauer. "I was really surprised that such increases in information quality are possible in such a short time!"

 

About Bissantz & Company

Bissantz & Company sees itself as a think tank for the application of artificial intelligence (AI) in management. The company was founded in 1996 and is still owner-managed and self-financed today - a true family business in the German-speaking business intelligence market. With our own basic research, the software is further developed in a scientifically sound and interdisciplinary manner. We combine insights from business administration, computer science, neurobiology, psychology, statistics and artificial intelligence. Our innovations are patented and have won numerous awards, including the Innovation Prize from the Gesellschaft für Informatik (GI) and the UX Design Award from the International Design Center Berlin (IDZ).

To the company page


"It was important to us during the course of the project that the end user received the automation and logic that they needed so that they could carry out their planning as conveniently as possible"         
Merle Schmidt-Brunn, 
Senior Director Financial Analytics
Hapag-Lloyd AG

The company Hapag-Lloyd AG

Hapag-Lloyd is one of the largest liner shipping companies in the world with an EBIT of EUR 1.315 billion (2020). The company has a clear claim: “Number one for quality”. This claim is also reflected in the effort to accurately plan global business. Hapag-Lloyd is one of the leading providers in the Transatlantic, Middle East, Latin America and Intra-America trade areas and is characterized by one of the world's largest and most modern refrigerated container fleets. Using driver-based, integrated and globally distributed corporate planning, Hapag-Lloyd wants to adhere to the strategic goal of high reliability and quality and continuously develop further.

KEY FACTS
Industry: Transport & Logistics
Locations: 418 offices in 137 countries with headquarters in Hamburg
Employees: Around 13,900 worldwide
Software: Board
Advantages & benefits: Consistent solution in the company | Standardization of processes | Greater data transparency | Better management over data | A single environment for planning | Better and more detailed operational planning | Greater user-friendliness.

The challenges of the project

The challenge of integrated corporate planning at Hapag-Lloyd still lies in the closely interlinked partial planning within the group. Starting from the allocation of ship capacities to the planning of global sales volumes and the associated direct costs of the containers through to the general costs, the individual planning steps are very coordinated and interlinked. In the past, the existing solution in Excel and other tools led to a lot of manual and time-consuming effort and a high susceptibility to errors. Changes to assumptions and adjustments to planning could only be made at aggregate levels. A particular challenge in the project are the direct container-related costs (Cargo Related Cost, CRC), especially for the terminal and transport costs. In this planning, the costs are planned for each individual data point of a trip. The starting point is the upstream volume planning with a transport volume of 12.0 million TEU (standard containers) per year as well as 121 liner services that ensure fast and reliable connections between more than 600 ports on all continents worldwide. This partial planning generates a large amount of data points with high complexity due to the large combination logic and was therefore individually planned locally and regionally using standard costs in the past. However, with the previous approach, it was not possible to achieve better transparency in the creation and management of costs worldwide, as the costs incurred could not be directly assigned to the volumes and regional cost drivers.

"In the end, our goal is to develop a process in which all partial planning is mapped in the same way as it is carried out by the planner themselves. The tool should then take over the transition."
Merle Schmidt-Brunn
Senior Director Financial Analytics
Hapag-Lloyd AG

The implementation of the project

Hapag-Lloyd's objective was to set up an efficient solution for corporate planning that, in particular, integrates operational partial planning and accelerates the planning process. Employees should also be relieved and automation and flexibility should be increased. It was particularly important to Hapag-Lloyd that the new solution was extremely user-friendly and that the design of the planning masks could be designed in the look and feel of Hapag-Lloyd in order to achieve the highest possible buy-in from employees.

After reviewing and selecting providers, including carrying out a proof of concept, Hapag-Lloyd ultimately decided on the Board planning platform and celver as a partner for implementing the solution. “Our focus was on operational planning. Most tools on the market, however, only focus on planning financial packages. Our choice of Board and the experts from celver as implementation partners was not least because of the good cooperation in analytical projects with Qlik,” said Merle Schmidt-Brunn.

In the following weeks, the planning process was analyzed in workshops and the future planning process was defined. Hapag-Lloyd's solution now consists of holistic capacity, sales and cost planning with around 450 users. The annual budget planning, which results in a strategic five-year plan, serves as the basis for further updates as part of the forecasts carried out three to four times per year. The individual planning steps are connected to each other through a workflow and linked to each other through partial plan integration. Through this integration and the underlying calculation logic as well as the integration of historical data, planners can usually use suggested values as part of their plan inputs. An important part of the project was data connection and preparation. Here, various preliminary systems with different levels of detail had to first be harmonized and merged in order to ultimately obtain a detailed planning solution including the required actual data. During the course of the project it became clear once again that an agile approach, retrospectives and good collaboration bring significant advantages on complex topics.

The new planning of Cargo Related Costs (CRC), which occupies a special place in integrated corporate planning, uses the worldwide planned container volumes and their distribution on the routes as input. The modeling of this network planning enables Hapag-Lloyd to adjust and simulate costs using a wide variety of parameters and thus to determine global or local effects on the routes and in the ports.

The use

The goal of standardizing the processes and creating a “one-system-for-planning” environment was achieved in the project. This ensured global data transparency (single point of truth) and management over the data at all times. The project has already come closer to the goal of reducing global planning by two weeks, but here too, further expansion stages and refinements in the planning process are necessary in order to achieve “pace and perfection”. The new planning environment, with its focus on operational planning, also has a direct impact on end users beyond the actual planning. Since the operational logic and, above all, the detailing of the data is close to the daily business of the planners, the information is also used for operational management using plan/actual comparisons.

About Celver AG

We have been implementing complex planning and analysis solutions based on smart data architectures for customers of a wide range of industries and sizes for over 20 years.

Our goal: to build tailor-made solutions together that form the basis for data-driven decisions. Our certified experts provide support with innovative concepts and technologies, from technical advice to process definition, complete implementation and integration into the system landscape, right through to training, roll-out and change management.

As a technology-independent consulting company, we are a member of the UNITY Innovation Alliance.

To the company page

 


Authors: Mike Schulze / Felix Broßmann / Bernd Wallraff

The launch of ChatGPT (Generative Pre-trained Transformer) in late 2022 sparked a wave of interest in generative artificial intelligence (AI). It is a chatbot that uses AI to communicate with users via text-based messages. In response to user input, the user is able to generate specific texts. Within days, millions of users around the world experimenting with this newly available technology had discovered and shared countless ways to use it effectively. In the weeks and months that followed, companies also tried to keep up with this immense development. Some companies have already taken a formal approach and formed special teams to investigate how generative AI can be used to benefit business models or companies and improve efficiency in the company.

What is generative AI?

Generative AI refers to machine learning models that can, for example, generate texts, images, audio sequences or synthetic data by imitating human-like language patterns and structures. These models are trained on various internet texts and are incredibly creative in generating stories, poems and subject-related articles. In addition, they can perform various tasks, answer questions, and provide detailed explanations, making them valuable tools for a variety of applications.

There are generative AI tools for different modalities, such as text, images, music, code and voices. Examples of different AI content generators include the following:

  • Text generation tools such as ChatGPT, Jasper, AI-Writer, Bard and Lex.
  • Image generation tools include Dall-E 3, Midjourney and Stable Diffusion.
  • Music creation tools: Amper, Dadabots and MuseNet.
  • Code generation tools: CodeStarter, Codex, GitHub Copilot and Tabnine
  • Speech synthesis tools include Descript, Listnr and Podcast.ai.

Basic capabilities of generative AI

Generative AI can be used extensively in many areas along the company value chain. It can make existing content easier to interpret and understand and automatically create new content. Some of the fundamental capabilities and resulting benefits of using generative AI are:

  • Automating the manual content creation process,
  • Reducing the effort required to respond to e-mails,
  • Improving the response to specific technical queries,
  • Summarizing complex information,
  • Simplifying the process of creating content in a specific style.

Opportunities for controlling and finance

Some specific use cases have already been discussed for controlling and finance areas:

Identification and assessment of risks: Generative AI models can process large amounts of text information and analyze and evaluate them in relation to different risk categories. They can answer questions and provide personalized recommendations. This technology allows financial professionals to provide better customer service and streamline communications.

Financial analysis and forecasting: Generative AI models are ideal for analyzing finance-related data such as financial statements, balance sheets, and profit and loss statements. You are able to identify trends, predict results or create detailed financial analysis.

Fraud detection: By analyzing historical transaction data, generative AI models can detect patterns and highlight potential anomalies that indicate fraudulent activity. By using AI-powered fraud detection, companies can improve their security measures and protect their assets.

Extracting data from financial documents: Generative AI can automate the extraction of specific data from various financial documents such as invoices, contracts, and regulatory filings. This automation reduces manual effort, improves accuracy and accelerates processes, which ultimately increases efficiency in the controlling and finance areas.

Creation of financial reports: Generative AI models can automate the creation of financial reports, saving time and effort for controlling. By using natural language features, these models can also produce annotated reports that enable better decision making.

Limits and risks

Although generative AI offers exciting and diverse possibilities, there are also limitations and risks. Data protection and future regulatory requirements regarding the use of AI are particularly important.

Data protection: Ensuring data protection is crucial in the age of regulations such as the EU General Data Protection Regulation (GDPR). Companies must handle customer data responsibly and comply with data protection regulations to avoid legal consequences.

Future regulatory landscape: New regulations relating to AI are currently being coordinated at the European level. For example, the European Union's Artificial Intelligence (AI) Act aims to reduce the risks associated with the use of AI by requiring developers to test their systems, document use and take security measures. The effects of these legislative initiatives cannot yet be conclusively assessed - what is certain is that there will be restrictions in the usability of non-European solutions if they do not meet the then applicable regulatory requirements.

Notes on practical application in a corporate context

Despite the risks outlined, generative AI tools can already be used in company practice in a comparatively legally secure manner, provided that data protection and the protection of business secrets are taken into account.

Use of non-European service providers: The technologies of non-European AI providers such as OpenAI (the company behind ChatGPT) should only be used in a corporate context if it is ensured that the data entered is both data protection compliant and does not represent any business secrets. In this regard, it is not problematic to use it to generate marketing and information materials. In the context of controlling and financial processes, however, it will only be possible to find use cases that meet these requirements to a limited extent. In any case, technical security should be used, for example by checking the input data before sending it from your own IT infrastructure, which is relatively easy to implement.

Use of GDPR-compliant AI models: The German company Aleph Alpha is focused on providing explainable and trustworthy AI models that are GDPR-compliant. The use of these models ensures compliance with the GDPR and offers flexibility in possible uses. In this case too, you should refrain from entering data that represents trade secrets. For such use cases, Aleph Alpha offers the option of integrating the language model completely independently into your company's infrastructure. This ensures that the data does not leave your own servers.

Use of open source models: To protect trade secrets and avoid data leaks, companies can use open source models that can be customized and also installed on the company's own infrastructure. This approach allows companies to maintain control over their protected information while benefiting from generative AI capabilities. For example, Bosch would like to provide its own BoschGPT for its employees by the end of the year. Other companies such as dm, Samsung, McKinsey and SKAD are also working on such solutions. The basis for BoschGPT is Bosch's in-house database. This procedure makes it possible to use current company data for the results created. This means that the system cannot currently be directly connected to solutions such as ChatGPT or Bard, otherwise data could leak. For this reason, the capabilities of these applications, despite immense improvements, do not yet come close to proprietary solutions such as ChatGPT or Bard. However, the rapid development of the past few months suggests that this will be the case in the medium term.

How do you achieve good results with generative AI?

Link statements, questions and instructions: In order to achieve good results, you have to give AI systems like ChatGPT instructions that are as accurate as possible. A crucial aspect that significantly influences the efficiency and accuracy of the results is so-called prompting. A prompt represents an input that is provided to the respective model to produce a response or prediction. This input can take various forms to direct the output in the desired direction. For example, questions can be asked, specific instructions can be given, or a chain of statements, questions or instructions can be strung together.

Examples of prompts

  • How many inhabitants does the capital of Denmark have?
  • Name the five most commonly practiced sports in Europe.
  • Is there a difference between “causality” and “correlation”? If so, please explain it using examples.

An effective prompt should generally be formulated as clearly and precisely as possible. Instead of “What can you do with ChatGPT in controlling?” the query leads to “I am planning to use ChatGPT in the area of analyzing business data for a medium-sized company. What areas of application are there?" leads to significantly more specific results. The structure of the prompt gives the AI models a clear context and direction, which ultimately leads to more focused and relevant answers.

Sample Prompt Construction: Creating an effective prompt is an essential step to getting accurate and nuanced answers from a generative AI. Here is a simple guide that walks you through the process step by step:

1. Facts: You should start with a clear definition of the central topic or question. In this step, it is important to understand and convey the exact context of the question. For example, a request could be: “I would like to develop a concept for optimizing cost center accounting in my company.” This gives the AI a clear starting point that allows it to focus on the specific details that are relevant to optimizing cost center accounting.

2. Framework conditions and restrictions: The next step is to determine the specific framework conditions and restrictions that the AI should take into account when answering the query. This could e.g. include paying particular attention to certain departments or business areas. By precisely defining these parameters, the AI can create a response that is tailored to the exact requirements.

3. Format: Finally, the format in which the answer should be presented is defined. This could be a textual representation that describes the optimized cost center accounting processes in detail. Clearly stating the desired format helps the AI structure the response in a way that is easy to understand and interpret.

Example of a prompt in this simplified design:

  • “I would like to develop a concept for optimizing cost center accounting in my company (fact).
  • Pay particular attention to the sales and production departments to ensure efficient allocation of costs (framework conditions and restrictions).
  •  Present the results in a textual representation that describes the optimized cost center accounting processes in detail (format).”

Advanced Techniques: The basics needed to create effective prompts are relatively easy to learn. At the same time, there are many advanced techniques in the field of prompt engineering that make it possible to further refine and optimize the output of generative language models.

Some of these techniques are based on the idea of "training" the model with different amounts of information or examples before producing an answer. These include approaches such as:

Zero Shot Prompting (standard case): In this case, the model is asked about a topic without prior specific examples or information. Example: “Explain the use of the balanced scorecard in controlling.”

One Shot Prompting: The model receives a single, relevant example before answering a query. Example: “Just as a company uses key performance indicators (KPIs) to measure success, how might an educational institution measure its performance?”

Few Shot Prompting: The model is provided with several relevant examples to prepare it for a specific query. Example: “A company might use a SWOT analysis to evaluate its strategic position. A sales team might use CRM software to manage customer relationships. How could an HR department use big data?”

Another example of advanced approaches is the so-called “chain of thoughts” approach. This is a method in which a language model is encouraged to explain its thinking or solution step by step when solving a task. The idea is that by showing examples that explain the thought process, the model learns to show its own thought process when answering questions. This type of prompting can make the model's answers more accurate because it is forced to think about each step of its response, which can be particularly helpful for complex tasks. This representation also makes the results of the AI more transparent for you.

In addition, a number of advanced prompt techniques such as Tree-of-Thoughts (https://arxiv.org/abs/2305.10601) or Graph-of-Thoughts (https://arxiv.org/abs/2305.16582) are currently being developed, which use different reflection techniques to improve the outputs generated by language models many times over.

Overall, it can be said that choosing the right prompt technique depends heavily on the specific request and the desired result. The only thing that helps here is the continuous practice of different techniques by the users.

Summary and conclusion

Generative artificial intelligence, such as ChatGPT or similar models, has transformative potential for controlling and financial areas in companies. Applications include conversational finance, financial analysis and forecasting, fraud detection, document analysis and financial reporting. However, companies need to keep an eye on data protection, regulatory compliance and changing legal environments. By using solutions like ChatGPT, collaborating with AI providers specializing in data security, using GDPR-compliant AI models, and adapting open source models, companies can maximize the power of generative AI while minimizing risks and comply with regulatory requirements. It will also be crucial for companies to continuously stay up to date with the latest developments in this extremely dynamically developing field and to introduce responsible AI practices within the company in order to be able to use generative AI effectively.

About the Controller Magazin

Controller Magazin provides you with first-class specialist information for your day-to-day controller practice! Every 2 months you can find out what the latest developments are, which topics concern your colleagues and which practical tools you can use to make your daily work much easier.

Language is German.

To the Controller Magazin page

 


“Carthago”: The name stands throughout Europe for premium motorhomes with an exceptional sense of space. When Karl-Heinz Schuler founded the company Carthago in Ravensburg in 1979 with individual conversions of panel vans according to customer requirements, he had the premium segment in the motorhome market in mind right from the start. Today, Carthago Reisemobilbau GmbH is one of the leading providers in Europe. The group of companies has operated from its headquarters in Aulendorf, Upper Swabia, since 2013.

In “Carthago City”, the owner-managed family business not only operates one of the most modern motorhome production facilities in Europe, including a sales exhibition, but also offers numerous rental vehicles. Around 1,400 people are employed here and at the Odranci production site in Slovenia, generating annual sales of around 390 million euros (2021).

The trend towards “traveling on four wheels in your own living space” was somewhat slowed down by delivery bottlenecks at the Upper Swabian premium manufacturer. Nevertheless, the Carthago Group remains on a growth path, which is underlined by the newly opened second production site in Slovenia.

Satisfy the need to catch up

The focus of Carthago's business activities has been the development and production of premium class motorhomes for over 40 years. Great importance is placed on comfort, safety and longevity, as well as on continually improving and refining the vehicles.

In view of the rapid growth, the Carthago group of companies was faced with changing planning and reporting requirements at the beginning of the 2020s, when the tools previously used - Excel and IBM Cognos Analytics - could no longer adequately reflect. Analyzes should be completed more quickly and reports should be available on a daily basis. “We had a certain amount of catching up to do,” says Christian Staud, Head of Controlling at Carthago. A new solution with BI functionality should help here.

The selection was easy thanks to existing internal system applications and experience. Carthago should make progress very quickly with the advice and technology of the service provider elKomSolutions GmbH from Tuttlingen. “I wasn’t part of the selection process yet, but I can only confirm this,” explains the qualified mathematician who has worked at Carthago since June 2019. At the turn of the year 2018/19, Carthago put the elKom solution into operation.

Prototypes simplify the introduction and operation of the software

“When I came to Carthago, the software was technically implemented but not yet fully rolled out. The roll-out then went very quickly, which, says Staud, was “particularly due to the methodology of elKomSolutions”. Developing prototypes that then serve as a template for operations leads to quick visibility and rapid implementation success. Staud also attributes this to the software, which is “completely uncomplicated to use and runs stably”. That's why there is very little need for support.

elKomBI is now in use based on the OLAP database IBM Planning Analytics TM1. Carthago uses the solution for reporting and planning. Staud emphasizes that a particular advantage is that the controlling department can operate and further develop the solution almost independently of internal IT or external consultants. IBM Cognos TM 1 carries out evaluations of large amounts of data in a very short time and is easy to use.

The BI function supports the analysis of more complex data sets and their condensation for reports. Thanks to the Excel integration, controlling can quickly and easily design reports for the various recipient groups in the company. TM1's technology then enables access via the web, so that report recipients can log in via the Internet and access their reports on a daily basis.

One keystroke instead of endless Excel evaluations

Time savings, convenient and customizable evaluations and a better overview of a wide range of key figures are the main advantages that Carthago derives from the solution from elKomSolutions. The cost center reporting goes to around 65 report recipients. Before introducing the software, Carthago had to invest at least half a year to create evaluations for all of them on their respective budget trends. Now all you need to do is press a button to send your specific report to all report recipients.

This “very great strength” also affects other specialist areas. Similar to car manufacturers, Carthago customers can configure their motorhome. A large selection of product variants is available. With the BI tool from elKomSolutions, these can be analyzed over several years and thousands of customer orders in a matter of seconds - in order to better understand customer needs and, for example, to be taken into account for future product development.

elKomBI has significantly accelerated the evaluation of detailed information from the product range over many years. elkomBI creates these reports in seconds: “We now run a data set with 20 million individual pieces of data through the software and receive the analyzes in a few seconds,” notes Staud. That really impressed him as a controller. Completely automated, the software delivers such reports not only monthly, but daily.

Outlook: even more visibility, even more functionality

“We have now rolled out the reporting to the first and second management levels for the purpose of economic management. This greatly benefits the first level of management, who have access to consistent data. The same applies to the second management level, which receives the information it needs at the push of a button,” says Staud. The Carthago Group's controlling department is constantly developing the analyzes and reports “because the benefits are so great”. After the cost center reporting and the managing director reporting, there are now individual reports for the specialist departments, for sales, production and others such as: purchasing controlling. Head of Controlling Staud summarizes: “In the area of controlling, we have catapulted ourselves into a different era. When we commissioned our new plant in Slovenia, we were particularly able to benefit from the scalability. In the Excel world we would probably have had to hire significantly more staff. Now, all you need is powerful BI software.”

elKomSolutions: Integration as the key to success

elKomSolutions GmbH has pursued an integrated approach since it was founded in 1997. From the outset, it has relied on IBM Planning Analytics TM1 database technology and connects previously separate departments in the company with a uniform database based on OLAP technology. The basic idea is to make work as easy as possible for customers from small and medium-sized businesses, but also large corporations. But meeting the customer where they are currently traveling also means starting from Microsoft Excel. 95 percent of companies continue to use the versatile tool for controlling, sales and production planning, group consolidation and reporting. However, there are limits, be it in terms of the efficiency, speed and transparency of these processes, or in their integration.

For this reason, elKomSolutions has created modular software components for the areas of business intelligence (BI), corporate planning and group consolidation - and is constantly developing them further. elKomBI, elKomPLAN and elKomKONS are independent solutions for the individual sub-areas. Connected via OLAP technology, they integrate seamlessly and offer all departments direct access to all data. What they have in common is extremely fast data processing, even with extra large volumes, openness to any database of operational systems, etc. from the ERP and financial accounting environment, the high level of flexibility and adaptability - without external employees having to do this - as well as a uniform front end for controlling, planning and consolidation. And of course Excel can still be used, which reduces the training effort for departments that use Excel, for example for data entry.

The solutions form a holistic, modular software platform for analysis, reporting, planning and consolidation, in short for integrated results and financial management. Through integration into the operational world, classic performance management becomes identical in terms of approach, methodology and database. In other words: planning, forecasting, consolidation, but also actual reporting are always from a single source.

About elKomSolutions

Software solutions for BI, planning and consolidation!

As a specialized IT service provider, we concentrate on the development, introduction and support of software solutions for business intelligence, corporate planning and group consolidation based on IBM Planning Analytics TM1.

elKomSolutions offers you comprehensive services from the conception and development of your individual software solutions with IBM Planning Analytics TM1 to user training and support after the end of the project.

3 solutions – 1 concept – 1 database. IBM Planning Analytics TM1

Thanks to consistent OLAP technology (IBM Planning Analytics TM1), dynamic Excel connection and seamless web integration, you benefit from maximum flexibility.

Our software solutions can be used as individual modules or as an integrated overall solution for business intelligence, corporate planning and group consolidation.

To the company page

 


BACKGROUND

Lufthansa CityLine was looking for an alternative to the predominantly static reporting system based on SAP BW. In addition, the airline's controlling wanted to optimize cost planning specifically with regard to the degree of automation, reliability and transparency of the planning values.

CHALLENGE

IT point of view:

  • There was no BI self-service for the specialist departments, so many individual steps were implemented manually.
  • Report development was slow and took an enormous amount of time.
  • Maintaining the BI system environment was very tedious and had to be simplified.

Controlling:

  • The SAP ERP based cost planning process had to be replaced because it was not efficient enough and cost a lot of capacity.
  • The planning had to be created from various data sources.
  • A system-supported target and actual cost object calculation could only be created with great effort.

LUFTHANSA CITYLINE: SOLUTION WITH FIPLANA

What spoke in favor of the solution with Fiplana were the ability to function both as a front end and to cover the ETL process in the back end, as well as the high flexibility in dealing with source systems and analyzes as well as the self-service functions. Lufthansa uses Qlik Sense as a source system for its data. Fiplana makes it possible to edit data directly in the Qlik interface or capture new data in Qlik Sense. Fiplana also contains complex planning functionalities, such as the transfer of reference data or the implementation of planning based on real historical data. In order to take relevant developments into account and bridge the gap between the planned values created in the previous year and the current actual values, a rolling forecast should also be presented.

Thomas Bayer and Patrick Lowski, co-project managers Controlling2.0@CLH at Lufthansa CityLine:
“We had previously planned the “anticipated actual” (VI) – as we call the forecast – in Excel and reported it to the group. We always had to manually book the expected actual cost items individually into the system or import them via uploads. We wanted to automate this input process instead. INFORM DataLab then implemented the budget planning, planned cost object accounting and VI processes in an agile process and also worked one or two night shifts in order, for example, to develop an algorithm for calculating the expected actual value.”

In the future, airlines will increasingly be able to use a BI system to see exactly which engine or aircraft causes which costs. “Actual cost accounting will bring us significant added value so that we can then derive statements at cost object level during the year and identify the differences to the planned rates. All of this is only possible because of Fiplana.”

ADDED VALUE THROUGH THE USE OF FIPLANA

  • Time savings by eliminating the need to manually enter planning data
  • Optimized planning, management and information supply
  • Relieving the burden on IT

Time to Value:
6 months until the first applications go live

Return on Investment:
1 day instead of 1.5 days monthly effort for creating the forecast and agile reports using the self-service BI approach

About Fiplana / INFORM DataLab

Fiplana, the new cloud-based platform solution from INFORM DataLab, enables intelligent corporate planning and offers comprehensive support in corporate performance management (CPM). By creating reports and dashboards, users gain quick insights into financial data, track financial planning performance, and identify trends. As a single source of truth for planning and analysis, Fiplana integrates real-time data, promotes team and interdepartmental collaboration, and simulates business cases and scenarios to enable data-driven and sustainable business decisions.

The INFORM DataLab offers comprehensive full-service consulting along the entire data value chain, supports customers in data-based decisions and accompanies them through digital transformation. The DataLab experts use individually tailored solution approaches, from advising on sustainable data strategies to implementing efficient data analysis and data management solutions.

To the company page

 


CHALLENGE

Adaptable controlling solution for growing companies

The controllers at Henkell Freixenet have many years of experience with Jedox; The software was introduced into the company in 2012 and central controlling has constantly modernized the application and established it as a group-wide platform for planning and reporting. And even after the Henkell Freixenet merger, the scope of applications will continue to be expanded.

During the initial implementation, the goal was to support the group consolidation of the management results with a suitable tool and to replace Excel. Over the years, more and more departments used Jedox for planning and reporting. An important milestone was the establishment of self-service options with easy access to the fully automatically updated daily invoice via Jedox Web.

Since joining Jedox Cloud at the end of 2022, there have been new opportunities for innovative applications. The Controlling International department is currently primarily exploring the further development of predictive forecasting and driver-based planning using Jedox AIssisted™ Planning.

SOLUTION

Reporting and planning for a wide range of topics and expert areas

With the move to the cloud, the number of active users has increased to over 150 worldwide. Six departments currently use Jedox for a wide variety of topics: from sales and rolling demand planning, predictive forecasting, fixed cost controlling, technical reports, brand reporting and market data analysis to group consolidation, IC publication and a pricing database.

Dashboarding instead of rigid PDF reports

In international controlling, the focus is primarily on management reporting. Management currently receives a PDF report consisting of approximately 120 pages twice a month, which summarizes the paragraphs by region and brand. The PDF version is static and at first glance does not allow any statements to be made about action-relevant KPIs such as drivers.

Using Jedox Canvas, the project manager built a prototype dashboard that summarizes the diverse sales information in a screen window with dynamic filters. Using the canvas functions, a variety of content and visualizations can be arranged side by side using drag-and-drop and the most important KPIs can be easily pinned to the report. The development of the global icons, deviations or individual drivers in the portfolio can now be seen at first glance in the dashboard, and management can create any additional detailed views, e.g., you can drill down by region, business unit, brand, brand subgroup or product group.

Simulation, predictive forecasting and driver-based planning

Using AI-supported forecasts from Jedox AIssisted™ Planning, controlling is currently checking whether the planning quality can be further increased with a view to the group result. Simulations also help to identify key drivers of business development and integrate them into planning.

When comparing the historical actual and planned values from previous years with the forecasts that the Jedox AI model generates on this basis, the automated algorithm performed significantly better than the laboriously created traditional planning, with a forecast accuracy of almost 91 percent. This was achieved in the first step based on key figures from just four years - as the database grows, the AI module can be expected to be more and more accurate.

OUTCOME

Scalable and investment-safe analysis platform

With Jedox, Henkell Freixenet has created a stable and expandable platform for planning and performance management, which has grown steadily with the successful company in over ten years of use. A key advantage for the experienced controllers is that they can further develop their application independently and roll it out within the group as required.

For example, in the latest expansion stage, the department responsible for management reporting created the sales dashboard without the need for consultants, which is able to replace the comprehensive PDF report. The dashboard offers faster and better insights as well as more analysis options.

The department also has data management under control and is continuously automated, from direct Excel uploads to a self-developed upload center and direct access to the source systems via the SAP connector. Among other things, this has made the work in investment controlling much easier and has meant that the responsible team can concentrate more on analyzing the data on reporting days instead of uploading it. And with better data quality and fewer coordination loops: Companies can not only provide the data more easily in self-service, but can also more easily validate and release it internally in advance in the upload center. This increases the companies' process commitment and ownership of their numbers, and saves over 175 person-days of non-value-adding work steps every year.

In addition, global access with live reporting status enables seamless, global collaboration by eliminating time zone-related downtime and sometimes nerve-wracking, short-term adjustments. Henkell Freixenet will continuously expand the Jedox platform. An important goal is the further development of driver-based planning using AI-generated suggested values. By simulating and verifying possible drivers, the planning of management-relevant KPIs should be further automated and made more precise. The team also wants to further optimize the visualization - and, above all, make better use of Jedox's great strength as a planning tool.

About Jedox

Jedox is the world's most adaptable business planning and performance management platform, enabling companies to create business plans that help companies exceed their previous results and expectations. More than 2,500 companies in 140 countries trust Jedox to model any scenario, integrate data from a variety of sources, and simplify planning across companies and systems. Jedox creates an environment in which users work better together, respond faster to changes, make informed decisions and realize previously unrecognized opportunities. Independent analysts regularly recognize Jedox for its expertise in planning and budgeting, automated reporting and analysis.

To the company page

 


“Until recently, annual planning took two months of work and involved entire teams. We are talking about an enormous number of working hours and the main problem: the error rate. Today, K4 Analytics can resolve the issue within hours.”

MARTIN ČEVELA, BUSINESS INTELLIGENCE ANALYST AT ESET

 

The customer

ESET is one of the world's largest manufacturers of security software and is one of the pioneers of virus protection. The company develops award-winning threat detection software for customers in more than 200 countries.

ESET – the challenge

  • Financial and human resources planning, consolidating financial plans across the company
  • Automated consolidation of plans and results
  • Management of deviations
  • Increase planning efficiency (top-down and bottom-up, re-forecasting, time saving)
  • Versioning of plans
  • Workflow

 

The solution

With K4, your requirements for a modern planning process can be solved with manageable effort:
“Under normal circumstances the process would take a very long time and cause a lot of stress. Working with Excel requires constant concentration, which can be overwhelming, especially in stressful situations, and can easily lead to failure. Additionally, the company is wasting money because employees are doing something they shouldn't be doing. They are demotivated and discouraged, and there is also a huge margin for error,” reports Martin Čevela.

Due to the positive experience with K4 Analytics, ESET has expanded its use from the finance department to sales. Sales teams can now improve collaboration with their partner networks and, for example, distribute their marketing budgets more efficiently depending on their performance.

The sales department now uses K4 instead of MS Excel® to deliver data to the finance department and K4 takes over a large part of the planning. Sales employees are given a tool with which they can continuously monitor their set goals. This means that retailers know immediately and at all times where they stand, whether they have to work more or whether they can look forward to a surcharge.

 

The use


K4 Analytics is particularly beneficial for ESET employees at lower management levels because they do not have to spend a lot of time recalculating costs due to a change from above. Now you can select an item to reduce the budget for and the changes will immediately be reflected in other parts of the plan. The procedure described above completely avoids the tedious management process, which also includes Excel files sent via e-mail, which must (additionally) be provided in a user-friendly format. This means less time wasted.

“Fewer errors and less time spent on Excel means that employees can work on something meaningful. They can save up to twenty days per month and invest the time in strategy, resulting in real added value,” concludes Martin Čevela.

About K4 Analytics

K4 Analytics extends leading analytics/BI platforms such as Power BI®, Tableau®, Qlik® and collaboration platforms such as Microsoft Teams® with extensive data entry and planning functions.

Close your process gaps to create a holistic and integrated environment for your data-based corporate management.

Simply use your existing data model. From simple data capture to complete corporate performance management (CPM) applications - including workflows and comprehensive commenting functions. Use what you need right now, whether focused or integrated - from data collection to xP&A, FP&A, HR planning with versioning and corresponding scenarios.

K4 Analytics is a unique no-code environment and the only multi-platform solution. It connects existing things, is database-independent and can be implemented flexibly, quickly and precisely thanks to the proven spreadsheet approach.

Increase your efficiency! Very often, the tasks in the CPM environment are depicted using e-mail and attached spreadsheets. With K4 you transform these processes into stable and understandable processes, e.g. for ESG reporting, monthly/annual financial statements, personnel-related surveys, etc.

To the company page

 


In a world in which there is no doubt about the enormous value of data and in which data-driven companies gain significant competitive advantages, controlling as an organizational unit must emancipate itself and reinvent itself to a certain extent. This is all the more true because not only are there incredible amounts of data available, but also technologies that open up unprecedented possibilities.

Integrated corporate management: xP&A as modern controlling

Companies have been using key figures to systematically guide their development towards success for over 100 years - the DuPont scheme, which the chemical company DuPont, which gave it its name, introduced in 1919, is perhaps the best-known example. As an organizational unit, controlling takes on an indispensable cross-sectional function for management and all departments and provides orientation with its reports. As a rule, companies are aware of the importance of their controlling. And yet your own self-image is rather defensive and the assessment from other departments is often not particularly positive.

Extended Planning and Analysis: Looking at the big picture

Apart from the fact that controlling should finally receive the appreciation it deserves - in a world in which there is no doubt about the enormous value of data and in which data-driven companies gain significant competitive advantages, controlling must emancipate itself as an organizational unit and reinvent it to some extent. This is all the more true because not only are there incredible amounts of data available, but also technologies that open up unprecedented possibilities.

The Financial Planning and Analysis (FP&A) approach can be seen as a first step in this direction, which goes well beyond traditional reporting. For example, the FP&A approach not only generates historical key figures, but also creates forecasts and simulations. But controlling can go far beyond that: if it does not focus on monetary variables, but rather acts holistically. FP&A then becomes Extended Planning and Analysis, or xP&A for short. The x stands for all aspects that go beyond finances.

Interdisciplinary connections

In concrete terms, this means: Controlling also includes the data that other departments collect - for example, purchasing on the performance of suppliers, production on the performance of the machines and systems on the shop floor or sales on the willingness of customers to buy. The highlight: Controlling does not look at the data from the specialist departments in isolation, but analyzes it holistically. In this way, dependencies can be identified that would never have been noticed from the perspective of a single department, and integrated corporate management becomes possible. For example, through the comprehensive evaluation, controlling could determine that falling purchase prices correlate with falling sales figures for a particular product. If experience data (e.g. opinions from customers) are available in addition to operational data, the reason for this connection may also become clear. In this case, perhaps customers no longer find the product as attractive because a component appears to be less valuable.

Interlinking with management and specialist departments

With such a comprehensive view, controlling can suggest optimization that benefits the company as a whole. When correlating falling purchase prices and falling sales figures, one of the things that needs to be clarified is in which scenario the company achieves the highest profit. It is also exciting to find out to what extent lower quality leads to a loss of image and what that means for future profits. At this point it becomes clear how closely controlling and management are linked in the xP&A approach. Controlling provides the facts, management makes the decisions.

The xP&A approach also promotes cooperation between controlling and specialist departments. Controlling supports the individual departments in formulating coordinated goals that do not contradict each other and all contribute to the company's goals. Controlling takes on an advisory position that respects the autonomy and competence of the individual departments in evaluations and at the same time provides visible added value for everyone.

Technology and organization: successfully introducing xP&A

If you want to implement an xP&A approach, you should look at two dimensions of an overall concept: On the one hand, there is the technology. What is required is a platform on which all data can be brought together and processed - on which a single source of truth is created. Tools are also needed that support the analysis of the data (using different methods) and the visualization of the results (for different roles). In practice, establishing a suitable technological setup is usually the easier part.

On the other hand, changes must take place within the organization, whereby massive forces of inertia almost always have to be overcome. It is important to realign the competencies and responsibilities of controlling and to establish controlling as a strategic partner for evidence-based decisions. This means that changes must also be made to management and specialist departments. And this is where things often get stuck.

In order to develop an overall concept that encompasses the technological and organizational dimensions, sensitivity and practical experience are required. An external partner like NTT Data Business Solutions offers both.

Webinar recording: Building an integrated corporate management system (in cooperation with the ICV)

Implementing successful application scenarios with processes, innovative concepts and best practices. In our lecture we will show you the current methods and technologies for operational, tactical and strategic decision-making and give you an outlook on the working world of the future and THE top trends in controlling. Here we will focus in particular on the “xP&A” controlling approach as the foundation for integrated corporate management. Managament tasks across the entire company can be connected and synchronized. We also present examples of architecture, functionality and key benefits for business users and IT.

To the Webinar video

 

About NTT DATA Business Solutions

We Transform. SAP® Solutions into Value

We understand our customers’ businesses and know how to lead companies successfully into the future. At NTT DATA Business Solutions, we drive innovation: From consulting and implementation to managed services and beyond, we continually improve SAP solutions and technologies so that they work for companies – and their employees.

You can use our services in over 30 countries and over our thirty years of existence we have helped thousands of companies become even more efficient and productive. Our more than 13,500 employees operate globally and will accompany you on your path to an Intelligent Enterprise – wherever you want to start!

To the company page

 


“With Excel the options were limited, now we can plan flexibly and quickly. The new planning system integrates all partial plans and will be rolled out to our branches worldwide. What we like best about it is the ability to plan continuously and issue flexible forecasts,” says Daniel Olthaus, Head of Financial Analysis and project manager for the ROSEN Group in Germany.

About the ROSEN Group

The ROSEN Group is a world-leading provider of highly developed technical solutions. Active in over 120 countries, the group implements innovative technological solutions for the inspection of industrial systems in the energy industry to ensure safe and reliable operation according to the highest standards to protect people and the environment.

Facts about ROSEN
Founded: 1981
Employees: 3.900
Headquarters: Stans, CH

“We have worked very Excel-heavy in the past. As many people know it – preparing and merging data. Some macros had opening times of over a minute, which made user handling very difficult. Overall, the planning took too long. Since introducing the system with smartPM, our planning and forecasting cycles have been massively shortened.” Daniel Olthaus, Head of Financial Analysis, ROSEN Group in Germany.

INITIAL SITUATION

Initial situation and challenges of the ROSEN Group before the start of the project:

  • Time-consuming and laborious merging and maintaining large Excel sheets.
  • Ensuring good data quality and data timeliness was challenging.
  • Different partial plans continually led to coordination efforts. The focus was on comparing partial plans and analyzing deviations.
  • The analysis was neglected and the derivation of management decisions was challenging because data interpretation was discussed instead of analyzes and recommendations for action.
  • The planning cycles were long. There was a lack of flexibility and responsiveness.
  • The call for a professional, integrated system with high user acceptance was loud.

Daniel Olthaus, Head of Financial Analysis:

“We planned the implementation of the fully integrated planning project in several implementation steps. We were aware that we would not have a fully developed planning system from the start and that we would not be able to use it across the group. That's why we have planned 5 stages or project phases:

  1. Legal planning of the German units: cost centers, project, personnel, CAPEX, investment, P&L with different planning cycles, so that we don't just plan on annual slices, as in the past, but continuously, throughout the year. The plan is continually updated and scenarios can be differentiated in the flexible system.
  2. Based on this, the hourly rates are derived from the planning and the balance sheet figures (intra-year development of working capital).
  3. Integration of legal entity planning and sales planning with order intake planning and sales and profit center planning.
  4. Automating the linking of subplans for a fully integrated system. A change in the subplan shows the impact on the other subplans (sales, cost planning, etc.).
  5. At the end there is the fully developed xP&A with a coherent picture of the future development for the entire group.”

Project goals

  • A fully integrated system with connection to all data sources and networking of all sub-plans that impact financial planning (sales/sales, procurement, production, delivery/service provision) for the entire group.
  • Acceleration of the budget process: Continuous planning with the ability to incorporate adjustments directly. This allows management decisions to be optimally supported.
  • Improving data quality and timeliness
  • Quick response to changing partial plans including adjustments during the year and flexible, easily configurable scenarios/bandwidth planning with value drivers.
  • Mapping and merging different planning dimensions: sales view vs. management view of the legal units.

Daniel Olthaus, Head of Financial Analysis at ROSEN Group in Germany:

“We can now plan and make decisions continuously - with current data. The planning process is standardized. All sub-plans are linked and the need for coordination has decreased significantly. The users or user groups have their own cockpit with their own planning steps. The responsibilities are clearly assigned and the submission of partial plans is scheduled in the system. This allows the status of the planning to be monitored. Thanks to the Teams and Office integration, you can contact the planners directly. This saves a lot of time. For example, planning scenarios, cost types compared to previous year's values, etc. can also be carried out in the standardized planning masks. Value changes can be easily adjusted and distributed automatically. Deviations can also be easily identified and comments for any special effects can be entered by the planners. Planning can be done at the account level and parent level with automatic distribution.”

Project implementation

  • 2022: Development of a 5-step plan: Go Live planned for 9/2023
  • December 2022 to March 2023: Software selection with exact requirements lists and demo dates with 5 providers on the longlist.
  • January 2023: Implementation of prototype capacity planning with ROSEN company data through smartPM, another 4 providers show their solutions
  • April-May 2023: Proof of Concept with 2 providers (shortlist): Testing data model and connection, user management, dashboards, license model, support, flexibility
  • May 2023: Unanimous decision for smartPM.solutions. Start implementation capacity & resource management, cost center planning, data connection
  • June 2023: Implementation of financial reporting
  • July/August 2023: Implementation of cash forecasting and test phase of the system, implementation check whether all requirements are met
  • September 2023: Planning go-live exactly according to schedule for all planners/users

Daniel Olthaus, Head of Financial Analysis, ROSEN:

“Support was a key point in the decision for smartPM.solutions. The software for most providers is quite identical. Our focus was more on: What is the implementation team like, what is the support like and how does it work after the project. We had a good feeling that the implementation with smartPM would also be successful. This was an important point for us and is now an important factor, even after we have completed the first implementation step on time, because points keep changing during the project or implementation phase, where we notice that we can cope with it in the short term Providers must react together and adjust their priorities. Ultimately, what is crucial is that we have a partner who is as flexible as possible and with whom we can implement things quickly. So far we have made the right decision with smartPM.”

Conclusion & Learnings

  • Step by step introduction is highly recommended – the proven 5-step plan
  • Decisive success factors for the BI and FP&A implementation project: Not the software, which is very similar from many providers, but the support even after the project and the experience of the implementation partner.
  • Massive improvement in data and decision quality by networking data and partial plans in one system. Significantly simplifying the monitoring of key financial indicators. Time savings: Fast and continuous budget planning.
  • Very clear personnel planning and investment planning with planning masks per cost center. Complete reporting with very good visualization displayed in the system.
  • High user acceptance, responsibilities can be adjusted centrally very easily – for entire units or functions, good user guidance with an individually definable home page – cockpit.

About smartPM.solutions

With smartPM.solutions as your trusted partner for integrated planning, analysis, budgeting, forecasting, reporting and consolidation, you will maximize your success and achieve your business goals more efficiently than ever before.

Accelerate your planning processes and gain valuable insights from all your company data.

Leading technology providers such as Jedox, MS Power BI, SAP and Unit4 FP&A (prevero) rely on smartPM.solutions to achieve the optimum from modern technology and business solutions.

Trust in smartPM, the experienced partner in implementing digitalization in controlling with an average project rating of 4.9 out of 5 stars.