<!-- Copyright 2026 Anthropic PBC -- <!-- SPDX-License-Identifier: Apache-2.0 -- Supplier Selection Ranking suppliers is arithmetic, not judgment. Compute it in Python via code execution — do not reason about it in prose. Method For a given SKU: 1. Read and filter to rows matching the SKU. This gives you for each candidate. 2. Join with on to get and . 3. Normalize price and lead time across the candidates (min-max to [0,1], where 0 is best). Reliability is already on [0,1] where higher is better. 4. Score each candidate: 5. Pick the highest score. Tie-breaks: lowest , then lowest , then alph…