Automated inventory allocation estimation

Company profile

Our customer is a globally operating company developing, manufacturing, and delivering medical devices to the worldwide market. They have 40 manufacturing sites across the globe.



With a growing backlog due to material constraints and supply chain disruptions, the company was dealing with an increasingly larger orderbook. As a result, planners struggled to respond quickly and efficiently to demand changes and to communicate estimated delivery dates to their customers. They needed a way of quickly assessing their inventory on-hand, splitting it between their clients, allocating it to specific orders and communicating estimated delivery dates.



Working directly with the excellence department and very closely with the planners, EyeOn was to support the creation of this new process and the tool to support it. The required deliverable was an orderbook that had a coherent split of inventory across orders, which aligned with the company’s business strategy.

Together with the customer we took a 3-step-approach:

  1. Identify key information for decision-making and allocation policy definition.
  2. Design a process to prioritize countries and orders and to split on-hand inventory.
  3. Develop a user-friendly Python application to automate decision-making at order level.



The result of this project are new decision making rules to fairly allocate inventory to order lines. We helped automate the process to generate output quickly and with high consistency, which is then communicated to clients. This reduced the planner’s workload from several days to less than 1 hour while allowing them to reach better service levels. The planners also achieved a bigger data maturity and awareness of essential requirements to work with data.

Search for