Design a Supplier Comparison Dashboard

Supplier Comparison Dashboard in Excel, ideal for evaluating multiple suppliers based on key performance indicators (KPIs). You can either create this manually or I can provide you with an Excel file (let me know if you want that).

✅ Dashboard Layout

📊 Sheet 1: Raw Data (Name it: Supplier_Data)

Tip: Use formulas like =AVERAGE, =RANK, and =IF for scoring

📈 Sheet 2: Dashboard (Name it: Dashboard)

📌 Top View Summary

• Dropdown Menu: Select Supplier (using Data Validation or a slicer)

• Overall Rating: Large number (linked to selection)

• Traffic Light/Status Bar: Based on score (Green = 90+, Yellow = 70–89, Red = <70)

📊 Supplier KPI Comparison (Charts)

1. Bar Chart: Quality Score vs. Delivery Time

2. Radar Chart: Quality, Cost, Compliance, Capacity

3. Column Chart: Cost Comparison

4. Map Chart: Supplier Locations (optional using Excel 365)

5. Trendline (Optional): Past 3 months of performance if historical data is available

📌 Conditional Formatting Suggestions

• Supplier Region

• Capacity

• Score Range (Above 90, 80–89, etc.)

🧮 Formula Tips

• =AVERAGE(B2, D2, E2) for overall score

• =RANK(G2, G$2:G$10) for rank among suppliers

• =IF(E2<85, "Review", "OK") for compliance alert

✅ Optional Features

• Macro Button: To refresh data or export summary as PDF

• Drop-downs for custom weighting of KPIs

• Score Weighting Table: Assign weights to KPIs like this:

Then compute weighted average score accordingly.

📁 Want a Ready-to-Use Excel Template?

I can generate and send you a downloadable Excel file based on this layout. Would you like me to prepare and share it here?