Description: Developed a comprehensive Supplier Evaluation Matrix to assist in the selection of the best suppliers based on a range of critical factors. The matrix utilized an Excel-based vendor scorecard, which included a weighted scoring model to compare suppliers across cost, quality, and lead time. The tool provided a data-driven approach for selecting suppliers that align with business needs, ensuring better procurement decisions and optimized supply chain performance.

Deliverables:

• Excel-based supplier evaluation matrix
• Vendor scorecard with weighted scoring model
• Supplier comparison report based on cost, quality, and lead time

Skills Used:

• Excel (Advanced formulas, Data analysis, Weighted scoring models)
• Supplier evaluation and vendor management
• Procurement decision-making
• Business analysis
• Data-driven decision-making

Key Features:

• Excel-based vendor scorecard for evaluation: Provides a detailed, easy-to-use platform for evaluating multiple suppliers at once.
• Weighted scoring model for supplier selection: Assesses suppliers based on a customized weight for cost, quality, and lead time, ensuring optimal decision-making.
• Comparison across cost, quality, and lead time: Allows for a direct comparison of suppliers, helping to choose the best one based on prioritized criteria.