SUPPLIER PERFORMANCE SCORING FRAMEWORK

Abstract

This project dissertation report, titled "Supplier Performance Scoring Framework," encapsulates a comprehensive initiative to design and implement a scalable, data- integrated, and modular framework for evaluating and benchmarking supplier performance in the material handling function of an FMCG company. One of the key levers to achieve this is robust supplier performance management. This project presents the design and development of a Scalable, Data-Integrated, and Modular Supplier Performance Scoring Framework aimed at evaluating and benchmarking suppliers involved in inbound material handling for an FMCG company. The primary objective of this system is to enable procurement and supply chain teams to make transparent, data-backed, and strategic sourcing decisions by continuously monitoring supplier performance across multiple critical dimensions. These include delivery efficiency, supply quality, responsiveness, pricing competitiveness, and compliance with service level expectations. The framework evaluates each supplier on nine distinct metrics—On-Time Delivery, In- Full Delivery, Capacity, Handling Quality, Supplier Defects, Responsiveness, Reliability, Pricing, and Issue Resolution. Each metric is scored out of 10 and derived from both system-generated sources (such as ERP, GRN systems, and SCM apps) and manually curated trackers (e.g., CAPA trackers, internal forms, and price logs). A weighted average scoring model is applied, with configurable weights that allow the organization to emphasize different priorities such as quality, cost, or service level depending on strategic requirements. To ensure granularity and actionable insights, the scoring is also mapped category-wise (e.g., Jerry Cans, Oils, Chemicals), providing a clear view of supplier performance within specific raw material streams. This empowers procurement managers to tailor engagement strategies, negotiate effectively, and make informed decisions on supplier retention, development, or replacement. A user-friendly dashboard interface built on Streamlit facilitates monthly data entry, automated scoring, visualization of supplier performance trends, and identification of risk- prone vendors. Key features include horizontal bar charts, supplier ranking tables, category-wise top performers, and integrated risk analysis, offering a comprehensive view of supply-side health. Furthermore, the system’s design promotes transparency, accountability, and vi continuous improvement. Suppliers can receive structured feedback, and internal stakeholders gain visibility into key performance indicators that were previously difficult to consolidate and interpret. Overall, the framework bridges operational and strategic supply chain functions by offering a flexible, repeatable, and scalable performance management tool that aligns supplier contributions with business goals. It enhances procurement efficiency, supports long-term vendor development, and helps mitigate supply chain risks, making it a valuable asset for any FMCG organization pursuing excellence in supplier relationship management.