Examples
Examples
Try the starting example
- Net spend records: supplier, parent group, category, signed amount $
- A,G,Office,100 B,G,Office,100 C,H,Tech,200
- Supplier positive-net-spend HHI
- 0.375
- Parent-group positive-net-spend HHI
- 0.5
- Largest positive-net parent share (%)
- 50
- Suppliers with net credit positions
- None
- Total signed net spend ($)
- $400.00
- Signed net spend by category ($)
- Office: 200.00; Tech: 200.00
Try another scenario
- Net spend records: supplier, parent group, category, signed amount $
- A,G,Office,100 B,G,Office,-100 C,H,Tech,200
- Supplier positive-net-spend HHI
- 0.555556
- Parent-group positive-net-spend HHI
- 1
- Largest positive-net parent share (%)
- 100
- Suppliers with net credit positions
- B
- Total signed net spend ($)
- $200.00
- Signed net spend by category ($)
- Office: 0.00; Tech: 200.00
Calculation method
Calculation method
Supplier positive-net-spend HHI
Aggregate each supplier net amount, clip negative net positions to zero for weights, then sum squared normalized positive-net shares.
Parent-group positive-net-spend HHI
Aggregate supplier net amounts to supplied parent groups first, then clip negative parent positions and compute HHI. Parent/supplier positive denominators can therefore differ.
Largest positive-net parent share (%)
Maximum normalized positive-net parent weight×100.
Suppliers with net credit positions
List suppliers whose aggregated net spend is below zero; credits remain visible in net totals.
Total signed net spend ($)
Sum all signed net amounts.
Signed net spend by category ($)
Aggregate signed records by supplied category, independent of concentration weighting.
Symbols and units
- a
- Net spend records: supplier, parent group, category, signed amount $
Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.
Assumptions & limits
Assumptions & limits
- A descriptive supplied-parent net-spend concentration audit. It does not verify corporate ownership, assess creditworthiness or recommend a supplier strategy. Negative positions are not silently used as negative HHI weights.
Are these inputs private?
These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.
Further reading
Background reading; this does not imply endorsement or independent review of SumFizz.