|
|
Vendor Performance Scoring Agent
Author: Venkata Sudhakar
ShopMax India works with dozens of electronics vendors. Some deliver on time with zero defects; others cause constant stock shortages and quality complaints. Without a systematic scoring framework, procurement decisions rely on relationships rather than data. A vendor performance agent that scores each supplier on delivery, defect rate, invoice accuracy, and price competitiveness gives the procurement team objective data to negotiate better terms and drop underperforming vendors. This tutorial builds a Vendor Performance Scoring Agent using ADK and Gemini. The agent aggregates quarterly data for each vendor, computes a weighted performance score across four dimensions, and produces a ranked scorecard with recommended actions for each vendor relationship. The below example shows a quarterly vendor scorecard for ShopMax India suppliers.
It gives the following output,
Vendor Performance Scorecard - ShopMax India Q1
Rank | Vendor | Delivery | Quality | Invoice | Price | TOTAL | Tier
-----|-------------------------|----------|---------|---------|-------|-------|----------
1 | Samsung India Pvt Ltd | 94.0 | 84.0 | 97.0 | 88.0 | 91.4 | PREFERRED
2 | Sony India Ltd | 88.0 | 70.0 | 100.0 | 58.0 | 80.4 | APPROVED
3 | Apple India Distributor | 78.0 | 94.0 | 95.0 | 40.0 | 78.2 | APPROVED
Recommended Actions:
Samsung India (PREFERRED): Increase TV order volumes and open contract
negotiations for FY26. Strong across all dimensions.
Sony India (APPROVED): Monitor pricing - 2% above market is manageable
but should be addressed in next contract renewal. Quality defect rate
of 1.5% is the weakest dimension - request quality audit.
Apple India Distributor (APPROVED): Delivery at 78% is the primary concern
- 22% of orders arriving late creates stockout risk for high-demand iPads.
Raise formal delivery SLA discussion before next quarter order.
Schedule this agent to run at the end of each quarter using Cloud Scheduler. Pull vendor data directly from your ERP or BigQuery orders table. Store scorecards in Firestore and send the report to the procurement team via email using Cloud Functions. Track score trends across quarters to identify improving or declining vendor relationships.
|
|