February 2023 | 5-minute read
Tagged: SupplierAssessment | ProcurementFramework | SupplierNegotiations | WinWinRelationships | SupplierPerformance | DataIntegration | CloudDataPlatform | AWSIntegration | BusinessIntelligence | DataAnalytics | SupplyChainOptimization | DecisionMaking | VendorManagement | DataLake | SupplierRelations
Sourcing & Procurement (S&P) teams generally spend much time collecting data for discussions with their suppliers. Post-data collection, these discussions with suppliers happen based on the performance of the products and their service. The negations with vendors are often Distributive in nature and are often a “Win-Lose” conversation where the party with more Power gets their way. This “Value Claiming” exercise often leads to long-term issues with suppliers and, in the future, impacts businesses.
To solve the above challenge, retailers should focus on creating frameworks that help the procurement team negotiate with their suppliers in integrative manner. Those discussions should focus on building longer-term relationships and working together to make a “win-win” business.
The solution approach would be as follows.
Supplier Assessment Framework:
As an individual from a consulting background, I like to assess problems in a 2x2 or 3x3 framework. One of the ways I propose is to create a 3x3 grid where on
Figure 1: 3X3 matrix segmenting the Suppliers in the Organisation
To score these suppliers and place them on the grid,
Figure 2:Illustrative example on how Supplier can be assessed and scored
The dashboard shows the scores calculated against each Performance and Capability KPI for different suppliers. This helps them to focus on specific gaps relevant to low scored KPIs and not on other metrics.
Unified Data Platform on Cloud:
For a unified data platform, retailers can leverage Amazon Web Services (AWS) to build their Data Lake & Warehouse systems on the cloud. Running this system on the cloud would bring various data formats/types from disparate systems in one common location for vendor-wise large-scale computation of these KPIs.
Figure 3:Illustrative AWS cloud architecture for Supplier Assessment Framework setup
The above figure is an illustrative example of design architecture on how data from Disparate sources are collated into Data Lake on Amazon Simple Storage Service (S3) and then further processed and stored in Data Warehouse where calculation of the KPI occurs in Materialized views feature of Redshift.
Businesses can further utilize Amazon QuickSight to build the Supplier Assessment Grid on a dashboard view, ensuring the Grid is pre-calculated and drillable for each category. Appropriate Category managers can act accordingly.
Supplier Assessment Grid gives businesses the leverage to have an open and integrative discussion with suppliers enabling enterprises to build more long-term partnerships with their suppliers. Building their data lake and Business Intelligent systems on AWS eco-system businesses can automate their data collection, allowing firms to save 10,000+ hours in data collection and report generation (if manually done previously), effectively helping them focus on effective decision making.
To learn more about Ganit and its solutions, reach out at firstname.lastname@example.org.