Case Study on Supply Chain Management
Utilization of RPA
Overview
Supply Chain Management (SCM) plays a crucial role in every sector, and its significance is particularly pronounced in the Food Industry. The SCM team closely monitors the currently available inventory and continually reminds the suppliers about upcoming purchase orders. They must make various calculations, such as determining the number of items to be ordered and when to make those orders. This case study on supply chain management talks about how RPA automated its challenges.
Challenges
- The inventory information is in multiple systems, and the SCM team collects that information manually.
- The task involves calculating the items at risk and sending reminder emails.
- The SCM team is deciding the quantity of items to order.
Solution
Input
- Current Inventory data from different systems are exported in Excel format.
- The new PO list is fetched in CSV format.
- Data for items consumed in the last week is exported in Excel format.
Trigger
RPA BOT is set up to trigger every week to process the current inventory data.
To begin with, RPA is retrieving inventory data from multiple applications. Then, RPA generates the report after consolidating inventory information. The report is analyzed for the items that are below the threshold and require attention to be drawn. And for those critical items that may be out of stock before the next purchase order, Vendors are getting notified. The ordering trends for upcoming holidays, festivals, and other local events are determined by AI, which has an impact on the ordering patterns. Based on this, new purchase orders are adjusted accordingly.
Result
Output
AI determines the quantity of items for new purchase orders, while RPA assists in creating them from the specific systems. Every Vendor is receiving notifications about critical items that need attention as they may soon run out of stock.