47 distributors | Oct 2024 - Aug 2026 ClickHouse
Act on it

Commercial insights

Movement, risk and coverage signals derived from the same warehouse the reports read.

Auto briefing

All distributors · last 90 days
  • Trailing 90 days billed Rs 2.22 L, down 100% on the previous 90 days.
  • Aug 26 closed at Rs 2.22 L across 2 invoices, behind Mar 26 by 100%.
  • Heineken Silver 500 ml is the strongest gainer, adding -32.3 cases (-100%).
  • KFS 650 ml needs attention, down 96044.4 cases (-99.9%).
  • 1 fast-moving SKUs sit under three weeks of cover, led by KFS 650 ml at 0 weeks.
  • 1 outlets worth Rs 547.39 Cr of trailing-year billing have gone quiet for 45+ days.
  • The top five outlets contribute 100% of the window's value, led by (unmapped outlet).

Gaining SKUs

Last 90 days against the prior 90.

SKU Now Before Change
Heineken Silver 500 ml 0 32.3 -100%
Heineken Silver Pint 0 34 -100%
KF 330 ml Can 0 39 -100%
KFM Pint 0 44.3 -100%
KFSL Pint 0 50.2 -100%
Heineken Silver 650 ml 0 65.2 -100%
KF Storm 650ml 0 96 -100%
Heineken Silver 20 L 0 166 -100%

Slipping SKUs

Biggest case losses versus the prior window.

SKU Now Before Change
KFS 650 ml 100 96144.4 -99.9%
(unmapped) 0 57353 -100%
KFS 500 ml Can 0 35974.9 -100%
LPS 650 ml 0 30852.6 -100%
LPS 500 ml 0 10683.2 -100%
KF Ultra 500 ml Can 0 9879.5 -100%
LP 500ml 0 8190.1 -100%
KF Ultra 650 ml 0 7474.2 -100%

Stock coverage on fast movers

1 SKUs

Balance is cumulative purchases minus sales, so read it as a directional inventory proxy. Weeks of cover uses the trailing 60-day selling rate.

SKU Purchased Sold Balance Cases / week Weeks cover Signal
KFS 650 ml 636930 758365.1 -121435.1 11.7 0 Stock out risk

Outlets to win back

Rs 547.39 Cr at risk

Bought in the trailing year but nothing in the last 45 days.

Outlet Area Last purchase Days quiet Trailing value
(unmapped outlet) 2026-03-31 153 547.39 Cr

Brand family share

Derived from SKU names; the ERP brand master is sparse.

KINGFISHER STRONG
100%

Portfolio concentration

Pareto classes over the trailing 180 days of value.

Class A
5
79.7% of value
Class B
10
14.6% of value
Class C
25
5.7% of value

5 of 40 SKUs drive 79.7% of value. Protect availability on those first.

Weekday rhythm

Cases dispatched by day of week, trailing 180 days.

Sun
14.6 K cs
Mon
70.2 K cs
Tue
51.9 K cs
Wed
43.6 K cs
Thu
34.3 K cs
Fri
48.8 K cs
Sat
49 K cs
An unhandled error has occurred. Reload x

Rejoining the server...

Rejoin failed... trying again in seconds.

Failed to rejoin.
Please retry or reload the page.

The session has been paused by the server.

Failed to resume the session.
Please retry or reload the page.