Gavrilović: Better with each generation with the help of a modern analytics platform

Modern reporting platform for better manufacturing planning and financial budgeting

Introducing a modern reporting platform became one of the priorities a few years ago, since the entire process was becoming slower and slower and required more manual effort. Gavrilović had SAP BusinessObjects BI solution (SAP BO) in place, which covered part of the reporting, as well as an Excel spreadsheet that was widespread across the company. This resulted in low data quality (many people have their version of numbers), and in general gaps in various business processes because the data were not up to date at every moment.

The two key challenges were operational manufacturing planning and financial budgeting; the process started with creating base reports in SAP BO, exporting them to Excel and sending them to an end user, and then importing back to ERP to roll-back raw material needs using bill-of-materials, and finally sending it back again to BI system for reporting purpose.

The decision to change the reporting system was not an easy one, but we took the right step at the right time. In parallel with the implementation of the ERP system, we introduced a new dimension of reporting through Qlik, gained flexibility in data processing and presentation, as well as opened the possibility of applying new technologies in our BI department.

- Kristina Autischer, Director of Business Process Development Sector at Gavrilović

Agile decision making fully based on trusted data and optimised manufacturing processes

There were a few end goals that Gavrilović wanted to achieve with this project, and they can all go under the same topic of introducing agile decision making based fully on trusted data. One of the processes, which was also part of revision, was end-to-end planning process revision. Qlik platform was also used as the central data repository and planning extension was used to input planning data. The second relevant business goal was to optimise manufacturing process while analysing total spent time in each production phase compared to nominal values. This was achieved through multiple data source integration using Qlik platform.

Integrating all our data sources into one system and reducing the number of static reports was the main goal of the implementation of the new BI tool. With Qlik and BE-terna, we got a whole package of additional knowledge and best practice solutions for this case.

- Tomislav Milošić, Business Intelligence and Controlling Department at Gavrilović

With Qlik Sense and K4 Analytics tools, users now have access to all real-time data on just one screen

The core solution is developed on Qlik platform using Qlik Sense self-service solution. Data integration phase (which integrated data from old Dynamics NAV, new Dynamics NAV, SPICA (time space), Excel and K4 Analytics) was delivered also using Qlik platform which was the crucial step in allowing a comprehensive insight into data which come from various data sources. Following that, a few analytical applications for sales reporting, manufacturing analysis and financial reporting were designed. Various analyses were deployed, ranging from raw materials planning, norms analysis and stock insight to sales trend and drill-down analysis. 

The second phase of the project was the introduction of K4 Analytics planning tool which is fully integrated with Qlik platform allowing users to plan, check complete historical analysis and see real-time simulation results all in one screen. End-to-end planning process was covered; quantities, unit price, marketing cost and overhead cost on gl account level.

From 10 daily reports to one sheet in Qlik App! The same truth (numbers) for all users!

Prior to introducing Qlik, the sales team had a huge overkill in number of reports (and data) – for example one user had up to 10 daily reports, and after the implementation this data was visible in one Qlik app/sheet delivering also roughly 50% reduction in reports that were not being used. Also, from manufacturing perspective, different users used to come with different numbers (ex. production tons). Nowadays, everyone is looking at the same numbers in one governed application which really increased speed of making decisions.

Gavrilović really made a perfect fit for a successful BI implementation; they had all important puzzle pieces to make that happen, starting from super-strong top management support, proactive and competent middle management and absolutely great capacity in BI and controlling teams.

- Milan Listeš, Customer Landing Manager; Data & AI, BE-terna Group

Let’s solve the challenges of inventory management with state-of-the-art Machine Learning (ML) algorithms!

Successful integration of time sheets resulted in an idea to present estimated work time for each work order directly on big screens in manufacturing, and to deliver tool to increase productivity directly at the core of process. Until now, people in production were mainly reported on historical results which actually didn’t give them a chance to interact with the process in real time.

Another business area BE-terna is currently piloting together with the customer is the use of Machine learning algorithms to better forecast demand and use that data to optimize raw materials order and production planning in general. This process has already been improved with the implementation of K4 Analytics planning tool, but the idea is to better leverage sales forecasting algorithms, and to use that information to create an automated ordering process and ensure lower stock levels and avoid out-of-stock situations.

About Gavrilović

The company is run today by the ninth generation of the Gavrilović family. It is precisely this long-lasting family legacy that distinguishes Gavrilović from all other companies in Croatia, making it one of a handful of such family-owned businesses in the world. The Gavrilović meat-processing company is equipped with state-of-the-art industrial machines and production lines. Gavrilović has more than 500 employees, with over 300 of them employed in manufacturing. All the production lines are in Croatia, which is also the main market for end products, but export also ranges from USA to Australia with the focus on EU-countries.