Managing multiple vendors effectively requires clear, data-driven insights into their performance. For teams using the FishGoo platform, a simple yet powerful spreadsheet can be transformed into a dynamic Seller Scoreboard. This guide will walk you through building a system to assign performance ratings based on two critical metrics: QC ReliabilityDelivery Punctuality.
Step 1: Define Your Data Structure
Create a new spreadsheet (e.g., in Google Sheets or Excel) with the following columns:
- Vendor ID/Name
- Order Number
- QC Pass/Fail Status
- Scheduled Delivery Date
- Actual Delivery Date
- On-Time Status
- Vendor Performance Score
- Performance Rating Tier
Step 2: Calculate Core Metrics
A. QC Reliability Rate
For each vendor, calculate the percentage of orders that passed quality control.
QC Reliability (%) = (Number of "Pass" Entries / Total Orders for Vendor) * 100B. Delivery Punctuality Rate
First, determine on-time status. In your "On-Time Status" column, use a formula to flag each order. Example in Google Sheets:
=IF(C2<=D2, "On Time", "Late")Where C2 is Actual Delivery Date and D2 is Scheduled Delivery Date.
Then, calculate the on-time rate:
Punctuality Rate (%) = (Number of "On Time" Entries / Total Orders for Vendor) * 100Step 3: Create a Composite Performance Score
Combine the two metrics into a single score. You can weigh them based on your business priorities. A common approach is a 50/50 weight:
Performance Score = (QC Reliability % * 0.5) + (Punctuality Rate % * 0.5)This yields a score from 0 to 100. Record this in the Vendor Performance Score
Step 4: Assign Performance Rating Tiers
Create a rating system to categorize vendors. In your Performance Rating TierIF
Example formula to assign tier (Google Sheets): Where G2 is the Performance Score.
Score Range
Rating Tier
Label
90 - 100
A
Top Performer
75 - 89
B
Reliable
60 - 74
C
Needs Monitoring
Below 60
D
Critical Review
=IFS(G2>=90, "A - Top Performer", G2>=75, "B - Reliable", G2>=60, "C - Needs Monitoring", TRUE, "D - Critical Review")
Step 5: Build the Visual Scoreboard
Create a new sheet or area in your workbook as the Seller Scoreboard. Summarize key data for each vendor:
- Vendor Name
- Total Orders (Volume)
- Avg. QC Reliability %
- Avg. Delivery Punctuality %
- Final Performance Score
- Assigned Rating Tier
Use Conditional Formatting
Step 6: Automate and Maintain
To keep your scoreboard dynamic:
- Set up your raw data sheet to be updated regularly (e.g., via FishGoo export or manual entry).
- Use PivotTablesQUERY
- Schedule periodic reviews (e.g., monthly) to update ratings and make sourcing decisions based on the tiers.
Conclusion
By leveraging a simple FishGoo spreadsheet, you can construct a transparent and objective Seller Scoreboard. This tool empowers your procurement and quality teams to reward high-performing vendors, proactively engage with those needing improvement, and ultimately build a more reliable and efficient supply chain based on concrete data from QC ReliabilityDelivery Punctuality.