June 2025 through February 2026 (9 months). All dollar figures are 9-month actuals unless labeled "Annualized," in which case they are multiplied by 12/9 (1.333x).
For each entity-SKU combination, we use the most recent purchase price with a 25% anomaly protection gate:
The Price Index uses SGA as the 100 baseline. It is spend-weighted:
Index = SUMPRODUCT(entity_price * entity_qty) / SUMPRODUCT(sga_price * entity_qty) * 100
For each multi-entity SKU (purchased by 2+ entities):
Savings = SUM( (entity_spend - best_price * entity_qty) )
This represents the savings if every entity purchased at the best available price across all three entities. Only multi-entity SKUs contribute to savings (single-entity SKUs have no comparison point).
For each multi-entity SKU, the entity with the lowest price "wins." Win rates show the percentage of the 4,001 multi-entity SKUs where each entity has the best price.