About
US’s leading distributor of quality pet food and animal supplies to pet stores nationwide.
Challenges & Goals
The nation’s leading distributor of wholesale pet food and animal supplies was constantly receiving requests from its 200+ vendors across the US for reports with varying levels of data to understand the performance of their products in various markets. These reports would take the distributors’ employees days and weeks to create; taking time away from their principal job functions. The company was looking to automate reporting of product performance, inventory levels and give deeper insights into various other parameters to their vendor partners.
Solution
- Effectus worked closely with the distributor’s vendor management team to understand the answers vendors were looking for through data and reports as well as assessed the current systems for the data being captured and available for reporting.
- We implemented an automated solution to integrate data that was scattered across multiple disjointed systems into a single source of clean data with unified definitions. A business rules engine was put in place to process the data for extracting intelligence answering various questions from vendors.
- Our team of reporting experts created a variety of standard reports for each vendor with insights into various performance metrics, inventory levels, top moving products and parameters helping them better plan their inventories and shipments. Report creation was automated, eliminating excruciating long hours the team had to put in to create reports.
- Each vendor was given secure and self-service access to the portal for viewing real-time reports with the ability to drill-down for further details as well as historical performance. The portal automates the creation of the reports per vendor and automatically refreshes the information at standardized cadences.
- The portal has also given insights into the performance of various products and vendors to the vendor management team.
Results
Vendors now get real-time answers to their questions about the performance of the products they supply through the distributor in various markets and regions in the US. The self-service portal created for vendors is one of the first ones in the industry to improve the supply chain. Additionally, vendors now have visibility to information not previously available such as nationwide inventory levels. With automated data collection, processing and report creation; the vendor management team saved significant hours and had the time available to focus on value-add activities.
Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.
Sam Billings
VP Operations, Gatorade
Areas Effectus Worked In
Data Management
Reporting and Analytics
Digital Transformation
Enterprise Vendor Portal
Change Management and Training