Building a Comprehensive Spend Analytics Dashboard for a Top International Kitchen Equipment Brand Owner and Manufacturer
Building a Comprehensive Spend Analytics Dashboard for a Top International Kitchen Equipment Brand Owner and Manufacturer
Challenges
Context
Approach
Results
Challenges
- Multiple ERP systems made it difficult to consolidate in a single tabular format
- Harmonization of SKUs. Same supplier SKUs had different part numbers and multi-lingual description
Context
- To create a single point reference for all operating sites spread across the globe and product category
- Consolidating data from multiple Database platforms like SAP, ERP, Oracle etc
- To facilitate top-level procurement managers to view and analyze different categories of spend across different sites
Approach
- A Simple and effective table was created to which all the data from ERP systems can be transferred to.
- SKU cleansing by mapping different SKU number versions and normalizing them to a single source of truth
- Normalizing suppliers by supplier groups
- Time series plotting of purchase of a similar product from different suppliers to help consolidate spend and review MOQ
- Historical commodity prices linked along to give better visibility of price trend and capture value.
- Price benchmarking analytic conducted through in-house web-based application to identify points for price negotiations, design rationalization, supplier rationalization to optimize supply chain category management.
Results
- Managers were able to compare, multiple products which could be standardized across categories
- Effective negotiations were held by category managers who had access to historical cost trends for different commodities.
- Supplier rationalization and consolidation process was effective because of data driven decisions
- Reduction in Administration spend due to better MOQs set by SKU using the dashboard.
- Initiatives identified to convert conventional packaging to more sustainable packaging.
Download Complete Business Case:
Explore Other Business Cases
All
Innovation Analytics
Procurement Analytics
Supply Chain Analytics
Business Operations Analytics
Sales & Marketing Analytics
All
Innovation Analytics
Procurement Analytics
Supply Chain Analytics
Business Operations Analytics
Sales & Marketing Analytics