Supplier Scorecard Builder

The problem

Sourcing teams often reorder based on memory or the most recent shipment rather than objective data. Managing multiple factories across 3C and consumer electronics makes it difficult to track which suppliers consistently hit quality and lead time targets.

What it does

• Generates a structured scorecard comparing multiple factories side-by-side.
• Assigns custom weights to quality, lead time, price, compliance, and communication.
• Calculates weighted totals to provide an objective performance ranking.
• Provides actionable verdicts like keep, watch, or replace based on data.
• Outputs clean Markdown tables for easy integration into sourcing folders or documentation.

Why this beats prompting it yourself

Writing prompts for weighted evaluations often results in inconsistent math or generic criteria. This skill enforces a specific logic for consumer electronics sourcing, ensuring trade-offs between price and quality are mathematically defensible and formatted for immediate use.

Use cases

• Compare two charger factories to decide which gets the high-volume order.
• Conduct quarterly performance reviews for existing auto-accessory suppliers.
• Evaluate new electronics vendors against incumbent partners.
• Create a defensible paper trail for switching suppliers due to poor compliance.

Known limitations

Calculations rely on user-provided performance data and notes. It generates the evaluation framework but does not perform independent factory audits.