How to analyze material flows using process mining techniques

posted by
Trevor Miles
Thought Leader

Process mining is a hot topic—and has been for more than five years. Celonis, one of the early solutions, is the first European “unicorn” and is now valued at over $11 billion. This type of growth and valuation can only be based upon proven value delivery. And there is no doubt that process mining techniques have delivered value in process analysis. 

For the readers who are unaware of process mining, here is a quick introduction. With the advent of ERP systems, particularly SAP, companies started capturing transactions, which are a record of when particular process activities are performed, by whom they are performed and on what they are performed.

Transaction capturing

For example, a transaction will capture that:  

  • Purchase Order 123456  
  • was issued by Trevor  
  • on 11-Aug-2021 at 12:26:31 GMT 
  • to Company XYZ 
  • for 2 printer cartridges and 3 reams of paper 
  • for delivery on 18-Aug-2021 
  • to the Bluecrux office in Mechelen 

Another transaction may be that: 

  • Purchase Order 123456 
  • was received by Christophe  
  • on 11-Aug-2021 at 16:45:32 GMT  
  • from Bluecrux  
  • for 2 printer cartridges and 3 reams of paper  
  • for delivery on 18-Aug-2021  
  • to the Bluecrux office in Mechelen

In the process mining world, the key information is the Case ID (PO123456), Activity ID (Issue PO, Receive PO) and Time Stamp (20210811 12:26:31 and 20210811 16:45:32). The rest of the information is descriptive and can be used for filtering. For example, an analysis can be performed on only those purchase orders issued by Trevor. Important information that can be mined from the transactions is the process time. In this case 16:45:32-12:26:31, or 4.316944 hours, is the process time from sending the PO to receiving the PO.

→ The analysis performed by process mining is across many, many transactions, resulting in an analysis such as in the diagram below. 

Source: (13) SAP Process Mining by Celonis – Frictionless Procurement – YouTube 

ERP systems & process mining

In an ERP system, there are many processes driven by different types of orders—sales, recruitment, manufacturing, shipping, receiving, picking, packing—for the processes covered by the ERP deployment—procure-to-pay, order-to-cash, hire-to-fire, etc. Each of these processes can be analyzed individually,  provided there is a unique case ID, activity ID and time stamp.  

Here is the rub for analyzing manufacturing and supply chain processes: The object of interest is the material, not the order. In the procure-to-pay (P2P) example above it was the order that was being analyzed, not the material flow. Wil van der Aalst, the “father” of process mining, has written some papers on the issue of “Object Centric Process Mining.” Van der Aalst uses the case of a purchase order to illustrate the issue. Normally, process mining follows the order of activities, the blue column, whereas we in supply chain are more interested in the objects, the brown column, on which the activities are being performed.  

I must pause to acknowledge that companies can indeed generate a lot of value through process standardization and conformity, which lead to efficiency gains. The concept of time and motion studies is not new, having been pioneered by Frederick Taylor in the early 1900s. What has changed is that the stopwatch and clipboard have been replaced by ERP transaction logs, creating a huge amount of data that can be analyzed to improve the efficiency of the processes as defined in the ERP systems. 

Because process mining is focused on the order and not the object, there are some serious and recognized drawbacks to the use of process mining to analyze manufacturing lines and supply chains: 

‘Anonymous’ Inventory 

In ERP systems, there is an order to put material into inventory, and there is an order to take material out of inventory, but there is no order to keep the inventory in stock. Hence, to process mining, inventory is “anonymous” because it can’t be associated with an order ID

This leads to a second problem, namely that incoming inventory is usually in much greater lot sizes than the outgoing inventory, so how do you match the incoming and outgoing inventories, especially given that the put-away order and picking order have different IDs? And how do you determine time in inventory? 

Material ID change 

Many operations—machining, assembly, etc.—result in a material ID change. This is completely apparent from the diagram above. 

Therefore, even if you can track the object ID, you need to understand the bill-of-materials (BoM), bill-of-lading (BoL), bill-of-distribution (BoD), etc and all the routing information in order to track the material ID changes through a supply chain. Process mining tools do not understand this information, in which case you are left with a number of links, but not a chain representing the connected links. 

Forecast 

The forecast does not have a transaction ID because the forecast is an object, not a process.

Most companies are make-to-stock, with sales orders only accounting for about 5% of material movements, the other 95% of material movements being generated by replenishment orders. While process mining could use replenishment orders, replenish orders are generated by safety stock (SS), re-order point (ROP), minimum order quantity (MOQ) and economic order quantity (EOQ) logic. Therefore, by using replenishment orders, you will have lost visibility to the demand picture, and consequently, the ability to use demand priorities to analyze the value stream flows.  

Anyone who has created a value stream map (VSM) of a production line or supply chain will know that an item will spend the vast majority of its time in a buffer of some sort, whether on a production line, in a warehouse or in a container. Not being able to analyze the time in inventory is a serious shortcoming of process mining in developing end-to-end supply chain VSMs

We also know that the material ID constantly changes by going through machining, packing, unpacking, assembly, loading and many other activities and processes. Without being able to follow the material ID changes, and object ID in process mining terms, you have a link to the chain but not a manufacturing line and not a supply chain. 

Many end-to-end supply chains have lead times of 9 to 18 months, meaning the forecast is required to understand what is driving more recent purchase orders, manufacturing orders and replenishment orders. Since the vast majority of supply chain and manufacturing systems are make-to-forecast/make-to-stock, if you only use sales orders to analyze your supply chain and manufacturing, in most cases you can only analyze the order-to-delivery process.  Even if the end-to-end supply chain lead times are 9 to 18 weeks, the forecast is required to understand more recent material movements. 

In summary, because of these shortcomings, it is impossible to perform end-to-end value stream analysis of a supply chain using standard process mining concepts and tools.

Enter Axon

Axon also uses transaction logs for process mining, however it does so from the material ID perspective. As Van der Aalst calls it, Axon performs object-centric process mining. In addition, Axon uses key master data, usually stored in ERP systems, to perform the process mining across processes. More importantly, Axon uses fuzzy matching to link material flows across master data record and transaction systems such as ERP, MES, WMS, LIMS and other core enterprise transaction systems. This first step of data association is very important because Axon links the data across the core systems and develops a graph model of the associations. 

Once the data is associated, end-to-end product flows can be determined by following the materials through material ID changes and ‘anonymous’ inventory locations. 

Now we can start the analysis that is more familiar to people who have used process mining before, which Axon calls supply chain contextualization, and is the discovery of different flow variants, frequency of use, lead times and other performance characteristics. Notice the very familiar variant analysis visualization, with associated “happy flows” and the ability to select the flows/variants to be analyzed and the proportion of the total represented by the selected flows/variants. 

As with standard process mining tools, Axon can perform an in-depth analysis of the past performance of your supply chain to identify key areas of value leakage. Axon can also be used to feed better and dynamic planning parameters to deterministic planning tools such as OMP, SAP IBP, Blue Yonder and Kinaxis. 

Putting this all together allows Axon to generate the very familiar value stream map below. Please note that the VSM below was generated across five different systems, with all the data association issues related to part number changes, unit of measure changes, time zone changes, etc. Notice also that, unlike traditional VSMs, Axon also provides the variability represented by the thin cyan vertical line (range) and blue bar (95% CI). 

Not surprisingly, the VSM generated by Axon is consistent with the standard VSM maps in that the total waiting time far exceeds the total processing time. As mentioned above, Axon also provides an analysis of the variability. As we know from Lean/SixSigma principles, variability is a major cause of value leakage. Knowing where your material flow is most variable and putting activities in place to reduce the variability is a great boost to productivity. 

This type of analysis is used by our consultants to perform reliability projects, the first step of which is to build Axon’s digital supply chain twin from the transaction logs, associating data across multiple systems to identify the areas of greatest variability, reducing the variability to improve reliability, and then reducing the component lead times to improve performance.

 

If you have been trying to conduct value stream analysis of your manufacturing lines or supply chains using standard process mining tools, please call us. We’d love to help.  

Read on below to discover more about data mining with a digital supply chain twin:

> Planning in the digital age: Let data do the dirty work

> Supply chain data harmonization: The role of AI & ML

Want to learn more about what a digital supply chain twin can do for you?

Let’s start working together

Let's start working together

Related articles

  • - by Trevor Miles

    How do you build a digital supply chain twin?

    Build your end-to-end digital supply chain twin for network visibility via crawling algorithms and process mining to establish true material flows. Learn how artificial intelligence (AI) and machine learning...
    Read more
  • Worker digitally monitoring inventory in warehouse.
    - by Trevor Miles

    What is a digital twin?

    You may have heard these terms before, but precisely what is a digital twin or, more specifically, a digital supply chain twin? These words aren’t just marketing lingo; they...
    Read more
  • - by Trevor Miles

    The rise of the resilient supply chain

    The Covid-19 pandemic underscored the need for a resilient supply chain. New tools like digital supply chain twins can help supply chains achieve stochastic planning, which models uncertainty and...
    Read more