Overstock Problems in a Purchase-to-Pay Process: An Object-CentricProcess Mining Case Study

Abstract

This paper addresses overstock issues in a real-life Purchase-to-Pay process in cooperation with the industry leader in pet retail in Europe. It highlights the development of solutions for more efficient inventory management, thereby reducing overstock. Our approach involves identifying patterns leading to overstock and proposing specific improvement measures within the existing logistics systems. This includes technical modifications in the order suggestion and purchase order processes using Logomate and SAP systems. The research utilizes object-centric process mining techniques as a crucial tool to uncover these patterns, with a focus on the practical solutions derived for overstock reduction. The case study conducted with the PM2 methodology demonstrates potential benefits in optimizing inventory structure and suggests a path for future research in generalizing these findings across various sectors and automating overstock pattern detection.

Publication
Advanced Information Systems Engineering Workshops - CAiSE 2024 InternationalWorkshops, Limassol, Cyprus, June 3-7, 2024, Proceedings

Practical problem

Retailers keep warehouses full to avoid empty shelves, and the result is often overstock worth millions of euros: goods bought without matching demand that tie up capital and reduce flexibility. Logistics managers know the problem exists but struggle to see which concrete ordering behaviors create it, because purchasing runs across several systems (a replenishment planner proposing orders, an ERP system creating and receiving them) and a single purchase order bundles many items from many suppliers in many shipments. Classical inventory formulas assume constant demand and costs, and process mapping or fishbone diagrams are not driven by data. Conventional process mining looks at one order at a time and cannot follow a material that is re-ordered across several purchase orders, so the chains of events that end in overstock stay invisible.

Research questions

  1. How do the relevant objects in the purchase-to-pay process (order suggestions, order suggestion items, purchase orders, purchase order items, materials) behave and interact with each other?
  2. Which behaviors and interactions of these objects lead to overstock?

Contributions

  • A real-life object-centric process mining case study at Europe’s largest pet retailer, following the PM2 project methodology adapted to the retailer’s setting.
  • A conceptual model of the purchase-to-pay process with five object types and their object-to-object and event-to-object cardinalities, covering both the order suggestion and purchase order sub-processes.
  • An extraction and transformation pipeline from Celonis (fed by Logomate and SAP) into an object-centric event log in the OCEL standard format.
  • Two object-centric Petri nets, discovered and analyzed with the ocpa Python library, giving a holistic view of ordering and a material-focused view of receipt behavior.
  • A catalogue of assessed behavior patterns in both sub-processes and two concrete improvement measures agreed with logistics management for the Logomate and SAP systems.

Key findings

  • The filtered log (January to April 2023, one central warehouse, short lead-time standard assortment) contains 13,151 events over 1,918 order suggestions, 39,853 order suggestion items, 3,144 purchase orders, 49,176 purchase order items, and 5,144 materials.
  • Order suggestion items exported manually earlier than the planner suggested, which locks in less accurate forecasts, occur 1,123 times in the review period and are assessed as a direct source of potential overstock.
  • Materials created as purchase order items repeatedly without being received, with replacement orders padded by undemanded items to meet minimum quantities or truck capacity, affect 171 materials and are assessed as both shortfall and overstock.
  • Other patterns, such as batch receipts, partially received orders, single-item purchase orders, and repeated deletion of suggestions, are assessed as shortfall, inefficiency, or rework rather than overstock.
  • Limitation: the material re-ordering pattern is only visible because objects are linked across purchase orders, which traditional single-case process mining cannot do; the study assumes predicted demand equals actual demand and the proposed measures are not yet operationalized or measured.