Portfolio annual revenue · Sample—
Selected SKU revenue share—
Selected SKU segment—
1. Experiment with a product
Adjust annual revenue or demand volatility (CV). Product rankings and all segment counts update together.
StableVariableVolatile
In the Excel product, CV is calculated from monthly demand history. It is adjustable here to demonstrate classification effects.
2. Explore the ABC-XYZ matrix
ABC ranks relative revenue contribution. XYZ measures demand volatility. The highlighted segment represents the selected product.
3. Portfolio breakdown
ABC depends on each SKU's position within the portfolio, not on fixed revenue amounts.
| Product | Revenue | Revenue share | Prior cumulative | ABC | CV | XYZ | Segment |
|---|
Synthetic demonstration data only. ABC uses prior cumulative revenue (A below 80%, B below 95%, otherwise C). XYZ: X CV below 0.50; Y below 1.00; Z 1.00 and above. The commercial tool supports 2,500 SKUs and 24 months of history and includes additional data controls and SBC segmentation.