Skip to content
v0.1.3latest release121 skills4 categories6 sub-categories247 tested scripts397 reference docsContact us

supplier-quality-scorecard-builder

Build supplier quality scorecards for ISO 9001 8.4 and IATF 16949 8.4.2.4 supplier monitoring: PPM from received and rejected quantities, on-time delivery, responsiveness to corrective action requests, scored 0-100 with configurable weights, a weighted total, A/B/C/D grades, trend against previous periods, and flags for grade D suppliers, two-period declines and PPM above target without a SCAR. Covers KPI definitions (PPM, incidents, OTD window, OTIF, premium freight, disruptions), normalising for low volumes and commodities, grade-to-action rules, the automotive escalation ladder (SCAR, executive escalation, controlled shipping levels 1 and 2, new-business hold, resourcing) and avoiding distorted scores. Use when setting up supplier monitoring, producing monthly or quarterly supplier scorecards, preparing a supplier review meeting, or deciding which suppliers need development or escalation.

A scorecard turns supplier performance into a number the supplier can reproduce and act on, and into decisions: who gets new business, who gets reduced inspection, who gets a SCAR and a development plan. scripts/scorecard.py scores quality, delivery and responsiveness per period, grades each supplier and flags the ones that need action.

Trigger Conditions

Activate this skill when the user:

  • Needs a supplier scorecard or supplier performance monitoring (ISO 9001 8.4, IATF 8.4.2.4)
  • Is preparing a quarterly supplier review or supplier day
  • Wants to decide which suppliers to escalate, develop or reward
  • Asks how to calculate supplier PPM or OTD

Actions for poor performers: supplier-corrective-action-request-writer, supplier-development-plan-writer.

Workflow

text
1. DEFINE  -> KPI definitions (kpi-definitions.md), PPM target per commodity, weights
2. COLLECT -> per supplier per period: received, rejected, deliveries, on_time, scars, scars_on_time
3. SCORE   -> python scripts/scorecard.py supplier_perf.csv --ppm-target 500
4. REVIEW  -> grade D, decliners (SC002), silent quality problems (SC003)
5. ACT     -> grade-to-action rules and escalation ladder (grading-and-actions.md)
6. SHARE   -> each supplier gets its card, definitions and raw data

Scoring

ComponentBasisPoints
QualityPPM vs target<= target 100, <= 2x 85, <= 5x 70, <= 10x 50, else 0
DeliveryOTD %>= 98 100, >= 95 85, >= 90 70, >= 85 50, else 0
ResponsivenessSCARs answered on time% on time (100 if none)
text
Supplier                 PPM   OTD %    Q    D    R  Score  Grade  Trend
PlastiForm               886    96.6   85   85  100   88.0    B    flat
CastCorp               7,600    81.2    0    0   33    6.7    D    down
SC002 CastCorp: score fell two periods running (88 -> 56 -> 7)
SC003 PlastiForm: PPM 886 above target with no SCAR issued

KPI definitions, IATF monitoring requirements and normalising: kpi-definitions.md. Grade actions, escalation ladder, running the scorecard and avoiding distortion: grading-and-actions.md.

Output Format

Deliver the scorecard table for the period, grade distribution, flags with the action for each supplier (SCAR, development plan, inspection level change, escalation), and the definitions used.

Scripts

bash
python scripts/scorecard.py supplier_perf.csv --ppm-target 500
python scripts/scorecard.py supplier_perf.csv --period 2026-Q3 --weights 40 40 20

Columns: supplier, period, received, rejected, deliveries, on_time, scars, scars_on_time. Periods sort as text (use 2026-Q3 or 2026-09). Exit codes: 0 no flags, 1 flags raised, 2 usage or data error.

Additional Resources

FileContent
kpi-definitions.mdPPM, incidents, OTD, OTIF, responsiveness, premium freight, disruptions; normalising
grading-and-actions.mdGrade actions, escalation ladder, running the scorecard, distortion
More in Quality Management & ISO 9001

8d-problem-solving-report-writer

Write and review 8D problem-solving reports for customer complaints and serious nonconformities (automotive and aerospace practice: Ford Global 8D, VDA, GM, Stellantis formats): D0 emergency response, D1 cross-functional team and champion, D2 problem description with 5W2H and is / is-not and no cause in the statement, D3 interim containment within 24 hours with verification and clean point, D4 verified occurrence and escape (non-detection) root causes plus systemic cause, D5 permanent corrective actions for each cause verified before implementation, D6 implementation, validation with production data and removal of containment, D7 PFMEA, control plan and read-across to similar products, D8 closure and recognition. Checks an 8D discipline by discipline for missing content, human-error root causes, missing escape cause or action, late containment and dates out of order.

acceptance-sampling-plan-selector

Select and evaluate acceptance sampling plans for incoming, in-process and final inspection: ANSI/ASQ Z1.4 / ISO 2859-1 single sampling under normal inspection (code letter from lot size and inspection level I, II, III, S-1 to S-4; sample size, Ac and Re from AQL, following the table's arrows to the correct plan; 100% when n reaches the lot size; AQLs above 10 per 100 units), operating characteristic curves (Pa at any quality, producer's quality level, indifference point, LTPD, AOQ and AOQL, binomial or hypergeometric), plans designed from producer and consumer risk, and c = 0 zero-acceptance plans. Covers AQL choice by defect class, switching rules between normal, tightened and reduced inspection, when sampling is not appropriate, and random sampling.

approved-supplier-list-manager

Manage and audit an approved supplier list (ASL) / external provider register for ISO 9001 8.4.1, IATF 16949 8.4 and AS9100 8.4.1: supplier status (approved, conditional, probation, pending, disqualified), scope of approval by commodity and process, risk class, certification and expiry, re-evaluation intervals by risk, conditions with end dates, single-source contingency, approver and customer-directed sources. Audits the list for expired or expiring certificates, overdue re-evaluations, conditional or probation status past its decision date, high-risk suppliers without the required certification, single-source suppliers without backup and missing approvers, and checks purchase orders for suppliers that are off-list, disqualified or pending, or buying outside the approved scope. Covers ERP blocks, PO requirements, off-list and emergency purchases.

apqp-phase-planner

Plan and track Advanced Product Quality Planning (AIAG APQP 3rd edition, IATF 16949) for a new or changed automotive part: back-schedule the five phases (plan and define, product design, process design, product and process validation, launch and feedback) from the start-of-production date by program complexity, with overlap, PPAP lead and safe-launch period; list the deliverables and gate for each phase (DFMEA, DVP&R, feasibility, process flow, PFMEA, control plans, MSA, Ppk, run at rate, PPAP, safe launch, lessons learned); adjust for build-to-print suppliers; flag compressed timelines and late or untracked deliverables against a status list. Covers gate reviews, red/yellow/green status reporting, run at rate and safe-launch exit criteria.

as9100-gap-analyzer

Run an AS9100D / EN 9100:2018 gap analysis for aviation, space and defence suppliers on the requirements added to ISO 9001: on-time delivery and conformity focus, management representative, ethics and human-factors awareness, operational planning and operational risk management, configuration management, product safety, counterfeit-part prevention, special requirements, critical items and key characteristics, external provider register and flow-down, FOD prevention, tooling and NC program control, special process validation, first article inspection (AS9102), traceability, in-service data and nonconforming product control. Generates and scores a worksheet, grades missing core controls as major, and checks invalid n/a claims. Covers AS9101/AS9104, OASIS, AS9102 FAI forms, counterfeit standards (AS5553, AS6174, AS6081), NADCAP and the planned IA9100 transition.

audit-report-writer

Write internal, supplier and pre-certification audit reports with the content ISO 19011:2018 6.5 expects: audit objectives, scope, criteria with revisions, dates, team and auditees, method and sampling statement, specific strengths, findings table and three-part finding details (requirement, evidence, statement), conclusion on the degree of fulfilment of criteria, diverging opinions, follow-up deadlines and distribution. Builds a Markdown report from a JSON audit record, generates the conclusion from the findings (major / minor / none) and flags reports missing required content or findings without clause or evidence. Covers conclusion wording, closing meetings, response expectations and verifying corrective actions.