Full transparency at the meat processing plant

Industry: Meat
 

Integration of ERP and BI

Staying abreast of what is going on is essential to being able to respond quickly – even more so when you supply fresh top-quality products to your customers. Aiming to keep track of the value chain in real time, EDEKA Südwest Fleisch has interlinked its ERP system with a BI solution. The integrated data is available much faster now. Plus, the system visualizes the data in user-specific, customizable views. This has been achieved by directly integrating the ERP from CSB-System into the analytics software of Qlik Sense.

EDEKA Südwest Fleisch GmbH was established in 1970 as a one-hundred percent subsidiary of EDEKA Südwest Handelsgesellschaft mbH.

Since 2011, the meat processing plant in Rheinstetten has been in operation, supplying over 1,100 EDEKA stores from Lake Constance to Saarland with beef and pork as well as fish, cheese, and convenience products. This operation is considered as one of the most advanced and efficient meat factories in Germany where 15,000 pigs and 1,200 cattle are cut and approx. 550 tons of sausages are produced every week – on an area of 52,700 square meters. The daily incoming 220,000 order lines are handled by 1,400 employees and shipped to the customers via a sophisticated logistics system.

Controlling such a state-of-the art operation would be virtually impossible without cutting-edge information tech nology. For quite some time now, EDEKA Südwest Fleisch has opted for automation and digital processes. “Given the high de gree of digitalization and our integrative equipment, we have already achieved a great deal – and we collect a huge amount of data. With our latest project, we aimed to access this data so we could evaluate and analyze it in accordance with our requirements,” describes CEO Edwin Mantel the task of the project team. “This is precisely what we achieved through a collaboration between EDEKA Südwest fleisch, our ERP provider CSB-System, and the Qlik partner Informatec,” adds Martin Skazel, chief administrative officer.

Visualize data from the ERP and beyond

The core of the value chain is the ERP system from CSB. Since the facility’s start-up in 2011, the ERP has controlled receiving, cutting, production planning and management, packaging and weigh price labeling, inventory entry and removal processes, order picking, loading of roller containers, and shipping. Com prehensive information on the current situation, the performance and the tech nical state come together at the technical and logistics control stations that monitor and control around 800 single processes.

Though the process is running smooth ly, EDEKA still wished to take it to the next level by enhancing the transparency. While not every user needs a maximum degree of detail, it is important that the staff and the managers of EDEKA Südwest Fleisch be supplied with the data on the spot and in the right form. Dynamic analyses of the business data from the CSB-System and from the Data Warehouse should improve the transpar ency of all processes. Through a direct integration of the ERP from CSB-System and the business intelligence solution from Qlik, this is precisely what has been achieved: EDEKA Südwest Fleisch now has a dynamic, high-performance eval uation tool for production, supply chain management, and billing. An important factor for the success of this project was the experience brought in by Informatec, as this company already supported numerous ERP-BI integration projects in the food industry.

Integration as the key to efficiency

Transparency begins with data. The Data Warehouse was continuously expanded with more data that should be made available and – in particular – analyz able in real time. At defined times, the information from the productive system is moved to a specific data warehouse; for instance, sales and procurement data, machine data as well as production data.

In the course of the project, the teams have learned to double-check the origin of the data and to define the concrete views in close coordination with the dashboard users. Especially for the Page 11 business management data, the calcula tions need to be discussed in detail with Controlling. The lessons learned will be incorporated into best-practice solutions. CSB and its partner Informatec have therefore decided to supply their cus tomers with out-of-the-box data models and reports – called iVIEW templates in Qlik jargon – to kick-start the projects and generally reduce the implementation times.

The data is still prepared and processed in CSB’s ERP – data that is also used to verify the Qlik Sense reports. CSB Line Control acts as a collector and interface for the connection of machines from various manufacturers, and will in future be used to review and analyze the live data in real time. In the Qlik Sense cloud analytics software, the data from the different sources is updated and visual ized in line with the requirements. For example, users in sales and marketing could display analyses of billing and sales data on their dashboards. The executive managers can see a combination of all rel evant data with the option to drill down. Purchasing and material requirements planning are supplied with evaluations on coverage and goods receiving postings. The technical and production depart ments monitor the machine data with regard to availability, performance, and maintenance.