Building A Comprehensive Spend Analytics Dashboard For A Kitchen Brand

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

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

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.

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.

Building a Comprehensive Spend Analytics Dashboard for a Top International Kitchen Equipment Brand Owner and Manufacturer