Business Issue
The company’s manual data entry on spreadsheets led to errors and inconsistencies, hindering operations.
- Efficiency: Lots of time and resources spent, diverting focus from core tasks
- Accuracy: Manual work leads to errors, affecting inventory and customer satisfaction.
- Consistency: Hard to keep data consistent across six countries, making planning difficult.
Approach
Recognizing the need for a transformative solution, Accelance implemented a customized Robotic Process Automation (RPA) solution specifically designed to automate the entire supply planning and net requirement process. This digital knight took the following steps:
- Discovery & PoC: Understanding the process and creating a PoC.
- Collected external data: Leveraging Microsoft Teams Automation, the bot seamlessly downloaded relevant supplier files from designated channels across all six countries.
- Extracted information from Qlik: UiPath's web automation allowed the bot to extract specified Excel files from the Qlik website using predetermined business logic, ensuring relevant data capture.
- Analyzed and updated data: The bot meticulously cross-referenced downloaded files with supply plan and net requirement data, updating specific cells according to predetermined business rules for accuracy and consistency across borders.
- Compiled and uploaded files: Assembling updated data and transferring it securely to the client system.
The Client
A global health and wellness focused consumer products company, known for its premium quality and innovative products.
Client operates in multiple markets worldwide, with a diverse customer base and a wide distribution network, which drives complexities in terms of ensuring seamless operations across different regions, managing supply chain complexities, and meeting the demands of it’s fast-growing customer base.
Project Statistics
Client Team Member: 4
Ignatiuz Team Members: 3
Project Duration: 10 Weeks
Location
United States
Results
75% reduction in
processing time
Enhanced
consistency
Eliminated human
error