Skip to content
Clear Process Solutions
Home Case Studies Global Lighting Manufacturer Moves $3.7M of Inventory with RPA Bot

Global Lighting Manufacturer Moves $3.7M of Inventory with RPA Bot

An SAP optimization company case study

Overview

The global lighting manufacturer was struggling with managing orders for distribution and the IT department was coming in on weekends to manage orders. The Enterprise Applications Director reached out to CPS to discuss their struggles. It was concluded implementing a robotic process automation (RPA) solution vs custom coding their ERP system could solve the global manufacturer’s issues.

Key Challenges

At times, the global lighting manufacturer had 1000s of orders or order lines (materials or products) to process. One major roadblock was moving or reassigning an order to a different distribution center based on where the inventory was available. The challenges they faced:

Manual process and prone to human error

ERP customization would cost $50K and massive amounts of time to maintain

Multiple spreadsheets to maintain

Results

CPS recommended UiPath / RPA as an option. Ultimately, the goal was for the RPA bot to read the data for the reassignment of location from Excel and open the order for each of those lines listed in the spreadsheet. Next, the bot would find the line number (could be 50 or 500 lines within an order) and pick the specific line to change. An unattended robot / virtual worker was deployed to manage backorders daily.  

RPA technology provides the ability to record keystrokes and mouse clicks which allows citizen developers to recreate tedious non-value-added tasks. Citizen developers are typically business users, business analysts or non-programmers on the IT staff enabled to create automations using digital transformation platforms. The power of UiPath is its flexibility to work with any existing application or system.

$3.7M

inventory moved by RPA bot

100%

reduced TCO of ERP by not adding custom code

100%

customer satisfaction with receiving orders faster

2 1

reduced FTE’s after bot implementation

Learn More About:

Strategic Services

Leverage our strategic services team to lay the foundation for your automation and data success.

Learn More

Technical Services

Our technical services team will choose the right technology to achieve your desired results.

Learn More

Managed Services

Maintain your solutions through continuous improvement while maximizing your technology investment.

Learn More

Start Your Digital Transformation Journey Today.

Work with our digital transformation advisors to identify what technology and professional services can be leveraged to solve your challenges.

Schedule Discovery Session