Can IT in Industry 4.0 replace all the spreadsheets?

Share On

it-industry-40

IT systems are essential for operations in manufacturing. They cover everything from business, execution to communication. Usually, systems are designed as static structures that natural workflow has to be fitted to. Practice shows that a lot of effort is lost for fitting and bypassing those structures. Is it possible to create a system that fits the natural workflow?

IT systems in manufacturing

The basis for the majority of the manufacturing companies is ERP (enterprise resource planning) system. ERP covers the business processes and passes production orders to shop floor through MES (manufacturing execution system). MES tracks realization and passes it back to ERP. That is how management can calculate the realistic cost of produced items. In addition, some companies have separate IT systems for attendance, planning, warehouse management or have it covered with spreadsheets.

Alternative ways of information transfer

Despite carefully designed IT systems specific production processes and people require different ways of communication. Whenever the workflow in an IT system does not mirror an actual workflow there are additional or substitute steps added by employees. Additional steps usually connect two different software solutions or transfer information to another department within a company. Substitute steps replace software that is no match for the process or replace repetitive manual tasks. Information transfer is usually executed in the form of spreadsheet files, notebooks, emails, calls, and meetings. Those steps enable employees to transfer information more efficiently and effectively.

Time lost with inefficient information transfer

Establishing and maintaining additional steps in information transfer require time. For example, let’s have a closer look at an automotive company that uses SAP and MES, collecting realization at the end of each shift and/or at the end of each production order.

A planner that builds a plan in SAP PP needs an extra 4 hours of effort to translate the plan in a more shop floor friendly form. Due to the ever-changing nature of production, he also spends an additional 8 hours per week to check the current status of the production and inventory. He collects this information with weekly meetings and phone calls to adjust schedules and plans if necessary. Together he spends almost 2 days building and maintaining the production plan. That is all happening outside the implemented IT system.

A digital twin of your company

New technologies such as artificial intelligence can help manufacturing companies to mirror production workflow in an IT system with actual workflow. Artificial intelligence is utilized to build a digital twin of a company based on historical data of production orders.

By utilizing digital twin a planner can build realistic production plans on one platform. Plans are then automatically translated to schedules for shop floor to execute. All the changes in business and production processes are automatically taken into account in production plans. Artificial intelligence is also used to pass relevant and urgent information to responsible employees. In effect reducing the number of spreadsheets, emails, and calls.

Can all the moving parts in production be handled by one IT system?

Manufacturing IT systems have a fixed structure that usually is no fit for the production workflow. To overcome these issues employees lose time to build bridges using spreadsheets, calls, and emails. Using the latest technologies such as artificial intelligence, you can build a digital twin of your company that will drive information transfer.

An experienced digitalization partner with extensive knowledge in artificial intelligence can help you to automatically build and maintain a digital twin of your company.

Read more articles

Four Steps to Implementing AI in Production Planning and Scheduling

ChatGPT Falls Short in Manufacturing — Here’s Why You Should Rely on Proven, Old-School AI

Elevate Your SAP with QLECTOR LEAP

testimonial-domen-skrbina-min

With QLECTOR LEAP, we have digitally mapped every process within our company, revolutionizing our operations. This allows us to swiftly and efficiently formulate our production plan, complete with auxiliary workstations. The true game-changer lies in the plan's automatic updates. Simultaneously, all subsidiary processes remain informed of any modifications

By bidding farewell to a multitude of Excel files once essential for production planning, we not only declutter but also reclaim valuable time. The era of manual updates is now behind us.
I wholeheartedly recommend Qlector Leap to those who have yet to establish a systematic production planning system and still rely on Microsoft programs. The tediousness of handling such files and their susceptibility to errors can now become a thing of the past

Domen Škrbina

Head of Production Logistics at Kovis

Kovis is an internationally innovative company for the development and production of high-quality components for the railway industry and various parts for other industrial sectors. The company has established itself internationally with the production of brake discs for all types of railway vehicles: from locomotives, trams, and metro lines to high-speed trains. In addition to the brake discs, Kovis is also the largest manufacturer of axle boxes for freight wagons in Europe.
Kovis turns good ideas into a safe and sustainable future.

marija-golja-testimonials-2

QLECTOR LEAP has enabled significant progress in production plan optimization, as it learns from historical data, optimizes the plan, and provides more optimal suggestions for planners and production.

The most useful functionalities include real-time inventory overview, scheduling of workers and tool changes, and a user-friendly experience for planners, who receive a Gantt chart and a real-time overview of weekly realization. Any changes made to the plan in SAP by the planner are immediately visible in LEAP, allowing us to see when we will have reconfigurations and reduces tool change time.
The condition for using QLECTOR LEAP is well-organized data. With this condition met, LEAP operates with great precision, which is why I would recommend it to other manufacturing companies.

Marija Golja

Production Planner at Kolektor

Kolektor is a global supplier that boasts a tradition of highly specialized industrial production. In almost 60 years of experience, the company became a global provider of mobility components and systems and has added programs outside the automotive industry in the process of diversification and globalization and has spread to other continents.
Kolektor is a synonym for credibility, trust, quality, and innovative products and services. The programs are managed in three strategic groups: Kolektor Mobility, Kolektor Technologies, and Kolektor Construction.

ingo-hild-testimonial-01

Qlector's software optimizes production planning in a simple, intuitive way and opens up new optimization options in a simple form thanks to the AI algorithms and various evaluations and reports. A must for modern production

Ingo Hild

Plant Manager at ams OSRAM Group

ams OSRAM is a global leader in innovative light and sensor solutions, building on over a century of experience. Combining engineering expertise with global manufacturing, the company delivers groundbreaking applications that make the world safer, smarter, and more sustainable. Specializing in high-quality semiconductor-based light emitters, sensors, and software, ams OSRAM continues to push the boundaries in illumination, visualization, and sensing across diverse industries.

matjaz-roblek-01-1

QLECTOR LEAP has enabled the automation of planners' work, faster response to changes in production planning, and management of a larger number of machines.

The results are currently evident in shorter inventory lead times for binding unfinished production and semi-finished goods, where we observe a 10% improvement. I would also highlight the expertise and agility of the Qlector team in terms of understanding and adapting to our production planning peculiarities. Domel follows modern trends in digitization, which is why QLECTOR LEAP seamlessly integrates into the ERP and MES system and is certainly one of the AI integrated APS solutions worth exploring.

Matjaž Roblek

Supply Chain Director at Domel

Domel is a global development supplier of electric motors, vacuum motors, blowers, and components. The company was founded in 1964 and has production facilities in Slovenia, Serbia and China. Their motors power over 300 million appliances in premium and consumer markets worldwide. Domel’s business processes employ high levels of technology, automation and robotisation, which form a basis for building competitiveness and excellence.